Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

IT And European Bank Performance

Authors: E. Beccalli

1st Edition

0230006949, 9780230006942

More Books

Students also viewed these Accounting questions

Question

What is a mineral and a rock? Why are pure metals not minerals?

Answered: 1 week ago

Question

Explain how to handle conflict effectively.

Answered: 1 week ago

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago