Complete the table below by calculating the MATURITY VALUE of $500 for the next 30 years...

 

Transcribed Image Text:

Complete the table below by calculating the MATURITY VALUE of $500 for the next 30 years at 10% interest rate using simple interest and compound interest (monthly compounding). Then, graph both the simple and compound interest values in the same plane. What can you say about the difference in the growth of $500 for each calculation? TIME Simple Interest Compounded Monthly 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Show your SCATTER graph below: 16 Write your observations below: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Calculate the growth (Maturity Value) of $1,000 for the next 40 years (1 year to 40 years) at 10.75% interest rate using a) Simple Interest, b) Compounded Quarterly, c) Compounded Daily and d) Continuous Compounding. NOTE: Your table must show all your calculatations from the first year all the way to 40 years. If you studied the PDF file I provided in your Learning Materials, all you need is one formula for year 1 and then drag it down to year 40. TIME Simple Interest 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Compounded Quarterly Compounded Daily Compounded Continuously Complete the table below by calculating the MATURITY VALUE of $500 for the next 30 years at 10% interest rate using simple interest and compound interest (monthly compounding). Then, graph both the simple and compound interest values in the same plane. What can you say about the difference in the growth of $500 for each calculation? TIME Simple Interest Compounded Monthly 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Show your SCATTER graph below: 16 Write your observations below: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Calculate the growth (Maturity Value) of $1,000 for the next 40 years (1 year to 40 years) at 10.75% interest rate using a) Simple Interest, b) Compounded Quarterly, c) Compounded Daily and d) Continuous Compounding. NOTE: Your table must show all your calculatations from the first year all the way to 40 years. If you studied the PDF file I provided in your Learning Materials, all you need is one formula for year 1 and then drag it down to year 40. TIME Simple Interest 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Compounded Quarterly Compounded Daily Compounded Continuously