Please use appropriate excel functions used and use formulatext function. Will leave positive feedback for the best answer!

Natural Mosaic Company (U.S.) is considering investing INR 50,000,000 in India to create a wholly owned tile manufacturing plant to export to the European market. After five years the subsidiary would be sold to Indian investors for INR100,000,000. A pro forma income statement for the Indian operation predicts the generation of INR7,000,000 of annual cash flow, is listed below. The initial investment will be made on December 31, 2021, and cash flows will occur on December 31 st of each succeeding year. Annual cash dividends to Natural Mosaic Composite from India will equal 75% of accounting income. The U.S. corporate tax rate is 21% and the Indian corporate tax rate is 50%. Because the Indian tax rate is greater than the U.S. tax rate, annual dividends paid to Natural Mosaic will not be subject to additional taxes in the United States. There are no capital gains taxes on the final sale. Natural Mosaic uses a weighted average cost of capital of 14% on domestic investments, but will add 6 percentage points for the Indian investment because of perceived greater risk