A fully linked three-statement financial model connecting the income statement, balance sheet, and cash flow statement. Changes in one statement flow automatically to the others. Includes working capital assumptions, debt schedules, and equity roll-forward.
What's included
Template preview
Step by step
Start with revenue assumptions and work down through COGS, operating expenses, interest, tax, and net income.
Enter days sales outstanding (DSO), days payable outstanding (DPO), and inventory days. These drive the balance sheet working capital lines.
The balance sheet populates from the P&L and working capital assumptions. Add fixed assets, debt, and equity lines manually.
The cash flow statement is derived automatically from changes in the P&L and balance sheet. Check that the closing cash balance matches the balance sheet.
Verify that Assets = Liabilities + Equity on the balance sheet. The template flags any imbalance automatically.
Watch out
Breaking the circular reference between interest expense and the debt balance
Forgetting to include changes in working capital in the cash flow statement
Not reconciling the cash flow statement closing balance to the balance sheet cash line
Using inconsistent time periods across the three statements
Related templates
Import this template directly into Grove FP and start planning. No credit card required.
FAQ