Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me fill years 2017 & 2018? Data can be found here: The data has to be transcribed into excel with formulas. Can

Can someone help me fill years 2017 & 2018?

image text in transcribed

Data can be found here:

image text in transcribed

The data has to be transcribed into excel with formulas. Can someone assist please?

Horizontal Analysis Comments Vertical Analysis Comments Year Year Year Year Year Year Year Year 2016 Year 2017 Year 2018 Year 2016 Year 2017 Year 2018 Balance Sheet All numbers in thousands Period Ending 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 Accumulated Amortization 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 Deferred Long-Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockhold Net Tangible Assets Balance Sheet All numbers in thousands Period Ending 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 Accumulated Amortization 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 Deferred Long-Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets December 31, 2017 2018 20,522 S 10,464 16,047 13,164 60,197 48,866 13,350 8,897 131,310 $ 31,750 9,500 17,174 16,677 75,101 61,797 14,548 11,202 162,648 $ $ 34,616 18.170 5.097 ASSETS Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Goodwill Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01 par value: Authorized shares 500 Issued and outstanding shares - none Common stock, $0.01 par value: Authorized shares 5.000 Issued shares 507 and 514 Outstanding shares 484 and 491 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 38,192 23,663 6,536 68,391 23,495 27.213 57,883 24,743 20,975 - (1,837) 21,389 (484) 8,636 27,709 131,310 $ (1.837) 26,791 (1,035) 19,625 43,549 162,648 $

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

Construction Industry IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304131920, 978-1304131928

More Books

Students also viewed these Accounting questions

Question

Let f, g, h: Z+ R where f O(g) and g 0 ().Prove that f 0(h)

Answered: 1 week ago