This model provides the foundation for a set of financial's - the basic integrated financial statements, the sheets included are:

1. Yearly Profit & Loss
2. Monthly Profit & Loss
3. Yearly Balance Sheet
4. Monthly Balance Sheet
5. Starting Balance Sheet
6. Yearly Cash Flows
7. Monthly Cash Flows

The model demonstrates the interaction between the three financial statements. The model can easily be expanded to include the 'feeder' sheets including the revenue model (usually highly tailored) and the budget/expenses required to meet revenue growth,

Note on the monthly cash flow sheet there are metrics of the business including a valuation (DCF) and a value for 'lowest cash balance'. The cash balance is the amount required to fund the business - not factoring in a cushion or stages of investment,

Excel Model FAQ

Back