Calculate returns for a given set of cash flows

Source: R/waterfall_functions.R

Calculate returns for a given set of cash flows

calculate_cash_flows_returns(
  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 = T,
  distribution_frequency = "annually",
  date_format = "%Y-%m-%d",
  scale_to_100 = F,
  return_percentage = F,
  return_df = T,
  return_message = T
)

Arguments

dates

vector of dates
cash_flows

vector of cash flows
working_capital

amount of working capital, minimum cash
remove_cumulative_cols

remove summary columns
distribution_frequency

when is the cash distributed
date_format

format of the date inputs
scale_to_100

scale numbers to 100
return_percentage

return percentages
return_df

return data frame
return_message

include a message
include_final_day

include the final day in calculation

Value

tibble

See also

Other calculation: calculate_cash_flow_dates(), calculate_cash_flow_waterfall_partnership(), calculate_cash_flow_waterfall(), 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_partnership(), calculate_cash_flow_waterfall(), calculate_irr_periods(), calculate_leverage_metrics(), calculate_loan_payment()

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

Examples

calculate_cash_flows_returns(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 = T, distribution_frequency = 'yearly', date_format = '%Y-%m-%d', scale_to_100 = F, return_percentage = F, return_df = T, return_message = T
)