1) Construct a pro-forma p&l and cash flow statement for 2021 to 2030 for the company assuming the relocation of Canadian production to Mexico. Comparing the base case (declining sales in Canada due to tariff/costs) vs. the scenario of moving production for Canadian customers to Mexico what are the financial impacts? (note: the answers to this set of questions should come from the Summary tab in the provided excel workbook)
a. What is the cash investment required in 2021 (expenses, severance, & working capital)?
b. What is the cash flow impact by year: 2021-2030 of moving production to Mexico vs. the base case?
c. What is the NPV of the move scenario vs. the base case? And what is the IRR?
2) Are there possible cost impacts that were not addressed or may need to be estimated in the Mexico scenario? If so, what are they? Did the group need to make any additional assumptions to complete the analysis and if so, what are they?
