CFA® Exam: Computing Horizon Yield Using IRR & MOD
soleadea
1 year 1 week 1 day
This blog post was created as a part of the CFA exam review series to help you in your level 1 exam revision, whether done regularly or shortly before your CFA exam.
How to calculate the horizon yield in the most efficient and fastest way using an approved CFA exam calculator?
Look at the example below:
An investor purchased an option-free bond with 6 years to maturity, the par value equal to USD 100, and both an annual coupon and a yield to maturity equal to 10%. What is the realized rate of return if the investor holds the bond till maturity and reinvests all coupons at 11%?
Before we begin our calculations, we should notice that the purchase price of the bond has to be USD 100 (the bond is selling at par) because the coupon rate is equal to the yield to maturity.
Let's solve this example using two different approaches. First, we will calculate the horizon yield in an 'algebraic way'. Then, we will use the TIBA Professional CF and IRR worksheets.
Horizon Yield: Algebraic Way
First, we have to calculate the future value of coupon payments:
\(\text{FV of coupons}=10\times1.11^5+10\times1.11^4+10\times1.11^3+\\+10\times1.11^2+10\times1.11+10=\text{USD }79.1286\)
and then we solve the following equation:
\(100=\frac{100+79.1286}{(1+r)^6}\)
So:
\(100\times(1+r)^6=100+79.1286\)
\((1+r)^6=\frac{100+79.1286}{100}\)
>\((1+r)^6=1.7913\)
\((1+r)=1.7913^{1/6}\)
\(r=1.7913^{1/6}-1\)
The calculator keystroke sequence (calculator set in chain mode) for the last part is:
\(1.7913\) 
.png)
\(1.1020 - 1 = 10.20\%\)
\(r = 10.20\%\)
Using CF and IRR Worksheets to Compute Horizon Yield
Here's how to compute the horizon yield using the CF and IRR worksheets in your CFA exam approved calculator (TIBA Plus Professional):
Press 
to enter the CF worksheet
Press 
to clear the CF worksheet
\(CF0=-100\)
\(C01=10\)\(F01=5\) [first five coupons]
\(C02=110\)[= last coupon (10) + face value (100)] \(F02=1\)
Press 
to enter the IRR worksheet
\(IRR\)
[calculate the internal rate of return]
\(RI=11\)[set the reinvestment rate]
\(MOD=10.20\%\)
MOD stands for the modified rate of return and is equal to the horizon yield.
To Sum Up
As you can see both approaches give us the same result, which is definitely good news;) But you should also notice that the second one is much quicker. Usually, the Curriculum doesn't teach you how to solve exam problems the fastest way, but WE DO. Set up your study plan and get all the CFA exam materials and tools that we have prepared for you.
Get More Study & Review Resources
Are you interested in the pros and cons of CFA exam approved calculators? Definitely, visit our CFA exam blog for more information, not only on the calculators authorized by CFA Institute!
LAST UPDATE: 1 Nov 2023
About Soleadea:
Our CFA Exam Study Planner is available to candidates of all levels at groundbreaking Pay-What-You-Can prices. You decide how much you want to pay for our services. After you activate your account, you get unlimited access to our Study Planner 4.0 with study lessons inside, various level 1/level 2 study materials & tools, regular review sessions, and a holistic growth approach to your preparation. Join