Accounting Analysis

profilenicdiamond2391
updatedMODULE3DELIVERABLETEMPLATE-FINANCIALANALYSIS.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting Analysis

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,040,720 1,786,156 Total Current Assets 3,151,157 2,813,049
Income from Continuing Operations 677,967 668,502 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 (BASE) 14,134,732 12,866,757 100.00% 100.00% 38,972,934 35,864,664 100.00% 100.00%
Cost of Revenue (ANALYSIS) 9,510,238 8,668,505 67.28% 67.37% 27,831,177 25,502,167 71.41% 71.11%
Gross Profit (ANALYSIS) 4,624,494 4,198,252 32.72% 32.63% 11,141,757 10,362,497 28.59% 28.89%
Operating Expenses
Selling General and Administrative (ANALYSIS) 2,576,098 2,395,608 18.23% 18.62% 6,923,564 6,375,071 17.77% 17.78%
Total Operating Expenses (ANALYSIS) 12,086,336 11,064,113 85.51% 85.99% 34,754,741 31,877,238 89.18% 88.88%
Operating Income or Loss (ANALYSIS) 2,040,720 1,786,156 14.44% 13.88% 4,218,193 3,987,426 10.82% 11.12%
Income from Continuing Operations
Total Other Income/Expenses Net (ANALYSIS) -7,676 -16,488 -0.05% -0.13% -44,982 -130,838 -0.12% -0.36%
Earnings Before Interest and Taxes (ANALYSIS) 2,048,396 1,802,644 14.49% 14.01% 4,218,193 3,987,426 10.82% 11.12%
Interest Expense (ANALYSIS) -18,847 -19,569 -0.13% -0.15% -8,860 -64,295 -0.02% -0.18%
Income Before Tax (ANALYSIS) 2,040,720 1,786,156 14.44% 13.88% 4,173,211 3,856,588 10.71% 10.75%
Income Tax Expense (ANALYSIS) 677,967 668,502 4.80% 5.20% 1,113,413 1,248,640 2.86% 3.48%
Net Income (ANALYSIS) 1,362,753 1,117,654 9.64% 8.69% 3,059,798 2,607,948 7.85% 7.27%

IS Horizontal Analysis

Income Statement Horizontal Analysis
COMPANY 1 COMPANY 2
2018 2017 $ CHANGE % CHANGE 2018 2017 $ CHANGE % CHANGE
Revenue
Total Revenue 14,134,732 12,866,757 1,267,975 9.85% 38,972,934 35,864,664 3,108,270 8.67%
Cost of Revenue 9,510,238 8,668,505 841,733 9.71% 27,831,177 25,502,167 2,329,010 9.13%
Gross Profit 4,624,494 4,198,252 426,242 10.15% 11,141,757 10,362,497 779,260 7.52%
Operating Expenses
Selling General and Administrative 2,576,098 2,395,608 180,490 7.53% 6,923,564 6,375,071 548,493 8.60%
Total Operating Expenses 12,086,336 11,064,113 1,022,223 9.24% 34,754,741 31,877,238 2,877,503 9.03%
Operating Income or Loss 2,040,720 1,786,156 254,564 14.25% 4,218,193 3,987,426 230,767 5.79%
Income from Continuing Operations
Total Other Income/Expenses Net -7,676 -16,488 8,812 -53.44% -44,982 -130,838 85,856 -65.62%
Earnings Before Interest and Taxes 2,048,396 1,802,644 245,752 13.63% 4,218,193 3,987,426 230,767 5.79%
Interest Expense -18,847 -19,569 722 -3.69% -8,860 -64,295 55,435 -86.22%
Income Before Tax 2,040,720 1,786,156 254,564 14.25% 4,173,211 3,856,588 316,623 8.21%
Income Tax Expense 677,967 668,502 9,465 1.42% 1,113,413 1,248,640 -135,227 -10.83%
Net Income 1,362,753 1,117,654 245,099 21.93% 3,059,798 2,607,948 451,850 17.33%

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 1,290,294 1,111,599 22.55% 20.94% 3,030,200 2,758,477 21.15% 19.62%
Short Term Investments 512 - 0.01% - 506,165 3.60%
Net Receivables 87,868 75,154 1.54% 1.42% 860,000 327,166 6.00% 2.33%
Inventory 1,641,735 1,512,886 28.69% 28.49% 4,579,000 4,187,243 31.96% 29.79%
Other Current Assets 11,847 13,642 0.21% 0.26% - 12,217 0.09%
Total Current Assets 3,151,157 2,813,049 55.07% 52.98% 8,469,200 8,485,727 59.12% 60.36%
Long Term Investments 712 1,288 0.01% 0.02% - -
Property Plant and Equipment 2,382,464 2,328,048 41.64% 43.85% 5,255,200 5,006,053 36.68% 35.61%
Goodwill 97,600 100,069 0.68% 0.71%
Intangible Assets - 144,900 1.03%
Other Assets 187,718 166,966 3.28% 3.14% 504,000 321,266 3.52% 2.29%
Deferred Long Term Asset Charges - 6,558 0.05%
Total Assets (BASIS) 5,722,051 5,309,351 100% 100% 14,326,000 14,058,015 100.00% 100.00%
Current Liabilities
Accounts Payable 1,059,844 1,021,735 18.52% 19.24% 2,644,100 2,488,373 18.46% 17.70%
Short/Current Long Term Debt 84,973 - 1.49% - -
Other Current Liabilities 9,902 24,559 0.17% 0.46% - 1,429,136 10.17%
Total Current Liabilities 1,926,402 1,752,506 33.67% 33.01% 5,531,300 5,125,537 38.61% 36.46%
Long Term Debt 311,994 396,493 5.45% 7.47% 2,233,600 2,230,607 15.59% 15.87%
Other Liabilities 434,347 412,335 7.59% 7.77% 1,512,500 1,331,645 10.56% 9.47%
Total Liabilities (BASIS) 2,672,743 2,561,334 46.71% 48.24% 9,277,400 8,909,706 64.76% 63.38%
Stockholders' Equity
Preferred Stock - - - -
Common Stock 3,796 3,919 0.07% 0.07% 5,048,600 628,009 35.24% 4.47%
Retained Earnings 2,071,400 1,801,138 36.20% 33.92% - 4,962,159 35.30%
Treasury Stock -318,252 -272,755 -5.56% -5.14% - -441,859 -3.14%
Capital Surplus 1,292,391 1,215,806 22.59% 22.90% - -
Other Stockholder Equity - -441,859 -3.14%
Total Stockholder Equity (BASIS) 3,049,308 2,748,017 53.29% 51.76% 5,048,600 5,148,309 35.24% 36.62%
Net Tangible Assets 3,049,308 2,748,017 53.29% 51.76% 4,951,000 4,903,340 34.56% 34.88%

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 1,290,294 1,111,599 178,695 16.08% 3,030,200 2,758,477 271,723 9.85%
Short Term Investments 512 - - 506,165 0.00%
Net Receivables 87,868 75,154 12,714 16.92% 860,000 327,166 532,834 162.86%
Inventory 1,641,735 1,512,886 128,849 8.52% 4,579,000 4,187,243 391,757 9.36%
Other Current Assets 11,847 13,642 -1,795 -13.16% - 12,217 0.00%
Total Current Assets 3,151,157 2,813,049 338,108 12.02% 8,469,200 8,485,727 -16,527 -0.19%
Long Term Investments 712 1,288 -576 -44.72% - -
Property Plant and Equipment 2,382,464 2,328,048 54,416 2.34% 5,255,200 5,006,053 249,147 4.98%
Goodwill 97,600 100,069 -2,469 -2.47%
Intangible Assets - 144,900 0.00%
Other Assets 187,718 166,966 20,752 12.43% 504,000 321,266 182,734 56.88%
Deferred Long Term Asset Charges - - - 6,558 0.00%
Total Assets 5,722,051 5,309,351 412,700 7.77% 14,326,000 14,058,015 267,985 1.91%
Current Liabilities
Accounts Payable 1,059,844 1,021,735 38,109 3.73% 2,644,100 2,488,373 155,727 6.26%
Short/Current Long Term Debt 84,973 - - -
Other Current Liabilities 9,902 24,559 -14,657 -59.68% - 1,429,136 0.00%
Total Current Liabilities 1,926,402 1,752,506 173,896 9.92% 5,531,300 5,125,537 405,763 7.92%
Long Term Debt 311,994 396,493 -84,499 -21.31% 2,233,600 2,230,607 2,993 0.13%
Other Liabilities 434,347 412,335 22,012 5.34% 1,512,500 1,331,645 180,855 13.58%
Total Liabilities 2,672,743 2,561,334 111,409 4.35% 9,277,400 8,909,706 367,694 4.13%
Stockholders' Equity
Preferred Stock - - - -
Common Stock 3,796 3,919 -123 -3.14% 5,048,600 628,009 4,420,591 703.91%
Retained Earnings 2,071,400 1,801,138 270,262 15.01% - 4,962,159 0.00%
Treasury Stock -318,252 -272,755 -45,497 16.68% - -441,859 0.00%
Capital Surplus 1,292,391 1,215,806 76,585 6.30% - -
Other Stockholder Equity 0 - -441,859 0.00%
Total Stockholder Equity 3,049,308 2,748,017 301,291 10.96% 5,048,600 5,148,309 -99,709 -1.94%
Net Tangible Assets 3,049,308 2,748,017 301,291 10.96% 4,951,000 4,903,340 47,660 0.97%