This function returns a data frame of summarised cash flows for given a set of inputs.
calculate_cash_flow_dates(dates = c("2016-09-01", "2017-08-31", "2018-08-31",
"2019-08-31", "2020-08-31", "2021-08-31", "2022-08-31", "2023-08-31"),
cash_flows = c(-4151601, 119499.036215643, 257186.036215643,
447646.036215643, 200652.036215643, 510409.036215643, 193.036215643166,
8788626.76409155), working_capital = 125000,
remove_cumulative_cols = TRUE, include_final_day = TRUE,
distribution_frequency = NA)
vector of dates
vector of cash flows
amount of working capital, minimum cash
TRUE
remove summary columns
TRUE
include the final day in calculation
frequency of distribution
weekly
: weekly distributions
monthly
: monthly distributions
quarterly
: quarterly distributions
annually
: annual distributions
sale
: distribution on residual
data_frame
Other calculation: calculate_cash_flow_waterfall_partnership
,
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_waterfall_partnership
,
calculate_cash_flow_waterfall
,
calculate_cash_flows_returns
,
calculate_irr_periods
,
calculate_leverage_metrics
,
calculate_loan_payment
Other partnership calculation: calculate_cash_flow_waterfall_partnership
,
calculate_cash_flow_waterfall
,
calculate_cash_flows_returns
,
calculate_days_accrued_pref
,
calculate_irr_periods
,
tidy_promote_structure
# NOT RUN {
calculate_cash_flow_dates(dates = c( "2016-09-01", "2017-08-31", "2018-08-31", "2019-08-31", "2020-08-31", "2021-08-31", "2022-08-31", "2023-08-31" ),
cash_flows = c( -4151601, 119499.036215643, 257186.036215643, 447646.036215643, 200652.036215643, 510409.036215643, 193.036215643166, 8788626.7640915 ),
working_capital = 125000, remove_cumulative_cols = TRUE, include_final_day = TRUE, distribution_frequency = NA)
# }
Run the code above in your browser using DataLab