Macaulay Duration Formula

Fx Copy
LaTeX Copy
Macaulay Duration is the weighted average time until cash flows are received. Check FAQs
Macaulaydur=(x,1,5,cfn,((CF1+YTMnc)cfn))(TyrsPV)
Macaulaydur - Macaulay Duration?cfn - Cash Flow Number?CF - Cash Flow?YTM - Yield to Maturity (YTM)?nc - Compounding Periods?Tyrs - Time in Years?PV - Present Value?

Macaulay Duration Example

With values
With units
Only example

Here is how the Macaulay Duration equation looks like with Values.

Here is how the Macaulay Duration equation looks like with Units.

Here is how the Macaulay Duration equation looks like.

2Edit=(x,1,5,5Edit,((1050Edit1+12Edit10Edit)5Edit))(4Edit10Edit)
You are here -
HomeIcon Home » Category Financial » Category Business » fx Macaulay Duration

Macaulay Duration Solution

Follow our step by step solution on how to calculate Macaulay Duration?

FIRST Step Consider the formula
Macaulaydur=(x,1,5,cfn,((CF1+YTMnc)cfn))(TyrsPV)
Next Step Substitute values of Variables
Macaulaydur=(x,1,5,5,((10501+1210)5))(410)
Next Step Prepare to Evaluate
Macaulaydur=(x,1,5,5,((10501+1210)5))(410)
LAST Step Evaluate
Macaulaydur=2

Macaulay Duration Formula Elements

Variables
Functions
Macaulay Duration
Macaulay Duration is the weighted average time until cash flows are received.
Symbol: Macaulaydur
Measurement: NAUnit: Unitless
Note: Value should be greater than 0.
Cash Flow Number
Cash Flow Number refers to the serial wise number of cash flow which is to be used while adding.
Symbol: cfn
Measurement: NAUnit: Unitless
Note: Value should be greater than 0.
Cash Flow
Cash Flow, in general, refers to payments made into or out of a business, project, or financial product.
Symbol: CF
Measurement: NAUnit: Unitless
Note: Value should be greater than 0.
Yield to Maturity (YTM)
Yield to maturity (YTM) is the total return anticipated on a bond if the bond is held until the end of its lifetime.
Symbol: YTM
Measurement: NAUnit: Unitless
Note: Value can be positive or negative.
Compounding Periods
Compounding Periods is the number of times compounding will occur during a period.
Symbol: nc
Measurement: NAUnit: Unitless
Note: Value can be positive or negative.
Time in Years
Time in Years refers to a duration or period measured in terms of the number of years elapsed or anticipated.
Symbol: Tyrs
Measurement: NAUnit: Unitless
Note: Value should be greater than 0.
Present Value
The present value of the annuity is the value that determines the value of a series of future periodic payments at a given time.
Symbol: PV
Measurement: NAUnit: Unitless
Note: Value can be positive or negative.
sum
Summation or sigma (∑) notation is a method used to write out a long sum in a concise way.
Syntax: sum(i, from, to, expr)

Other formulas in Business category

​Go Retention Ratio
RR=NI-DNI
​Go Inventory Shrinkage
IS=(RI-IRI)100

How to Evaluate Macaulay Duration?

Macaulay Duration evaluator uses Macaulay Duration = sum(x,1,5,Cash Flow Number,((Cash Flow/(1+Yield to Maturity (YTM)/Compounding Periods))^Cash Flow Number))*(Time in Years/Present Value) to evaluate the Macaulay Duration, The Macaulay Duration formula helps to find the present value of a bond’s future coupon payments and maturity value. Macaulay Duration is denoted by Macaulaydur symbol.

How to evaluate Macaulay Duration using this online evaluator? To use this online evaluator for Macaulay Duration, enter Cash Flow Number (cfn), Cash Flow (CF), Yield to Maturity (YTM) (YTM), Compounding Periods (nc), Time in Years (Tyrs) & Present Value (PV) and hit the calculate button.

FAQs on Macaulay Duration

What is the formula to find Macaulay Duration?
The formula of Macaulay Duration is expressed as Macaulay Duration = sum(x,1,5,Cash Flow Number,((Cash Flow/(1+Yield to Maturity (YTM)/Compounding Periods))^Cash Flow Number))*(Time in Years/Present Value). Here is an example- 2 = sum(x,1,5,5,((1050/(1+12/10))^5))*(4/10).
How to calculate Macaulay Duration?
With Cash Flow Number (cfn), Cash Flow (CF), Yield to Maturity (YTM) (YTM), Compounding Periods (nc), Time in Years (Tyrs) & Present Value (PV) we can find Macaulay Duration using the formula - Macaulay Duration = sum(x,1,5,Cash Flow Number,((Cash Flow/(1+Yield to Maturity (YTM)/Compounding Periods))^Cash Flow Number))*(Time in Years/Present Value). This formula also uses Summation Notation Function function(s).
Copied!