Show for Mexico & China operations in Excel with the info below. Show formulas

Initial Investment/Salvage (show year 1-5)

Net Cash Flow from Operations (show year 1-5)

Repatriated Net Cash Flow from Ops (show year 1-5)

Initial Investment/Salvage (show year 1-5)

Lays has $22B in revenues from all sources in 2019 fiscal year. Lays is considering moving some of its production that is currently in the US to be sent to China and Mexico. This shift will represent about 25% of their overall production. Lays discount rate for capital investments is 11%. The China manufacturing location will cost 25B with a salvage value of 7.5B by the 5th year. Operations will drive approximately 2.0B in the first-year , while net operating revenues with 14% year over year growth thru year three and 20% year of year growth in years 4 & 5. Lays plans to repatriate 79% of all net cash flow. The Mexico manufacturing location will initially cost MEX$15B with a salvage value of MEX$ 4B by the fifth year. Operations will drive approximately MEX$ 1.0B in the first-year net operating revenues with 25% YoY (year over year) growth through year three and 30% year of year growth in years 4 & 5.Lays only plans to repatriate 60% of all net cash flow. 1 USD = 7 Yuan or 25 Mex$ (Pesos) throughout the 5 years.