Question: Need help writing correct formulas in excel to get the answers provided below. 3a. You have won a jackpot at a casino! The casino is

3a. You have won a jackpot at a casino! The casino is offering to pay you $30,000 five years from now or $25,000 today. You aren't sure which option to take. Let's calculate the second option ( $25,000 today). Assume that you can invest the money and earn 3.5\% each year compounded monthly. How much will $25,000 given to you today be worth five years from now? 3b. Remember IF statements? Let's mix the IF statement with the financial function that you wrote for question 3a. Using the same data as in question 3a, write a formula that displays "Take the money now!!" or "Wait five years" depending on the result of the financial function as compared to $30,000. Don't refer to the result in the cell calculated for question 3a - put the financial function in an IF statement to practice using an IF function with a financial function. 3c. The casino threw in a new twist. In addition to the previous offer (options 1 and 2 ): 1) $30,000 five years from now, or 2) $25,000 today Numeric Answers to Exercises (you have to write the formulas to calculate the numbers)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
