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

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 in excel is modifed from the book. Thank you
can you help me inputing the exact inputs into excel, I Know
the hardcode formula but not how to exactly input in execl. The

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

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!