Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

No other info... I have to solve it with only those info....plz help Assignment

ID: 2715991 • Letter: N

Question

No other info... I have to solve it with only those info....plz help

Assignment – Discounted Cash Flow Valuation:

Selected company is 3M Company (MMM). Using the facilities of ValuePro (http://www.valuepro.net) for the company that you have selected to study conduct a discounted cash flow valuation. The analysis should explain each variable used in the analysis, why you accepted the given input, or how and why you changed a variable. The analysis should also examine the relevant cash flows, compare the final valuation to the stock’s current price and explain any differences. (Note: Remember to adjust the equity risk premium to between 5% and 6%; also, adjust the growth rate to an appropriate long-term growth rate.)

Intrinsic Stock Value 125.07 Excess Return Period (yrs) 10 Depreciation Rate (% of Rev) 4.31 Revenues ($mil) 30052 Investment Rate (% of Rev) 4.96 Growth Rate (%) 8.84 Working Capital (% of Rev) 20.52 Net Oper. Profit Margin (%) 20.92 Short-Term Assets ($mil) 13855 Tax Rate (%) 28.972 Short-Term Liab ($mil) 6041 Stock Price ($) 156.73 Equity Risk Premium (%) 5 Shares Outstanding (mil) 690.2 Company Beta 0.8925 10-Yr Treasury Yield (%) 5 Value Debt Out. ($mil) 4864 Bond Spread Treasury (%) 1.5 Value Pref. Stock Out. ($mil) 0 Preferred Stock Yield (%) 7.5 Company WACC(%) 9.25

Explanation / Answer

SHARES OUTSTANDING(MIL)=690.2

STOCK PRICE=$156.73

EQUITY(MIL)=$1,08,175.046

VALUE OF DEBT OUT.(MIL)=$4,864

TOTAL DEBT AND EQUITY(MIL)=$1,13,039.046

COMPANY WACC=9.25%=$1,13,039.046MIL*9.25%=$10,456MIL

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote