Answered step by step
Verified Expert Solution
Link Copied!

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
  1. Complete the horizontal analysis column of the prior 3
  2. 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:

  1. What accounts changed for the period and how did this affect the financial analysis calculation?
  2. Why did the account change during the period? Explain what business decisions may have caused the change.
  3. How does this change influence the company's performance?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel Applications For Accounting Principles

Authors: Gaylord SmithBruce Walz

4th Edition

1133388027, 9781133388029

More Books

Students also viewed these Accounting questions