Question

In: Finance

Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a...

Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a picture of your work) for Q21.

Q21. Consider a 2-year bond. The coupon rate of the bond is 10%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8.0% annually, or 4.0% semi-annually.

(a) What is the duration of the bond measured in half-years and in years? (10 points)

(b) If the semi-annually yield changes from 4.0% to 5.0%, what is the predicted change in the price of the bond (a dollar amount) using duration? (7 points)

(c) Suppose you are the company that is issuing this coupon bond. To immunize your liability, you would like to invest in a portfolio consists of one-year zero-coupon bonds and three-year zero-coupon bonds. What are the durations of the one-year zero and the three-year zero, respectively? What weight of the one-year zero will you need to hold for immunization? (5 points)

Solutions

Expert Solution

a. The formula for duration is: Duration = Summation(nxPVn)/Summation(PVn). So, according to the cash flows we calculate the duration. We will have 4 cashflows each in 6 months time.

Duration = (10/1.04 x 0.5 + 10/1.04^2 x 1 + 10/1.04^3 x 1.5 + 110/1.04^4 x 2)/(10/1.04 + 10/1.04^2 +10/1.04^3 + 110/1.04^4) = 1.76914 years.

Measured in half years it will be: Duration = (10/1.04 x 1 + 10/1.04^2 x 2 + 10/1.04^3 x 3 + 110/1.04^4 x 4)/(10/1.04 + 10/1.04^2 +10/1.04^3 + 110/1.04^4) = 3.538

b. TO calculate this, we need to know the effective duration which is = Duration/(1+yield) = 1.76914/1.04= 1.7010. So, an increase in 1% yield will cause a decrease in the bond pricee by 1.7010%. The present value of the bond = (10/1.04 + 10/1.04^2 +10/1.04^3 + 110/1.04^4) = 121.779. So, the dollar amount change for a $100 face value bond will be = 121.779 x 0.01701 = $2.0714.

c. Duratio of a one year zero and a 3-yar zero is 1 and 3 respectively because there are no intermediate cash flows.

Let the one-year zero have the weight A. So, the three-year zero will have 1-A.

A + 3x(1-A) = 1.76914.

Solving, we have:

A = 61.543%.


Related Solutions

Read the assignment and answer the questions. You must also upload your Excel file, Word document...
Read the assignment and answer the questions. You must also upload your Excel file, Word document or pdf showing your work. Bodacious Building Co. is considering four different acquisition methods for obtaining pickup trucks. If the contractor’s MARR is 6%, which alternative do you recommend? The alternatives are: Immediate cash purchase of the trucks for $22,500 each, and after five years sell each truck for an estimated $4,900. Lease the trucks for five years for $4,000 per year paid at...
Answer the following problems in an Excel file. Please upload only one Excel file with all...
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...
. You must use Excel (submit either a pdf, word or Excel file only). . You...
. You must use Excel (submit either a pdf, word or Excel file only). . You must identify the 5 steps (you must address each in detail). Problem: Use the given data to complete a t-test using Excel. Question: Is there a difference in group means between the number of words spelled correctly for two groups of fourth graders? Group Assignment Score 1 3 1 4 1 10 2 14 2 7 2 8 2 10 2 15 2 9...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...
Use the following filename: yourlastname.FIL242Assignment3; there will be one file submission, an Excel spreadsheet. ALL calculations...
Use the following filename: yourlastname.FIL242Assignment3; there will be one file submission, an Excel spreadsheet. ALL calculations must use Excel functions or Excel formulas. For example, bond prices can be computed using Excel’s PV function. All calculations must use cell references rather than typing in a number into a formula. For consistency in spreadsheet design—use the template provided in the assignment. NOTE the spreadsheet template has THREE tabs—one tab for each question. 1. (10 points) For each of the bonds described...
Use the following filename: yourlastname.FIL242Assignment3; there will be one file submission, an Excel spreadsheet. ALL calculations...
Use the following filename: yourlastname.FIL242Assignment3; there will be one file submission, an Excel spreadsheet. ALL calculations must use Excel functions or Excel formulas. For example, bond prices can be computed using Excel’s PV function. All calculations must use cell references rather than typing in a number into a formula. For consistency in spreadsheet design—use the template provided in the assignment. NOTE the spreadsheet template has THREE tabs—one tab for each question. 1. (10 points) For each of the bonds described...
Answer the following questions and upload to Canvas. Submit in Word or PDF format.  Show your work...
Answer the following questions and upload to Canvas. Submit in Word or PDF format.  Show your work and upload the Excel sheet as well. All the writing parts must be your original writing, don't quote, write in your own words. The following table presents the orders of Samson Company for the last 36 months (3 years). Month Order Year 1 Order Year 2 Order Year 3 January 502 614 712 February 408 592 698 March 491 584 686 April 456 532...
Read the situation below and answer the questions. Create a Word Doc then upload your document...
Read the situation below and answer the questions. Create a Word Doc then upload your document to this area. Handling Sales Resistance Brenda recently returned from a two-week training session that focused on how to handle sales resistance and how to earn a commitment. Brenda has become quite familiar with the ADAPT questioning system and knows she must use assessment questions to allow the buyer to describe their present situation. She has also developed a pretty good set of discovery...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT