3-Way Forecast Excel Template: 3 Models to Compare

How-to basics · Updated November 21, 2026

A three-way forecast Excel template links a projected income statement, balance sheet, and cash flow statement so changes in sales, costs, working capital, and funding flow through the business. This guide compares three real Excel template sources—CFI, Wall Street Prep, and eFinancialModels—and is for owners, analysts, and finance teams deciding whether they need a learning model, a modeling-course framework, or a business-specific starting point.

1. CFI 3-Statement Model Template

Corporate Finance Institute offers a 3-statement model template for Excel that is designed to show how the income statement, balance sheet, and cash flow statement connect; it is a useful first pick for someone who wants a recognizable financial-modeling structure rather than a standalone sales forecast or budget worksheet. The practical value is the integrated layout: projected net income can feed retained earnings, non-cash expenses can be added back in operating cash flow, and balance-sheet movements such as receivables, inventory, and payables can affect cash instead of remaining isolated assumptions. Before adapting it, check the current CFI download page for the file version, included instructions, and any access requirements, because template availability and packaging can change, then make a copy and replace sample inputs with your own reporting periods and chart of accounts.

This option is particularly worthwhile for analysts learning the mechanics of a conventional three-statement model, or for a small company that has historical statements and wants a structured base to customize. A template is not automatically a forecast that fits your company: a manufacturer may need inventory and production drivers, while a subscription business may need deferred revenue and customer churn schedules, so verify that the source model has places for the assumptions that actually move your numbers. Treat the workbook’s checks and existing formulas as a framework to inspect, not as proof that a changed model is correct; after editing, confirm that the balance sheet balances in every forecast period and that cash on the cash flow statement agrees with cash on the balance sheet.

2. Wall Street Prep 3-Statement Modeling Template

Wall Street Prep’s three-statement modeling materials are aimed at building a conventional integrated financial model, making this a good choice for a reader who wants to understand the logic behind the workbook as well as fill in forecast cells. Its modeling approach is useful when you need to connect operating assumptions to statement line items—for example, forecast revenue and margins on the income statement, estimate working-capital balances, then reflect the resulting cash generation or use in the cash flow statement. Check the current Wall Street Prep resource page for the exact template or course materials available, since a downloadable workbook, instructional content, and access terms may differ from one offering to another.

The strength of a training-oriented model is that it can encourage a consistent build order: establish historical results, add explicit operating assumptions, forecast the statements, and test the links. That makes it more helpful than a prefilled sheet when you need to explain your model to a manager, lender, or investor, although the audience still needs to review the assumptions and definitions. It may be more structured than a very small business needs, so avoid copying advanced schedules simply because they appear in a sample; if your company has no debt, leases, or complex capital expenditures, a simpler schedule can be easier to maintain and less likely to hide an error.

3. eFinancialModels Three-Statement Excel Models

eFinancialModels is a marketplace with downloadable financial-model workbooks, including three-statement models and industry-specific examples, rather than one universal template that fits every buyer. That makes it worth comparing when a generic model would require substantial additions: a listing aimed at a particular business type may already include relevant operating drivers or schedules, and an Excel workbook can provide a more developed starting point than a blank grid. Read each listing closely before purchase, including the stated business use, forecast horizon, currency, level of detail, included statements, and whether the file is editable in Excel; the available models, features, and prices depend on the individual product.

This route can save setup time if the template’s business logic resembles yours, but it does not remove the need to inspect formulas or validate outputs. For example, a model built for a product company may forecast inventory and cost of goods sold in a way that is inappropriate for a consulting firm, while an annual model may not answer a question that depends on monthly cash timing. Compare at least two candidate listings using the same checklist, and look for a clear description of assumptions, historical input areas, forecast periods, and balance checks; a polished dashboard is less valuable than transparent formulas and schedules you can adapt without breaking statement links.

How to Choose

First confirm what you mean by three-way forecast. In financial modeling, the phrase usually means three linked financial statements: the income statement, balance sheet, and cash flow statement. Some people use similar wording to mean three scenarios—base, upside, and downside—so check the template’s terminology before you download or buy it. A scenario-ready workbook can be valuable, but three scenarios are not a substitute for three connected statements; if you need both, look for an integrated model with a clear way to switch or compare assumptions without overwriting the base case.

Next, match the time scale to the decision you need to make. Annual forecasts are often adequate for long-range planning or a high-level valuation, whereas a company managing runway, seasonal sales, collections, payroll, or inventory replenishment usually needs monthly periods. A monthly model should make opening cash, receipts, payments, and closing cash visible for each period; a yearly total can conceal a shortfall that occurs in one month even when the year ends with a positive balance. Also check how many historical periods and forecast periods the template supports, and whether adding another year or month means copying formulas safely rather than rebuilding the workbook.

Review the model’s drivers before judging its appearance. A useful workbook separates historical actuals from forecast assumptions, identifies units and currency, and explains whether an input is entered as a percentage, days, dollars, or a count. Its assumptions should relate to operating activity: revenue might depend on units sold and price, payroll on headcount and average compensation, and cash collection on customer payment timing. A template with one unexplained growth percentage applied to every line can be fast to fill out but difficult to defend or update when the business changes.

Check whether the statements are genuinely linked and whether the workbook includes balance checks. A simple revenue projection illustrates how a driver can feed a forecast: with prior-period revenue in B6 and the growth assumption in C6, enter the formula in D6: =B6*(1+C6). If B6 is 100000 and C6 is 8%, the result is 108000. In a full model, forecast revenue should flow to the income statement, but the model also needs appropriate links for taxes, working capital, capital spending, debt, and cash; one correct growth formula does not make the whole workbook integrated.

For a basic cash roll-forward, with beginning cash in B15 and the period’s net cash movement in B16, enter the closing-cash formula in B17: =B15+B16. If beginning cash is 45000 and net cash movement is -12000, the formula returns 33000. In a three-statement workbook, that closing cash should agree with the cash balance on the balance sheet, and the cash flow statement should explain the movement rather than rely on an unexplained plug. A separate balance check is also useful: with total assets in B30 and total liabilities plus equity in B31, use =B30-B31 in B32; when both totals are 250000, the check returns 0.

Finally, consider maintainability and access. Microsoft Excel for Microsoft 365 on Windows is the assumed environment here; ask whether a purchased file uses macros, external links, or functions that may behave differently in Excel for the web or an older Excel release. A workbook that depends on macros may require additional security review, and formulas that rely on newer functions may not work in older versions. Prefer a file with readable formulas, labeled inputs, a documented units convention, and a clear way to distinguish editable cells from calculated cells. Before using any template for a real forecast, make a working copy, test a small change in an assumption, and trace whether the expected statements and cash balances respond correctly.

Frequently Asked Questions

What does a three-way forecast include?
A standard three-way forecast includes a projected income statement, balance sheet, and cash flow statement. The statements are linked so profit, asset and liability movements, and cash changes reconcile across the forecast periods.

Is a three-way forecast the same as three scenarios?
No. Three-way generally refers to the three financial statements, while scenarios usually mean alternative sets of assumptions, such as base, upside, and downside. A workbook can include both, but check that it has linked statements as well as a usable scenario method if you need both features.

Can I use one of these templates for a small business?
Yes, if you adapt its accounts, timing, and operating assumptions to the business. A small business may not need a complex debt or acquisition schedule, but it can still benefit from a monthly cash forecast and a balance-sheet check. Do not keep sample numbers or assume an industry schedule fits without review.

Should I choose a monthly or annual Excel forecast?
Choose monthly periods when cash timing, seasonality, payroll, collections, or inventory matter to decisions; use annual periods when a high-level long-range view is enough. Some teams maintain a monthly near-term forecast and a simpler annual outlook for later years, provided the workbook keeps the assumptions and statement links clear.

Do I need accounting data before using a template?
Historical income statements and balance sheets make it much easier to establish opening balances and realistic assumptions. If you have only sales and expense totals, you can still build a limited forecast, but you will not have enough information to project every balance-sheet account reliably. Reconcile the starting figures to your accounting records before forecasting.

How can I tell whether an Excel template is working?
Check that the balance sheet balances in each period, closing cash matches across the balance sheet and cash flow statement, and a controlled change to an input produces an expected result. Review formulas around any rows or columns you modify, and compare outputs with source records and business logic rather than relying only on a dashboard or a green check cell.

Final Thoughts

CFI is a practical starting point for learning a standard three-statement structure, Wall Street Prep suits readers who want modeling instruction alongside the framework, and eFinancialModels is worth considering when an industry-specific workbook could reduce setup work. Choose based on statement links, forecast timing, relevant operating drivers, transparent formulas, and checks—not on visual polish alone. Whichever option you select, adapt it to your business, test the links, and keep a clean copy of the original template.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.