excle please

intereson interest Suhy Kuhas made the following deposit at the First National bank of Kent. How much will she have at the end of her savings Number of periods Initial investment Interest rate per Year $ 500 70% At the end of the investment, she will have As shown in the textbook, the future value of $1 is found by the equation PV = $1x1rY. in Excel, the carat)raises a number to a power of Simple & Compound Interest Initial investment: $500 Interest rate per Year 10% What is the value of the investment each year over the next 5 years? How much of the interest is simple interest and how much is compound interest? We will answer this question with the following table 50 10 Simple $ Year 1 2 3 4 5 Totals Beginning Amount 5 500.00 5 550.00 605.00 665.50 732.05 s Simple Compound Interest Interest 50.00 5 50.00 5.00 50.00 10.0 50.00 16.55 50.00 23:21 250.00 55.26 Amount with Total Ending Interest Amount interest 50.00 $ 550.00 $ 550,00 55.00 605.00 600.00 ca 650.00 66.55 732.05 700.00 73.21 805.26 750.00 1 Example 4.3: Interest on interest 3 Suh Pynek has made the following deposit at the First National bank of Kent. How much will she have at the end of her savings 3 Number of periods Initial investment Interest rate per Year s 5 500 7.0% Simple & Compound Interest At the end of the investment, she will have As shown in the textbook, the future value of $1 is found by the equation IV-51X(Y. In Excel, the carries a number to a power Initial investment S500 Interest rate per Year 10% What is the value of the investment each year over the next 5 years? How much of the interest is simple interest and how much is compound interest? We will answer this question with the following table: 2 Beginning Amount $ 500.00 550.00 Year 1 2 3 4 5 Totals PERIOD Amount with Total Ending Simple Interes Amount interest 50.00 $550.00 $550.00 55.00 605.00 600.00 0.50 665.50 650.00 66.55 732.05 700.00 73.21 805 26 750.00 305 26 Simple Compound Interest Interest 50.00 5 $ 50.00 5.00 50.00 10.50 50.00 16,55 50.00 23.21 250.00 $ 55.26 S 605.00 Sle Interest 665.50 7320 $