# 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

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)

Don't use plagiarized sources. Get Your Custom Essay on
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
Just from \$13/Page

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.