Number of period (Nper) = 3 * 2 = 6
Semi-annual payment = $5,000 * 9% / 2 = $225
Rate = 3.5%
Future value of the coupon investment is calculated by using the
following excel formula:
=FV(rate,nper,pmt,pv)
=FV(3.5%,6,-225,5000)
= $1,473.78
Amount received at the time of maturity = $5,000 + $1,473.78 = $6,473.78
Annual rate of return can be calculated by using the following
excel formula:
=RATE(nper,pmt,pv,fv)*2
=RATE(6,0,-5000,6473.78)*2
= 8.80%
Annual rate of return = 8.80%
FEEL FREE TO ASK DOUBTS.. PLEASE RATE MY ANSWER..
Get Answers For Free
Most questions answered within 1 hours.