FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-21, using the organizational design displayed in the worksheet file Do not modify the fonts, format, or cell addresses. 2. Enter numerical values in cells C139:C142, C147:C150, and also enter these values in the BA II Plus calculator (or a similar financial calculator). Enter the results computed by the calculator in cells E143, E151 3. Enter equations that solve for the values required in cells C156:C167. 4. Print the worksheet. Grade Value: 25 points G21 128 129 Problem 4-21 130 131 132 133 134 135 136 137 Part a. 138 Using the BA Il Plus calculator 139 140 141 142 143 144 145 Part b 146 Using the BA II Plus calculator 147 148 149 150 151 152 153 Part c. 154 Using Excel's-PV Financial Function Command 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 te bond M= Coupon rate- $1,000 10% S100 INT Semiannual payments Semiannual periods in 8 years FV = Semiannual rate of interest Semiannual payments PMT PV- Semiannual period s in 8 years Semiannual rate of interest PMT- Semiannual payments Remaining Periods Bond Price 16 15 14 13 12 10 4 172 173 174 The price of the bond declines toward $1,000 FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-21, using the organizational design displayed in the worksheet file Do not modify the fonts, format, or cell addresses. 2. Enter numerical values in cells C139:C142, C147:C150, and also enter these values in the BA II Plus calculator (or a similar financial calculator). Enter the results computed by the calculator in cells E143, E151 3. Enter equations that solve for the values required in cells C156:C167. 4. Print the worksheet. Grade Value: 25 points G21 128 129 Problem 4-21 130 131 132 133 134 135 136 137 Part a. 138 Using the BA Il Plus calculator 139 140 141 142 143 144 145 Part b 146 Using the BA II Plus calculator 147 148 149 150 151 152 153 Part c. 154 Using Excel's-PV Financial Function Command 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 te bond M= Coupon rate- $1,000 10% S100 INT Semiannual payments Semiannual periods in 8 years FV = Semiannual rate of interest Semiannual payments PMT PV- Semiannual period s in 8 years Semiannual rate of interest PMT- Semiannual payments Remaining Periods Bond Price 16 15 14 13 12 10 4 172 173 174 The price of the bond declines toward $1,000