One of the biggest mystery is the exclusion of BRK-A from the DJIA (or the DOW Index). The reason is BRK-A share price is far higher than any other companies in the DOW. Suppose that WBA was replaced by BRK-A in December 31, 2021 when their prices were $43.5 a share and $375,000 a share respectively. The value of the DJIA divisor was 0.14748 at the end of 2021. How will the divisor change if this change have happened? What would be the value of the DOW today (using the closing prices of the companies in the DOW and BRK-A a week before this assignment is due)?

Please show how to solve in excel