Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ineed both the horizontal and vertical analysis for the income statement. I filled out the excel sheet to the best of my knowledge. Here are
Ineed both the horizontal and vertical analysis for the income statement. I filled out the excel sheet to the best of my knowledge. Here are the spreadsheets containing the income statement and balance sheet :
Revenue | 2020 | 2019 | 2018 |
Total Revenue | $220,747.00 | $213,883.00 | $225,847.00 |
Cost of Revenue | 53,768 | 46,291 | 39,748 |
Gross Profit | 274,515 | 260,174 | 265,595 |
Operating Expenses | |||
Research Development | 18,752 | 16,217 | 14,238 |
Selling General and Administrative | 19,916 | 18,245 | 16,705 |
Non Recurring | |||
Others | |||
Total Operating Expenses | 38,668 | 34,462 | 30,943 |
Operating Income or Loss | 235,847 | 225,712 | 234,652 |
Income from Continuing Operations | 66,288 | 63,930 | 70,898 |
Total Other Income/Expenses Net | 803 | 1,807 | 2,005 |
Earnings Before Interest and Taxes | 67,091 | 65,737 | 72,903 |
Interest Expense | |||
Income Before Tax | |||
Income Tax Expense | 9,680 | 10,481 | 13,372 |
Minority Interest | |||
Net Income From Continuing Ops | $57,411.00 | $ 55,256.00 | $ 59,531.00 |
Nonrecurring Events | |||
Discontinued Operations | 1202 | 3802 | -3407 |
Extraordinary Items | -63 | 25 | 1 |
Effect of Accounting Changes | 1139 | 3827 | -3406 |
Other Items | 42 | 2781 | 3026 |
Net Income | |||
Net Income | 57,453 | 58,037 | 56,505 |
Current Assets | |||
Cash and Cash Equivalents | 38,016 | 48,844 | 25,913 |
Short-Term Investments | |||
Net Receivables | 16,120 | 22,926 | 23,186 |
Inventory | 4,061 | 4,106 | 3,956 |
Other Current Assets | 11,264 | 12,352 | 12,087 |
Total Current Assets | 69,461 | 88,228 | 65,142 |
Long Term Investments | |||
Property Plant and Equipment | 36,766 | 37,378 | 41,304 |
Goodwill | |||
Intangible Assets | |||
Accumulated Amortization | |||
Other Assets | 108,175 | 175,697 | 234,386 |
Deferred Long-Term Asset Charges | |||
Total Assets | 144,941 | 213,075 | 275,690 |
Current Liabilities | |||
Accounts Payable | 42,296 | 46,236 | 55,888 |
Short/Current Long-Term Debt | 8,773 | 10,260 | 8,784 |
Other Current Liabilities | 42,684 | 37,720 | 32,687 |
Total Current Liabilities | 93,753 | 94,216 | 97,359 |
Long-Term Debt | 98,667 | 91,807 | 93,735 |
Other Liabilities | 54,490 | 50,503 | 45,180 |
Deferred Long-Term Liability Charges | |||
Minority Interest | |||
Negative Goodwill | |||
Total Liabilities | |||
Stockholders' Equity | |||
Misc. Stocks Options Warrants | |||
Redeemable Preferred Stock | |||
Preferred Stock | |||
Common Stock | 50,779 | 45,174 | 40,201 |
Retained Earnings | 14,966 | 45,898 | 70,400 |
Treasury Stock | |||
Capital Surplus |
- Complete the horizontal analysis column of the prior 3
- Complete the vertical analysis column for the prior 3
Address in the following questions in the comments section of both the Balance Sheet and Income Statement tabs:
- What accounts changed for the period and how did this affect the financial analysis calculation?
- Why did the account change during the period? Explain what business decisions may have caused the change.
- How does this change influence the company's performance?
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