Question

A four-year bond has a 9% coupon rate and a face value of $1000. If the...

A four-year bond has a 9% coupon rate and a face value of $1000. If the current price of the bond is $848.31, calculate the yield to maturity of the bond (assuming annual interest payments). You will need to use Excel. Please round your answer to two decimal places. Remember to input your answer in decimal form (i.e. 12.34% would be entered as 0.1234).

A three-year bond has a 6.0% coupon rate and face value of $1000. If the yield to maturity on the bond is 14%, calculate the price of the bond assuming that the bond makes semi-annual coupon interest payments. Assume the first payment will be made 6 months from now. Please round your answer to the nearest penny.

Mr. Hopper is expected to retire in 20 years and he wishes to accumulate $850,000 in his retirement fund by that time. If the interest rate is 11% per year, how much should Mr. Hopper put into the retirement fund each year in order to achieve this goal? [Assume that the payments are made at the end of each year]. Hint: First find the PV of the savings goal. Please round your answer to the nearest dollar.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼, conditional Format . Cell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard AU55 AT Alignment Number Cells Edting AU AV AW AY AZ BA BD BE BF BG 45 46 47 48 49 50 51 52 53 54 1 YEARS 4 1000 FV COUPON PRICE YTM 848.31 14.23% EXCEL= RATE(AY45-AY47*AY46,AY48,-AY46) 2 YEARS FV 1000 COUPON 696 SEMI ANNUAL 14% PRICE $ 809.34 EXCEL PV(AY54/2,AY51 *2,-AY53 AY52/2,-AY52) 56 57 58 59 60 61 62 (4 トト 3 YEARS ACCUMULATED AMOUNT RATE PMT ANNUAL DEPOSIT $ 13,239.29 EXCEL PMT(AY59,AY57,,-AY58) 20 850000 11% , NOTE BIDDING, UNDERWRITING . . EUAC AW PM LIFE / LP, lp, MRP, INFLATION YIELD ( WARRANTrefund bond , CLEAN INVOICE PRICE Sheet1 Sheet3 Sheet4 15-01-2019

Add a comment
Know the answer?
Add Answer to:
A four-year bond has a 9% coupon rate and a face value of $1000. If the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT