Overview

The 12 Month Rolling Cash Flow Forecast 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

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 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.
 

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
1,810
0
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
1,993
0
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Consumer Loan Model
1,869
0
The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This…
Venture Capital Financial Model
1,982
4
The Venture Capital Returns Model is used to provide an analysis into an investment return for a VC fund. This…
DCF Valuation Financial Model
2,263
0
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
1,980
1
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
See All