Please show all work in excel! Will upvote once both answered thank you!
1- You want to invest an amount of money today and receive back twice (double) that amount in the future. You expect to earn 8 percent interest. Approximately how long must you wait for your investment to double in value?
7 years
8 years
not enough information to calculate
6 years
9 years
2-
You just won the lottery! As your prize you will receive $1,200 a month for 100 months. If you can earn 8% compounded monthly on your money, what is this prize worth to you today?
179,938
120,000
32,981.85
87,380.23
14,993