Loan payment calculation

Calculate loan payment information based upon specified parameters.

calculate_loan_payment(
  loan_start_date = "2016-06-01",
  amount_initial_draw = 3000,
  is_interest_only = F,
  interest_only_periods = 24,
  interest_rate = "10%",
  is_actual_360 = TRUE,
  amortization_years = 10,
  amortization_months = 0,
  term_years = 10,
  term_months = 0,
  pct_loan_fee = 0,
  balloon_year = 10,
  override_monthly_interest = FALSE,
  interest_reserve_period = 0,
  balloon_month = 0,
  return_annual_summary = F
)

Arguments

loan_start_date	date loan starts in year, month, date form
amount_initial_draw	amount of initial draw
is_interest_only	TRUE has interest only periods
interest_only_periods	count of interest only periods
interest_rate	interest rate in character or numeric form
is_actual_360	TRUE interest calculated on actual/360 basis
amortization_years	amortization in years
amortization_months	amortization additional months
term_years	term of the loan in years
term_months	term of the loan additional months
pct_loan_fee	loan fee in percent
balloon_year	year loan baloons
override_monthly_interest	TRUE override
interest_reserve_period	periods of interest reserve
balloon_month	month loan baloons
return_annual_summary	TRUE returns annual summary

Value

a tibble

See also

Other leveraged finance calculation: calculate_cash_flow_dates(), calculate_cash_flow_waterfall_partnership(), calculate_cash_flow_waterfall(), calculate_cash_flows_returns(), calculate_irr_periods(), calculate_leverage_metrics()

Other calculation: calculate_cash_flow_dates(), calculate_cash_flow_waterfall_partnership(), calculate_cash_flow_waterfall(), calculate_cash_flows_returns(), calculate_days_accrued_pref(), calculate_irr_periods(), calculate_leverage_metrics(), calculate_residual_valuation_cap_rates(), calculate_residual_valuation_ebitda_multiples(), calculate_share_proceeds(), calculate_valuation_post_money(), tidy_promote_structure()

Examples

calculate_loan_payment(loan_start_date = "2016-06-01", amount_initial_draw = 3000, is_interest_only = F, interest_only_periods = 24,
interest_rate = "10%", is_actual_360 = TRUE, amortization_years = 10, amortization_months = 0,
term_years = 10, term_months = 0, pct_loan_fee = 0, balloon_year = 10,
override_monthly_interest = FALSE, interest_reserve_period = 0, balloon_month = 0,
return_annual_summary = F)