B G 1 J C D E F Amortization: 5.0%, 15 years, loan amount $180,000 Beginning Total Monthly Monthly Interest Principle Balance Payment Payment Reduction Year End Balance Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 3 1 2 + 24 25 26 27 28 30 31 32 33 34 35 36 37 38 39 40 41 42 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 15 year 30 year Senstivitiy Analysis + Home Insert Draw Page Layout Formulas Data Review View Tell me 12 ' Wrap Text Currency [D Paste BIU V a. Av E Merge & Center $ % ) F39 . A B C G H I J 1 D E F Amortization: 5.0%, 15 years, loan amount $180,000 Beginning Total Monthly Monthly Interest Principle Balance Payment Payment Reduction Year Month End Balance 13 2 TY 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 14 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 Total 167 + 15 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 15 year 30 year Senstivitiy Analysis + ** v 12 2 Wrap Text General Paste A A BI III III v V il Merge & Center $ % 9 G363 1 J L D E F Abortization: 6.5%, 30 years, loan amount $180,000 Beg Bal Payment Interest Reduction End Bal B 1 2 Year Month 3 1 4 2 5 3 6 4 7 5 1 6 7 10 8 11 9 12 10 13 11 14 12 15 13 16 17 15 18 16 19 17 20 2 18 21 19 22 20 23 21 24 22 25 23 26 24 26 27 28 29 30 31 32 3 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 34 35 36 37 38 39 40 41 15 year 30 year Senstivitiy Analysis AutoSave OFF Amortization template-1.3ds - Come Home Insert Draw Page Layout Formulas Data Review View Tell me R# 12 A = 2 Wrap Text General Paste BIV v MA Merge & Center $ %) G363 G H I J K D F Amortization: 6.5%, 30 years, loan amount $180,000 Beg Bal Payment Interest Reduction End Bal 343 A B 1 2 Year Month 332 28 330 333 331 334 332 335 333 336 334 337 335 338 336 339 337 340 338 341 339 342 340 341 342 29 345 313 346 344 347 345 346 349 350 348 351 349 352 350 353 351 354 352 355 353 356 30 351 357 355 358 356 359 357 360 358 361 359 362 360 363 Total 364 365 366 367 368 369 347 370 371 372 15 year 30 year Senativity Analysis + AutoSave OF Amortization template-1.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me R 12 ' ES V Wrap Text Paste B IVB Accounting $ %) Merge & Center Conditional Format Cell Formatting as Table Styles L D16 XVfx TABLE(B5,84) A B E F G 1 Seastivity Analysis of mortgage 2 10-yr mortgage with monthly payment 3 Loan Amount $ 180,000 4 Interest Rate 5 Number of years 30 6 Monthly payt
