Templates


No Image
Duration, Convexity, Price Yield Curve Spreadsheet

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

Article Link
Excel Template
Excel
No Image
Duration Calculator Excel

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

Excel Template
Excel
No Image
Bond Price and Yield Using Zero Curve Spreadsheet

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

Excel Template
Excel
No Image
Options Pricing and Geeks Spreadsheet

Download the options pricing and geeks spreadsheet.

Excel Template
Excel
No Image
Options Pricing using Monte Carlo Simulation Spreadsheet

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

Excel Template
Excel
No Image
Efficient Frontier in Excel - Guide

PDF Guide
PDF
No Image
Covariance Correlation Calculator

Excel Template
Excel
No Image
EWMA Correlation and Volatility

Excel Template
Excel
No Image
Foreign Exchange Rates

Excel Template
Excel
No Image
Real Estate Valuation - Income Approach

Excel Template
Excel
No Image
MCC Schedule

Excel Template
Excel
No Image
Stock Evaluator

Excel Template
Excel
No Image
Sensitivity Analysis

Sensitivity Analysis (Duration and Convexity)

Excel Template
Excel
No Image
Volatility Calculator

Excel Template
Excel
No Image
Profitability Index Calculator

Excel Template
Excel
No Image
Jensens Alpha Calculator

Excel Template
Excel
No Image
Monte Carlo Simulation - Single Asset Template

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

Excel Template
Excel
No Image
Parametric VaR Spreadsheet

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

Excel Template
Excel