Part $1$: It is the end of $2024.$ 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 $20252026202720282029$

Cash flow $1,0001,6001,8002,0002,200$

Your uncle is fairly wealthy and very reliable. You currently have $$10,000$ in a savings account paying an annual interest rate of $11\%.$

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.$ annual interest rate of $11\%.$

Part $2$: You also want to know how much each gift will be worth in $2029$ if you save it$.$ Add another row to your spreadsheet and calculate the value of each cash flow in $2029.$ What is the sum of all future values?

Part $3$: What is the present value of the sum of future values calculated in the previous part?

Part $4$: Now assume that the interest rate is $9\%.$ What is the present value of all the gifts?

Part $5$: Still assume that the interest rate is $9\%.$ What is the future value of all the gifts?

Part $6$: Now assume that the iStill assume that the interest rate is $15\%.$ What is the future value of all the gifts?nterest rate is $15\%.$ What is the present value of all the gifts?

Part $7$: Still assume that the interest rate is $15\%.$ What is the future value of all the gifts?

Please show all the formulas used to assess each Present & Future value. Thank you.