12 Month Rolling Cash Flow Forecast Template

12 Month Rolling Cash Flow Forecast Template

The 12 Month Rolling Cash Flow Forecast Template is an extension of the 3 Statement Model where the Income Statement, Balance Sheet and Cash Flow Statements are linked together. This will give you a month-by-month forecast of the business for an entire year. Included in the template you will find:

• The Income Statement, Balance Sheet and Cash Flow Statement
• An Assumptions Section with key drivers for the business
• Supporting Schedules Section for PPE and Debt
• Graphs to visually display the Monthly Cash Flow Statement and Debt Service Ratio

In the 12 Month Rolling Cash Flow Forecast Template, first is the Assumptions sections where Assumptions are entered in the cells for the projection periods. All assumptions can be modified to fit specific key drivers of the business to see their impact to the 3 Statement model in a 12-month period. Up to 5 months of historical data are entered into the income statement, balance sheet and cash flow statement; the following projected months are driven by the Assumptions section.

The Supporting Schedules section of the 12 Month Rolling Cash Flow Forecast Template is all formulas that are tied to the Assumptions and 3 Statement sections so no editing is necessary. Lastly, the Charts and Graphs sections displays the Cash Flow Statement and Debt Service Ratio visually. The correlating data is above the graphs and tied to the model with formulas so they will automatically adjust to any modifications in the model.

All cells in black font are input cells where custom information can be entered. All cells in blue font are formulas set to streamline the model. Sections are grouped to condense the model to view sections individually.