Capital Markets Financial Model Templates

Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.

Pull trading multiples from peer companies and calculate implied valuation ranges.

Mortgage loan portfolio analysis with prepayment speeds, default rates, and cash flow projections.

Financial model for equipment leasing cash flows, accounting treatment, and lessor/lessee analysis.

Model trade finance facilities with collateral coverage, payment terms, and default loss scenarios.

Asset-backed securities and collateralized loan obligation analysis.

Portfolio-level analytics for equity holdings with performance attribution, risk, and rebalancing.

Bond portfolio analytics with duration, convexity, credit spreads, and yield curve positioning.

Operating model for hedge funds including investor cash flows, fee structure, leverage, and performance-based compensation.

Portfolio construction and performance tracking model for fund-of-funds vehicles investing across multiple manager-run funds.

Comprehensive financial planning model for family offices with assets, spending, taxes, and legacy.

Multi-asset portfolio model for endowments with allocation, returns, spending, and perpetual sustainability.

Asset allocation and performance tracking model for sovereign wealth funds showing allocation drift, returns, and rebalancing mechanics.

Model a target date fund with asset allocation glide path, rebalancing, and fee structures by vintage year.

Allocation framework that weights assets by inverse volatility to achieve equal risk contribution across equities, bonds, and alternatives.

Asset allocation model optimizing portfolio construction across equities, bonds, alternatives, and real assets.

Valuation of dividend-paying stocks using multi-stage dividend growth and terminal yield.

Fixed income trading desk P&L and risk analytics.

Currency exposure tracking and hedging strategy model for multinational companies with multi-currency revenue and cost bases.

Track commodity positions, hedges, and P&L with mark-to-market and exposure metrics.

Portfolio model for insurance investment holdings including asset allocation, duration matching, credit risk, and spread analysis.

Aggregate risk metrics and exposures across the organization with heat maps and limits.

Model convertible bond economics with conversion scenarios, dilution, and bond value.

Financial model for SPAC mergers analyzing trust account, sponsor shares, redemptions, and pro forma ownership after combination.

Five-year ROE decomposition into margin, turnover, and leverage with peer benchmark.

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.

Black-Scholes call and put prices with Greeks, payoff grid, and two-way sensitivity.

Plan, value, and assess the returns of a wealth-management or RIA business.

Sell-side equity research initiation model: segment revenue build, consensus estimates bridge, and multi-method valuation.

Merger arbitrage model: collared deal consideration, closing probability from a condition tree and a monthly hazard curve, break downside, and annualised return to close.