Projects RH

All insights

Capital raising

Financial Model for Capital Raising: The 60-Month View

A financial model for capital raising should give investors one auditable view of revenue, costs, cash flow, funding needs and returns across a 60-month forecast.

Paul Raftery, 12 min read

A financial model for capital raising should give investors something more valuable than a large spreadsheet: a single, auditable view of how the project or business is expected to perform, how much capital it requires and what drives investor returns.

For many capital-intensive opportunities, a five-year or 60-month financial model provides a useful planning horizon. Sixty monthly columns can reveal when capital is required, when revenue begins, how operating costs develop, when cash flow turns positive and how returns change when assumptions move.

The purpose of a financial model is not to impress an investor with complexity. It is to make the investment case understandable, testable and internally consistent.

For sponsors preparing to raise capital, the model should become a single point of truth for the financial investment case.

Why a Financial Model for Capital Raising Matters

A financial model for capital raising is different from a spreadsheet designed primarily to manage day-to-day operations.

An operational model may contain considerable detail:

  • Individual employees
  • Department budgets
  • Purchase orders
  • Product-level data
  • Weekly operating metrics
  • Detailed cost centres
  • Internal management assumptions

That information can be useful to management.

An institutional investor, however, needs to understand the economic drivers that determine whether the opportunity can create value and support the proposed capital structure.

Those drivers can include:

  • Revenue
  • Volume
  • Pricing
  • Gross margin
  • Operating costs
  • CAPEX
  • Working capital
  • Funding requirements
  • Cash flow
  • Debt
  • Equity
  • IRR
  • NPV
  • Exit assumptions

The model should contain enough detail to demonstrate the economics without burying the investment case beneath unnecessary complexity.

Why Use a 60-Month Financial Model?

Five years expressed as 60 monthly columns can provide a useful planning horizon for many capital-raising situations.

Monthly forecasts reveal timing that annual forecasts may conceal.

For example, a project might require:

  • 12 months of development and construction
  • 6 months of commercial ramp-up
  • Working capital before customers begin paying
  • Debt or equity injections at different stages

A monthly model can show exactly when:

  • Development costs occur
  • CAPEX is paid
  • Equity is required
  • Debt is drawn
  • Revenue begins
  • Working capital increases
  • Interest accrues
  • Cash flow turns positive
  • Debt service begins
  • Investor distributions may become possible

Timing can materially change the total funding requirement.

Sixty Columns Can Reveal the Real Funding Requirement

A project that appears profitable by Year 3 can still run out of cash before reaching Year 3.

Capital may be required during:

  • Development
  • Construction
  • Commissioning
  • Ramp-up
  • Working-capital build
  • Early operating losses

A 60-month model makes the cumulative funding requirement easier to identify.

Conceptually:

Opening Cash + Funding + Operating Cash Flow - CAPEX - Debt Service = Closing Cash

If closing cash becomes negative before stable operations begin, the financing structure contains a gap.

Finding that gap during project preparation is far preferable to discovering it during investor due diligence.

Build One Defensible Base Case

One of the most important functions of an investor-facing financial model is establishing a single point of truth.

The model should contain the approved assumptions used throughout the investment case.

These may include:

  • Development timetable
  • Construction timetable
  • Production or sales volume
  • Pricing
  • Revenue
  • Gross margin
  • Staffing
  • OPEX
  • CAPEX
  • Working capital
  • Financing
  • Tax
  • Cash flow
  • Investor returns

Those assumptions should reconcile with the project's other investment materials.

The financial model, Information Memorandum, investor presentation and teaser should not tell different financial stories.

What Investors Need to Understand

An investor does not necessarily need every operational detail in the first presentation.

The investor does need to understand what drives value.

A strong financial model should help answer:

  1. What generates revenue?
  2. What assumptions drive that revenue?
  3. What does it cost to operate the opportunity?
  4. How much capital is required?
  5. When is that capital required?
  6. What happens if assumptions underperform?
  7. When does the project generate cash?
  8. What return could the investor receive?
  9. Which assumptions drive that return?
  10. Which risks have the greatest financial impact?

These questions are more important than the number of worksheets or formulas in the workbook.

Complexity Does Not Equal Quality

Financial models often become complicated because teams continually add detail.

Eventually that complexity can make a model more difficult to:

  • Understand
  • Audit
  • Update
  • Stress-test
  • Explain
  • Maintain

It can also increase the likelihood of errors.

The FAST Standard describes strong financial models using four principles:

  • Flexible
  • Appropriate
  • Structured
  • Transparent

A model should contain sufficient detail to represent material economics without unnecessary complexity.

Hard-Coded Numbers Are a Warning Sign

A recurring spreadsheet weakness is a hard-coded number embedded inside a formula.

For example:

Revenue = Volume × 125

That calculation does not clearly tell another analyst what 125 represents.

If 125 is the selling price, a more transparent structure is:

Selling Price = Assumption

followed by:

Revenue = Volume × Selling Price

This allows the assumption to be identified, changed and sensitivity-tested consistently.

Centralising important assumptions makes a model easier for investors, advisers and lenders to review.

Separate Inputs, Calculations and Outputs

A financial model should allow another analyst to understand where numbers come from.

A practical architecture separates three broad areas.

Inputs

  • Prices
  • Volumes
  • Inflation
  • Construction assumptions
  • Operating assumptions
  • Financing terms
  • Tax
  • Timing
  • Scenario selections

Calculations

  • Revenue
  • Operating costs
  • Working capital
  • CAPEX
  • Depreciation
  • Financing
  • Tax
  • Cash flow
  • Investor returns

Outputs

  • Income statement
  • Balance sheet
  • Cash-flow statement
  • Funding requirement
  • Debt metrics
  • IRR
  • NPV
  • Sensitivities
  • Key investment metrics

This structure can make the model easier to review and reduce hidden assumptions.

Revenue Should Be Built From Drivers

Revenue forecasts are generally more useful when investors can trace them back to underlying commercial or operational drivers.

Instead of simply entering:

Year 3 Revenue = $50 million

the model should build the figure from identifiable assumptions where possible.

For example:

Volume × Price = Revenue

For a data centre:

MW Commissioned × Utilisation × Contract Economics = Revenue

For a mine:

Ore Processed × Grade × Recovery × Payability × Commodity Price = Revenue

For a renewable-energy project:

Generation × Availability × Contract Price = Revenue

For an operating business:

Customers × Units per Customer × Price = Revenue

This architecture allows investors to challenge material assumptions without rebuilding the entire model.

Operating Costs Need the Same Discipline

OPEX should also connect to operational assumptions.

Relevant categories can include:

  • Labour
  • Energy
  • Feedstock or raw materials
  • Maintenance
  • Logistics
  • Insurance
  • Administration
  • Technology
  • Regulatory compliance

The objective is not maximum detail.

The objective is enough detail to distinguish costs that are:

  • Fixed
  • Variable
  • Semi-variable
  • Indexed
  • Contracted
  • Assumed

That distinction becomes particularly useful during sensitivity analysis.

CAPEX Needs Timing, Not Just a Total

A project requiring $100 million of CAPEX does not necessarily need the entire $100 million on Day 1.

Expenditure may follow:

Development → Procurement → Construction → Installation → Commissioning

A monthly model can show the cash requirement through that sequence.

This matters because capital may also arrive in stages.

The model should reconcile:

Sources of Capital → Funding Timing → Uses of Capital

rather than presenting one aggregate funding figure without timing.

Sources and Uses Must Reconcile

Before approaching capital, sponsors should understand exactly how much money is required and what it will fund.

Potential Sources

  • Existing sponsor equity
  • New equity
  • Strategic investment
  • Senior debt
  • Subordinated debt
  • Grants
  • Concessional finance

Potential Uses

  • Development
  • Engineering
  • Land
  • Equipment
  • Construction
  • Working capital
  • Financing fees
  • Interest during construction
  • Contingency
  • Transaction costs

Total Sources should reconcile with Total Uses.

An unexplained gap is a financing problem, not a presentation problem.

Working Capital Can Change the Capital Requirement

A business can produce accounting profit while still consuming cash.

Working capital can create that difference.

For example, customers may take 60 days to pay invoices while suppliers require payment in 30 days.

As sales increase, capital tied up in receivables can increase as well.

A 60-month model should therefore reflect material assumptions for:

  • Receivables
  • Payables
  • Inventory
  • Other working-capital balances

Ignoring working capital can materially understate the amount of capital required.

Cash Flow Matters More Than Accounting Profit Alone

Investors need to understand both earnings and cash.

EBITDA can help explain operating performance, but EBITDA is not cash flow.

A project may still require cash for:

  • CAPEX
  • Working capital
  • Interest
  • Tax
  • Debt repayment

This is why the financial model should connect accounting performance with actual cash generation.

IRR Needs to Be Traceable

Internal Rate of Return, or IRR, is frequently used to analyse investment performance.

But IRR is only as reliable as the cash flows behind it.

The model should make clear:

  • Initial investor contribution
  • Follow-on contributions
  • Distribution timing
  • Operating distributions
  • Exit proceeds
  • Exit timing
  • Terminal assumptions

A high IRR can be mathematically correct while still being economically unrealistic if the assumptions driving it are weak.

The question should therefore never be only:

What is the IRR?

It should also be:

Which assumptions produce that IRR?

Model the Investor's Cash Flow

Project cash flow and investor cash flow are not necessarily identical.

Where new equity is being raised, the model may need to identify:

  • Pre-money valuation
  • New investment
  • Post-money valuation
  • Ownership
  • Dilution
  • Investor cash contributions
  • Potential distributions
  • Exit assumptions
  • Investor proceeds

Conceptually:

Investor Cash Outflows → Ownership → Distributions + Exit Proceeds → Investor Return

This allows sponsors and investors to examine the economics from the same model.

EBITDA Is Useful but Not Sufficient

EBITDA is commonly used when discussing operating profitability and valuation.

But investors should not rely on EBITDA alone.

Two opportunities with similar EBITDA can have materially different:

  • CAPEX requirements
  • Working-capital requirements
  • Debt levels
  • Taxes
  • Cash conversion
  • Risk
  • Growth requirements

A financial model should therefore connect EBITDA to cash flow rather than presenting EBITDA as the final economic answer.

Base Case, Downside and Upside

A model designed only to demonstrate the sponsor's preferred outcome is incomplete.

Capital providers need to understand how results change when assumptions change.

Base Case

The assumptions the sponsor believes are reasonably supportable.

Downside Case

More conservative assumptions around variables such as:

  • Revenue
  • Pricing
  • Volume
  • Construction cost
  • Construction timing
  • Operating cost
  • Availability
  • Financing

Upside Case

Potential improvement where credible evidence supports stronger operating outcomes.

The objective is not to predict every possible future.

It is to understand which assumptions have the greatest influence on project economics.

Sensitivity Analysis Shows What Really Matters

A strong model lets investors test material assumptions.

Depending on the opportunity, scenarios might include:

  • Revenue -10%
  • CAPEX +10%
  • CAPEX +20%
  • OPEX +10%
  • Commercial operation delayed six months
  • Lower utilisation
  • Lower product price
  • Higher financing cost
  • Lower exit valuation

The appropriate ranges depend on the project and available evidence.

Sensitivity analysis helps identify whether returns depend on one optimistic assumption or remain credible across reasonable scenarios.

Model Checks Should Be Visible

An auditable financial model should contain controls designed to identify errors.

Examples include:

  • Balance sheet balances
  • Sources equal Uses
  • Opening cash reconciles
  • Debt does not become unintentionally negative
  • Debt roll-forward reconciles
  • Cash-flow statements reconcile
  • Depreciation reconciles with the asset base
  • Scenario switches operate correctly
  • Formula errors are identified

A sophisticated forecast without basic checks can still be unreliable.

Why Model Errors Damage Investor Confidence

Investors and their advisers may test formulas, assumptions and cell references.

If simple errors are discovered, confidence in other parts of the investment case can weaken.

One incorrect formula can potentially affect:

Revenue → EBITDA → Cash Flow → Valuation → IRR

That is why financial-model review should happen before investor engagement.

The model is not merely supporting material.

It is part of the evidence supporting the investment proposition.

The Model Must Match the Information Memorandum

The financial model and investment documentation should tell the same story.

The Information Memorandum should not contain:

  • Different revenue figures
  • Different CAPEX
  • Different project timing
  • Different funding requirements
  • Different margins
  • Different investor returns

Material figures should trace back to the same approved base case.

For more detail, read the Information Memorandum Development: Built to Be Tested.

Financial Model for Capital Raising and Investor Readiness

A financial model for capital raising should form part of the wider investor-readiness process.

A practical sequence is:

Project Facts → Assumptions → Financial Model → Sensitivities → Funding Requirement → Investment Documentation → Capital Strategy → Investor Engagement

Investors should not be expected to discover fundamental model problems during due diligence.

Projects RH helps sponsors identify financial, commercial and documentation gaps before an opportunity is broadly presented to institutional capital.

Learn more about How Projects RH Works and explore Projects RH Services.

60-Month Financial Model Checklist

Before approaching institutional investors or lenders, sponsors should be able to confirm:

  1. The model has a clearly defined purpose.
  2. Key assumptions are visible.
  3. Hard-coded assumptions are separated from formulas.
  4. Revenue is built from identifiable drivers.
  5. OPEX reflects realistic operating assumptions.
  6. CAPEX includes timing.
  7. Working capital is included where material.
  8. Sources and Uses reconcile.
  9. Funding timing is visible.
  10. Cash does not fall below required levels unnoticed.
  11. The balance sheet balances where IRR calculations are traceable.**
  12. Base-case assumptions have supporting evidence.
  13. Downside scenarios have been modelled.
  14. Key sensitivities have been tested.
  15. Model checks are visible.
  16. Material formulas can be audited.
  17. The Information Memorandum reconciles with the model.
  18. The investor presentation uses the same material numbers.
  19. The model can be updated without rewriting major calculations.
  20. Another analyst can understand the model architecture.
  21. The capital requirement follows the economics rather than the sponsor's preferred raise amount.

If several of these elements remain unresolved, additional preparation may be appropriate before institutional review.

What Good Financial Modelling Standards Emphasise

The FAST Standard describes good financial models through four principles:

  • Flexible
  • Appropriate
  • Structured
  • Transparent

The standard emphasises understandable formulas, logical structure and an appropriate level of detail.

The Financial Modeling Institute similarly encourages model structures that centralise inputs, improve formula transparency and reduce reliance on values hard-coded inside formulas.

These principles support the same practical conclusion:

The strongest financial model is not necessarily the most complicated. It is the model an investor can understand, challenge, audit and use to make a decision.

Frequently Asked Questions About a Financial Model for Capital Raising

What is a financial model for capital raising?

A financial model for capital raising translates commercial and operational assumptions into projected financial performance, cash flow, funding requirements and investor returns so capital providers can evaluate an opportunity.

Why use a 60-month financial model?

Monthly forecasts can show the timing of development expenditure, CAPEX, revenue ramp-up, working capital, funding requirements, debt service and cash generation more clearly than annual forecasts alone.

What should investors be able to see in the model?

Investors should be able to understand revenue drivers, costs, CAPEX, working capital, cash flow, funding requirements, financing assumptions, downside scenarios and potential returns.

Why should hard-coded numbers be avoided?

Hard-coded values inside formulas can make assumptions difficult to identify, update and audit. Material assumptions should generally be visible and referenced consistently.

Does a more detailed model mean a better model?

No. Excessive detail can make a model difficult to understand and audit. The appropriate level of detail depends on the investment decision and the material drivers of the economics.

What is the difference between EBITDA and cash flow?

EBITDA measures operating earnings before interest, tax, depreciation and amortisation. Cash flow also reflects items such as working capital, CAPEX, taxes, financing and debt service.

Why does sensitivity analysis matter?

Sensitivity analysis allows investors and sponsors to understand how changes in material assumptions affect cash flow, funding requirements, valuation and investor returns.

Should the financial model match the Information Memorandum?

Yes. Material assumptions and financial outputs used in the Information Memorandum and investor presentation should reconcile with the financial model.

Does a strong financial model guarantee capital?

No. A strong financial model improves transparency and investor readiness, but funding remains subject to the complete investment case, due diligence, investor criteria, market conditions and transaction structure.

Sources

  • /insights/investor-readiness-what-investors-test-before-they-commit
  • /insights/information-memorandum-development-built-to-be-tested
  • /how-we-work.html
  • /services.html

Is Your Financial Model Ready for Institutional Investors?

A complex spreadsheet is not necessarily an investment-ready financial model. Investors need a model whose assumptions can be understood, whose formulas can be tested and whose outputs reconcile with the wider investment case.

Projects RH helps project sponsors establish their financial base case, test project economics, identify investor-readiness gaps and prepare institutional-quality investment documentation before formal capital raising begins.

If you already have a financial model, feasibility study, business plan or project forecast, /intake.html so the team can assess the financial and documentation gaps that may affect institutional review.

Learn more about /services.html and /how-we-work.html.

Preparing a project for capital? /intake.html.

What to do next

Projects RH prepares the company and the project first, then takes them to investors. The fastest way to find out where you stand is a short call.

Book a free 20-minute discovery callSend your documents