Planning Frameworks for Excel: Direct Method, Rolling Forecast, 3-Statement Model

Three proven frameworks to take your Excel financial planning to a professional level. Each framework has its use case — here you'll learn which one you need and when.

Frameworks are powerful — but time-consuming in Excel. Finban automates data collection and calculation so you can focus on analysis. Start for free →

Framework 1: Direct vs. Indirect Method

Choosing the right cash flow method is the first strategic decision in your financial planning.

Direct Method (Recommended for SMEs)

The direct method lists all actual inflows and outflows. You work directly with cash movements.

Advantages:

Easier to understand and build
Directly derivable from bank account data
Ideal for short-term liquidity planning (weeks/months)
Immediately shows where money comes from and where it goes

Structure in Excel:

Operating Inflows
  + Customer payments
  + Interest income
  + Tax refunds
= Total Inflows

Operating Outflows
  - Suppliers
  - Salaries & social contributions
  - Rent & utilities
  - Tax payments
= Total Outflows

Net Cash Flow = Inflows − Outflows

Suitable for:

Solo entrepreneurs and small teams
Short-term planning (1–12 months)
First financial plan in a company

Indirect Method (Standard in Accounting)

The indirect method derives cash flow from net income (P&L) and adjusts for non-cash items.

Advantages:

Standard for investors and banks
Shows the connection between profit and cash flow
Enables working capital analysis
Basis for professional reporting

Structure in Excel:

Net Income (from P&L)
  + Depreciation
  + Additions to provisions
  ± Change in receivables
  ± Change in payables
  ± Change in inventory
= Operating Cash Flow

  − Investment in fixed assets
  + Proceeds from asset sales
= Investment Cash Flow

  + Loan drawdown
  − Loan repayment
  ± Equity changes
= Financing Cash Flow

Net Cash Flow = Operating CF + Investment CF + Financing CF

Which Method Is Right for You?

Criterion	Direct Method	Indirect Method
Complexity	Low	High
Data source	Bank accounts	P&L + Balance Sheet
Planning horizon	Short-term (weeks/months)	Medium/long-term (months/years)
Target audience	Entrepreneurs, Controllers	CFOs, Investors, Banks
Setup in Excel	1–2 hours	1–2 days

Recommendation: Start with the direct method. If you need investor reporting or bank presentations, build the indirect method additionally.

Framework 2: 13-Week Rolling Forecast

The gold standard for short-term liquidity management. Especially important for companies with fluctuating cash flow.

Why 13 Weeks?

13 weeks = 1 quarter → sufficient foresight for operational decisions
Weekly granularity → early detection of bottlenecks
Short enough for reliable forecasts
Long enough for countermeasures

Structure in Excel

Columns: Calendar week 1–13 (always starting from current week) Rows: Categories for inflows and outflows

                    Wk 1    Wk 2    Wk 3    ...    Wk 13
Opening Balance     50,000  48,200  45,500  ...    38,100
Inflows
  Customer Payments  8,000   7,500   9,200  ...     8,500
  Other                500     200     300  ...       500
Outflows
  Salaries         -12,000       0       0  ...   -12,000
  Suppliers         -3,500  -2,800  -4,100  ...    -3,200
  Rent              -1,800       0       0  ...    -1,800
  Other               -500    -600    -500  ...      -700
Net Cash Flow       -1,800   4,300   4,900  ...    -8,700
Closing Balance     48,200  52,500  50,400  ...    29,400

Weekly Update Process

Enter actual data: Overwrite completed week (Wk 1) with real bank data
Shift column: Wk 1 is archived, a new Wk 14 is added
Compare actual vs. plan: How large was the variance?
Adjust forecast: Correct expectations for remaining weeks
Check early warning: Does the closing balance drop below minimum reserve in any week?

Weekly time investment: 30–60 minutes after setup.

Framework 3: 3-Statement Model

The complete financial plan for professionals — three financial statements, fully linked.

The Three Statements

1. Profit & Loss Statement (P&L) Shows profitability: Is the company making money?

2. Balance Sheet Shows financial position: What does the company own and owe?

3. Cash Flow Statement (Indirect Method) Shows cash position: Where is the money flowing?

Linkages (The Critical Part)

From	To	What Gets Linked
P&L → Balance Sheet	Net income increases equity
Balance Sheet → Cash Flow	Changes in receivables, payables, inventory → working capital
Cash Flow → Balance Sheet	Ending cash = liquid assets on balance sheet
Balance Sheet → P&L	Depreciation on fixed assets → expense in P&L

When You Need a 3-Statement Model

Yes: Bank meetings, investor reporting, M&A preparation, internal strategic planning (10+ employees)
No: Solo entrepreneurs, pre-revenue startups, pure liquidity planning

Time required: 1–2 days for initial build, 2–4 hours monthly maintenance.

Which Framework Fits Me?

Situation	Recommended Framework
First financial plan, solo/micro business	Direct Method
Weekly liquidity assurance	13-Week Rolling Forecast
Investor search / bank meeting	Indirect Method + 3-Statement
10+ employees, professional controlling	All three combined
Startup with runway < 12 months	13-Week Forecast + Runway Calculator

Frameworks provide the structure — but data collection remains manual. Finban automates the most time-consuming part: importing bank data, categorizing, and calculating the forecast. You focus on the analysis. Try free now →

Planning Frameworks for Excel: Direct Method, Rolling Forecast & 3-Statement