Question

In: Operations Management

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to...

Instructions:

You are required to use a financial calculator or spreadsheet (Excel) to solve related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance):

(i) Describe and interpret the assumptions related to the problem.

(ii) Apply the appropriate mathematical model to solve the problem.

(iii) Calculate the correct solution to the problem.

PROBLEM:

Consider a 10 year bond with face value $1,000 that pays a 6.8% coupon semi-annually and has a yield-to-maturity of 8.4%. What is the approximate percentage change in the price of bond if interest rates in the economy are expected to decrease by 0.60% per year? Submit your answer as a percentage and round to two decimal places. (Hint: What is the expected price of the bond before and after the change in interest rates?)

Solutions

Expert Solution

Consider a 10 year bond with face value $1,000 that pays a 6.8% coupon semi-annually and has a yield-to-maturity of 8.4%. What is the approximate percentage change in the price of the bond if interest rates in the economy are expected to decrease by 0.60% per year?

Solution: Given that,

n = time period = 10 years, FV = Face value = $1000, Coupon rate = p

Semi Annually, YTM = 8.4% = 0.084

The price of bond is computed using the formula as below:

Case 1: Coupon rate = p = 6.8%/2 = 0.068/2 = 0.034

Coupon value = 0.034 x 1000 = 34

Bond Value = (C/R) x {1-[1/(1+R)T] } + (FV/(1+R)T

= 34/(0.042) x {1-[1/(1+0.042)20]} + (1000/(1+0.042)20

= (809.524 x 0.5608) + 439.1831

= 893.1641

Case 2: Coupon rate = p = 6.2% / 2 = 0.062/2 = 0.031

Coupon value = 0.031 x 1000 = 31

Bond Value = (C/R) x {1-[1/(1+R)T] } + (FV/(1+R)T

= (31 / 0.042) x {1-[1/(1+0.042)20] } + (1000/(1+0.042)20

= (738.0952 x 0.5608) + (439.1831)

= $853.1069

Change in Bond price = 893.1641 - 853.1069 = $40.06 (approx)


Related Solutions

Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (iii) Calculate...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i) Develop...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT