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
Mathematics, 21.06.2019 23:00
40 points. given: two congruent angles ∠c and ∠r are supplementary. prove: ∠r and ∠c are both right angles. it doesn't have to be exactly 10 rows.statements reasons1. 1. 2. 2. 3. 3. 4. 4. 5. 5. 6. 6. 7. 7. 8. 8. 9. 9. 10. 10.
Answers: 2
Mathematics, 21.06.2019 23:50
Mariah is randomly choosing three books to read from the following: 5 mysteries, 7 biographies, and 8 science fiction novels. which of these statements are true? check all that apply. there are 20c3 possible ways to choose three books to read. there are 5c3 possible ways to choose three mysteries to read. there are 15c3 possible ways to choose three books that are not all mysteries. the probability that mariah will choose 3 mysteries can be expressed as . the probability that mariah will not choose all mysteries can be expressed as 1 −
Answers: 1
It is the end of 2021. You plan to complete a Ph. D. in 5 years. Your favorite uncle has promised to...
Mathematics, 07.10.2019 22:40
Mathematics, 07.10.2019 22:40
English, 07.10.2019 22:40
World Languages, 07.10.2019 22:40
Social Studies, 07.10.2019 22:40
English, 07.10.2019 22:40
History, 07.10.2019 22:40
Social Studies, 07.10.2019 22:40
Social Studies, 07.10.2019 22:40