Question
Done Below: DCF & CPER Calculations & Three Year Averages Historical Data Components/Ratios 2017 2018 2019 Three Year Average Business Revenue 76,450,000,000 81,581,000,000 82,059,000,000 80,030,000,000
Done Below:
DCF & CPER Calculations & Three Year Averages
Historical Data Components/Ratios 2017 2018 2019 Three Year Average
Business
Revenue 76,450,000,000 81,581,000,000 82,059,000,000 80,030,000,000
COG
and Services 25,354,000,000 27,091,000,000 27,556,000,000 26,667,000,000
Operating
Inc/Exp 32,382,000,000 34,441,000,000 34,423,000,000 33,748,666,667
EBIT
18,714,000,000 20,049,000,000 20,080,000,000 19,614,333,333
Sales
76,450,000,000 81,581,000,000 82,059,000,000 80,030,000,000
EBIT/Sales
24.48% 24.58% 24.47% 24.51%
Income
tax expense 16,373,000,000 2,702,000,000 2,209,000,000 7,094,666,667
Income
before sales 17,673,000,000 17,999,000,000 17,328,000,000 17,666,666,667
Tax
Rate (Income tax exp/Income before sales) 92.64% 15.01% 12.75% 40.13%
Property,
plant & equip 17,005,000,000 17,035,000,000 17,658,000,000 17,232,666,667
Sales
76,450,000,000 81,581,000,000 82,059,000,000 80,030,000,000
Property,
Plant & Equipment/Sales 22.24% 20.88% 21.52% 21.55%
Depreciation
24,461,000,000 24,816,000,000 25,674,000,000 24,983,666,667
Property,
plant & equip 17,005,000,000 17,035,000,000 17,658,000,000 17,232,666,667
Depreciation/Property, Plant & Equipment 1.44 1.46 1.45 1.45
Current
Assets 43,088,000,000 46,033,000,000 45,274,000,000 43,088,000,000
Current
Liabilities 30,537,000,000 31,230,000,000 35,964,000,000 33,597,000,000
Net
Working Capital 12,551,000,000 14,803,000,000 9,310,000,000 12,221,333,333
Sales 76,450,000,000 81,581,000,000 82,059,000,000 80,030,000,000
Net Working Capital/Sales 0.16 0.18 0.11 0.15
- Determine the stock price? Note: your enterprise value is in thousands of dollars and the number of shares outstanding Is in billions.
Submit a summaryof your analysis and valuation with a few brief summary exhibits explaining how your analysis and outlook are quantified in your valuation model.Would you recommend investing in the company? Why or why not?
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