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
Get step-by-step solutions from verified subject matter experts
