
Concept explainers
(a)
To Discuss:
To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.
Spreadsheet 11.1
Introduction:
A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.
Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average
(b)
To Discuss:
To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.
Spreadsheet 11.1
Introduction:
A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.
Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Want to see the full answer?
Check out a sample textbook solution
Chapter 16 Solutions
Investments
- What do you think would be the best approach if a company is entering a new industry with little historical data or no true comparable firms to derive a beta?arrow_forwardDo you think market efficiency varies significantly between developed and emerging markets, and if so, how should companies or investors adjust their strategies in each environment?arrow_forwardDescribe the key stages of the audit progress and indicate how each stage contribute to a comprehensive auditarrow_forward
- regulations 28 of the company act no 71 of 2008 regulates on the category of companies which are required to be audited, list three types of companies that are required to be audited regulations 43 speak of the social and ethics committee. it is a must that certain companies appoint such a committee. list these three types of companies in terms of regulation 43. more so what is the function of the social and ethics committee.arrow_forwardDo you think moves like this could potentially backfire by reducing community access or hurting brand reputation, even if they improve financial performance in the short term? How should companies like Walgreens balance cost-cutting with maintaining customer reach?arrow_forwardDo you think companies like Kohl's can recover investor confidence more effectively by focusing on operational improvements, or is a broader shift in business strategy (such as digital transformation or restructuring) more likely to make an impact in the long run?arrow_forward
- 3. After discussing things with a bank, the family learned that they can (1) refinance the remaining $15 comma 400 amount on the vehicle 1 at 13%, over 4 years, (2) refinance the remaining $8500 loan amount on the vehicle 2 at 13%, over 3 years, (3) refinance the remaining $119 comma 900 loan amount on their home at 5%, over 25 years, and (4) reduce their car insurance payments by $30 per month. Complete the following table. (Round to the nearest cent as needed. Do not include the $ symbol in your answer.) Part 9Part 10Part 11Part 12Part 13Part 14 Item Current Loan Amount New Interest Rate New Term of Loan New Monthly Payment Motor vehicle 1 $ enter your response here enter your response here% enter your response here years $ enter your response here Motor vehicle 2 $ enter your response here enter your response here% enter your response here years $ enter your response here Home $ enter your response here enter your response here%…arrow_forwardConsider the data below for six furniture companies. 2 A Variance- covariance matrix B D E F G H La-Z-Boy Kimball Flexsteel Leggett Miller Shaw Means 3 La-Z-Boy 0.1152 0.0398 0.1792 0.0492 0.0568 0.0989 29.24% 4 Kimball 0.0398 5 Flexsteel 0.1792 6 Leggett 0.0492 0.0649 0.0447 0.0447 0.3334 0.0062 0.0775 0.0062 0.0349 0.0269 20.68% 0.0775 0.0886 0.1487 25.02% 0.1033 0.0191 0.0597 31.64% 7 Miller 8 Shaw 0.0568 0.0349 0.0989 0.0269 0.1487 0.0886 0.0191 0.0594 0.0243 15.34% 0.0597 0.0243 0.1653 43.87% a. Given this matrix, and assuming that the risk-free rate is 0%, calculate the efficient portfolio of these six firms. b. Repeat, assuming that the risk-free rate is 10%. c. Use these two portfolios to generate an efficient frontier for the six furniture companies. Plot this frontier.arrow_forwardNoor HOME PROFILE « CENGAGE MINDTAP Homework - Chapter 9: Stock Valuation Assignment: Homework - Chapter 9: Stock Valuation Questions Problem 9.04 (Nonconstant Growth Valuation) Q Search th Assignment Score: 93 Save Submit Assignment for Grad Question 3 of Check My Work (1 remainin ORDERS 1. RENTALS 2. 3. eBook COURSES 4. 5. 6. Holt Enterprises recently paid a dividend, Do, of $2.75. It expects to have nonconstant growth of 14% for 2 years followed by a constant rate of 4% thereafter. The firm's required return is 8%. a. How far away is the horizon date? I. The terminal, or horizon, date is Year 0 since the value of a common stock is the present value of all future expected dividends at time zero. II. The terminal, or horizon, date is the date when the growth rate becomes nonconstant. This occurs at time zero. Study Tools 7. III. The terminal, or horizon, date is the date when the growth rate becomes constant. This occurs at the beginning of Year 2. IV. The terminal, or horizon, date…arrow_forward
- 2. These monthly expenses do not include car insurance ($215.00215.00 per month), health insurance ($280.00280.00 per month), or real estate taxes and insurance on their home ($33503350 per year), among other expenses. Find their total monthly outlay for all of these expenses. (Round to the nearest cent as needed. Do not include the $ symbol in your answer.) Part 7 Expenses Monthly Outlay Payments on debt from (a) $enter your response here Car insurance $ Health insurance $ Real estate taxes and insurance on home $ Total $arrow_forwardABC Corporation issued a 10-year 5.85% coupon bond on February 15, 2018. Today is February 15, 2020 and the bond is trading at $1,025.50 (face value $1,000). What is the yield to maturity of this bond?arrow_forwardA couple is struggling to make their monthly payments as they accumulated too much debt. Roberto took on a second job during the evenings and they have been making payments regularly for 8 months. Answer parts 1 through 4. LOADING... Click here to view the Real Estate Amortization Table (Principal and Interest per Thousand Dollars Borrowed). LOADING... Click here to view the Loan Payoff Table. Question content area bottom Part 1 1. Find the monthly payments on each of the following purchases and the total monthly payment. (Round to the nearest cent as needed. Do not include the $ symbol in your answer.) Part 2Part 3Part 4Part 5 Purchase Original Loan Amount Interest Rate Term of Loan Monthly Payment Motor vehicle 1 $18 comma 900 13% 4 years $ enter your response here Motor vehicle 2 $14 comma 500 18% 4 years $ enter your response here Home $126 comma 400 6 and one half % 10 years $ enter your response here 2nd mortgage on home $4000 14% 3 years $ enter your…arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author: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 ProfessorPublisher:McGraw-Hill Education





