0 0 A U B $ + U C X U BU y! 1 0 UMIER G2G 2+ G docs.google.com/spreadsheets/d/1rS6XuTlbwDZR604ff3JBr1duw5q9Hzp1wKOW5rw2WXw/edit#gid=0 Relaunch to update : C TDSB Bookmarks Copy of Usman Rizve - 02C_How Money Grows at Different Interest Rates File Edit View Insert Format Data Tools Extensions Help Q5 100% % .0 .00 123 Arial H53 fx A B C D E - 10 + B I = A F G H 1 Complete the data for Years 1-30 below, then create a chart comparing how money grows at the different interest rates. 2 3 Principal $1,000 4 5 Year @ 4% 6 0.04 @ 6% 0.06 @ 8% @ 10% @ 12% 0.08 7 1 $1,040.00 $1,060.00 $1,080.00 0.10 $1,100.00 0.12 $1,120.00 8 2 1081.6 1123.6 1166.4 1210 9 3 1124.86 1191.02 1259.71 1331 1254.4 1404.93 10 4 1169.85 1262.48 1360.49 1464.1 1573.52 11 5 1216.64 1338.23 1469.33 1610.51 1762.34 12 6 1265.31 1418.52 1586.88 1771.56 1973.82 13 7 1315.92 1503.63 1713.83 1948.72 2210.68 14 8 1368.56 1593.85 1850.94 2143.59 2475.96 15 9 1423.3 1689.48 1999.02 2357.95 2773.08 + = Sheet1 Type here to search D || A - O 13C Mostly cloudy J O : 8 Share K L 1:32 PM 4/18/2024 31 Q + 19 PRE 0 0 A U B $ + U C X U BU y! 1 0 UMIER G2G 2+ C TDSB Bookmarks docs.google.com/spreadsheets/d/1rS6XuTlbwDZR604ff3JBr1duw5q9Hzp1wKOW5rw2WXw/edit#gid=0 Copy of Usman Rizve - 02C_How Money Grows at Different Interest Rates File Edit View Insert Format Data Tools Extensions Help 5 2 100% % .0 .00 123 Arial - 10 + B I A O K L (8) 31 Q 4 + 1:32 PM 4/18/2024 19 PRE 0 0 A U B $ + U C X U BU y! 1 0 UMIER G2G 2+ G docs.google.com/spreadsheets/d/1rS6XuTlbwDZR604ff3JBr1duw5q9Hzp1wKOW5rw2WXw/edit#gid=0 Relaunch to update : C TDSB Bookmarks Copy of Usman Rizve - 02C_How Money Grows at Different Interest Rates File Edit View Insert Format Data Tools Extensions Help Q5 100% % .0 .00 123 Arial - 10 + B I A 0 0 A U B $ + U C X U BU y! 1 0 UMIER G2G 2+ G docs.google.com/spreadsheets/d/1rS6XuTlbwDZR604ff3JBr1duw5q9Hzp1wKOW5rw2WXw/edit#gid=0 Relaunch to update : C TDSB Bookmarks Copy of Usman Rizve - 02C_How Money Grows at Different Interest Rates Data Tools Extensions Help File Edit View Insert Format Q5 < 8 7 80% % .0 .00 123 Arial - 10 + B I A fx A B C D E F G H N35 || A - 8 Share 31 J K L M N 38 39 1) Use your spreadsheet to help you complete the second row in the table below. 40 41 2) Multiply each number in the first row by the number below it in the middle row and write the product in the bottom row. What pattern do you discover in the numbers in the bottom row? 42 43 3) Use the pattern you discovered in 2 to estimate the doubling time d corresponding to a growth rate of 7%. What value would you expect the expression (1.07) to have if d is the exact doubling time for a 7% growth? 44 45 4) Calculate the exact doubling time corresponding to a growth of 18%. Does this doubling time follow the same pattern as you discovered for the other growth rates? Explain. 46 47 5) Use the pattern you discovered in 2 to estimate the number of years it would take an investment growing at 9% to quadruple in value 48 49 6) An investment of $18 000 grows in value to $71 400 in a period of 16 years. Use the pattern you discovered above to estimate its average annual rate of growth. Explain how you obtained your estimate. 50 51 Growth Rate as 52 a percent 4% 6% 8% 10% 12% Note: Money invested at 12% Doubles every 6 years 53 Doubling time in years 54 55 Growth Rate X Doubling Time + = Sheet1 Type here to search D C - O Temps to drop (8) 1:33 PM 4/18/2024 + 19 PRE