this is the sixth time I am posting this question. please look over the formula

B 1-year forward exchange rate, U.S. dollars required to buy 1 peso Annual depreciation rate of peso against dollar Peso-denominated dividend annual growth rate Number of common shares owned Cost of equity.rs $0.10 5.00% 8.00% 5,000,000 13.00% FC Step 1: Convert Pesos to Dollars Year 1 dividends in dollars, Di Step 2: Find the Growth Rate in Dollar-Denominated Divdiends: Growth in exchange rate Growth rate in dollar-denominated dividends Step 3: Calculate the Per-Share Stock Price in Dollars: Po Step 4: Calculate the Dollar Value of the Equity Investment: Value of equity investment, in dollars Chapman, Inc.'s Mexican subsidiary, V. Gomez Corporation, is expected to pay to Chapman 20 pesos in dividends in 1 year after all foreign and U.S. taxes have been subtracted. The exchange rate in 1 year is expected to be $0.10 per peso. After this, the peso is expected to depreciate against the dollar at a rate of 5% a year forever due to the different inflation rates in the United States and Mexico. The peso- denominated dividend is expected to grow at a rate of 8% a year indefinitely. Chapman owns 5 million shares of V. Gomez. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below