Your friend, Mike Szyslak wants be a millionaire, and he found several ways applicable. But he is still hesitating among the various options and comes to you for financial advice. Use TVM tables, or financial calculator, or Excel (to show formulas) to solve these problems, and present a report to explain the concept of Time Value of Money.

Option 1: He is considering to buy Mega Millions lottery. If the current tax rate on earnings of lottery is 40%, how much money will he have to win on a lottery to become a millionaire? Option 2: His uncle promised to invest his business $100.000 a year over the next 15 years, and the interest rates over next 15 years are expected be at 5% per annual. Can you help him to know whether the present value of such series of investments make him equivalent to be a millionaire today? Option 3: He considers to save money and become a millionaire. Starting at age 22, every night Mike takes $5 out of your pocket and put it in a manila envelope. At the end of the year, you place the money from the envelope in a stock fund with an average interest rate of 10%. Will the amount he has in the account ensure him a millionaire when you retire at age 65? What if he starts saving at age 40? Option 4: He sets aside $50,000 into a saving account now, and will deposit $50,000 into the account at the beginning of each year for next 10 years. If the market rate is 10%, Will he become a millionaire in 10 years? Option 5: Mike considers to buy 1,000 bonds. The bond is semi-annual coupon bond with 10-year maturity, $1,000 par value bond with a 10 percent annual coupon, and 10 percent annual required rate of return? How much does it cost now if he wants to receive all the coupon payments and par values during the 10-year period? What would be the value of the bond if, just after it had been issued, the expected inflation rate rose by 3 percentage points, causing Mike to require a 13 percent return? What would happen to the bonds' value if inflation fell, and required rate of return declined to 7 percent? Which of the options would you recommend that Mike choose? Why