Calculate ROA and ROE ratios of your selected company for 3 years based on DuPont Ratio. Analyze
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Related Book For
Entrepreneurial Finance
ISBN: 978-0538478151
4th edition
Authors: J . chris leach, Ronald w. melicher
Posted Date: