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\mathrm{.}5$ a share and $$375,000$ a share respectively. The value of the DJIA divisor was $0\mathrm{.}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 last weeks closing prices of the companies in the DOW and BRK$)$

Show me how to solve using excel please.