Question: Please answer the following questions using Excel: You won the lottery and you need to choose between these two options: Option A: You receive $10,000

Please answer the following questions using Excel:

You won the lottery and you need to choose between these two options: Option A: You receive $10,000 today, and 5 payments of $2,000 each for the next 5 years. The first of this 5 payments will be made the end of this year. Option B: You receive $18,000 today. Assume the annual interest rate is 5%, which option would you choose? Justify your answer by showing your calculations

Your parents want to provide the local library with financial support for the next 10 years. They pledge to give $1,500 to the library today, then 3 donations of $2,000 each for the next 3 years, followed by 6 donations of $2,500 each, and a final donation of $5,000 at the end of year 10. If the annual rate of interest is 5%, how much money will your parents have spent at the end of 10 years?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!