65% Insert Table Chart Add Category Text View Zoom Sheet1 + 1 r H L M N O A C B D saving regular Amounts Month Problem the Bar One while we deschmuth, APR of compound Cate the describe wolf you want to the wind the worrow terest 6 pro 56 380 Dance 05 10.000.00 15 90.00 5.100 0.500 1.11 11020226 100523 1500057056 2.20 590052 2.5 410 93 300 50.0025 IM 1923 2:40 5 1000 31722 115 3005571.00 12 5 4.255.00 15.03.38 Question where were will you being launches what you would expect to release in think the short the end of the Polen 2. Regar Depecite Balance Formula verify the combat the end of the month the theorie to www Depair and 33 periods rate wheel pements Balance after sepse teatre and forest you want to have. Your current compounded dach more the end BE 35 38 37 35 40 41 42 43 44 45 40 b.Bepul formulate you would need to put on the che 14.000 the end of Gol be Medede 40 49 50 51 62 53 54 55 fio 57 58 59 50 Prawo for up to to We had maderechnete wand ole B 1 K L M N F G H Saving regular Amounts monthly Problem 1. You have a savings account at Bank One into which you invest $50 at the end of each month, and the court pel you APR of compounded monthly Calculate the bathe account at the end of each month for 12 months. Use the table below Reminder if you want to fix a wale we wound the comid/orrow Interest At end of month paid on previous Depourt Balance balance 5 550.00 50.00 0.21.550.00 510018 35 0.735 50.00 5.151.11 ALS 1.13.350.00 $ 202 26 55 1.525 50.00 5 253.28 1.00 50.00 52056 2.295 50.00 5 397.97 250.00 410.16 95 3.055 50.00 54.74 105 2,450.0065 51722 115 3.80 50.00 5571.10 115 4285190.00 62513 Question. By using a savings account that are interest, will you be waving at least as much as what you would expect to save! Please explain int: Think about how much you would set the end of 12 months you the 550 under your mettres Problem 2. Ure the Ropular Deposits Balance Formula to verify the balance in the account from Problem 1 at the end of six months. Use the space provided below to do your work Deposit amount period interest rute number of monthly payments Balance after o deposits Proble). Suppose that at the end of one you want to have 54.000. Your current savings account pays 27 APR compounded monthly Without considering the APR prate om maar weld need to see each month order to have 3.000 de -0 31 32 13 4 55 56 b. Use the Deposit Needed Formula to calculate how much you would need to deposit each month in the savings account in der to have $4.000 at the end of one ye perisic rate number of mo Meeded Deposit wount Where you red by Depor needed amount 18 49 50 57 52 53 54 55 56 57 58 59 60 Problem when people use money na mgaccount they wanya rok open the came out each month. Create a table to tell the calculate how much you would save if you need money in a wavings account and deposti afferent quantes each month nine to find the APR hat tanis are currently paying cats that APR w your table enerber you the cerce A B 1 K L M N O D E F H Saving Regular Amounts monthly Problem 1. You have a savings account at Bar One into why net 550 at the end of each month, and the account per you an APR of compounded monthly Calculate the balance in the end of each month for 12 months. Use the table below Reminderitye wat val sound the column and/or rom 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 Interest Alende paldo Deposit Balance number previous balance 15 5 50.00 50.00 15 0.285 50.00 5.10023 0.7755. 50.00 5151.13 43 1.135 50.00 $ 202 26 SS 1.525 50.00 5 253.78 63 1.550.00 105.66 25 2.29 $50.00 5357.97 2.685 50.00 5.410.66 3.00 50.00 5.46).74 tos 145 50.00 5 517,22 10 5 3.885 50.00 5571.10 125 428550.00 5.49515 Questions By using a savings account that earns Interest, will you be saving at least as much as what you would expect to save? Please explain HintThink about how much you would have at the end of 12 months you put the 350 under your mattres.) Problem 2. Use the Regular Deposits Balance Formula to verify the balance in the account from Problem 1 at the end of six months. Use the space provided below to do your work Deposit munt 33 period interest 34 number of monthly payments Balance after 6 deposits Problem ). Suppose that at the end of one year you want to have $4,000. Your current savings account pays 2.7 APR compounded more ..) without considering the APR pproximate how much you would need to we cach month order to have 1.000 at the end of one year 40 41 42 43 44 .) Use the Deposit Needed Formula to calculate how much you would need to deporteach month in the savings account in order to have 54.000 33 period interest frate 34 number of monthly payments Balance after 6 deposits Problem 3. Suppose that at the end of one year you want to have $4.000. Your current savings account pays 2.7X APR compounded monthly 35 36 37 38 39 40 41 42 43 44 45 . Without considering the APR approximate how much you would need to save each month inorder to have $4.000 at the end of one year! b.) Use the Deposit Needed Formula to calculate how much you would need to deposit each month in the savings account in order to have $4,000 at the end of one year 46 47 48 49 Geal periodic rate number of monthly Needed Deposit amount ca where you surprised by the depost needed amount in part b. why or why not? 50 51 52 53 54 55 56 57 58 59 60 Problem 4. When people save money in a savings account they usually do not deposit the same amount each month. Create a table for up to ste months to calculate how much you would save if you invested money in a savings account and deposited different quantities each month. Go online to find the APR. that babies are currently paying on savings accounts and use that APR for your table. Remember you use cell references 65% Insert Table Chart Add Category Text View Zoom Sheet1 + 1 r H L M N O A C B D saving regular Amounts Month Problem the Bar One while we deschmuth, APR of compound Cate the describe wolf you want to the wind the worrow terest 6 pro 56 380 Dance 05 10.000.00 15 90.00 5.100 0.500 1.11 11020226 100523 1500057056 2.20 590052 2.5 410 93 300 50.0025 IM 1923 2:40 5 1000 31722 115 3005571.00 12 5 4.255.00 15.03.38 Question where were will you being launches what you would expect to release in think the short the end of the Polen 2. Regar Depecite Balance Formula verify the combat the end of the month the theorie to www Depair and 33 periods rate wheel pements Balance after sepse teatre and forest you want to have. Your current compounded dach more the end BE 35 38 37 35 40 41 42 43 44 45 40 b.Bepul formulate you would need to put on the che 14.000 the end of Gol be Medede 40 49 50 51 62 53 54 55 fio 57 58 59 50 Prawo for up to to We had maderechnete wand ole B 1 K L M N F G H Saving regular Amounts monthly Problem 1. You have a savings account at Bank One into which you invest $50 at the end of each month, and the court pel you APR of compounded monthly Calculate the bathe account at the end of each month for 12 months. Use the table below Reminder if you want to fix a wale we wound the comid/orrow Interest At end of month paid on previous Depourt Balance balance 5 550.00 50.00 0.21.550.00 510018 35 0.735 50.00 5.151.11 ALS 1.13.350.00 $ 202 26 55 1.525 50.00 5 253.28 1.00 50.00 52056 2.295 50.00 5 397.97 250.00 410.16 95 3.055 50.00 54.74 105 2,450.0065 51722 115 3.80 50.00 5571.10 115 4285190.00 62513 Question. By using a savings account that are interest, will you be waving at least as much as what you would expect to save! Please explain int: Think about how much you would set the end of 12 months you the 550 under your mettres Problem 2. Ure the Ropular Deposits Balance Formula to verify the balance in the account from Problem 1 at the end of six months. Use the space provided below to do your work Deposit amount period interest rute number of monthly payments Balance after o deposits Proble). Suppose that at the end of one you want to have 54.000. Your current savings account pays 27 APR compounded monthly Without considering the APR prate om maar weld need to see each month order to have 3.000 de -0 31 32 13 4 55 56 b. Use the Deposit Needed Formula to calculate how much you would need to deposit each month in the savings account in der to have $4.000 at the end of one ye perisic rate number of mo Meeded Deposit wount Where you red by Depor needed amount 18 49 50 57 52 53 54 55 56 57 58 59 60 Problem when people use money na mgaccount they wanya rok open the came out each month. Create a table to tell the calculate how much you would save if you need money in a wavings account and deposti afferent quantes each month nine to find the APR hat tanis are currently paying cats that APR w your table enerber you the cerce A B 1 K L M N O D E F H Saving Regular Amounts monthly Problem 1. You have a savings account at Bar One into why net 550 at the end of each month, and the account per you an APR of compounded monthly Calculate the balance in the end of each month for 12 months. Use the table below Reminderitye wat val sound the column and/or rom 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 Interest Alende paldo Deposit Balance number previous balance 15 5 50.00 50.00 15 0.285 50.00 5.10023 0.7755. 50.00 5151.13 43 1.135 50.00 $ 202 26 SS 1.525 50.00 5 253.78 63 1.550.00 105.66 25 2.29 $50.00 5357.97 2.685 50.00 5.410.66 3.00 50.00 5.46).74 tos 145 50.00 5 517,22 10 5 3.885 50.00 5571.10 125 428550.00 5.49515 Questions By using a savings account that earns Interest, will you be saving at least as much as what you would expect to save? Please explain HintThink about how much you would have at the end of 12 months you put the 350 under your mattres.) Problem 2. Use the Regular Deposits Balance Formula to verify the balance in the account from Problem 1 at the end of six months. Use the space provided below to do your work Deposit munt 33 period interest 34 number of monthly payments Balance after 6 deposits Problem ). Suppose that at the end of one year you want to have $4,000. Your current savings account pays 2.7 APR compounded more ..) without considering the APR pproximate how much you would need to we cach month order to have 1.000 at the end of one year 40 41 42 43 44 .) Use the Deposit Needed Formula to calculate how much you would need to deporteach month in the savings account in order to have 54.000 33 period interest frate 34 number of monthly payments Balance after 6 deposits Problem 3. Suppose that at the end of one year you want to have $4.000. Your current savings account pays 2.7X APR compounded monthly 35 36 37 38 39 40 41 42 43 44 45 . Without considering the APR approximate how much you would need to save each month inorder to have $4.000 at the end of one year! b.) Use the Deposit Needed Formula to calculate how much you would need to deposit each month in the savings account in order to have $4,000 at the end of one year 46 47 48 49 Geal periodic rate number of monthly Needed Deposit amount ca where you surprised by the depost needed amount in part b. why or why not? 50 51 52 53 54 55 56 57 58 59 60 Problem 4. When people save money in a savings account they usually do not deposit the same amount each month. Create a table for up to ste months to calculate how much you would save if you invested money in a savings account and deposited different quantities each month. Go online to find the APR. that babies are currently paying on savings accounts and use that APR for your table. Remember you use cell references