Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started