1. what woulb be another way to calculate total interest rather than merely using '=sum?
1 What Woulb Be Another Way To Calculate Total Interest Rather Than Merely Using Sum 1 (51.63 KiB) Viewed 38 times
1 What Woulb Be Another Way To Calculate Total Interest Rather Than Merely Using Sum 2 (51.63 KiB) Viewed 38 times
1 What Woulb Be Another Way To Calculate Total Interest Rather Than Merely Using Sum 3 (42.78 KiB) Viewed 38 times
4:31 PM Sun Jul 10 Activity 4 Regular Payments Savings Plan Student Template... Math 10 11 12 13 11 14 36 17 IN 39 20 21 23 24 251 26 21 29 29 10 31 32 33 34 35 16 Line Number 12 Principal 125.00 P 33.00 3.800 AM Compan Principal 125.00 158.40 191.50 225 51 299.21 293.04 995.15 429.40 463.76 532.80 567.49 602.29 637.20 67221 70734 74758 771.9 813.40 SAXT 38466 420.46 996 18 992.41 1028 55 106481 1101.18 1137 1174.27 12100 1247 82 1284.77 1799.0 Total Template HE Interest 0.49 11.50 061 071 Exp 0.93 1.04 1.14 1.25 1.M LIFT 1.58 100 1.80 191 2.00 213 2.24 2.15 246 2.50 2.60 2.91 300 314 126 1.37 3.49 300 3.72 3.83 195 4.00 4.19 1396.33 Pomat 33.00 11.00 33.00 33.00 31.00 330 11.00 33.00 33.00 31.00 31.00 33.00 33.00 33.00 31.00 33.00 31.00 11.00 33.00 31.00 31.00 11.00 33.00 33.00 33.00 31.00 33.00 33.00 33.00 33.00 31.00 31.00 31.00 11.00 Tatal 125.00 158.40 291.90 225.51 259.22 291.04 336.97 364.00 295.15 429.40 46.3.76 495.23 $32.80 567.41 62009 637.20 67221 707 34 742.58 777.91 $13.40 99241 102K55 $48.97 Month 13 formada (Regular P 85466 742.38 IN 1901 Metho 920.45 1211-00000/127²18+27+/12/ 956.34 1837.66 111439 1200.99 124742 1284.77 132184 Month nation 176 11 €27-07-27 Meeth Exel Fonction 741.53 FV-DC37DADI Rection 1: What would be another way to calculate total interest rather than menying Reflection 2: When was the original principal invested and when the payment the period in the finance world, what type of investments this called? Ģ 71% 0 1 +
4:31 PM Sun Jul 10 OF M ST ON TU P1 12. TH 24 75 TA T 16 TH NO BE OF W W BE M ST M 100 181 192 103 124 Activity 4 Regular Payments Savings Plan Student Template....e & Template Reflection 1: What would be another to calculate total interest rather than merely using? Reflection 2: When was the original principal invested and when was the payment invested t or beginning of the period? In the finance world, what type of investment is this called? Reflection 3: What are some of the pros and cons to each of the three methods you have used Disadvantage of this way is not very popular when we have large number of entries. Because it will take lot of time. If you are using -SUM function then it would be very easier to you to calculate all the entries in one time. The Excel formula function has advantage. It can add all of the numbers on a sheet. If et finds a cell with text it ignores it and does not include it in the calculation. This makes it easier to simply the formula Reflection 4: Which of the three methods is your favorite way to calculate the balance and why?My favorite method is to add the first formulas SUM, and have everything add up instantly and then rectify with the manu formulas of Principal APR/compound. Reflection 5: What impressions or insights have you gained from this exercise? I gained more experience using a statistical method in the excel sheet, just by entering the excel formules, you can do the calculation immediately through the sheet. 71% 0 1 +
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!