Every file below opens in Excel, LibreOffice or Google Sheets. No macros, nothing locked. They are free: one email address opens every download. Each page explains what the model does, shows its worked example, and links to the rest of the companion files for the same book.
Teaching, or building a course or library guide? All 130 models with direct downloads, no sign-up.
Premium packs
The Financial Model Library: all 130 models in one download, plus two modelling books in PDF. $79 →
Real Estate Fund Model, Pro Edition: closed-end fund, up to eight assets, full waterfall, 30 checks, user guide. $129 → · See what is inside
LBO Model, Pro Edition: seven-year buyout, four debt tranches, covenants, management ratchet, 31 checks, user guide. $99 → · See what is inside
Real Estate Acquisition and Development Model, Pro Edition: monthly over 60 months, S-curves, construction loan and mezzanine, JV waterfall, 33 checks, user guide. $99 → · See what is inside
The Pro Models Bundle: the LBO, Development and Fund models, Pro Editions, in one purchase. $199 instead of $327 → · See what is inside
Launch offer until November 30: 20% off any order of $49 or more with the code LAUNCH20 at checkout.
REPE Interview Prep Pack: 18 solved real estate PE interview cases and three Excel models. $129 →
The individual templates stay free. Secure checkout by Stripe.
No download needed: 24 free online calculators, from yield maintenance, NOI and cash-on-cash return to XIRR, safety stock and the R&D tax credit.
- LBO modelSources and uses to sponsor IRR, twelve sheets, every figure checked. From The Buyout Investor.
- Brewery cost per barrel calculatorBarrels by channel, prices and costs in: standard cost per barrel, contribution by channel, EBITDA, DSCR and break-even barrels out. From The Craft Brewery Owner.
- Real estate property modelRent roll, cash flow, debt and returns for one asset, empty and ready to fill. From Real Estate Financial Modeling.
- Residual land valuationDevelopment appraisal with the four downside tests and peak debt. From The Real Estate Development Manager.
- DCF with terminal valuePerpetuity growth and exit multiple side by side, with the TV share of value. From The Private Markets Valuation Specialist.
- Distribution waterfall modelReturn of capital, pref, catch-up and carry, three catch-up readings, European vs deal-by-deal. From Real Estate Fund Management.
- Loan sizing: LTV, LTC, DSCR, debt yieldThe four lender tests at once, the binding one, and a rate shock. From Real Estate Fund Management.
- Direct lending credit modelUnitranche underwriting: coverage, leverage, sweep, base, downside and stress. From The Private Credit Investor.
- Data center financial modelTurnkey, powered shell and powered land on one campus, levered returns and delay. From The Data Center Development Handbook.
- 13-week cash flow modelLiquidity on paper against usable liquidity, a springing covenant and six levers. From The Corporate Restructuring Handbook.
- Income tax provision templateCurrent tax, the deferred tax rollforward by category and the rate reconciliation in the eight categories of ASU 2023-09, in dollars and in percent, worked on a fictional 2025 year. From The Income Tax Provision Handbook.
- Transfer pricing benchmark templateComparables, the interquartile range and the median by the counting rule of the regulation, a tested party below the range and the true-up. From The Transfer Pricing Professional.
- Roofing business modelJob costing per square, the lead funnel, a P&L with adjusted EBITDA and SDE, crew capacity, break-even, the storm normalization, a three-year plan and two offers for the company. From The Roofing Company Owner.
- Pest control business modelCustomers and churn, technician capacity, a P&L with adjusted EBITDA and SDE, what a customer is worth, a three-year plan and two offers for the company. From The Pest Control Business Owner.
- ESOP transaction modelA 100% leveraged ESOP buyout: seller note and warrants, the 25% test, ten years of cash waterfall, a stress case and the repurchase schedule. From The ESOP Handbook.
- SaaS metrics board modelEight quarters in, one board page out: ARR bridge, quick ratio, CAC payback, magic number, burn multiple, Rule of 40 and runway to the covenant. From The SaaS CFO.
- Small business acquisition model (SBA loan)SBA 7(a) loan sized in closed form, lender coverage against cash coverage, exit returns. From Buying a Small Business.
- 3-statement financial modelFive-year forecast feeding a DCF and an LBO on one case, with a blank build. From Financial Modeling from First Principles.
- Project finance modelSolar and storage project, debt sculpted to a 1.35x DSCR, no circularity. From The Project Finance Handbook.
- REIT valuation modelFFO, AFFO, NAV and the implied cap rate for one REIT, plus an empty template. From REIT Analysis and Valuation.
- Self-storage financial modelCohort rent roll, break-even occupancy, ten-year hold and the bid for one store. From Self-Storage Real Estate.
- Credit Manager WorkbookDSO three ways, CEI, credit limits by capacity and need, and the bad debt reserve. From The Commercial Credit Manager.
- ASC 606 Revenue WorkbookSSP allocation, variable consideration, revenue schedule, contract balances and commissions. From The Revenue Recognition Handbook.
- Tax lien certificate yield calculatorBid, minimum charge and redemption month turned into a real annual yield. From The Tax Lien Investor.
- Sale and leaseback modelNine buildings, the price split five ways, rent cover on the entity that signs. From Sale and Leaseback.
- PME calculatorKaplan-Schoar PME, PME+, Direct Alpha, IRR and TVPI on one fund's cash flows. From Private Markets Performance.
- Working capital peg modelFive peg definitions, the completion-date effect, locked box against completion accounts. From Closing the Deal.
- JV waterfall and promote modelSponsor against capital partner: pref, IRR hurdles and the promote in a two-party JV. From Real Estate Joint Ventures.
- Student housing modelA 520-bed scheme from rate card to RevPAB, costs, capex cycle and exit value. From Student Housing Real Estate.
- Net effective rent calculatorHeadline rent to net effective rent after rent-free and incentives, and back again. From Office Real Estate.
- VaR and expected shortfall modelParametric VaR and expected shortfall step by step, crisis correlations and a backtest. From Financial Risk Management.
- Corporate liquidity modelMinimum liquidity, revolver headroom and the covenant test that takes the revolver away. From Treasury Management.
- Co-investment fee savings modelWhat an LP co-investment programme saves in fees, its break-even loss rate and deal count. From The Private Markets Limited Partner.
- Accretion and dilution modelCombined EPS over five years under four conventions, purchase price allocation and a year-one bridge. From Mergers and Acquisitions.
- Budget vs actual variance analysisBudget vs actual variance analysis: one quarter against budget, prior year, forecast, last quarter and plan. From Financial Planning and Analysis.
- Cap rate and exit yield calculatorSix entry yields against the exit yield (cap rate), the sale price and the promote it buys. From Commercial Real Estate Investing.
- Comparable company analysisTrading multiples, precedent deals, quartiles and the control premium converted into annual synergies. From Business Valuation.
- Fulcrum security recovery modelA $600m enterprise value walked down $850m of claims: recoveries, the fulcrum, and where it moves. From The Distressed Debt Investor.
- Price volume mix analysisPrice volume mix analysis: volume, price, cross term, a group bridge and the margin split into mix and price. From Financial Planning and Analysis.
- Private equity fund cash flow modelCapital calls and distributions as inputs: J-curve, TVPI, DPI, IRR and the commitment a target really needs. From Alternative Investments.
- LP secondary pricing modelAn LP interest bought at 88 for a NAV of 100: IRR, MOIC, where the return comes from, and a stress. From The Private Equity Secondaries Investor.
- Subscription line IRR calculatorWhat a capital call facility does to IRR and to cash: 20.00% becomes 38.41% while the multiple falls. From The Fund Finance Professional.
- Venture capital fund modelA 28-company fund: fees with step-down, carry by year and under five conventions, J-curve, gross vs net IRR. From Venture Capital.
- Run-rate EBITDA bridgeReported to adjusted, pro forma and run-rate EBITDA, each line with the buyer's haircut and the price of the gap. From Mergers and Acquisitions.
- Bank stress test: PPNR, CET1 and MDANine quarters of PPNR, provisions, RWA and CET1, base and adverse, against the MDA threshold. From Bank Management.
- Lease-adjusted leverage calculatorEBITDAR, debt plus 8x rent against IFRS 16 lease liabilities, fixed charge cover and a peer that owns. From Credit Analysis.
- Solvency II SCR calculatorThe standard formula, simplified: market, default, life and non-life modules, the Annex IV matrices, Basic SCR, operational risk and the ratio. From Insurance Capital for Asset Managers.
- Implied cap rate calculatorThe cap rate a REIT share price pays for the buildings: enterprise value, forward NOI, the spread to private market and the discount to NAV. From REIT Analysis and Valuation.
- Dimson beta calculatorLagged market regression on smoothed quarterly fund returns: simple beta 0.50, three-lag Dimson beta 0.97, and the unsmoothed series. From Private Markets Performance.
- Commercial real estate underwriting modelA 312-unit value-add deal underwritten to a levered IRR, five sensitivities, the maximum bid for a 14% target, and an industrial retrade. From The Real Estate Acquisitions Analyst.
- Real estate DCF modelA ten-year discounted cash flow for a multi-let office, quarter by quarter and lease by lease, with voids, rent-free, fit-out and the exit. From Office Real Estate.
- Borrowing base calculatorA borrowing base certificate computed from a 1,880-contract tape: eligibility, concentration limits, advance rate, reserves and headroom. From The Asset-Based Finance Handbook.
- Debt sculpting modelDebt service sculpted to a minimum DSCR on a toll road concession: binding year, debt quantum, maintenance reserve and the equity IRR. From The Infrastructure Investment Analyst.
- Black-Scholes and binomial option pricingOne call priced by Black-Scholes, a binomial lattice at any step count and Monte Carlo, then the spread between models against the volatility input. From Quantitative Finance.
- Safety stock calculatorSafety stock with uncertain demand and lead time, the cycle service level against the fill rate, EOQ, and the service level priced in euros. From Supply Chain Management.
- Mortgage note pricing modelA non-performing mortgage note bid from its foreclosure floor, reinstatement, modification and deed-in-lieu paths, and an eight-loan tape priced loan by loan. From The Mortgage Note Investor.
- Forecast bias and accuracy calculatorForecast error split into bias and noise, mean absolute error before and after removing the bias, and the next quarter's forecast corrected. From Financial Planning and Analysis.
- LCR and NSFR calculatorThe liquidity coverage ratio and the net stable funding ratio for one bank, HQLA after encumbrance, 30-day outflows and inflow cap, ASF and RSF. From Financial Regulation.
- Risk-weighted assets (RWA) calculatorRisk-weighted assets for one bank on the standardised and internal-model ladders, the mortgage loan split, capital ratios and the output floor year by year. From Financial Regulation.
- Credit scorecard modelA credit scorecard built from 8,400 applications: bins, weight of evidence, information value, the points scale and a leaking characteristic. From Machine Learning for Finance.
- Price waterfall analysisList to invoice to pocket price for one account and for 458 account lines: nine leakages ranked, the pocket price band and who gives the discount. From Pricing Strategy.
- Capital call and distribution templateAn investor register, a capital call allocated pro rata, a distribution through the waterfall, and the capital account roll tied to NAV. From The Private Equity Fund Controller Playbook.
- Value creation bridgeEntry equity to exit equity in six buckets with a zero residual: organic growth, add-ons net of cash, market, multiple, cross-term and deleveraging. From The Private Equity Operating Partner.
- Aircraft lease modelAn aircraft sale-leaseback from lease rate factor to unlevered and levered IRR, residual sensitivity, return conditions, repossession, ABS and lessor ROE. From The Aircraft Leasing Professional.
- Ship finance modelA term loan on six bulk carriers with LTV tests, cure and release prices, a bareboat lease with purchase options, a default and recovery, and the lending fund's waterfall. From The Ship Finance Professional.
- Cell tower valuation modelOne tower with one to three tenants, then a 1,200-tower portfolio over ten years: multiples, DCF, ground lease buyouts, securitisation against term loan, and returns. From The Wireless Tower Investor.
- Quality of earnings (QoE) templateA quality of earnings bridge from reported to diligence-adjusted EBITDA, net debt and debt-like items, the working capital peg and the closing statement. From The Financial Due Diligence Associate.
- Bond price, DV01 and duration calculatorBond price, DV01 and modified duration, yield shocks, roll-down, a DV01-neutral 2s10s steepener, a hedged client trade, limits and desk P&L. From The Fixed Income Trader.
- LTV and CAC unit economics modelCustomer lifetime value by horizon under net revenue retention, the acquisition cost that reverses growth, and what survives a cut in marketing. From The Venture Capital Associate.
- ABS, CLO and RMBS waterfall modelMonthly and quarterly cash flow waterfalls for an auto ABS, a CLO under base, stress and severe defaults, and a non-QM RMBS, tranche by tranche. From The Structured Credit Analyst.
- Partnership flip tax equity modelA solar partnership flip from the ITC and its bonuses to the flip year and IRR, capital accounts and the DRO, credit transfer, recapture, back-leverage and HLBV. From The Tax Equity Investor.
- Battery storage (BESS) financial modelA 200 MW / 800 MWh battery from degradation and augmentation to merchant revenue, merchant, toll and floor cases, debt sizing, the credit and development value. From The Battery Storage Development Handbook.
- Population stability index (PSI) calculatorPopulation stability index on fixed score bands, band by band, and the reject inference problem: the bad rate of declined applicants. From Machine Learning for Finance.
- Early payment discount calculatorThe annual rate hidden in an early payment discount, the cash conversion cycle in money, supply chain finance for both sides, and a cash pool. From Treasury Management.
- Discount break-even calculatorThe break-even volume of a price cut and of a price rise at the real pocket margin, four profit levers, the rebate cliff and the rate hidden in payment terms. From Pricing Strategy.
- NAV facility LTV modelA NAV facility underwritten from reported NAV to eligible NAV and loan to value, a downside by bucket, and the second decline. From The Fund Finance Professional.
- Reserve-based lending (RBL) modelAn oil and gas borrowing base from three reserve reports at the bank deck, hedge credit, advance rate, a deficiency and its cure, covenants and a PDP ABS. From The Oil and Gas Lender.
- IPO pricing modelAn IPO from primary and secondary shares, greenshoe, free float and fees to the IPO discount, book coverage, first-day return and a follow-on block. From The Equity Capital Markets Banker.
- Mortgage DTI and underwriting calculatorA mortgage file from qualifying income to PITI, housing ratio and DTI, funds to close and reserves, a low appraisal, FHA and VA contrast files and a repurchase. From The Mortgage Underwriter.
- Care home valuation modelA 70-bed care home built from admissions, length of stay and payor conversion to fees, staff hours, EBITDARM, rent cover and value on the trade and on the lease. From Senior Living and Healthcare Real Estate.
- Venture debt modelA venture loan with two tranches, fees, a prepayment and warrants valued by Black-Scholes, runway, the lender's IRR, a recovery and the fund's net return. From The Venture Debt Lender.
- Pro rata and dilution calculatorPro rata rights through two follow-on rounds: the cheque, ownership defended or diluted, multiple and IRR, the exit at which follow-ons lose money, and fund reserves. From The Growth Equity Investor.
- Month-end close and covenant modelThe month-end close corrections, a contract allocated by standalone selling price, volume, price and cost variances, and a leverage covenant certificate. From The Financial Controller.
- CMBS deal modelA $1bn twenty-loan CMBS from the tape to a fourteen-class capital structure, credit support, loan-by-loan liquidations, five stress scenarios and surveillance. From CMBS and CRE CLOs.
- Loan amortization scheduleA fixed-rate loan repaid monthly over up to 30 years: payment, schedule, total interest, and what an extra monthly payment saves. From Real Estate Finance.
- Rental property calculatorOne rental property bought with a mortgage: NOI, cap rate, cash flow, cash-on-cash, DSCR, the 1% rule and a ten-year IRR with a sale. From Commercial Real Estate Investing.
- Fix and flip and BRRRR calculatorA distressed house run two ways: a flip with hard money (profit, return on cash, the 70% rule) and a BRRRR refinance (cash left in, cash flow). From The Real Estate Development Manager.
- XIRR, NPV and IRR calculatorIrregular dated cash flows turned into XIRR and XNPV, compared with the periodic IRR and NPV, money multiple and the NPV() first-period error. From Financial Modeling from First Principles.
- 12-month cash flow forecastA small company's cash month by month for a year, from sales and collection timing to suppliers, payroll, capex and tax, with the buffer and the credit line needed. From Treasury Management.
- Startup financial model (SaaS)A SaaS startup over 24 months: customers, churn, MRR and ARR, gross margin, CAC, team cost, burn, runway, LTV to CAC and the round size needed. From Venture Capital.
- Private credit fund modelA levered direct lending fund over eight years: called capital, gross assets, interest and fees, borrowing cost, losses, management and incentive fees, net IRR. From The Private Credit Investor.
- Hotel acquisition modelA 150-key hotel from occupancy, ADR and RevPAR to GOP, base and incentive management fees, FF&E reserve, NOI, and a five-year unlevered and levered IRR. From How to Read a Hotel Management Agreement.
- Cap table and exit waterfallA startup cap table through a post-money SAFE, a seed and a Series A with option pool top-ups, and the exit waterfall under 1x non-participating preferences. From Venture Capital.
- WAULT calculatorWAULT to expiry and to break, rent and area weighted, vacancy at ERV and the expiry profile. From The Real Estate Asset Manager.
- Brinson attribution modelBrinson performance attribution: allocation, selection and interaction by segment, reconciled to the active return. From Asset Management.
- Should-cost modelShould-cost model: a supplier price rebuilt from material, machine time and mark-ups, with the gap attributed by driver. From Contract Management.
- Yield maintenance and defeasance calculatorYield maintenance and defeasance: the prepayment cost of a fixed-rate commercial mortgage, both ways, with a rate grid. From How to Read a Real Estate Loan Agreement.
- DPI, TVPI and net IRR templateDPI, RVPI and TVPI, the net IRR with and without the NAV, PME and the subscription line effect. From Private Equity Investor Relations.
- Evergreen vs drawdown fund calculatorEvergreen net return against a drawdown IRR on committed capital, share classes, PME and volatility. From The Evergreen Fund Handbook.
- Family office cost calculatorA single-family office's annual cost against a multi-family office fee, the crossover and the hurdle. From The Family Office Professional.
- Operational due diligence scorecardEight risk domains, veto rules and twelve fund managers rated by averaging and by veto. From Operational Due Diligence in Private Equity.
- Co-investment follow-on and reserve modelFollow on or not through a down round, plain dilution against pay-to-play, and the optimal reserve. From The Co-Investment Practitioner.
- KYC remediation capacity modelBack book segmentation, analyst-days, a one-year against a five-year plan and the outreach funnel. From The EU AML Handbook.
- ESG value creation modelAn ESG programme's EBITDA effect carried to equity, MOIC and IRR, and the value it protects. From The ESG Manager in Private Equity.
- AUM and net flow forecast modelGross flows, redemptions, net flows and AUM over 84 months from platforms and advisor conversion. From The Private Wealth Fundraiser.
- Loan pricing and return on capital calculatorMargin and fees to net spread and return on capital for two loans, the PD tie, a floor and prepayment. From The Real Estate Debt Investor.
- Reinsurance model: quota share to cat XLQuota share, sliding scale commission, surplus, stop loss, cat layers, reinstatements and burning cost. From The Reinsurance Professional.
- Loan workout options modelEnforcement, extension, discounted payoff and consensual sale priced as present values. From The Real Estate Workout.
- Fundraising funnel and timeline modelLP funnel, the founder's meeting diary, committee dates, the first close and the cash burn. From Raising a Real Estate Fund.
- Compound interest and fees calculatorEarly against late investing, what a 1% fee costs over forty years, and today's money. From Stock Market Investing for Beginners.
- Debt snowball vs avalanche calculatorMinimums only, avalanche against snowball month by month, and the cost of an emergency fund. From Personal Finance for Beginners.
- European Defence Fund funding rate calculatorEDF funding rates and bonuses, the co-financing each partner finds, EDIP windows and scoring. From Breaking Into European Defence Procurement.
- Real estate capital stack calculatorSenior, mezzanine, preferred and common equity, DSCR, debt yield, blended cost and leverage. From Private Equity Real Estate.
- Fund formation modelLaunch budget, management fees by close, equalization for later investors and the manco P&L. From The Fund Formation Handbook.
- Litigation finance modelCase draws, outcomes, MOIC and IRR, the funder waterfall, a portfolio and award monetization. From The Litigation Finance Investor.
- Industrial development and letting modelMonthly carry, four letting outcomes weighted, expected profit and the land residual. From Logistics and Industrial Real Estate.
- 13-week cash flow, ABL availability and variance templateReceipts from the aging, availability against a springing trigger, and variance tagged timing or permanent. From The 13-Week Cash Flow Handbook.
- SRT investor return modelFirst-loss tranche cash flows, IRR with and without leverage, break-even losses and stresses. From Significant Risk Transfer.
- Development appraisal and cost headroomProfit on cost at contract sum and final account, break-even construction cost and headroom. From Construction Cost Control.
- Secondaries discount to NAV calculatorDiscount to NAV restated to spot value, to all capital deployed and net of fees to term. From The Real Estate Secondaries Investor.
- Commercial loan and covenant modelSources and uses, leverage and FCCR covenants by quarter, borrowing base and collateral. From The Commercial Banker.
- Laundromat acquisition modelNet income to SDE, the seller's unpaid hours, the offer and an SBA 7(a) loan with its checks. From The Laundromat Owner.
- ASC 842 lease accounting modelLease liability, right-of-use asset, monthly schedule, entries and classification tests under ASC 842. From The Lease Accounting Handbook.
- Med spa treatment margin and break-even calculatorContribution per neurotoxin treatment and filler syringe, per room hour, the member discount and break-even treatments. From The Med Spa Owner.
- Home care bill rate and break-even calculatorThe aide's full cost per hour, the lowest bill rate for a target margin and the weekly break-even. From The Home Care Agency Owner.
- Child care center break-even and ratio plannerRatios to teacher slots room by room, open places under the license, and break-even enrollment of a center. From The Child Care Center Owner.
- Auto repair shop acquisition modelNet income to SDE, rent at market, the owner's job, the offer and an SBA 7(a) loan with its checks. From The Auto Repair Shop Owner.
- purchase price allocation modelConsideration, earn-out, intangible asset valuations, deferred taxes, goodwill and impairment under ASC 805 and ASC 350. From The Purchase Price Allocation Handbook.
- Optometry practice revenue per patient and break-even calculatorRevenue per patient seen, optical gross margin, break-even exams a month and ten more points of capture. From The Optometry Practice Owner.
- Pharmacy margin per prescription and break-even calculatorThe margin of a generic and a brand prescription, and the prescriptions a day a pharmacy needs to break even. From The Independent Pharmacy Owner.
Articles — worked arithmetic from the books →