Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate ROA and ROE ratios of your selected company for 3 years based on DuPont Ratio. Analyze the trend and explain the reason of the
Calculate ROA and ROE ratios of your selected company for 3 years based on DuPont Ratio. Analyze the trend and explain the reason of the increase/decrease in those ratios.
Provide a table of three years Actual and five years forecast of income Statements of your selected company. Include the assumptions that you used for your forecast. For example how did you calculate future revenues, expenses, and other items and why?
Breakdown | 2019 | 2018 | 2017 | 2016 |
Total Revenue | 4'509'000 | 4'313'200 | 4'088'400 | 3'900'900 |
Cost of Revenue | 1'517'600 | 1'434'000 | 1'425'300 | 1'376'200 |
Gross Profit | 2'991'400 | 2'879'200 | 2'663'100 | 2'524'700 |
Operating Expenses | ||||
Selling General and Administrative | - | - | - | 0 |
Total Operating Expenses | 2'398'400 | 2'242'500 | 2'065'700 | 1'959'500 |
Operating Income or Loss | 593'000 | 636'700 | 597'400 | 565'200 |
Interest Expense | 35'000 | 18'800 | 15'600 | 14'100 |
Income Before Tax | 561'100 | 620'600 | 582'800 | 554'100 |
Income Tax Expense | 49'200 | 133'500 | 130'300 | 134'300 |
Income from Continuing Operations | 511'900 | 487'100 | 452'500 | 419'800 |
Net Income | 509'600 | 485'100 | 450'700 | 419'700 |
Net Income available to common shareholders | 509'600 | 485'100 | 450'700 | 419'700 |
EBITDA | 918'900 | 818'900 | 767'400 | 719'700 |
Intangible Assets | 603,700 | 602,100 | 610,000 | 620,800 |
Total non-current assets | 5,065,100 | 4,316,800 | 4,194,500 | 4,054,300 |
Total Assets | 8,040,800 | 7,249,800 | 6,975,600 | 6,428,800 |
Liabilities and stockholders' equity | ||||
Liabilities | ||||
Current Liabilities | ||||
Current Debt | 505,500 | 12,300 | 9,200 | 316,400 |
Accounts Payable | 233,900 | 214,200 | 217,300 | 180,400 |
Total Current Liabilities | 1,689,700 | 1,028,100 | 1,049,800 | 1,258,900 |
Non-current liabilities | ||||
Long Term Debt | 498,500 | 998,700 | 998,200 | 748,900 |
Deferred taxes liabilities | 541,500 | 467,000 | 444,200 | 433,500 |
Other long-term liabilities | 5,900 | 6,600 | 7,700 | 7,600 |
Total non-current liabilities | 1,680,900 | 1,735,300 | 1,730,800 | 1,495,900 |
Total Liabilities | 3,370,600 | 2,763,400 | 2,780,600 | 2,754,800 |
Stockholders' Equity | ||||
Common Stock | 24,300 | 24,300 | 24,100 | 23,700 |
Retained Earnings | 4,982,200 | 4,655,400 | 4,246,200 | 3,743,800 |
Total stockholders' equity | 4,659,800 | 4,477,300 | 4,186,300 | 3,667,200 |
Total liabilities and stockholders' equity | 8,040,800 | 7,249,800 | 6,975,600 | 6,428,800 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To calculate the ROA Return on Assets and ROE Return on Equity ratios using the DuPont analysis I will use the financial data provided for the selecte...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