# Hey, i’m stuck at a questioni’m trying to make it on excel but i can’t seem to find the exact answer and i

Posted: December 30th, 2021

Answer to (a)Using the same excel formula from P6-20, we can calculate the priceBondCouponCouponTime toYield toRateFrequencyMaturityMaturityPar-ValueBond ValueA6%1512%1000(\$783.71)B14%1512%1000(\$1,072.10)Answer to (b)a) Bond ANumber of Bonds = \$20,000 / \$783.71 = 25.52 of Bond AMark could purchase 25 of Bond Ab) Bond BNumber of Bonds = \$20,000 / \$1,072.10 = 18.66 of Bond BAnswer to (c)*note: pretending that Mark can purchase a fraction of the bond (while he really can’t)a) Interest Income of A = 25.52 (6%*1000) = \$1,531.17b) Interest Income of B = 18.66 (14%*1000) = \$2,611.71Answer to (d)Answer to (e)

### Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00