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

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)