Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its...

Transcribed Image Text:

Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.9%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ Check My Work Reset Problem 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Bond valuation Years to maturity Par value of bond Coupon rate Frequency interest paid per year Effective annual rate Calculation of periodic rate: Nominal annual rate Periodic rate Calculation of bond price: Number of periods 15 Interest rate per period Coupon payment per period Par value of bond 16 17 18 Price of bond 30 $1,000.00 8.00% 2 10.90% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.9%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ Check My Work Reset Problem 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Bond valuation Years to maturity Par value of bond Coupon rate Frequency interest paid per year Effective annual rate Calculation of periodic rate: Nominal annual rate Periodic rate Calculation of bond price: Number of periods 15 Interest rate per period Coupon payment per period Par value of bond 16 17 18 Price of bond 30 $1,000.00 8.00% 2 10.90% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A

Answer rating: 100% (QA)

Bond Valuation Given Par value 1000 Coupon rate 8 paid semiannually Years to maturity 30 Effective a... View the full answer