70.2K

Verified Solution

Link Copied!

What would be another way to calculate total interest rather than merely using =sum(?

: What are some of the pros and cons to each of the three methods you have used

What impressions or insights have you gained from this exercise?

E F B Givens: G H Rev 0 C Principal Payment APR Compounds D 500.00 25.00 4.50% 12 Payment Methods Month Principal Interest 0 1 500.00 1.88 2 526.88 1.98 3 553.85 2.08 4 580.93 2.18 5 608.11 2.28 6 635.39 2.38 7 662.77 2.49 8 690.25 2.59 9 717.84 2.69 10 745.54 2.80 11 773.33 2.90 12 801.23 3.00 13 829.24 3.11 14 857.35 3.22 3 15 885.56 3.32 4 16 913.88 3.43 5 17 942 31 3.53 18 970.84 3.64 19 999.48 3.75 20 1028.23 3.86 29 21 1057.09 3.96 30 1086.05 4.07 31 23 1115.12 4.18 32 24 1144.30 4.29 33 25 1173.60 4.40 34 26 1203.00 4.51 35 27 1232.51 4 62 36 28 1262.13 4.73 37 29 1291.86 4.84 30 1321.71 39 31 1351.66 40 5.07 32 1381.73 5.18 41 33 1411.91 5.29 42 34 1442 21 5.41 43 35 1472.62 5.52 44 36 1503.14 5.64 45 13.3.78 Template + Total 500.00 526.88 553.85 580.93 608.11 635.39 662.77 690.25 717.84 745.54 773.33 801.23 829.24 857.35 885.56 913.88 942.31 970.84 999 48 1028.23 1057.09 1086.05 1115.12 1144.30"- 1173.60 1203.00 123251 1262.13 1291.86 1321.71 1351.66 1381.73 1411.91 1442.21 1472.62 1503.14 1533.78 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 900.00 Month $18 Turations (Steps) 999.48 Month 18 Formule Regular Payment) 999.48 Month 18 Ercel Foro 999.48 4.96 Total Type here to search O

Answer & Explanation Solved by verified expert

See Answer