Need Assistance

nelda2495
MODULE3DELIVERABLETEMPLATE-FINANCIALANALYSIS.xlsx
Home>Business & Finance homework help>Management homework help>Need Assistance

Company 1

Company #1
Income Statement Balance Sheet
All numbers in thousands All numbers in thousands
Revenue 2018 2017 Period Ending 2018 2017
Total Revenue 14,134,732 12,866,757 Current Assets
Cost of Revenue 9,510,238 8,668,505 Cash And Cash Equivalents 1,290,294 1,111,599
Gross Profit 4,624,494 4,198,252 Short Term Investments 512 -
Operating Expenses Net Receivables 87,868 75,154
Selling General and Administrative 2,576,098 2,395,608 Inventory 1,641,735 1,512,886
Total Operating Expenses 12,086,336 11,064,113 Other Current Assets 11,847 13,642
Operating Income or Loss 2,048,396 1,802,644 Total Current Assets 3,151,157 2,813,049
Income from Continuing Operations Long Term Investments 712 1,288
Total Other Income/Expenses Net -7,676 -16,488 Property Plant and Equipment 2,382,464 2,328,048
Earnings Before Interest and Taxes 2,048,396 1,802,644 Other Assets 187,718 166,966
Interest Expense -18,847 -19,569 Deferred Long Term Asset Charges - -
Income Before Tax 2,040,720 1,786,156 Total Assets 5,722,051 5,309,351
Income Tax Expense 677,967 668,502 Current Liabilities
Net Income 1,362,753 1,117,654 Accounts Payable 1,059,844 1,021,735
Short/Current Long Term Debt 84,973 -
Other Current Liabilities 9,902 24,559
Total Current Liabilities 1,926,402 1,752,506
Long Term Debt 311,994 396,493
Other Liabilities 434,347 412,335
Total Liabilities 2,672,743 2,561,334
Stockholders' Equity
Preferred Stock - -
Common Stock 3,796 3,919
Retained Earnings 2,071,400 1,801,138
Treasury Stock -318,252 -272,755
Capital Surplus 1,292,391 1,215,806
Total Stockholder Equity 3,049,308 2,748,017
Net Tangible Assets 3,049,308 2,748,017

Company 2

Company #2
Income Statement Balance Sheet
All numbers in thousands All numbers in thousands
Revenue 2018 2017 Period Ending 2018 2017
Total Revenue 38,972,934 35,864,664 Current Assets
Cost of Revenue 27,831,177 25,502,167 Cash And Cash Equivalents 3,030,200 2,758,477
Gross Profit 11,141,757 10,362,497 Short Term Investments - 506,165
Operating Expenses Net Receivables 860,000 327,166
Selling General and Administrative 6,923,564 6,375,071 Inventory 4,579,000 4,187,243
Total Operating Expenses 34,754,741 31,877,238 Other Current Assets - 12,217
Operating Income or Loss 4,218,193 3,987,426 Total Current Assets 8,469,200 8,485,727
Income from Continuing Operations Long Term Investments - -
Total Other Income/Expenses Net -44,982 -130,838 Property Plant and Equipment 5,255,200 5,006,053
Earnings Before Interest and Taxes 4,218,193 3,987,426 Goodwill 97,600 100,069
Interest Expense -8,860 -64,295 Intangible Assets - 144,900
Income Before Tax 4,173,211 3,856,588 Other Assets 504,000 321,266
Income Tax Expense 1,113,413 1,248,640 Deferred Long Term Asset Charges - 6,558
Net Income 3,059,798 2,607,948 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

IS Vertical Analysis

Income Statement Vertical Analysis
COMPANY 1 COMPANY 2
2018 2017 2018 2017 2018 2017 2018 2017
Revenue
Total Revenue
Cost of Revenue
Gross Profit
Operating Expenses
Selling General and Administrative
Total Operating Expenses
Operating Income or Loss
Income from Continuing Operations
Total Other Income/Expenses Net
Earnings Before Interest and Taxes
Interest Expense
Income Before Tax
Income Tax Expense
Net Income

IS Horizontal Analysis

Income Statement Horizontal Analysis
COMPANY 1 COMPANY 2
2018 2017 $ CHANGE % CHANGE 2018 2017 $ CHANGE % CHANGE
Revenue
Total Revenue
Cost of Revenue
Gross Profit
Operating Expenses
Selling General and Administrative
Total Operating Expenses
Operating Income or Loss
Income from Continuing Operations
Total Other Income/Expenses Net
Earnings Before Interest and Taxes
Interest Expense
Income Before Tax
Income Tax Expense
Net Income

BS Vertical Analysis

Balance Sheet Vertical Analysis
Company #1 Company #2
Period Ending 2018 2017 2018 2017 2018 2017 2018 2017
Current Assets
Cash And Cash Equivalents
Short Term Investments
Net Receivables
Inventory
Other Current Assets
Total Current Assets
Long Term Investments
Property Plant and Equipment
Goodwill
Intangible Assets
Other Assets
Deferred Long Term Asset Charges
Total Assets (BASIS)
Current Liabilities
Accounts Payable
Short/Current Long Term Debt
Other Current Liabilities
Total Current Liabilities
Long Term Debt
Other Liabilities
Total Liabilities (BASIS)
Stockholders' Equity
Preferred Stock
Common Stock
Retained Earnings
Treasury Stock
Capital Surplus
Other Stockholder Equity
Total Stockholder Equity (BASIS)
Net Tangible Assets

BS Horizontal Analysis

Balance Sheet Horizontal Analysis
COMPANY 1 COMPANY 2
Period Ending 2018 2017 $ CHANGE % CHANGE 2018 2017 $ CHANGE % CHANGE
Current Assets
Cash And Cash Equivalents
Short Term Investments
Net Receivables
Inventory
Other Current Assets
Total Current Assets
Long Term Investments
Property Plant and Equipment
Goodwill
Intangible Assets
Other Assets
Deferred Long Term Asset Charges
Total Assets
Current Liabilities
Accounts Payable
Short/Current Long Term Debt
Other Current Liabilities
Total Current Liabilities
Long Term Debt
Other Liabilities
Total Liabilities
Stockholders' Equity
Preferred Stock
Common Stock
Retained Earnings
Treasury Stock
Capital Surplus
Other Stockholder Equity
Total Stockholder Equity
Net Tangible Assets