Skip to content

View Basket

Cash Flow Forecast Model Template.
  • Cash Flow Forecast Model Template.
  • cf1_assumptions
  • cf2_user_revenue
  • An example of monthly Operating and Capital Costs in a Cash Flow Forecast
  • An example of using a SUMIF formula in a Cash Flow Forecast.
  • cf5_cf_model_summary
  • An example of a Equity Requirement and the Use of Funds forecast.
  • An example of a DCF Calculation and Capital Structure in a Cash Flow Forecast.
  • cf8_model_returns
  • An example of an Excel sheet with cash flow forecast assumptions and scenarios.
  • An example of a Profit and Loss Statement in a Cash Flow Forecast.
  • cf11_debt_model_example

Cash Flow Forecast Template

CA$39.00

20% off with a purchase of two or more templates*

An Excel Template with a Cash Flow Model and Assumptions, Monthly Revenue and Cost calculations, Equity Requirement and Return on Investment Analysis, DCF, Profit and Loss, Balance Sheet Statements and Debt estimates.

The file is in Excel format, but you can convert it to Google Sheets using the instructionsย hereย [external link].

Learn More:ย How to Build a Cash Flow Forecast in Microsoft Excel

Order risk-free with a 30-day Money Back Guarantee

Category: Tag:

The Cash Flow Model Template contains the following Excel sheets and sections:

  • Assumptions:ย The Template starts with the primary inputs used in the model linked to the rest of the monthly calculations. The sheet also allows you to switch between different scenarios for sensitivity analysis.
  • Monthly Cash Flow Model:ย Calculations of forecast Sales, Revenues, Operating Costs, and Capital Expenditures. The template also contains an annual summary of the model.
  • Equity Returns and the Use of Funds:ย The spreadsheet estimates the required equity, allocation, and investment return.
  • Cash Flow, Profit & Loss and Balance Sheet:ย Monthly and Annual forecast of Operating, Investment, and Financing cash flows along with Net Income and Assets and Liabilities estimates.
  • Debt Model and Capital Structure:ย An example of simplified calculations of interest and principal repayments and a structure with returns and share of ownership for each tranche of investment.
  • Discounted Cash Flow (DCF):ย The template contains examples of Discounted Cash Flow and Terminal Value estimates.

Click on product images for screenshots of the template.

Learn More:ย How to Build a Cash Flow Forecast in Microsoft Excel

Related products

*the 20% discount applies to the entire order with a purchase of two or more templates.