John is the CEO of a very successful company. He is healthy and planning on retiring from the company at the age of 55 years to pursue his dream of helping others (I am a bit jealous of John). His company is offering two options for his retirement: Option 1: Five hundred thousand dollars today and $900,000 everyday for next 30 years. Option 2: $900 right now and then double the amount given the previous year for next 30 years. Which option should John choose and why? Please write your advice using complete sentences and mathematical proof (hint: include formulas)!

Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of $16,000 per month for 25 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $375,000. Third, after he passes on at the end of the 25 years of withdrawals, he would like to leave an inheritance of $1.5 million to his nephew Frodo. He can afford to save $2,150 per month for the next 10 years. If he can earn an EAR of 10 percent before he retires and an EAR of 7 percent after he retires, how much will he have to save each month in Years 11 through 30? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Michael Scott is 30 years old at the beginning of the year and is thinking about getting an MBA. Michael is currently making $40,000 per year and expects the same for the remainder of his working years (until age 65). If he goes to a business school, he gives up his income for two years and, in addition, pays $20,000 per year for tuition. In return, Michael expects an increase in his salary after his MBA is completed. Suppose that the post-graduation salary increases at a 5% per year and that the discount rate is 8%. What is minimum expected starting salary after graduation that makes going to a business school a positive-NPV investment for Michael? For simplicity, assume that all cash flows occur at the end of each year.  This is about time value of money, need excel for formula and solution, u can use shortcut in excel if applicable like PMT NPER and etc.

Colin is 40 years old and wants to retire in 27 years. His family has a history of living well into their 90s. Therefore, he estimates that he will live to age 95. He currently has a salary of $150,000 and expects that he will need about 75% of that amount annually if he were retired. He can earn 8 percent from his portfolio and expects inflation to continue at 3 percent. Some years ago, he worked for the government and expects to receive an annuity that will pay him $20,000 in today's dollars per year beginning at age 67. The annuity includes a cost of living adjustment, which is equal to inflation. Colin currently has $200,000 invested for his retirement. His Social Security benefit in today's dollars is $30,000 per year at normal age retirement of age 67. How much does he need to accumulate at age 67 exclusive of his pension and Social Security benefits? ANSWER CHOICES: $2.2 million $2.1 million $2.8 million $2.9 million