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

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

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

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!