Answer:
MIRR = 4.32%
Explanation:
year cash flow
0 -$795,000
1 $375,000
2 -$500,000
3 $600,000
4 $400,000
Since there are 2 cash outflows, the IRR calculation would result in two different answers (1 for every cash outflow), that is why we use the MIRR function in excel.
=MIRR (cash flows, finance rate, reinvestment rate)
=MIRR (-795000 to 400000, 5.5%, 5.5%)
Since we are only given one interest rate, we will use it as our finance rate and our reinvestment rate.
MIRR = 4.32%
Answer:
Bond price= $1,793.62
Explanation:
Giving the following information:
Face value= $2,000
Number of periods= 17
Cupon rate= 0.077
YTM= 0.089
T<u>o calculate the price of the bond, we need to use the following formula:</u>
Bond Price= cupon*{[1 - (1+i)^-n] / i} + [face value/(1+i)^n]
Bond Price= 154*{[1 - (1.089^-17)] / 0.089} + [2,000/1.089^17)
Bond Price= 1,324.21 + 469.41
Bond price= $1,793.62
Answer:
9.78%
Explanation:
The yield to maturity can be determined using the rate formula in excel as shown below:
=rate(nper,pmt,-pv,fv)
nper is number of times coupon interest would be paid,which is 12 years multiplied by 2(semi-annual interest payment) i.e 24
pmt is the semi-annual interest which is $1000*8%/2=$40
pv is the current price of the bond at $876.40
fv is the face value of the bond which is $1000
=rate(24,40,-876.40,1000)=4.89%
Semi-annual yield is 4.89%
Annual yield is 4.89%*2=9.78%
The yield to maturity on these bonds is approximately 9.78%
