Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a vertical analysis of the balance sheet for 2019 and 2018. You must use formulas with cell references for all calculations in the yellow

Create a vertical analysis of the balance sheet for 2019 and 2018. You must use formulas with cell references for all calculations in the yellow cells.
image text in transcribed
image text in transcribed
D CONSOLIDATED BALANCE SHEETS 31-Dec-19 31-Dec-18 6 $ $ 235,876 867,124 5,369 19,403 1,032 1,128,804 159,987 201.495 86,414 10,791 1,931 1,589.422 658,364 863,063 12,585 28,399 595 1,563,006 172,990 211,977 11,532 2,644 $ 1.962,149 s S $ 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Investments (short term) 12 Accounts receivable 13 Prepaid expenses and other current assets 14 Restricted cash 15 Total current assets 16 Investments, non-current 17 Property and equipment, net 18 Right-of-use assets, operating leases 19 Restricted cash, non-current 20 Other non-current assets 21 Total assets 22 Liabilities and Stockholders' Equity 23 Current liabilities: 24 Accounts payable 25 Accrued liabilities 26 Deferred revenue 27 Other current liabilities 28 Total current liabilities 29 Deferred revenue, non-current 30 Operating lease liabilities, non-current 31 Financing lease liabilities, non-current 32 Deferred lease obligation, non-current 33 Lease financing obligation 34 other non-current liabilities 35 Total liabilities 36 Stockholders equity: 37 common stock par value 50.0001;1,600,000,000 shares authorized as of December 31, 2019 38 Additional paid in capital 39 Accumulated other comprehensive gain (losa) 40 Accumulated deficit 41 Total stockholders' equity 42 Total liabilities and stockholders' equity 7,090 67,652 63,310 5,063 143,115 138,995 93,675 38,689 31,210 79,073 109,056 3,464 222,803 165,352 10,006 33.489 258 431,908 138 414,512 34 2.669,426 1,804 11.496,454) 1.174,810 1.589,422 33 2,538,155 11,320) (1,006,627 1,530,241 $ 1,962,149 G23 C 1 2 3 BALANCE SHEET Vertical Analysis 31-Dec-19 31-Dec-18 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Investments (short term) 12 Accounts receivable 13 Prepaid expenses and other current assets 14 Restricted cash 15 Total current assets 16 Investments, non-current 17 Property and equipment, net 18 Right-of-use assets, operating leases 19 Restricted cash, non-current 20 Other non-current assets 21 Total assets 22 Liabilities and Stockholders' Equity 23 Current liabilities: 24 Accounts payable 25 Accrued liabilities 26 Deferred revenue 27 Other current liabilities 28 Total current liabilities 29 Deferred revenue, non-current 30 Operating lease liabilities, non-current 31 Financing lease liabilities, non-current 32 Deferred lease obligation, non-current 33 Lease financing obligation 34 Other non-current liabilities 35 Total liabilities 36 Stockholders' equity Common stock, parvalue $0.0001; 1,600,000,000 shares authorized as of December 31, 2019 and 2018; 336,536,985 and 328,798,904 shares issued and outstanding as of December 31, 2019 37 and 2018, respectively 38 Additional pald-in capital 39 Accumulated other comprehensive gain (loss) 40 Accumulated defici 41 Total stockholders' equity 42 Total liabilities and stockholders' equity

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

Payroll Accounting 2021

Authors: Bernard J. Bieg, Judith A. Toland

31st Edition

0357358287, 9780357358283

More Books

Students also viewed these Accounting questions

Question

2. Should a disciplinary system be established at Carter Cleaning?

Answered: 1 week ago

Question

1. What would you do if you were Jennifer, and why?

Answered: 1 week ago

Question

1. Explain what is meant by ethical behavior.

Answered: 1 week ago