Resuelva en una hoja de c$$lculo de Excel.

Global perspective: In Mexico vehicle market had been tightening for the past years. This OEM had decided to do some changes and invest in a new electric vehicle to be produced in Mexico and Venezuela. Initial investment is $350 Million usd (assume is the same amount per country). Marketing had made a tremendous work putting together a 6-Year-plan assuming a year over year increase of 5%. Sales starting in year 1 are: 30,000 Units. Marketing is expecting to sell this for $45,000 Usd/vehicle. Assume: Inflation in Mexico: 4.6% Inflation in Venezuela: 80% Only 30% of the initial investment are depreciable assets in Mexico. Assume no depreciation allowed in Venezuela. Taxes in Mexico are 30% Taxes in Venezuela are 10% Expenses are 55% of income. Please provide an excel file with NPV, TIR rate and the answer to the following questions. 1.- Invest in both countries is feasible? Yes/no, Why? 2.- Based on data from question 1. What are your recommendations? 3.- Assume we obtain an investor that requires 70% MARR. Would this project be profitable for them?