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

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it.

Order a Similar Paper Order a Different Paper

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)


Most students find it hard to finish papers at some point in their studies. If it ever happens to you, don’t get desperate—we have a service for every writing emergency! Whether you’re stuck with a problem, equation, or a piece of creative writing, we will definitely come to your rescue. Fill in the order form with the details of your paper. Write your personal instructions so we can meet your expectations.

Order a Similar Paper Order a Different Paper