Analytical Approach to Calculating VaR (Variance-C...We earlier saw how VaR can be calculated using the parametric method. We will now look at this metho...

Lessons

- What is Macaulay Duration?
- Duration of a Bond - Video
- Calculating the Macaulay Duration Using Excel
- Properties of Duration
- Modified Duration of a Bond
- Calculating Price and Yield of a Bond Using Zero Curve
- Price-Yield Relationship
- Current Yield of a Bond
- Basis Point Value (BPV / DV01)
- Quick Approximation of Price Value of a Basis Point (PVBP)

# Calculating the Macaulay Duration Using Excel

This video takes a simple example and demonstrates how the duration of the bond is calculated using excel. In this example, The bond has a duration of 20 years, and pays annual coupon of 3%. The current market interest rates are 4%.

Download the duration calculator to calculate the duration and modified duration of a bond.

#### Lesson Resources

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

Member-only

### You may find these interesting

Calculating VaR Using Historical SimulationThe fundamental assumption of the Historical Simulations methodology is that you base your results o...

Calculating VaR using Monte Carlo SimulationMonte Carlo Simulations correspond to an algorithm that generates random numbers that are used to co...

CFA Calculator: Financial Calculator for CFA ExamIn order to work with quantitative sections of the study material, it is important that you be able ...

Hedging Derivative Products Using GreeksTo understand how a commercial bank dealer hedges a derivative exposure, four key terms must be iden...

Bond Duration and Convexity Simplified – Part 1 of...While analyzing bonds, it is important to apply the concepts of duration and convexity. Duration has...

Bond Duration and Convexity Simplified – Part 2 of...As we learnt in [part 1](https://financetrain.com/bond-duration-and-convexity-simplified-part-1-of-2...

Annuity Functions in ExcelMicrosoft Excel provides various functions to perform constant annuity calculations. These functions...

Calculating Net Present Value (NPV) and Internal R...### Net Present Value (NPV) Function
The NPV function calculates the present value of a series of c...

Introduction to SuperMontage used by NASDAQSuperMontage is a very powerful fully integrated order entry and execution system used by NASDAQ.
I...

Finance Train Premium

Accelerate your finance career with cutting-edge data skills.

Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.

I WANT TO JOINJOIN 30,000 DATA PROFESSIONALS

## Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.