Interactive Business Planning Tool

12-Month Pro-Forma Financial Model & Cash Flow Generator

Transform simulation results, startup assumptions, or classroom business plans into a complete 12-month pro-forma income statement and cash runway forecast. Free, private, and runs entirely in your browser.

Model Generator Pro-Forma Table Modeling Framework FAQ

Executive Pro-Forma Summary

Instant feedback on Year 1 financial viability, operating profit (EBITDA), and minimum cash reserves.

Step 1: Input Assumptions

Business Model Parameters & Cost Structure

Expected starting monthly sales volume.
$
Average revenue realized per transaction.
%
Compounding monthly transaction increase.
%
Direct product / ingredient cost share.
$
Wages, salaries, and staffing overhead.
$
Commercial lease and fixed occupancy cost.
$
Customer acquisition and promotion budget.
$
Power, POS software, insurance & admin.
$
Liquid capital available at Month 1 start.
FY1 Revenue
$0
FY1 Gross Profit
$0
FY1 Total OPEX
$0
FY1 Operating Profit
$0
Break-Even Month
-
Cash Liquidity
-

Step 2: Pro-Forma Income Statement

12-Month Financial Statement & Cash Flow Projection

Financial Metric M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12 Total FY1

Financial Analysis

How to read a 12-month pro-forma model

A pro-forma financial model maps operational assumptions to accounting outcomes. When evaluating a business plan or simulation run, examine these four critical layers:

  1. Unit Margin Health: Gross margin must leave sufficient dollar contribution after variable COGS to support fixed monthly overhead.
  2. Operating Leverage: Fixed operating expenses (Rent, Base Payroll) do not increase automatically with volume, creating margin expansion as sales grow.
  3. Cash Trough (J-Curve): Initial months often burn capital before customer growth reaches breakeven volume. Starting cash must safely exceed the lowest cumulative point.
  4. Sensitivity Scenarios: Test what happens if growth is half your forecast, or if COGS increases by 5 percentage points due to supply price inflation.

Connect these principles to our Free Business Calculators or dive deeper into managerial accounting with the Managerial Accounting Lesson.

Core Formulas

Standard pro-forma calculations

Gross Profit = Revenue − Cost of Goods Sold (COGS)

Total OPEX = Payroll + Rent + Marketing + Utilities & Admin

Operating Income (EBITDA) = Gross Profit − Total OPEX

Ending Cash (Month N) = Ending Cash (Month N-1) + Monthly Cash Flow

Break-Even Units = Total Monthly OPEX ÷ (Price − Unit Variable Cost)

For classroom simulations, compare your pro-forma assumptions against live results in the Coffee Shop Simulator, Restaurant Simulator, Bookstore Simulator, or Motel Simulator.

FAQ

Financial model and pro-forma questions

What is a pro-forma financial statement?

A pro-forma financial statement is a forward-looking financial projection that models expected revenues, Cost of Goods Sold (COGS), operating expenses (OPEX), and net operating profit over a defined future period such as 12 months.

How do you determine the break-even month?

The break-even month is the first projection month where gross profit equals or exceeds total monthly operating expenses, generating zero or positive operating income.

What is the difference between operating income (EBITDA) and net cash flow?

Operating income measures profitability before taxes and interest. Net monthly cash flow tracks actual cash entering or leaving liquidity reserves, reflecting operating profit combined with working capital timing.

How does revenue growth affect cash runway?

Positive revenue growth increases gross profit and narrows monthly cash deficits. Once monthly revenue passes fixed costs, the business transitions from burning cash to accumulating self-sustaining reserves.

Can I download or print this financial model?

Yes. You can export the full 12-month dataset as a UTF-8 CSV spreadsheet with formula injection defense or use the print button to generate a clean 1-page executive pro-forma summary.

Are these projections real financial advice?

No. These models provide educational estimates for classroom planning and simulation analysis. They omit income taxes, debt service, non-cash depreciation, and irregular inventory purchases.

Explore More Business Tools & Resources

Explore our complete collection of 18 Free Online Business Simulations, test individual metrics with the Free Business Calculators Suite, download printable classroom assignments from the Student Worksheets Directory, or browse the exhaustive Business Education Resource Index.