PLEASE SHOW EXCEL formula for answer so I can rate you well. Thank you. My age is 31 years old.

1. You are offered a contract with a signing bonus. If they offered you either $215,000 in cash or $2,000 a month for 15 years, guaranteed, which do you take (based strictly on the math)? Your safe rate of return is 7.5%.

2. Computer value of the $2,000 a month here:

3. Which is greater? The lump sum or the cash flow?