1 Tab 4 Part 1: FY - PV (1+i) An lavested Interest No. of Use Excel 2 # Amount (PV) Rate (1) Periods (n) Function Use Formula 91 15000 6% 12 4. 2 200 na 10 6 3 30000 12% 20 64 50000 12 7 & Tab 1 Part 2: FV - PV (L=1*n: PY - FV / (1+1)^1 Interest No. of Use Excel # Future Value Rate Periods Function Use Formula 10 1 20000 7% 10 11 2 140 00 8% 12 12 3 25000 12% 20 18 4 40000 10% 8 14 15 Tah 4 Part 3: 16 Nichole deposits $20,000 in her savings account earning 4% interest quarterly and leaves it 17 there for 7 years. What does she have at the end of 7 years? Show the formula you can use to get the answer 19 Now, we low excel furuction to calculate your number: 20 21 Tor wants to have $12,000 by Summer 2022 to take me on a super nice vacation. How much 92 money does die wed to put away at the end of EACH MONTH to be able to live il grow le $12,000 28 by June 2022. Ee can earn 4% on his money (hiat: this is an annual rate). 24 Ile will start putting money away at the end of November 2020 (10 months). 1 Tab 4 Part 1: FY - PV (1+i) An lavested Interest No. of Use Excel 2 # Amount (PV) Rate (1) Periods (n) Function Use Formula 91 15000 6% 12 4. 2 200 na 10 6 3 30000 12% 20 64 50000 12 7 & Tab 1 Part 2: FV - PV (L=1*n: PY - FV / (1+1)^1 Interest No. of Use Excel # Future Value Rate Periods Function Use Formula 10 1 20000 7% 10 11 2 140 00 8% 12 12 3 25000 12% 20 18 4 40000 10% 8 14 15 Tah 4 Part 3: 16 Nichole deposits $20,000 in her savings account earning 4% interest quarterly and leaves it 17 there for 7 years. What does she have at the end of 7 years? Show the formula you can use to get the answer 19 Now, we low excel furuction to calculate your number: 20 21 Tor wants to have $12,000 by Summer 2022 to take me on a super nice vacation. How much 92 money does die wed to put away at the end of EACH MONTH to be able to live il grow le $12,000 28 by June 2022. Ee can earn 4% on his money (hiat: this is an annual rate). 24 Ile will start putting money away at the end of November 2020 (10 months)