Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use the excel functions to solve the problems A bond with a face value of $1,000 has 10 years until maturity, carries a coupon
please use the excel functions to solve the problems
A bond with a face value of $1,000 has 10 years until maturity, carries a coupon rate of 8.6%, and sells for $1,140. Interest is paid annually. (Assume a face value of $1,000 and annual coupon payments.) a. If the bond has a yield to maturity of 9.4% 1 year from now, what will its price be at that time? (Do not round intermediate calculations. Round your answer to nearest whole number.) Price $ 953 b. What will be the rate of return on the bond? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Negative amount should be indicated by a minus sign.) Rate of return 8.86 X % c. If the inflation rate during the year is 3%, what is the real rate of return on the bond? (Assume annual interest payments.) (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Negative amount should be indicated by a minus sign.) Real rate of return 11.54 X %Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started