Skip to content

Excel Models

Professional Excel models for finance professionals

Showing 49 professional models

Showing 49 models in Portfolio Management

Portfolio Management

Dollar-Cost Averaging Calculator Excel Template

Free DCA Excel template for recurring investments, running average cost, period-by-period shares, and DCA vs...
Portfolio Management

Kelly Criterion Calculator Excel Template

Professional Kelly Criterion Excel template for optimal bet sizing and portfolio allocation. Supports gambling and...
Portfolio Management

Commodity Roll Yield Calculator Excel Template

Decompose commodity futures returns into spot, roll yield, and collateral components. Analyze contango vs backwardation...
Portfolio Management

Calmar Ratio Calculator Excel Template

Calculate the Calmar Ratio in Excel with live formulas. Enter CAGR and maximum drawdown to...
Portfolio Management

Time-Weighted Return Calculator Excel Template

Calculate annualized time-weighted return (TWR) to measure investment performance independent of cash flow timing. Industry-standard...
Portfolio Management

Treynor Ratio Calculator Excel Template

Professional Treynor Ratio Excel template with automatic performance rating. Calculate excess return per unit of...
Portfolio Management

Sortino Ratio Calculator Excel Template

Calculate risk-adjusted portfolio performance using downside deviation. Includes Sortino ratio, Sharpe comparison, and volatility metrics.
Portfolio Management

Portfolio Rebalancing Calculator Excel Template

Professional Excel template for corridor-based portfolio rebalancing. Calculates drift, trade amounts, and transaction costs for...
Portfolio Management

Portfolio Beta Calculator Excel Template

Calculate portfolio beta as the weighted average of individual asset betas. Supports up to 10...
Portfolio Management

Pension Funded Status Calculator Excel Template

Calculate funded ratio, project Year 1 pension status, and determine required contributions with this professional...
Portfolio Management

Performance Attribution Calculator Excel Template

Professional Brinson-Fachler attribution analysis with per-sector allocation, selection, and interaction effects. Supports 2-10 sectors.
Portfolio Management

Money-Weighted Return Calculator Excel Template

Professional Money-Weighted Return (IRR) calculator with live Excel formulas. Calculates your actual dollar-weighted investment return...
Search
Contact Ryan

Get in touch

Contact Me

Have a question or want to work together? Fill out the form below and we'll get back to you as soon as possible.

Contact Form Demo

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Results appear as you type. Use the arrow keys to move through them.