use the excel template below please. thank you

2. TrinTec, Inc. a chip manufacturing company is planning to establish a new factory overseas. The project requires an initial investment of $15,000,000. Management intends to own the factory for 6 years then sell it to a local tech company. Management projects the first year's cash flow of $4,000,000 will grow at approximately 3% per year over the holding period. Management also estimated an expected sales price of $5,000,000 at the end of the holding period. If TriniTec's required rate of return is 20%, how would you advise the Board to proceed? ( 25 points) Assumptions