Templates & Downloads

Access our collection of financial templates, models, and guides

Duration, Convexity, Price Yield Curve Spreadsheet

Duration, Convexity, Price Yield Curve Spreadsheet

Member Only

This spreadsheet shows the relationship between price and yield where price is calculated using actual formula, and using the duration-convexity estimate.

Excel Template
Excel
Article Link
Duration Calculator Excel

Duration Calculator Excel

Member Only

This excel calculator helps you to calculate the duration and modified duration of a bond.

Excel Template
Excel
Bond Price and Yield Using Zero Curve Spreadsheet

Bond Price and Yield Using Zero Curve Spreadsheet

Member Only

This spreadsheet demonstrates how to calculate the price and yield of a bond using the zero curve.

Excel Template
Excel
Options Pricing and Geeks Spreadsheet

Options Pricing and Geeks Spreadsheet

Member Only

Download the options pricing and geeks spreadsheet.

Excel Template
Excel
Options Pricing using Monte Carlo Simulation Spreadsheet

Options Pricing using Monte Carlo Simulation Spreadsheet

Member Only

This spreadsheet illustrates how to calculate the price of a call option using Monte Carlo Simulation.

Excel Template
Excel
Efficient Frontier in Excel - Guide

Efficient Frontier in Excel - Guide

Member Only
PDF Guide
PDF
Covariance Correlation Calculator

Covariance Correlation Calculator

Member Only
Excel Template
Excel
EWMA Correlation and Volatility

EWMA Correlation and Volatility

Member Only
Excel Template
Excel
Foreign Exchange Rates

Foreign Exchange Rates

Member Only
Excel Template
Excel
Real Estate Valuation - Income Approach

Real Estate Valuation - Income Approach

Member Only
Excel Template
Excel
MCC Schedule

MCC Schedule

Member Only
Excel Template
Excel
Stock Evaluator

Stock Evaluator

Member Only
Excel Template
Excel
Sensitivity Analysis

Sensitivity Analysis

Member Only

Sensitivity Analysis (Duration and Convexity)

Excel Template
Excel
Volatility Calculator

Volatility Calculator

Member Only
Excel Template
Excel
Profitability Index Calculator

Profitability Index Calculator

Member Only
Excel Template
Excel
Jensens Alpha Calculator

Jensens Alpha Calculator

Member Only
Excel Template
Excel
Monte Carlo Simulation - Single Asset Template

Monte Carlo Simulation - Single Asset Template

Member Only

This spreadsheet provides a step-by-step example of how to calculate the VaR of an asset using Monte Carlo Simulation.

Excel Template
Excel
Parametric VaR Spreadsheet

Parametric VaR Spreadsheet

Member Only

This spreadsheet helps you calculate the VaR of a two-asset and a three-asset portfolio using the Parametric VaR method.

Excel Template
Excel