Question: can you help me inputing the exact inputs into excel, I Know the hardcode formula but not how to exactly input in execl. The probelm

529. (Comparing present and future values) Much to your surprise, you were selected to appear on the TV show The Price Is Right. As a result of your prowess in identifying how many rolls of toilet paper a typical American family keeps on hand, you win the opportunity to choose one of the following: $1,000 today, $10,000 in 12 years, or $25,000 in 25 years. Assuming that you can earn 11 percent on your money, which should you choose? K50 A B C D E F G H 1 2 3 4 5 6 P5-29M (change the interest rate you can earn to 7%) Much to your surprise, you were selected to appear on the TV show The Price is Right. As a result of your prowess in identifying how many rolls of toilet paper a typical American family keeps on hand, you will win the opportunity to choose one of the following: $1,000 today, $10,000 in 12 years, or $25,000 in 25 years. Assuming that you can earn 7 percent on your money, which should you choose? 7 8 9 $1,000 today $10,000 in 12 years PV 1 nper m FV $25,000 in 25 years 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 PV i nper m FV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
