Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the excel soreadsheet with the 800 principl 5.5% apr. i accidentlynuploaded the other one and dont know how to delete it! 2. When was the
the excel soreadsheet with the 800 principl 5.5% apr. i accidentlynuploaded the other one and dont know how to delete it!
2. When was the original principal invested and when was the payment invested (end or beginning of the period)? In the finance world, what type of investment is this called? Answer: E F B Givens G H Rev 0 C Principal Payment APR Compounds D 500.00 25.00 4.50% 12 Payment 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 22 1086.05 4.07 23 1115.12 4.18 114430 23 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 38 30 1321.71 4.96 39 31 1351.66 5.07 40 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 Total 133.78 Template + 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 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 Methods 970.84 999.48 Month $18 Irations (Steps) 1028.23 999.48 1057.09 1086.05 Month 18 Formule Regular Payment) 1115.12 999.48 1144.30"- 1173.60 1203.00 Month 18 Excel Fruction 1232.51 999.18 1262.13 1291.86 132171 1351.66 1381.73 1411.91 144221 1472 62 1503.14 1533.78 4.29 Type here to search orkbook Views Show Zoom fy 12 E F G H Rev 0 Principal Payment APR Compounds 800.00 25.00 5.50% 12 Interest Payment Methods Principal 0 1 800.00 2 828.67 3 857.46 4 886.39 5 915.46 6 944.65 7 973.98 8 1003.45 9 1033.05 10 1062.78 11 1092.65 12 1121.66 13 1152.81 14 1183.09 15 1213.51 16 1244.07 17 1274.78 18 1305,62 19 1336.60 20 1367.73 21 1399.00 22 1430.41 23 1461.97 24 1493.67 25 1525.51 26 1557.30 27 1589.64 28 1621.93 29 1654.36 30 1686.94 31 1719.68 32 1752.56 33 1785.59 34 1818.77 35 1852.11 36 1885.60 Total: 3.67 3.80 3.93 4.06 4.20 4.33 4.46 4.60 4.73 4.87 5.01 5.15 5.28 5.42 5.56 5.70 5.84 5.98 6.13 6.27 6.41 6.56 6.70 6.85 6.99 7.14 7.29 7.43 758 7.73 7.88 8.03 8.18 8.34 8.49 8.64 219.24 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.000 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 Total 800.00 828.67 857.46 886.39 915.46 944.65 973.98 1003.45 1033.05 1062.78 1092.65 1122.66 1152.81 1183.09 1213.51 1244.07 1274.78 1305.62 1336.60 1367.73 1399.00 1430.41 1461.97 1493.67 1525.51 1557.50 1589.64 1621.93 1654.36 1686.94 1719.68 1752.56 1785.59 1818.77 1852.11 1885.60 1919.24 Month #18 Merations (Steps) 1336,60 Month #18 Formula (Regular Payments) 1336.60 Month #18 Excel Function 1336.60 Template + Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started