calculate_cash_flow_waterfall_partnership: Partnership waterfall and cash flows

In abresler/fundManageR: Investment management toolkit for R

Partnership waterfall and cash flows

Description

This function is a variant of the calculate_cash_flow_waterfall function that also includes the calculation of the share of cash flow available to each member based upon the specified percentage equity splits and promote allocation

Usage

calculate_cash_flow_waterfall_partnership(
  dates = c("2016-09-01", "2017-08-31"),
  cash_flows = c(-1500000, 1.05e+08),
  working_capital = 2e+05,
  promote_structure = c("20 over 12", "30 over 20", "50 over 3.5x", "100 over 10x"),
  assign_to_environment = TRUE,
  general_partner_pct = 0.05,
  gp_promote_share = 1,
  unnest_data = FALSE,
  exclude_partnership_total = FALSE,
  distribution_frequency = NA,
  is_actual_360 = TRUE,
  widen_promote_structure = FALSE,
  bind_to_cf = FALSE,
  remove_zero_cols = TRUE,
  widen_waterfall = FALSE
)

Arguments

dates	vector of dates in year-month-day format
cash_flows	vector of cash flows
working_capital	amount of working capital
promote_structure	vector of the promote structure
general_partner_pct	ercentage of capital provided by general partner
gp_promote_share	share of promote to general partner
unnest_data	unnest final results
exclude_partnership_total	exclude total columns
distribution_frequency	frequency of distribution
is_actual_360	TRUE is the rate of return actual 360
widen_promote_structure	TRUE widen the promote structure
bind_to_cf	TRUE bind results to data frame
remove_zero_cols	TRUE remove zero-value columns
widen_waterfall	TRUE returns waterfall in wide form

Value

tibbleO

See Also

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

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

Other partnership calculation: calculate_cash_flow_dates(), calculate_cash_flow_waterfall(), calculate_cash_flows_returns(), calculate_days_accrued_pref(), calculate_irr_periods(), tidy_promote_structure()

Examples

calculate_cash_flow_waterfall_partnership(dates =c("2016-09-01", "2017-08-31"), cash_flows = c(-1500000, 105000000),
working_capital = 200000, promote_structure = c("20 over 12", "30 over 20", "50 over 3.5x", "100 over 10x"),
general_partner_pct = .05, gp_promote_share = 1, unnest_data = F,
exclude_partnership_total = F,
distribution_frequency = 'annually', is_actual_360 = TRUE,
widen_promote_structure = FALSE, bind_to_cf = FALSE, remove_zero_cols = TRU,
widen_waterfall = FALSE)

abresler/fundManageR documentation built on April 1, 2024, 5:46 p.m.