Question
Please help with any of this! Info obtained on _____4/26/2023 _______ - from Yahoo Finance Price ___151.25___ Shares Outstanding ___2.7B___ Annual Dividend Rate ___2.28___ Beta
Please help with any of this!
Info obtained on _____4/26/2023 _______ - from Yahoo Finance
Price ___151.25___
Shares Outstanding ___2.7B___
Annual Dividend Rate ___2.28___
Beta (5Y Monthly) ___0.49___
Next 5 Years (per annum) ___5.09____
STD Jan 2022 ___ 5,207,000___
STD Jan 2023 $ __ 6,603,000 ___
LTD Jan 2022 ___LTD 52,116,000___
LTD Jan 2023 $ ___LTD 52,320,000___
Interest expense 2023 __2,128,000____
- from Morningstar.com
Tax rate ___.34___
ROE ___14.60%___
Payout ratio __52.46____
- from excel doc or website
Risk free ___0.12%___
Market premium (from excel doc) __12.32%____
Calculations:
Dividend growth rate -
historical dividends g = ___-1.24%___ -
Sustainable growth rate g = __6.94%____
Total debt 2023 = ___58,923,000___
Total debt 2022 = ___57,323,000___
Cost of equity CAPM Ce = ___-0.15%___
DDM Using analysts estimate Ce = ______
Using historical data Ce = ______
Using sustainable growth rate Ce = ______
Decide which cost of equity you will use and explain your decision.
Cost of debt Cd = ______
After-tax Cd= ______
Weights Total Debt 2023 = ______
Mk value of equity = ______
We = ______
Wd = ______
Compute WACC WACC =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started