Intro It is the end of 2022. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2023 2024 2025 2026 2027 Cash flow 1,100 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 8%. Part 1 IB Attempt 1/10 for 10 pts. Create an Excel spreadsheet showing the years and cash flows as in the table above, then add a row that shows the number of years from now and another row that shows the present value of each cash flow. What is the sum of present values? Hint: do not hardcode the discount rate into your formulas. Instead, keep it in a separate cell and refer back to it. You'll be asked to change in discount rate in parts 4 to 7. 6787 Correct It is considered best practice to keep the discount rate in a separate cell (B1 in this example), so that it is easy to see and easy to change. B D E F 1 Disc. rate 0.08 2 3 Year 2023 2024 2025 2026 2027 Sum 4 From now 1 2 3 4 5 5 Cash flow 1,100 1,600 1,800 2,000 2,200 6 PV2022 1,018.52 1,371.74 1,428.9 1,470.06 1,497.286,787 14A Part 4 IB Attempt 1/10 for 10 pts. Now assume that the interest rate is 6%. What is the present value of all the gifts? 0+ decimals e Submit BrAttempt 1/10 for 10 pts. Part 5 Still assume that the interest rate is 6%. What is the future value of all the gifts? 0+ decimals Submit Part 6 IB Attempt 1/10 for 10 pts. Now assume that the interest rate is 12%. What is the present value of all the gifts? 0+ decimals Submit Part 7 18 Attempt 1/10 for 10 pts. Still assume that the interest rate is 12%. What is the future value of all the gifts? 0+ decimals