Question: Create an excel sheet that takes as input Face Value (as one number in dollars), Coupon Rate (as one number as a percentage), Years to
Create an excel sheet that takes as input Face Value (as one number in dollars), Coupon Rate (as one number as a percentage), Years to maturity (as one number), and Yield to Maturity for three bonds (three different numbers as a percentage). Using these inputs, calculate the bond prices for all three bonds (again, I recommend using the PV formula to calculate the price), for years to maturity from the number you input, all the way down to zero. Plot these three price series on a line chart with markers. They should be on the same chart. In the excel sheet answer the following question. Are the bond prices further apart from each other when you are close to
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
