Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It is the end of 2023. You plan to complete a Ph. D. in 5 years. Your favorte uncle has promised to help you with

image text in transcribed
image text in transcribed
It is the end of 2023. You plan to complete a Ph. D. in 5 years. Your favorte uncle has promised to help you with your tschool expenses by giving you the following amounts for Christmas: Your uncle is faity wenttly and sery relable. You currenty have $10,000 in a savings acoount paying an annual interest rate of 14%. Part 1 - Attempt 2/3 for 95 pts. Create an Excel sproadsheet showing the yours and cash flows as in the table abovo, then add a row that shows the number of ytars from now and another row that thows the present value of each cash fow, What is the sum of prosent values? Hint: do not hardoode the decount tate into your formulas, Instead, keep it in a separate cell and refer back to it. You't be asked to chanpe in discount rate in parts 4 to 7 . Part 2 - Arempt is tor 10 pts You also wart to know how much each git wit be worth in 2028 if you save it. Add another row to your spreadiheet and calculate the value of each cash flow in 2028. What is the sum of al future values? Part 3 - Atempet is tor 10 po What is the prosent valoe of the sum of futere vilues calculated in the provious part? Now assume that the interest rate is 12%. What is the present value of all the gifts? Part 5 F Attempt 1/3 for 10 pts. Still assume that the interest rate is 12%. What is the future value of all the gifts? Part 6 * Attempt 1/3 for 10 pts. Now assume that the interest rate is 18%. What is the present value of all the gifts? Part 7 Attempt 1/3 for 10 pts. Still assume that the interest rate is 18%. What is the future value of all the gifts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The School Fundraising Handbook

Authors: Lindsey Marsh

1st Edition

1785834266, 978-1785834264

More Books

Students also viewed these Finance questions

Question

Who are our markets? Within those, who are our target markets? P987

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago

Question

What is the role of the Joint Commission in health care?

Answered: 1 week ago