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
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter11: Bond Pricing And Amortization (bonds)
Section: Chapter Questions
Problem 7R
Related questions
Question
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45ca41ad-593a-47be-ba58-1becf5d74f6e%2F3757d902-1bd3-4534-a9a1-f4acead1b57d%2F0e55ya_processed.png&w=3840&q=75)
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
![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.
$](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45ca41ad-593a-47be-ba58-1becf5d74f6e%2F3757d902-1bd3-4534-a9a1-f4acead1b57d%2Fzdiza7s_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning