How Do You Turn a Sales Forecast Into a Balance Sheet?
Forecast sales first, then model each account according to its actual economic driver.
Income statement
Forecast revenue, then estimate variable expenses, fixed expenses, interest, taxes, and net income.
Balance-sheet accounts
Some operating accounts such as receivables, inventory, and certain payables often move with revenue.
Retained earnings
Forecast retained earnings using expected earnings and distributions under the applicable assumptions.
External financing
If forecasted assets exceed financing generated by liabilities and equity, additional external financing may be required.
Do not scale everything
Long-term assets, debt, and other accounts may move according to different assumptions rather than sales.
The takeaway
Sales is the starting point, not the growth rate for every account.
Related Summit guides
FAQ
Does every balance-sheet account grow with sales?
No.
Can retained earnings provide financing?
Yes.
What is external financing needed?
The remaining financing gap after internal and spontaneous sources.