# Capital Markets Financial Model Templates

Free capital markets model templates in Excel - LBO models, M&A and merger analysis, IPO and equity raise models, and trading comps. Built for bankers, private equity associates, and corporate development teams who need a clean, defensible structure for a live process.

Canonical: https://finamodel.com/templates/categories/capital-markets

## Templates

- [DCF Model](https://finamodel.com/templates/dcf-model) - Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.
- [Comparable Companies Analysis](https://finamodel.com/templates/comparable-company-analysis) - Pull trading multiples from peer companies and calculate implied valuation ranges.
- [Mortgage Portfolio Model](https://finamodel.com/templates/mortgage-portfolio-model) - Mortgage loan portfolio analysis with prepayment speeds, default rates, and cash flow projections.
- [Equipment Leasing Model](https://finamodel.com/templates/leasing-model) - Financial model for equipment leasing cash flows, accounting treatment, and lessor/lessee analysis.
- [Trade Finance Underwriting](https://finamodel.com/templates/trade-finance-model) - Model trade finance facilities with collateral coverage, payment terms, and default loss scenarios.
- [ABS CLO Model](https://finamodel.com/templates/abs-clo-model) - Asset-backed securities and collateralized loan obligation analysis.
- [Equity Portfolio Analysis](https://finamodel.com/templates/equity-portfolio-model) - Portfolio-level analytics for equity holdings with performance attribution, risk, and rebalancing.
- [Fixed Income Portfolio Model](https://finamodel.com/templates/fixed-income-portfolio-model) - Bond portfolio analytics with duration, convexity, credit spreads, and yield curve positioning.
- [Hedge Fund Operating Model](https://finamodel.com/templates/hedge-fund-model) - Operating model for hedge funds including investor cash flows, fee structure, leverage, and performance-based compensation.
- [Fund of Funds Portfolio Model](https://finamodel.com/templates/fund-of-funds-model) - Portfolio construction and performance tracking model for fund-of-funds vehicles investing across multiple manager-run funds.
- [Family Office Financial Plan](https://finamodel.com/templates/family-office-model) - Comprehensive financial planning model for family offices with assets, spending, taxes, and legacy.
- [Endowment Fund Model](https://finamodel.com/templates/endowment-model) - Multi-asset portfolio model for endowments with allocation, returns, spending, and perpetual sustainability.
- [Sovereign Wealth Fund Portfolio Model](https://finamodel.com/templates/sovereign-wealth-model) - Asset allocation and performance tracking model for sovereign wealth funds showing allocation drift, returns, and rebalancing mechanics.
- [Target Date Fund](https://finamodel.com/templates/target-date-model) - Model a target date fund with asset allocation glide path, rebalancing, and fee structures by vintage year.
- [Risk Parity Portfolio Model](https://finamodel.com/templates/risk-parity-model) - Allocation framework that weights assets by inverse volatility to achieve equal risk contribution across equities, bonds, and alternatives.
- [Multi-Asset Portfolio Allocation](https://finamodel.com/templates/multi-asset-allocation-model) - Asset allocation model optimizing portfolio construction across equities, bonds, alternatives, and real assets.
- [Dividend Discount Model](https://finamodel.com/templates/dividend-discount-model) - Valuation of dividend-paying stocks using multi-stage dividend growth and terminal yield.
- [Bond Trading Model](https://finamodel.com/templates/bond-trading-model) - Fixed income trading desk P&L and risk analytics.
- [FX Hedging and Portfolio Model](https://finamodel.com/templates/fx-portfolio-model) - Currency exposure tracking and hedging strategy model for multinational companies with multi-currency revenue and cost bases.
- [Commodities Trading Model](https://finamodel.com/templates/commodities-trading-model) - Track commodity positions, hedges, and P&L with mark-to-market and exposure metrics.
- [Insurance Portfolio Risk and Return Model](https://finamodel.com/templates/insurance-portfolio-model) - Portfolio model for insurance investment holdings including asset allocation, duration matching, credit risk, and spread analysis.
- [Chief Risk Officer Dashboard](https://finamodel.com/templates/cro-model) - Aggregate risk metrics and exposures across the organization with heat maps and limits.
- [Convertible Bond Model](https://finamodel.com/templates/convertible-bond-model) - Model convertible bond economics with conversion scenarios, dilution, and bond value.
- [SPAC Merger Economics Model](https://finamodel.com/templates/spac-model) - Financial model for SPAC mergers analyzing trust account, sponsor shares, redemptions, and pro forma ownership after combination.
- [DuPont Analysis](https://finamodel.com/templates/dupont-analysis) - Five-year ROE decomposition into margin, turnover, and leverage with peer benchmark.
- [Earn-Out](https://finamodel.com/templates/earn-out) - 4-year M&A earn-out structure model with revenue and EBITDA targets, per-year and aggregate caps, plus buyer all-in and seller NPV views.
- [Option Pricing](https://finamodel.com/templates/option-pricing) - Black-Scholes call and put prices with Greeks, payoff grid, and two-way sensitivity.
- [Wealth Management](https://finamodel.com/templates/wealth-management) - Plan, value, and assess the returns of a wealth-management or RIA business.
- [Equity Research Initiation Model](https://finamodel.com/templates/equity-research-initiation) - Sell-side equity research initiation model: segment revenue build, consensus estimates bridge, and multi-method valuation.
- [Merger Arbitrage Model](https://finamodel.com/templates/merger-arb) - Merger arbitrage model: collared deal consideration, closing probability from a condition tree and a monthly hazard curve, break downside, and annualised return to close.

## Frequently asked questions

### Are these templates really free to download?

Yes. Every template is a free Excel download with live formulas after email signup. No credit card or paywall is required. Click any template, enter your email, download the .xlsx file, and open it in Excel, Google Sheets, or LibreOffice.

### What's the difference between an LBO and a merger model?

An LBO model values a target through a financial sponsor's lens - entry multiple, debt financing, and exit IRR. A merger model tests accretion/dilution to an acquirer's EPS when one company buys another. Both are in this category.

### Are these models suitable for live deals?

They are institutional-style templates with the standard structure analysts use - sources & uses, financing schedules, and returns output. Always pressure-test the assumptions against your own diligence before relying on them in a transaction.

### Can I edit the models after downloading?

Yes. The free downloads are unlocked Excel workbooks with live formulas, no macros, and no password protection. You can change assumptions, add rows, relabel line items, and adapt the structure.