Mathematics, 20.09.2021 01:00 desderievelasquez

It is the end of 2021. 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 2022 2023 2024 2025 2026 Cash flow 1,200 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 6%. 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.

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

What is the present value of the sum of future values calculated in the previous part?

Now assume that the interest rate is 4%. What is the present value of all the gifts?

Still assume that the interest rate is 4%. What is the future value of all the gifts?

Now assume that the interest rate is 10%. What is the present value of all the gifts?

Still assume that the interest rate is 10%. What is the future value of all the gifts?

Answers: 1

Show answers

Another question on Mathematics

Mathematics, 21.06.2019 23:30

Pleting the square f the given find the x-intercepts of the parabola with vertex (-5,13) and y-intercept (0, 12). write your answer in this form: (14,.99). if necessary, round to the nearest hundredth. *- h enter the correct answer, de verter, and ametry 00000 done doo

Answers: 2

Answer

Mathematics, 22.06.2019 00:10

Which polygon is she in the process of constructing ?

Answers: 1

Answer

Mathematics, 22.06.2019 00:20

When steve woke up. his temperature was 102 degrees f. two hours later it was 3 degrees lower. what was his temperature then?

Answers: 3

Answer

Mathematics, 22.06.2019 00:40

Ican interpret and represent the remainder in division calculations sensibly for the context (eg 27.4 in calculating average height in cm: $27.44 if it represents an amount of money) solve the following problems. 15) the wildlife park charges $25.50 dollars per person to enter their park if the park made $15096 dollars today, how many people entered the park? 16) ms adams plus 2,230 other keen runners ran a marathon: between them they ran 94817.5km. how many km did each competitor run?

Answers: 1

Answer

You know the right answer?

It is the end of 2021. You plan to complete a Ph. D. in 5 years. Your favorite uncle has promised to...

Questions

Mathematics, 21.09.2021 02:00

A baseball team played three consecutive home games. The first game was attended by 28,453 people. The second game was attended by 30,678 people. The...