COMPANY 1

Income Statement All numbers in thousands Revenue 2018 2017 Total Revenue 38,972,934 35,864,664 Cost of Revenue 27,831,177 25,502,167 Gross Profit 11,141,757 10,362,497 Operating Expenses Selling General and Administrative 6,923,564 6,375,071 Total Operating Expenses 34,754,741 31,877,238 Operating Income or Loss 4,218,193 3,987,426 Income from Continuing Operations Total Other Income/Expenses Net -44,982 -130,838 Earnings Before Interest and Taxes 4,218,193 3,987,426 Interest Expense -8,860 -64,295 Income Before Tax 4,173,211 3,856,588 Income Tax Expense 1,113,413 1,248,640 Net Income 3,059,798 2,607,948

Balance Sheet All numbers in thousands Period Ending 2018 2017 Current Assets Cash And Cash Equivalents 3,030,200 2,758,477 Short Term Investments - 506,165 Net Receivables 860,000 327,166 Inventory 4,579,000 4,187,243 Other Current Assets - 12,217 Total Current Assets 8,469,200 8,485,727 Long Term Investments - - Property Plant and Equipment 5,255,200 5,006,053 Goodwill 97,600 100,069 Intangible Assets - 144,900 Other Assets 504,000 321,266 Deferred Long Term Asset Charges - 6,558 Total Assets 14,326,000 14,058,015 Current Liabilities Accounts Payable 2,644,100 2,488,373 Short/Current Long Term Debt - - Other Current Liabilities - 1,429,136 Total Current Liabilities 5,531,300 5,125,537 Long Term Debt 2,233,600 2,230,607 Other Liabilities 1,512,500 1,331,645 Total Liabilities 9,277,400 8,909,706 Stockholders' Equity Preferred Stock - - Common Stock 5,048,600 628,009 Retained Earnings - 4,962,159 Treasury Stock - -441,859 Capital Surplus - - Other Stockholder Equity - -441,859 Total Stockholder Equity 5,048,600 5,148,309 Net Tangible Assets 4,951,000 4,903,340

I am really stuck on this one, I put the data in for 1 out of the 2 companies, maybe after seeing an example of how to do it with the first company, I can do the second one myself and draw a conclusion. Thank you so much! :)

Competency Appraise the financial health and performance of a company. Scenario The Corporate Director of Acquisitions has approached you to assist with preparing financial data to help identify a potential new acquisition for your company. They have narrowed down the target to two companies and need your help in selecting the best one. You agree to help and think that the best approach would be to take the two companies and prepare a vertical and horizontal analysis of both the income statement and balance sheets for two years of data. Instructions You discuss your plan with the director, and you both decide that you should create an Excel file containing four tabs, labeling the four tabs as follows: Tab 1: "Income statement vertical analysis" Tab 2: "Income statement horizontal" Tab 3: "Balance sheet vertical analysis" Tab 4: "Balance sheet horizontal analysis" In addition, you both decide it best to also create a Word document with your assessment of each company's performance and support which company is the better acquisition target