FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-17, Problem 4-19, using the organizational design displayed in the work sheet file. addresses. Do not modify the fonts, format, or cell 2. Enter or compute numerical values in cells C97 and D97 and enter equations that solve for the values required in cells C101:C105, D101 D105 3. Enter equations that solve for the values required in cells D113, D114, F121, F124, F125. 87 Problem 4-17 89 Bond C-coupon bond 90 Bond Z- zero coupon bond 91 92 93 94 95 96 97 98 99 Using Excel's -PV Financial Function Command 100 101 102 103 104 105 106 107 108 Problem 4-19 109 DRP 0 and LP 0 for Treasury securities 110 Bond CBond Z 4 M-S1,000 YTM = 9.6% Coupon rate 10% 4 $1,000 95% INT = Year 0 Price of C Price of Z 4 r* = 11 12 3% 8% 5% 112 113 11413 to 1,-4% 115 116 117MRP2 118 MRPs- 119 120 121 122 123 124 125 IP T5= 10% MRP2 MRPs = Thus, MRPs MRP2 Sho0t0