What is the cash flow impact by year: 2021-2030 of moving production to Mexico vs. the base case?

Make a power point presentation with notes and Answer only these two questions and do it in the excel file provided.

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  vs. the scenario of moving production for Canadian customers to Mexico what are the financial impacts?
a. What is the cash investment required in 2021?
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?

© 2020 Essaylane.com. All Rights Reserved. | Disclaimer: for assistance purposes only. These custom papers should be used with proper reference.