Bon 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 Interest rate per period Coupon payment per period Par value of bond Price of bond 10 $1,000.00 11.00% 2 8.15% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A
Bon 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 Interest rate per period Coupon payment per period Par value of bond Price of bond 10 $1,000.00 11.00% 2 8.15% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text: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
Interest rate per period
Coupon payment per period
Par value of bond
Price of bond
10
$1,000.00
11.00%
2
8.15%
0.00%
$1,000.00
Formulas
#N/A
#N/A
Formulas
#N/A
#N/A
#N/A
Transcribed Image Text:Excel
Online Structured Activity: Bond valuation
You are considering a 10-year, $1,000 par value bond. Its coupon rate is 11%, 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 8.15%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent.
$
Expert Solution
Step 1
A bond is a debt instrument that takes a loan (in the form of the bond price) and repays the interest along with the principal (in the form of face value and coupons). It is different from a traditional loan because it can be traded on the secondary market.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education