hello, can you calculate the yellow boxes? provide answer and how you calculated please. thank you
B5 X A B D 2 3 BALANCE SHEET Vertical Analysis 4 5 6 31-Dec-19 31-Dec-18 7 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: Instructions Income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Rabo Anal Clipboard BS B 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, par value $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 37 outstanding as of December 31, 2019 and 2018, respectively 38 Additional paid in capital 39 Accumulated other comprehensive gain (loss) 40 Accumulated deficit 41 Total stockholders' equity 42 Total liabilities and stockholders' equity Instructions Ratio income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Paste BIU- a-A- ill IMI Merge & Center - $ -% -93 Conditional Formats Formatting Table - Sty Styles Clipboard Font Alignment Number 621 A C D G 6 B 31-Dec-19 31-Dec-18 $ $ 7 8 Assets 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 Totalline Instructions Income Statement 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 $ $ $ 7,090 67,652 63,310 31,210 79,073 109,056 3,464 327903 Vertical Analysis 5,063 14 115 Horizontal Analysis Consolidated Balance Sheets Ratio Analysis Type here to search o 11 Calibri General . 11 ' ' 6. A. 2 Wrap Text Merge & Center Paste BIU- ihl IM $ - %, 48-58 Conditional Format Formatting Table Clipboard Font Alignment Number Styles G21 B E F 67,652 63,310 5,063 143,115 138,995 93,675 38,689 D 79,073 109,056 3,464 222,803 165,352 A 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 $0.0001; 1,600,000,000 shares authorized as of Decembe 38 Additional paid-in capital 39 Accumulated other comprehensive gain (loss) 40 Accumulated deficit 41 Total stockholders' equity 42 Total liabilities and stockholders' equity 43 44 45 10,006 33,489 258 431,908 138 414,612 34 2,669,426 1,804 (1,496,454) 1,174,810 1,589,422 33 2,538,155 (1.320) (1,006,627) 1,530, 241 $ 1,962,149 $ 46 Vertical Analysis Ratio Analy Horizontal Analysis instructions Income Statement Consolidated Balance Sheets
