Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Makers And Takers The Rise Of Finance And The Fall Of American Business

Authors: Rana Foroohar

1st Edition

0553447238, 978-0553447231

More Books

Students also viewed these Finance questions

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

5. What are the main groups without health insurance? LO24.3

Answered: 1 week ago