DELIVERABLETEMPLATE-FINANCIALANALYSIS3.xlsx

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 Percent Percent Percent Percent

Total Revenue (BASE NUMBER) 14,134,732 12,866,757 100.00% 100.00% 38,972,934 35,864,664 100.00% 100.00%

Cost of Revenue 9,510,238 8,668,505 27,831,177 25,502,167

Gross Profit 4,624,494 4,198,252 11,141,757 10,362,497

Operating Expenses

Selling General and Administrative 2,576,098 2,395,608 6,923,564 6,375,071

Total Operating Expenses 12,086,336 11,064,113 34,754,741 31,877,238

Operating Income or Loss 2,048,396 1,802,644 4,218,193 3,987,426

Income from Continuing Operations

Total Other Income/Expenses Net -7,676 -16,488 -44,982 -130,838

Earnings Before Interest and Taxes 2,048,396 1,802,644 4,218,193 3,987,426

Interest Expense -18,847 -19,569 -8,860 -64,295

Income Before Tax 2,040,720 1,786,156 4,173,211 3,856,588

Income Tax Expense 677,967 668,502 1,113,413 1,248,640

Net Income 1,362,753 1,117,654 3,059,798 2,607,948

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 38,972,934 35,864,664

Cost of Revenue 9,510,238 8,668,505 27,831,177 25,502,167

Gross Profit 4,624,494 4,198,252 11,141,757 10,362,497

Operating Expenses

Selling General and Administrative 2,576,098 2,395,608 6,923,564 6,375,071

Total Operating Expenses 12,086,336 11,064,113 34,754,741 31,877,238

Operating Income or Loss 2,048,396 1,802,644 4,218,193 3,987,426

Income from Continuing Operations

Total Other Income/Expenses Net -7,676 -16,488 -44,982 -130,838

Earnings Before Interest and Taxes 2,048,396 1,802,644 4,218,193 3,987,426

Interest Expense -18,847 -19,569 -8,860 -64,295

Income Before Tax 2,040,720 1,786,156 4,173,211 3,856,588

Income Tax Expense 677,967 668,502 1,113,413 1,248,640

Net Income 1,362,753 1,117,654 3,059,798 2,607,948

BS Vertical Analysis

Balance Sheet Vertical Analysis

Company #1 Company #2

Period Ending 2018 2017 2018 2017 2018 2017 2018 2017

Current Assets PERCENT PERCENT PERCENT PERCENT

Cash And Cash Equivalents 1,290,294 1,111,599 3,030,200 2,758,477

Short Term Investments 512 0 0 506,165

Net Receivables 87,868 75,154 860,000 327,166

Inventory 1,641,735 1,512,886 4,579,000 4,187,243

Other Current Assets 11,847 13,642 0 12,217

Total Current Assets 3,151,157 2,813,049 8,469,200 8,485,727

Long Term Investments 712 1,288 0 0

Property Plant and Equipment 2,382,464 2,328,048 5,255,200 5,006,053

Goodwill 0 0 97,600 100,069

Intangible Assets 0 0 0 144,900

Other Assets 187,718 166,966 504,000 321,266

Deferred Long Term Asset Charges 0 0 0 6,558

Total Assets (BASE NUMBER) 5,722,051 5,309,351 100.00% 100.00% 14,326,000 14,058,015 100.00% 100.00%

Current Liabilities

Accounts Payable 1,059,844 1,021,735 2,644,100 2,488,373

Short/Current Long Term Debt 84,973 0 0 0

Other Current Liabilities 9,902 24,559 0 1,429,136

Total Current Liabilities 1,926,402 1,752,506 5,531,300 5,125,537

Long Term Debt 311,994 396,493 2,233,600 2,230,607

Other Liabilities 434,347 412,335 1,512,500 1,331,645

Total Liabilities 2,672,743 2,561,334 9,277,400 8,909,706

Stockholders’ Equity

Preferred Stock 0 0 0 0

Common Stock 3,796 3,919 5,048,600 628,009

Retained Earnings 2,071,400 1,801,138 0 4,962,159

Treasury Stock -318,252 -272,755 0 -441,859

Capital Surplus 1,292,391 1,215,806 0 0

Other Stockholder Equity 0 0 0 -441,859

Total Stockholder Equity 3,049,308 2,748,017 5,048,600 5,148,309

Net Tangible Assets 3,049,308 2,748,017 4,951,000 4,903,340

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 3,030,200 2,758,477

Short Term Investments 512 0 0 506,165

Net Receivables 87,868 75,154 860,000 327,166

Inventory 1,641,735 1,512,886 4,579,000 4,187,243

Other Current Assets 11,847 13,642 0 12,217

Total Current Assets 3,151,157 2,813,049 8,469,200 8,485,727

Long Term Investments 712 1,288 0 0

Property Plant and Equipment 2,382,464 2,328,048 5,255,200 5,006,053

Goodwill 0 0 97,600 100,069

Intangible Assets 0 0 0 144,900

Other Assets 187,718 166,966 504,000 321,266

Deferred Long Term Asset Charges 0 0 0 6,558

Total Assets 5,722,051 5,309,351 14,326,000 14,058,015

Current Liabilities

Accounts Payable 1,059,844 1,021,735 2,644,100 2,488,373

Short/Current Long Term Debt 84,973 0 0 0

Other Current Liabilities 9,902 24,559 0 1,429,136

Total Current Liabilities 1,926,402 1,752,506 5,531,300 5,125,537

Long Term Debt 311,994 396,493 2,233,600 2,230,607

Other Liabilities 434,347 412,335 1,512,500 1,331,645

Total Liabilities 2,672,743 2,561,334 9,277,400 8,909,706

Stockholders’ Equity

Preferred Stock 0 0 0 0

Common Stock 3,796 3,919 5,048,600 628,009

Retained Earnings 2,071,400 1,801,138 0 4,962,159

Treasury Stock -318,252 -272,755 0 -441,859

Capital Surplus 1,292,391 1,215,806 0 0

Other Stockholder Equity 0 0 0 -441,859

Total Stockholder Equity 3,049,308 2,748,017 5,048,600 5,148,309

Net Tangible Assets 3,049,308 2,748,017 4,951,000 4,903,340

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code GURUH