Background Congratulations! You recently won $200,000 after tax after betting big on the Kansas City Chiefs to win the Super Bowl. Nice work betting your life savings.

Now that you have some cash, it's time to investigate and few options:

Option 1 - Buy A House Or Condo: 1. Find a house or condo you like that is actually listed. You can find it on Zillow or any other site. The property has to be priced reasonably between $500k - $700k. 2. Using your $200K, you need to put together a capital stack of how much equity and debt you will need to close. To do so, you will probably have to contact a bank or mortgage lender to figure out current mortgages available. The analysis here has to include any fees or points required in an actual mortgage with today's rates. 3. Please assess your options of taking out a 30 year fixed rate mortgage vs a 5 year ARM. 4. What is the APR of this mortgage and EBC if you hold for 5 years? 5. Please show all details on how this transaction will work, what the payments look like, and which option of mortgage you prefer and why.

Option 2 - Invest In A Mortgage Fund: Your friend has given you the option of investing in his mortgage fund, for an anticipated yearly return of 13% for 5 years, paid yearly at the end of the year. 1. Please show how this investment will look with future value.

Option 3 - Invest In A Rental Property: Invest the money in a $200K rental property, with no mortgage, that gives you $20K year 1, $27k year 2, $29K year 3, $33K year 4, and $40K year 5, and then you can sell it for $220K. 1. What is the IRR here?

Option 4 - What Happens In Vegas Stays In Vegas: Go to Vegas, collect your cash, and spend it on the rest of your Vegas trip (i.e. casinos, hotel parties, clubs, etc.). We won't judge you if this is your option! 1. Tell us the pros and cons of this option. 2. If you choose this option, please give detailed reasoning as to why.

- Explain in detail each calculation in a excel document for each option.

- Explain which option would be the best one?