Project A requires an investment (cost) of $900,000 in a project that is expected to save the company $300,000 each year. [7 marks] Another project, project B requires costs of $300,000 with no associated cash savings that will make the company an incremental $150,000 each year for the next 20 years at $3 million. Clearly, the second project can make the company twice as much money, but: 1. How long will it take to pay the investment back for Projects A and B? Show your detailed work by using the payback formula and upload an Excel sheet with the payback period graph. [3 marks] 2. Which project would you select for the short team investment (4 years)? And Why? [1 mark] 3. Using the Trend analyses (linear Regression), for a long-term investment (say 10 years) what would be the return on investment for Project A and B? Which project is more profitable? (Show your linear regression equation and calculation) [3 marks]