Find WACC using the following info - Price $149.52

Shares Outstanding 2.7B

AnnualDividendRate 2.28

Beta(5YMonthly) 0.49

Next5Years(perannum). 5.09%

STDJan2022 $5207000000

STDJan2023$ 6603000000

LTDJan2022 52116000000.

LTDJan2023 $52320000000

Interestexpense2023. $2,128,000

• fromMorningstar.com Tax rate 25.4%

ROE 14.60%

Payoutratio: 2022 68.62, 5 yr avg 60.06

• fromexceldocorwebsite Marketpremium(fromexcel doc) -18.01%

For historical dividend growth, use data between 3/8/2013 and 12/8/2022. This represents ten years of dividends.

2013-03-08	2013-04-01	0.470 USD(18.09%)
2022-12-08	2023-01-03	0.560 USD

SOLVE FOR: Dividendgrowthrate

historicaldividendsg=

Sustainablegrowthrateg=

Totaldebt2023=

Total debt 2022=

Ce=

CAPM =

DDM=

Using analysts estimate Ce=

Using historical date Ce=

using sustainable growth rate Ce =

Cost of debt, Cd =

After tax Cd =

Mk Value of equity =

We =

Wd =

Wacc =