# Number of Total interest

Principal $ 600.00 Rate 0.05 Number of Total interest years earned 0 $ 1 $ 30.00 2 $ 60.00 3 $ 90.00 4 $ 120.00 5 $ 150.00 10 $ 300.00 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Value of account $ 600.00 Write a formula in cell E3 to compute the value year. Then use the fillto 30 years. Note: We are skipping years 6, 7, You will need to use the See the formula already provided in cell D3 for Experiment with different values in years is at least $1,000. What value did you u return the value in A1 to $600. Experiment with different values in after 10 years (cell E8) is at least $1,000. What Answer here, then return the value in A2 to 0.0 ormula in cell E3 to compute the value of the account after 1 en use the fill-down feature to complete columns D and E up rs. Note: We are skipping years 6, 7, 8, & 9. need to use the symbol “$” to lock certain cell references. ormula already provided in cell D3 for a hint. with different values in (Cell A2) until the value after 10 at least $1,000. What value did you use? Answer here, then he value in A1 to $600. with different values in B2 until the value of the account cell E8) is at least $1,000. What value did you use? ere, then return the value in A2 to 0.05. Principal $ 600.00 Rate 0.05 Number of Total interest years earned 0 $ 1 $ 30.00 2 $ 60.00 3 $ 90.00 4 $ 120.00 5 $ 150.00 10 $ 300.00 11 $ 330.00 12 $ 360.00 13 $ 390.00 14 $ 420.00 15 $ 450.00 16 $ 480.00 17 $ 510.00 18 $ 540.00 19 $ 570.00 20 $ 600.00 21 $ 630.00 22 $ 660.00 23 $ 690.00 24 $ 720.00 25 $ 750.00 26 $ 780.00 27 $ 810.00 28 $ 840.00 29 $ 870.00 30 $ 900.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Value of account 600.00 630.00 660.00 690.00 720.00 750.00 900.00 930.00 960.00 990.00 1,020.00 1,050.00 1,080.00 1,110.00 1,140.00 1,170.00 1,200.00 1,230.00 1,260.00 1,290.00 1,320.00 1,350.00 1,380.00 1,410.00 1,440.00 1,470.00 1,500.00 Write a formula in cell E3 to compute the valu year. Then use the fillto 30 years. Note: We are skipping years 6, 7 You will need to use the See the formula already provided in cell D3 fo Experiment with different values in years is at least $1,000. What value did you u here,$6667.00 then return the value in A1 to Experiment with different values in after 10 years (cell E8) is at least $1,000. Wha Answer here 0.167, then return the value in A ormula in cell E3 to compute the value of the account after 1 en use the fill-down feature to complete columns D and E up rs. Note: We are skipping years 6, 7, 8, & 9. need to use the symbol “$” to lock certain cell references. ormula already provided in cell D3 for a hint. with different values in (Cell A2) until the value after 10 at least $1,000. What value did you use? Answer then return the value in A1 to $600. with different values in B2 until the value of the account years (cell E8) is at least $1,000. What value did you use? , then return the value in A2 to 0.05.

Purchase answer to see full attachment