Templates
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This spreadsheet shows the relationship between price and yield where price is calculated using actual formula, and using the duration-convexity estimate.
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This excel calculator helps you to calculate the duration and modified duration of a bond.
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This spreadsheet demonstrates how to calculate the price and yield of a bond using the zero curve.
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
Download the options pricing and geeks spreadsheet.
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This spreadsheet illustrates how to calculate the price of a call option using Monte Carlo Simulation.
![No Image](/_next/image?url=%2Fpdf-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
Sensitivity Analysis (Duration and Convexity)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This spreadsheet provides a step-by-step example of how to calculate the VaR of an asset using Monte Carlo Simulation.
![No Image](/_next/image?url=%2Fexcel-icon.png&w=128&q=75)
This spreadsheet helps you calculate the VaR of a two-asset and a three-asset portfolio using the Parametric VaR method.