# Financial Modelling by Industry and Use Case

Questions about financial models for real estate, startups, SaaS, energy, infrastructure, and other industries.

Canonical: https://finamodel.com/faq/financial-modeling-by-industry

## Questions and answers

### How do you build a financial model for a bank?

A bank model starts with the balance sheet because lending volumes, funding and capital drive earnings. Forecast loans by product, deposits by type and securities separately; then calculate interest income and expense from average balances and yields. Add fees, operating costs, credit losses, tax and dividends. The model should produce the income statement, balance sheet, cash-flow view and regulatory-capital ratios.

A compact driver chain is:

- **Loan book:** opening loans + originations - repayments - write-offs.
- **Net interest income:** average interest-earning assets × yield - average funding × cost.
- **Credit loss:** average loans × expected loss rate.
- **Capital:** opening CET1 + retained profit - distributions and deductions.

For example, £10bn of average loans at a 6% yield generates £600m of interest income before funding costs and losses. *Do not model a bank like an industrial company:* EBITDA and ordinary working-capital ratios are usually not the central outputs. Use the [JPMorgan Chase company example](/companies/jpmorgan-chase) to inspect a bank-specific structure, and the [bank capital adequacy model](/templates/bank-capital-adequacy-model) for a regulatory-capital framework.

### How can a financial model help with personal finance?

A personal-finance model turns income, spending, debt, savings and investments into a forward cash plan. Start monthly, because salary dates, bills and debt payments matter more than annual averages. Separate essential spending from discretionary spending, add irregular items such as insurance or holidays, and model each loan using its actual rate and repayment schedule.

A useful structure is:

| Driver | Calculation | Output |
|---|---|---|
| Net income and spending | income - expenses | monthly surplus |
| Surplus and contributions | opening cash + surplus | closing cash |
| Investment balance | opening balance × (1 + return) + contribution | future wealth |

Create **base, cautious and stressed** cases for income growth, investment returns, inflation and unexpected costs. Avoid treating expected returns as guaranteed; show the range and keep an emergency-cash threshold visible. The [compound-interest calculator](/tools/compound-interest-calculator) can check long-term savings growth, while the [loan amortisation calculator](/tools/loan-amortization-calculator) helps validate debt repayments. A personal model is most useful when it supports a specific decision—such as affordability, debt repayment or retirement—not when it becomes an unnecessarily detailed record of every purchase.

### How do you build a financial model for retirement planning?

A retirement model projects how savings accumulate before retirement and how withdrawals, investment returns, inflation and tax affect them afterwards. Build it annually for a strategic plan or monthly when contribution timing and drawdowns matter. Separate pensions, taxable investments, cash and property rather than applying one return or tax assumption to everything.

The core roll-forward is:

`closing assets = opening assets + contributions + investment return - withdrawals - fees - tax`

Model at least three phases: **accumulation**, the transition into retirement, and **drawdown**. Include salary growth, contribution rates, planned retirement age, inflation-linked spending, one-off costs and any dependable income. Then test longevity, poor early returns and higher inflation. Sequence risk matters: a loss shortly after retirement can be more damaging than the same loss later because withdrawals crystallise it.

Use *real* values alongside nominal values so future spending remains understandable. The [compound-interest calculator](/tools/compound-interest-calculator) provides a useful independent check on accumulation, and the [scenario-planning template](/templates/scenario-planning) can structure alternative return and spending cases. This is a planning model, not personalised investment or tax advice; assumptions should be reviewed when circumstances or rules change.

### Where can you find an NBFC financial model in Excel?

For an NBFC model in Excel, start with a lending structure rather than a generic three-statement template. The workbook should forecast disbursements, repayments, prepayments, arrears and write-offs by product or borrower cohort. Those schedules determine the closing loan book, interest income, expected credit losses, funding needs and capital position.

Key modules normally include:

- **Loan book:** opening principal + disbursements - collections - write-offs.
- **Revenue:** average performing principal × portfolio yield, plus fees.
- **Credit:** delinquency buckets, probability of default, recovery and provisions.
- **Funding:** bank facilities, bonds, securitisation, interest and maturities.
- **Outputs:** net interest margin, cost-to-income, ROA, ROE, leverage and liquidity.

A generic download is only a starting point: NBFC regulation, provisioning and capital definitions vary by jurisdiction and business type. Finamodel does not currently offer a dedicated NBFC workbook, but the [microfinance model](/templates/microfinance) is a close operating reference and the [bank capital adequacy model](/templates/bank-capital-adequacy-model) shows how to structure capital ratios. Verify local regulatory rules before relying on either framework, and reconcile the model to audited opening balances.

### Where can you find an agricultural financial model in Excel?

An agricultural Excel model should reflect the biological and seasonal operating cycle rather than applying a flat annual growth rate. Forecast planted area, yield, harvest timing and realised price by crop or production line. Then add seed, feed, fertiliser, labour, water, energy, transport and storage costs, distinguishing costs per hectare or animal from fixed overhead.

A simple crop example is:

`revenue = hectares planted × yield per hectare × saleable percentage × price per tonne`

If 500 hectares produce 6 tonnes each, 95% is saleable and price is £220 per tonne, revenue is £627,000. The model should then show monthly working-capital needs because costs often occur well before receipts. Include weather, disease, commodity-price and yield scenarios; *a single expected yield hides the main risk*.

The [farm model](/templates/farm-model) is the most direct Excel starting point, while the [aquaculture operations model](/templates/aquaculture-operations-model) demonstrates a different production cycle. Check that any template matches the farm’s crop calendar, units, financing and ownership structure. Replace illustrative assumptions with agronomic and commercial evidence, and keep volume, price and foreign-exchange effects separate.

### How do you build a financial model for a company?

Build a company model from the economics of the business, then link those drivers into the financial statements. Begin with historical accounts in a consistent currency and accounting basis. Forecast revenue by segment using operational drivers—such as units × price, customers × average revenue, or contracts × value—then model gross margin, operating costs, working capital, capital expenditure, debt and tax.

For a construction company, use a project backlog: opening backlog + awards - revenue recognised = closing backlog. Add project margins, mobilisation cash, retention balances and contract assets. For an Indian company, the same architecture applies, but reporting, tax, currency and Ind AS treatment must match the entity.

A robust model produces:

- **integrated income statement, balance sheet and cash flow**;
- base, upside and downside forecasts;
- liquidity, covenant and valuation outputs; and
- checks for statement balance and schedule roll-forwards.

Start with the [three-statement model](/templates/3-statement-model) and its [step-by-step guide](/blog/3-statement-financial-model). The [company examples library](/companies) shows how sector drivers change the model. *Do not force every company into one revenue formula:* the operating build should explain how that specific business earns money.

### How does a financial model support a business plan?

The financial model is the numerical core of a business plan. The written plan explains the market, product, team and strategy; the model tests whether those claims can produce sustainable revenue, cash flow and funding capacity. Every important narrative claim should have a measurable counterpart.

For example:

| Business-plan claim | Model driver |
|---|---|
| Enter two new markets | launch dates, customers and local costs |
| Hire a sales team | start dates, salary and ramped productivity |
| Reach break-even | contribution margin and fixed-cost base |

Build monthly for the first 12–24 months, then annualise only when detail becomes immaterial. Include revenue, headcount, operating expenditure, working capital, capital expenditure, tax, financing and the three statements or at least a complete cash forecast. Show **funding required, minimum cash and break-even timing**, not merely profit.

The [startup financial model guide](/blog/startup-financial-model-guide) explains a driver-led planning approach, while the [startup financial model](/templates/startup-financial-model) provides a practical workbook. For an established company, use the [three-statement model](/templates/3-statement-model). Keep assumptions traceable to the plan and update both documents together; otherwise they will quickly contradict each other.

### How do you build a financial model for a manufacturing company in Excel?

A manufacturing model should connect sales demand to production, inventory, capacity and cash. Forecast unit demand and selling price by product, then translate sales into required production after allowing for opening and target finished-goods inventory. Build bills of materials, labour hours, machine capacity, scrap and overhead allocation explicitly rather than forecasting cost of sales as one percentage.

A compact production bridge is:

`units produced = units sold + closing finished goods - opening finished goods`

For each period, calculate:

- **Materials:** units produced × material quantity × input price.
- **Labour:** production hours × wage rate.
- **Factory overhead:** fixed costs + variable cost per machine hour.
- **Capex:** equipment required when utilisation exceeds practical capacity.

The output should show gross margin by product, inventory days, working-capital funding, capacity utilisation, EBITDA and cash flow. Run sensitivities for volume, raw-material prices, yield and downtime; these often move value differently. The [food manufacturing model](/templates/food-manufacturing-model) provides a sector-specific Excel reference, while the [inventory forecast](/templates/inventory-forecast) helps develop the stock schedule. Reconcile units as carefully as currency—tonnes, cases and individual items should never be mixed silently.

### How does J.P. Morgan use financial models?

J.P. Morgan uses financial models across banking, markets, asset management and corporate advisory, so there is no single ‘J.P. Morgan model’. Analysts may forecast a borrower’s debt capacity, value a company, model an acquisition, price securities, stress a portfolio or project the bank’s own earnings and capital. The structure changes with the decision and available data.

For the bank itself, a simplified chain is:

- deposits and wholesale funding → **interest expense**;
- loans and securities → **interest income**;
- balances and spreads → net interest income;
- borrower quality → credit losses;
- profit and distributions → regulatory capital.

In an advisory assignment, the same analyst might instead use a [DCF model](/templates/dcf-model), [comparable company analysis](/templates/comparable-company-analysis) or [M&A model](/templates/ma-model). These are general methods, not proprietary J.P. Morgan workbooks.

To study a public-data model of the institution, use the [JPMorgan Chase example](/companies/jpmorgan-chase). It illustrates bank-specific drivers and statements without claiming to reproduce an internal model. *Never treat a public template as evidence of a firm’s confidential methodology:* rely on disclosed information and label assumptions clearly.

### How do you build a mining financial model, and where can you find a template?

A mining model is built around ore movement, grade, recovery, commodity prices and the mine plan. Start with reserves and resources, then model tonnes mined, tonnes processed, head grade, recovery and payable metal. Translate production into revenue using realised prices, treatment and refining charges, royalties and foreign exchange. Add operating costs by activity, sustaining capex, closure costs and tax.

A small production example is:

`payable metal = ore processed × grade × recovery × payable percentage`

If one million tonnes at 1.2% grade achieve 90% recovery and 95% payability, payable metal is 10,260 tonnes. The model should also show annual and life-of-mine cash flow, NPV, IRR, payback and funding. Test **grade, recovery, price, capex and schedule delay** separately.

Finamodel’s [mining model](/templates/mining-model) is the relevant downloadable Excel template, and the [NPV calculator](/tools/npv-calculator) can provide an independent return check. A template cannot supply a credible mine plan: replace all sample inputs with technical-report, engineering, fiscal and marketing assumptions, and preserve units carefully. *Tonnes, percentages and metal-price units are a common source of large errors.*

### Where can you find a financial model of Reliance Industries?

Finamodel does not currently provide a dedicated Reliance Industries model, but you can build one from the company’s published financial statements and segment disclosures using a general corporate framework. Reliance is diversified, so a single revenue-growth assumption would obscure the economics. Model material segments separately, using the appropriate volume, price, subscriber, utilisation or retail-footprint drivers, then consolidate them.

A practical structure is:

- **Segment forecasts:** revenue, EBITDA, capex and working capital by business.
- **Corporate items:** central costs, financing, tax and minority interests.
- **Consolidation:** eliminate inter-segment transactions and reconcile totals.
- **Valuation:** combine a DCF or segment multiples in a sum-of-the-parts view.

Start with the [three-statement model](/templates/3-statement-model) for the integrated accounts and use the [sum-of-the-parts model](/templates/sum-of-parts-model) for valuation. The [company examples hub](/companies) shows how public disclosures can be turned into forecast drivers, although it is not a substitute for Reliance’s own filings. Clearly label historical data, management guidance and analyst assumptions. *Do not download or rely on an unverified spreadsheet simply because it carries the company name.*

### Where can you find a financial model of Tata Motors?

Finamodel does not currently host a dedicated Tata Motors workbook. A useful model can be built from published accounts and operating disclosures, with separate schedules for automotive volumes, average selling prices, product mix, finance operations and major geographic or brand segments. Consolidation and currency translation matter because the group is not economically homogeneous.

For an automotive segment, use:

`revenue = vehicle volume × average net selling price`

Then forecast material cost per vehicle, labour, warranty, logistics, R&D, selling costs and emissions or regulatory expenditure. Link production and sales volumes to inventory, receivables and payables, and model capex, leases, debt and tax. Include **volume, pricing, commodity-cost, FX and margin** scenarios; avoid assuming that historical margins simply continue.

The [three-statement model](/templates/3-statement-model) provides the core Excel architecture. The [Ford company example](/companies/ford-motor) is a relevant automotive reference for driver design, but its assumptions must not be transferred to Tata Motors. For valuation, consider the [sum-of-the-parts model](/templates/sum-of-parts-model) where distinct businesses warrant different methods. Use current company disclosures, reconcile every opening balance and distinguish reported results from your own estimates.

### How do you build a financial model for a mining project?

A mining-project model converts a technical mine plan into dated project cash flows. Unlike a high-level mining-company model, it must follow development, ramp-up, steady-state production, declining grades and closure over the project life. Build construction timing first, then production by period, because schedule changes affect capex, interest, revenue and tax simultaneously.

The model chain is:

**reserves and mine plan → ore processed → recovered product → sales → operating cash flow → project returns**

Include development and sustaining capex, working capital, royalties, rehabilitation, tax losses, financing drawdowns, interest during construction and debt service. Key outputs are project NPV, equity NPV, IRR, payback, DSCR, minimum cash and covenant headroom. Run downside cases for lower commodity prices, weaker recovery, capex overruns and delayed commissioning.

Use the [mining model](/templates/mining-model) for life-of-mine operations and pair it with the [debt schedule](/templates/debt-schedule) when financing is material. The [IRR calculator](/tools/irr-calculator) is useful as an independent check. *Keep nominal/real prices, currency and tax assumptions explicit:* hidden inflation or FX mismatches can distort a project valuation materially.

### How do you build a financial model for a renewable energy project?

A renewable-energy project model should follow the asset from construction through operation and decommissioning. Start with capacity, construction schedule and commissioning date. Forecast generation from capacity × availability × resource factor, then apply degradation, curtailment and losses. Revenue depends on the contract: fixed PPA price, merchant power price, certificates or capacity payments may each require a separate line.

A simplified annual example is:

`generation = 100 MW × 8,760 hours × 30% capacity factor = 262,800 MWh`

From there, model operating costs, land or lease payments, insurance, maintenance, capex, working capital, tax and financing. Report **project and equity IRR, NPV, DSCR, LLCR, distributions and minimum cash**. Test resource, availability, price, curtailment, capex and commissioning delays.

The [renewable energy model](/templates/renewable-energy-model) provides the broad Excel framework; the [battery storage model](/templates/battery-storage-model) is more suitable when revenue comes from charging, discharging and ancillary services. Use the [DSCR calculator](/tools/dscr-calculator) to cross-check coverage. A bankable model must reflect the actual PPA, debt terms, tax rules and engineering assumptions—not generic template defaults.

### How do you build a financial model for a solar project?

A solar-project model begins with installed capacity and an energy-yield forecast. Convert irradiation and technical assumptions into net generation after temperature effects, inverter and wiring losses, availability, curtailment and annual panel degradation. Apply the relevant PPA, feed-in tariff or merchant price to generation, then add operating costs, capex, tax and financing.

A compact calculation is:

`net generation = capacity × hours × capacity factor × (1 - losses)`

For a 50 MW plant at a 22% capacity factor and 8% total losses, first-year generation is about 88,651 MWh. The forecast should normally be monthly during construction and early operations, then annual if seasonality is captured adequately.

Include **construction drawdown, interest during construction, debt service, reserve accounts, distributions, NPV, equity IRR and DSCR**. Sensitise irradiation, degradation, electricity price, capex, delay and availability. The [renewable energy model](/templates/renewable-energy-model) is the closest Excel starting point, while the [NPV calculator](/tools/npv-calculator) and [DSCR calculator](/tools/dscr-calculator) provide independent checks. Keep DC and AC capacity, MWh and MW, and nominal versus real tariffs clearly labelled; unit errors can overwhelm the economics.

### How do you build a financial model for a battery energy storage system?

A BESS model links battery physics to dispatch revenue and degradation. Define power capacity in MW, energy capacity in MWh, round-trip efficiency, usable depth of discharge, availability and degradation. Forecast charge and discharge volumes by market and time period, applying electricity purchase prices, sale prices, capacity payments and ancillary-service revenue where relevant.

A simple arbitrage contribution is:

`discharge revenue - charging cost = discharged MWh × sale price - charged MWh × purchase price`

Because discharged energy is lower after losses, charging and discharging must not use the same MWh. Add augmentation or replacement capex, fixed and variable O&M, connection costs, rent, insurance, tax and debt. Key outputs include annual cycles, gross margin by service, EBITDA, free cash flow, NPV, equity IRR and DSCR.

The [battery storage model](/templates/battery-storage-model) provides an Excel structure designed for this use case. Compare it with the broader [renewable energy model](/templates/renewable-energy-model) when storage is co-located with generation. Test **price spread, utilisation, efficiency, degradation, capex and revenue stacking**. Avoid double-counting mutually exclusive services in the same interval; an attractive stacked-revenue case must still be operationally feasible.

### How do you build a financial model for an infrastructure project?

An infrastructure model is a long-term, contract-led cash-flow model covering construction, operations, financing and handback or decommissioning. Begin with the concession or service agreement: availability payments, user charges, escalation, performance deductions and termination provisions determine the revenue logic. Build the construction schedule and funding drawdown before modelling operations.

Typical modules are:

- **Construction:** milestones, capex, contingency and delay.
- **Operations:** demand or availability, tariffs, opex and lifecycle capex.
- **Financing:** debt drawdown, interest, fees, repayment and reserve accounts.
- **Tax and distributions:** taxable profit, losses, cash waterfall and equity returns.

The outputs should include project and equity IRR, NPV, DSCR, LLCR, debt balance, minimum cash and covenant breaches. For a toll road, for example, revenue is traffic × tariff, while an availability PPP earns contracted payments adjusted for performance.

Use the [toll-road model](/templates/toll-road-model) for demand-based infrastructure or the [PPP availability model](/templates/ppp-availability-model) for contracted availability payments. The [debt-capacity calculator](/tools/debt-capacity-calculator) can help sense-check financing. *Make dates and cash waterfalls explicit:* even correct annual totals can give incorrect returns when timing is wrong.

### How does financial modelling work in project finance?

Project-finance modelling assesses whether a ring-fenced project can fund construction, operate and repay debt primarily from its own cash flows. The model is usually contract-based, highly date-sensitive and designed around lender covenants. Build the operating case first, then size and sculpt debt against cash flow available for debt service rather than forcing an arbitrary repayment profile.

A common definition is:

`DSCR = cash flow available for debt service ÷ scheduled principal and interest`

The workbook should include construction, revenue, opex, lifecycle capex, working capital, tax, debt, reserve accounts and the distribution waterfall. Distinguish **project returns** from **equity returns** and show NPV, IRR, DSCR, LLCR, debt tenor, minimum cash and lock-up events. Run scenarios for construction delay, capex overrun, lower output, weaker prices and higher interest rates.

Use the [renewable energy model](/templates/renewable-energy-model), [PPP availability model](/templates/ppp-availability-model) or [mining model](/templates/mining-model) according to the asset. The [DSCR calculator](/tools/dscr-calculator) provides an independent coverage check, and the [debt schedule guide](/blog/debt-schedule-excel) explains roll-forwards. *A model is not bankable merely because the base case repays debt:* lenders focus on downside resilience and contractual allocation of risk.

### How is financial modelling used to set utility tariffs?

A utility-tariff model calculates the revenue a regulated provider needs to recover efficient costs and an allowed return over a control period. Start with the regulatory asset base, depreciation, allowed return, operating expenditure, tax and permitted adjustments. Then divide the revenue requirement by forecast billing determinants such as customers, capacity, demand or energy volume.

A simplified building block is:

`revenue requirement = opex + depreciation + allowed return + tax ± regulatory adjustments`

If the requirement is £120m and forecast billed volume is 2,000 GWh, the average volumetric tariff is £60/MWh before fixed charges, customer classes and losses. A full model should allocate cost across classes, apply tariff structures and show customer-bill impacts.

Include **demand scenarios, inflation indexation, efficiency targets, capex additions, asset disposals, losses and under/over-recovery**. Keep nominal and real returns consistent and document whether the allowed return applies to opening, closing or average assets. Finamodel does not currently have a dedicated tariff-setting workbook; the [renewable energy model](/templates/renewable-energy-model) can support asset and financing schedules, while the [scenario-planning template](/templates/scenario-planning) helps organise regulatory cases. Actual tariffs must follow the relevant regulator’s methodology, definitions and approved inputs.

### Where can you find a PPP financial model in Excel?

For a PPP model in Excel, choose the template by payment mechanism. An availability-payment PPP earns contracted revenue when the asset is available, subject to deductions. A demand-risk concession earns user charges, so volume and tariff assumptions become central. Both require construction, operations, financing, tax and equity cash-flow schedules.

The [PPP availability model](/templates/ppp-availability-model) is the closest downloadable Finamodel workbook. For a demand-based concession, compare the [toll-road model](/templates/toll-road-model). Adapt the selected file to the concession agreement rather than copying sample assumptions.

Check that it includes:

- construction milestones, capex and delay mechanics;
- index-linked revenue and performance deductions;
- operating and lifecycle costs;
- debt drawdown, fees, interest, repayment and reserve accounts;
- tax, distributions, DSCR, LLCR, NPV and equity IRR.

Trace a mini-model chain: *availability × unitary charge → revenue; revenue - costs - tax → project cash flow; project cash flow - debt service → equity cash*. The [DSCR calculator](/tools/dscr-calculator) can independently verify coverage. Before using any PPP spreadsheet, confirm dates, day-count conventions, escalation, cash waterfalls and handback obligations against the executed documents.

### How do you build a financial model for a hotel?

A hotel model should forecast rooms, occupancy and average daily rate rather than treating revenue as one growth line. Rooms revenue is driven by available room nights × occupancy × ADR. Add food and beverage, events, spa and other income using their own volume and spend assumptions. Then model departmental costs, undistributed expenses, management fees, property costs, refurbishment capex, working capital and financing.

For a 200-room hotel operating 365 days at 70% occupancy and £150 ADR:

`rooms revenue = 200 × 365 × 70% × £150 = £7.665m`

Key outputs include **RevPAR, GOP, EBITDA, NOI, free cash flow, debt coverage and investment returns**. Reflect seasonality monthly, especially for resort or event-driven properties. Test occupancy, ADR, wage inflation, utilities, renovation downtime and financing costs.

The [hotel model](/templates/hotel-model) is the direct Excel starting point. For a property-investment perspective, compare the [real-estate model](/templates/real-estate-model), and use the [debt-capacity calculator](/tools/debt-capacity-calculator) to sense-check leverage. Separate owner economics from operator fees and, where applicable, model lease, franchise or management-contract terms explicitly. *RevPAR growth alone does not guarantee cash generation if costs and required capex rise faster.*

### How do you build a financial model for a hospital or healthcare business?

A hospital or healthcare-business model should begin with the unit that creates activity: occupied beds, patient visits, procedures, tests, prescriptions, enrolled members or contracted lives. Forecast volume, case mix and reimbursement by payer, then connect clinical activity to staffing, consumables, drugs, equipment utilisation and facilities costs.

For an inpatient service:

`revenue = available beds × occupancy × days × cases per occupied day × net revenue per case`

The exact formula varies, but volume and reimbursement should remain separate. Model payment lags, denied claims and receivables carefully because accounting revenue can precede cash. Add staffing ratios, agency labour, variable clinical costs, fixed overhead, maintenance and growth capex, debt and tax.

Important outputs include **revenue per patient, contribution margin, EBITDA, cash conversion, capacity utilisation, break-even volume and debt coverage**. Test occupancy, reimbursement, wage rates, case mix and collection days. The [hospital model](/templates/hospital-model) provides a specialist workbook; the [healthcare company examples](/sectors/healthcare) show how listed businesses may differ. Use the [working-capital calculator](/tools/working-capital-calculator) to check receivable assumptions. Protect patient confidentiality and use aggregated operational data only.

### Where can you find a hospital financial model in Excel?

Finamodel’s [hospital model](/templates/hospital-model) is the relevant downloadable Excel starting point. It should be adapted to the facility’s service lines, payer system, accounting rules and available operational data; a generic workbook cannot determine credible occupancy, reimbursement or staffing assumptions.

Before using it, verify that the model covers:

- **Activity:** beds, occupancy, admissions, procedures and outpatient visits.
- **Revenue:** payer mix, tariffs, case mix, discounts and denied claims.
- **Costs:** staffing by grade, clinical supplies, drugs, utilities and overhead.
- **Investment:** equipment replacement, facilities capex and financing.
- **Outputs:** margin by service, cash flow, break-even volume and debt coverage.

A useful test is to trace one driver end to end: `occupied bed days × net revenue per bed day` should feed revenue, receivables, cash collection and the relevant capacity metrics. Compare the workbook with the [healthcare company examples](/sectors/healthcare) for alternative industry structures, and use the [working-capital calculator](/tools/working-capital-calculator) to sense-check collection days. Keep a clean original, document every changed input and remove any sample data before using the file in a real decision.

### How do you build a financial model for a real estate investment or project?

A real-estate model converts lease or sales assumptions into property cash flow, financing and investor returns. For an income-producing asset, forecast rentable area, occupancy, rent per square metre, lease expiries, incentives, operating expenses and capital expenditure. For a development, model acquisition, construction, leasing or sales timing and the funding draw.

A simple operating-asset bridge is:

`gross rent - vacancy - incentives - operating costs = net operating income`

Then subtract capex, tax and debt service to calculate equity cash flow. Key outputs include **NOI, yield on cost, DSCR, loan-to-value, cash-on-cash return, NPV and equity IRR**. Model an exit value from stabilised NOI and an exit capitalisation rate, but show the sensitivity rather than relying on one terminal assumption.

Use the [real-estate model](/templates/real-estate-model) for a broad investment framework, the [development pro forma](/templates/development-pro-forma-model) for construction-led projects, and the [real-estate pro forma guide](/blog/real-estate-pro-forma) for the build logic. The [cap-rate guide](/blog/cap-rate-explained) clarifies valuation. Track area, dates and currency explicitly; mixing monthly rent with annual costs is a common modelling error.

### How do you build a financial model for a rental property?

A rental-property model should show the cash an owner actually receives, not only headline rent and property appreciation. Forecast unit-level or total rent, occupancy, rent-free periods, bad debt and other income. Deduct repairs, management, insurance, property tax, service charges, utilities and recurring capital expenditure. Then model mortgage drawdown, interest, principal repayment, tax and sale proceeds.

A compact calculation is:

`NOI = gross potential rent - vacancy and credit loss - operating expenses`

Do not include mortgage payments in NOI; financing comes afterwards. Report **NOI yield, cash-on-cash return, DSCR, loan-to-value, NPV and equity IRR**. Test vacancy, rent growth, repairs, interest rates and exit cap rate. For short-term rentals, add nights available, occupancy, average daily rate, platform fees and seasonality rather than using an annual rent assumption.

The [real-estate model](/templates/real-estate-model) provides the broad workbook structure, while the [office-building model](/templates/office-building-model) offers a detailed lease-based example. Use the [loan amortisation calculator](/tools/loan-amortization-calculator) to validate mortgage payments and the [cap-rate guide](/blog/cap-rate-explained) for valuation context. *Appreciation should be a scenario, not the mechanism that makes weak operating cash flow look acceptable.*

### How does financial modelling work in real estate development?

Real-estate development modelling follows land acquisition, design, approvals, construction, leasing or unit sales, financing and exit. Timing is central: a three-month delay can increase interest, postpone receipts and reduce returns even when total costs appear unchanged. Build monthly or quarterly until completion and stabilisation.

The main chain is:

**area or units → construction programme → cost draw → completion → leasing/sales → debt repayment → equity proceeds**

Include land cost, hard and soft costs, contingency, professional fees, taxes, marketing, tenant incentives, financing fees and interest. For a build-to-hold project, forecast stabilised NOI and terminal value; for build-to-sell, model reservations, deposits, completions and sales proceeds. Key outputs are total development cost, yield on cost, profit on cost, peak debt, minimum equity, NPV and equity IRR.

Use the [development pro forma model](/templates/development-pro-forma-model) and the [real-estate pro forma guide](/blog/real-estate-pro-forma). The [construction draw model](/templates/construction-draw-model) is useful for funding mechanics, while the [real-estate IRR waterfall guide](/blog/real-estate-irr-waterfall) explains investor distributions. Test sales or rent, cost overruns, delay, interest rates and exit yield separately; do not hide them in one arbitrary downside percentage.

### How is financial modelling used by startups?

Startups use financial models to translate a growth plan into hiring, spending, cash runway and funding requirements. Because historical data may be limited, the model should be driven by operational assumptions—customers, conversion, pricing, retention, usage and headcount—rather than extrapolating a short revenue history. Monthly periods are usually most useful.

A typical flow is:

- **Acquisition:** leads × conversion = new customers.
- **Customer base:** opening customers + new customers - churned customers.
- **Revenue:** customers × average revenue per customer.
- **Cash:** opening cash + receipts - payroll - other payments - capex.

The outputs should show monthly recurring revenue where relevant, gross margin, burn, runway, break-even, hiring affordability and the timing and size of a funding round. Build base, upside and downside cases, and distinguish bookings, accounting revenue and cash collection.

The [startup financial model guide](/blog/startup-financial-model-guide) explains the complete process, and the [startup examples library](/startups) shows different sectors and funding stages. Use the [startup runway calculator](/tools/startup-runway-calculator) for a quick independent check. *A startup model is a decision tool, not a promise:* assumptions should be observable, owned and updated as real data arrives.

### How do you build a financial model for a startup or SaaS business?

A startup or SaaS model should connect customer acquisition and retention to recurring revenue, gross margin, headcount and cash. Forecast new customers by channel, churn or retention by cohort, plan and pricing mix, expansion revenue and payment timing. For SaaS, separate MRR, ARR, bookings, billings, deferred revenue and cash; they are related but not interchangeable.

A compact SaaS roll-forward is:

`closing MRR = opening MRR + new MRR + expansion MRR - contraction MRR - churned MRR`

Then calculate revenue recognition, hosting and support costs, sales and marketing, product development, G&A, headcount, capex and funding. Important outputs include **ARR growth, gross margin, net revenue retention, CAC payback, LTV:CAC, burn multiple, runway and break-even month**. Test acquisition, churn, pricing, hiring and funding delay.

The [startup financial model](/templates/startup-financial-model) covers the integrated plan, while the [SaaS MRR/ARR model](/templates/saas-mrr-arr-model) focuses on subscription metrics. The [SaaS modelling guide](/blog/saas-financial-model-guide) explains the logic and the [LTV:CAC calculator](/tools/ltv-cac-calculator) checks unit economics. Treat any named version such as ‘SaaS Financial Model 3.0’ as a specific product label, not a universal modelling standard.

### How do you build a startup financial model in Excel?

Build a startup model in Excel with separate Inputs, customer or revenue, headcount, operating costs, statements, funding and dashboard sheets. Use monthly columns for at least the near-term forecast. Enter assumptions once and reference them consistently; do not scatter hard-coded growth rates through formulas.

A practical build order is:

1. Opening cash and historical results.
2. Customer acquisition, retention, price and revenue.
3. Headcount by role, start date and fully loaded cost.
4. Other operating costs, working capital and capex.
5. Profit and loss, cash flow and balance sheet where needed.
6. Funding, dilution, scenarios and checks.

For example, `closing cash = opening cash + cash receipts - payroll - other payments - capex + funding`. Highlight the first month cash falls below the chosen minimum and test a delayed raise.

Use the [startup financial model](/templates/startup-financial-model) as an Excel reference and follow the [startup model guide](/blog/startup-financial-model-guide). The [Excel best-practices guide](/blog/excel-financial-modeling-best-practices) covers layout and formula consistency, while the [startup runway calculator](/tools/startup-runway-calculator) supplies a quick check. Keep scenarios controlled by clearly labelled switches, not manual overwrites.

### Where can you find a financial model template for a startup?

You can use Finamodel’s [startup financial model](/templates/startup-financial-model) as an integrated template for revenue, headcount, operating expenditure, cash and runway. If the company is subscription-based, add or compare the [SaaS MRR/ARR model](/templates/saas-mrr-arr-model). For a simpler liquidity question, the [runway model](/templates/runway-model) may be more appropriate than a full three-statement workbook.

Choose by decision rather than file size:

| Need | Starting point |
|---|---|
| Integrated operating plan | Startup financial model |
| Subscription roll-forward | SaaS MRR/ARR model |
| Cash survival and raise timing | Runway model |

Before adapting a template, confirm monthly periods, currency, accounting basis, opening cash and funding assumptions. Replace every illustrative input and trace one driver through to cash. For instance, a new salesperson should affect salary immediately, bookings after a ramp period, revenue according to recognition, and cash according to collections.

The [startup examples library](/startups) provides populated cases, and the [startup modelling guide](/blog/startup-financial-model-guide) explains the underlying logic. *A template saves structure, not judgement:* simplify irrelevant sections and add checks before using it for fundraising or hiring decisions.

### Where can you download a free SaaS financial model in Excel?

Finamodel’s [SaaS MRR/ARR model](/templates/saas-mrr-arr-model) is the most relevant downloadable Excel starting point for subscription revenue. Pair it with the [startup financial model](/templates/startup-financial-model) when you need a fuller view of headcount, operating expenditure, cash and funding. Both are starting frameworks; remove example assumptions and verify the workbook before relying on it.

A useful SaaS model should include:

- opening MRR plus new, expansion, contraction and churned MRR;
- customer or cohort counts by plan;
- bookings, billings, revenue recognition and deferred revenue;
- hosting, support and payment costs;
- sales, product, G&A and headcount;
- **ARR, gross margin, NRR, CAC payback, LTV:CAC, burn and runway**.

Trace a simple example: 100 customers at £200 MRR produce £20,000 MRR; 3% monthly customer churn without new sales reduces the customer base to 97 next month. Then confirm revenue, cash and retention metrics update consistently. The [SaaS financial model guide](/blog/saas-financial-model-guide) explains the build, and the [LTV:CAC calculator](/tools/ltv-cac-calculator) offers an independent unit-economics check. Free access does not make illustrative assumptions suitable for your company.