Please make sure that you use formulas in Excel or type the answers on the Excel sheet.

Suppose that you invested $5000 in a mutual fund. Four years later you had $7000. What was your rate of return? Suppose that you are thinking of buying a $200,000 house. What would be your monthly payment on a 30-year mortgage loan to buy the house if the annual interest rate is 5%? Suppose that you plan to retire when you have saved $1,000,000. If you can earn 11% on your money by investing in a stock mutual fund, how many years will it take to reach your goal if you add $5000 each year to your savings? Suppose that you are a manager for Abeka, Inc. You are evaluating a project that would result in improved efficiency for the organization. You estimate that the improved efficiency would allow the organization to save money for the next six years. The project, however, has initial upfront costs of $100,000. The organization's required return is 11%. Evaluate this project using NPV. What do you recommend? Explain your recommendation. The expected net cash flows are listed below. Net cash flows for a given year-cash inflows minus cash outflows