Summary cash flows

Source: R/waterfall_functions.R

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,
  is_annual_budget = T,
  distribution_frequency = NA
)

Arguments

dates

vector of dates
cash_flows

vector of cash flows
working_capital

amount of working capital, minimum cash
remove_cumulative_cols

TRUE remove summary columns
include_final_day

TRUE include the final day in calculation
distribution_frequency

frequency of distribution

  • weekly: weekly distributions

  • monthly: monthly distributions

  • quarterly: quarterly distributions

  • annually: annual distributions

  • sale: distribution on residual

Value

tibble

See also

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()

Examples

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)