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 19:30

Order the measurements from the least to the greatest. 2,720 ml , 24.91 l , 0.0268 kl

Answers: 1

Answer

Mathematics, 22.06.2019 01:30

Simplify the rational expression. state any restrictions on the variable. t^2-4t-12 / t-8 the / is a fraction sign.

Answers: 1

Answer

Mathematics, 22.06.2019 02:20

What is the length of ac in the given triangle?

Answers: 1

Answer

Mathematics, 22.06.2019 03:50

Amovie producer conducted a survey after the screening of his movie to find out how the film would be received by viewers from different age groups. the columns in the two-way table indicate the numbers of viewers who rated the film on a four-point scale: excellent, good, average, and poor. viewer's age group excellent good average poor marginal totals 16-25 52 42 12 7 113 26-35 33 50 5 9 97 36-45 58 12 28 34 132 which of these observations is supported by the data in the table? note: a rating of good or excellent means the audience liked the movie, while a rating of poor means the audience disliked the movie. a. the majority of the audience in the 26-35 age group disliked the movie. b. among those who liked the movie, the majority were in the oldest age group. c. among those who disliked the movie, the majority were in the 26-35 age group. d. the majority of the audience in the 16-25 age group liked the movie. e. the majority of the audience from all the age groups disliked the movie

Answers: 3

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, 09.02.2021 21:10

C) What is the area of the shape in Step n? ...

Mathematics, 09.02.2021 21:10

Conuder the function defined by f(x) = 7 – 2e-3a Find the limit ( at infinity) of f....