Excel formula needed to calculate answers 1-9.

D G H K M N R 1 4. Your saving for a child's college fund. You currently have $50,000 but want to have $150,000 in 10 years. What annual interest rate must the $50,000 be invested so that it will grow to be $150,000? 2 3 1. Future value amount(s) 150000 4 2. Present value amount -50000 5 3. Time and number of periods (including compounding timing) 10 6 4. Interest rate ??? 11.61% 7 8 TIMELINE interest balance 9 0 50000 50000 10 1 $ 5,806 $ 55,806 11 2 $ 6,480 $ 62,287 12 3 $ 7,233 $ 69,519 13 4 $ 8,073 $ 77,592 14 5 $ 9,010 $ 86,603 15 6 $ 10,057 $ 96,659 16 7 $ 11,224 $ 107,883 17 8 $ 12,528 $ 120,411 18 9 $ 13,983 $ 134,394 19 10 150000 $ 15,606 $ 150,000