calculate ratio analysis for 2019. show work. thank you
AutoSave On Excel Case No.1 Fs Analysis acct. Saved 20. Sanch Review View File Home Formulas Data Page Layout Insert Help Number Calibri Paste BTU -12 - A A 13 Wrap Text O. A Mergea Center - Font Alignment $ - %) 8-98 Conditional Format as Formatting Table Styles Number Clipboard D3 c 3 Current Ratio 7.817 Acid test Ratio 4 A/R Turnover Profit Margin 5 Days Sales Uncollected Return on Total Assets 6 Asset Turnover Debt to Equity Ratio Debt Ratio ESSE Merge & Center - S - % Clipboard Conditional Formatas Formatting - Table- Styles Font Alignment Number A17 X Loss from operations A D 1 CONSOUDATED STATEMENTS OF OPERATIONS 3 Years Ended December 31, 2019 2018 2017 $ 42,803 $ 5,233 12,173 60,209 3 Revenue: Collaboration revenue Collaboration revenue from related party (Note 14) 1. Grant revenue 2 Total revenue 3 Operating expenses: Research and development 5 General and administrative 5 Total operating expenses Loss from operations 3 76,519 $ 45,993 12,556 135,068 146,953 30,021 28,851 205,825 496,309 109,620 605,929 (545.720) 454,082 94,252 548,334 1413,266) 410,459 64,722 475,181 (269,356) Paste a. A.EE % 90 IH BIU- Merge & Center - Formatting Table Styles Number Alignment Clipboard Font G39 B E D 31-Dec-18 31-Dec-19 6 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: 24 Accounts payable 25. Accrued liabilities 26 Deferred revenue 27 Other current liabilities 39. Totalt ihdon 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 5,063 TA 116 Horizontal Analysis 31,210 79,073 109,056 3,464 222002 Vertical Analysis Ratio and Consolidated Balance Sheets Type here to search o Paste BIU- a A Merge & Center $ -% -8 Conditional Formatting Clipboard Font Alignment Number G39 B D $ $ 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 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 $0.0001; 1,600,000,000 shares authorized as of Decembe 38 Additional paid-in capital 39 Accumulated other comprehensive gain (105) 40 Accumulated deficit 41 Total stockholders' equity 42 Total liabilities and stockholders' equity 43 44 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 s 45 14 Instructions Income Statement Consolidated Balance Sheets Horizontal Analysis Ratio Vertical Analysis Ready HA Type here to search
