Question

Time Value of Money and Bonds Valuation

As Laura’s new year resolution, she wants to begin saving money for her retirement. You are hired as her financial advisor. Following your suggestion, today Laura will deposit $100,000, which she inherited from her parents, into a 5-year savings account at Citi bank, which pays 3.25% interest annually.

Use the above information to answer the following questions. When answering your question, make sure to include the calculation steps or formula. (Assume END mode)

5. Assume after 5 years, Laura will be 40 years old and will have $150,000 in her saving account, and she is planning to retire at 65 years old and she will need $1,000,000 at retirement. What annual interest rate must she earn to reach her goal, assuming each year she will only save $20,000.

Laura asks you to help her invest in the bonds market. You have the following three bonds good for investment. Assume all coupons are paid annually and END mode, find the best option for your friend?

Option One: Treasury bond has 4% annual coupon, matures in 10 years, and has a $10,000 face value. Its price is $9,550

Option Two: Corporate Bond A has a 9% annual coupon, matures in 5 years, and has a $10,000 face value. Its price is $10,500

Option Three: Corporate Bond B has a 10% annual coupon, matures in 8 years, and has a $10,000 face value. Its price is $9,950

5. Calculate YTM for each bond.

6. Compare YTM with coupon rate, indicate whether each bond is trading at a premium, at a discount, or almost at par.

7. Which one do you recommend Laura to buy and why, assume Michelle has a high-risk tolerance and the current market interest rate is around 6%, Corporate Bond A is rated as BB bond and Corporate Bond B is a high-yield risky bond?

8. Assume Laura also told you her expected residual savings from 2019 to 2023 will be: $15,000, $20,000, $25,000, $30,000, $35,000. She wants to know the present values of these savings at an 8% discount rate. Calculate PVs of the streams.

Answer 1

too many questions posted solving first 4

1)Use the below formulae
future =initial*(1+r)^n
=100000*(1+3.25%)^5=117341.14
2)use rate formuale in excel
=rate(nper,pmt,pv,fv,type)
=rate(25,20000,150000,-1000000,0)
=2.74%
3)use rate formuale in excel to find ytm of bond
=rate(nper,pmt,pv,fv,type)
Option1:=rate(10,(4%*10000),-9550,10000,0)=4.57%
option 2:=rate(5,(9%*10000),-10500,10000,0)=7.76%
option 3:=rate(8,(10%*10000),-9950,10000,0)=10.09%
option1 trading at discount since ytm is higher than coupon rate
option 2 trading at premium since ytm is lesser than coupon
optin 3 trading at discount since ytm is higher than coupon rate