hi please do the ratio analysis, show all work. thank you!
File Insert Page Layout Formulas Data Review View Help Calibri -12 ta Nurnber Paste - A A 23 Wrap Text A.EE Mergea Center - B TU $ - % !!! Clipboard Font Conditional Formatas Cell Formatting Table Styles Styles Alignment Number BS 1 Ratio Analysis 2 3 Current Ratio Acid test Ratio 4 A/R Turnover Profit Margin 5 Days Sales Uncollected Return on Total Assets 6 Asset Turnover Debt to Equity Ratio Instructions Income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Ratio Analysis Grading Type here to search o File Home Insert Page Layout Formulas Data Review View Calibri 12 - A A Wrap Text Paste A- E + Merge & Ce V Clipboard Font 22 Alignment B8 X B 7 Debt Ratio 8 Equity Ratio 9 10 11 12 13 14 15 3 Dutca Paste BTU --A- Merge & Center $ - % 98 Copboard Conditional Format as Formatting Table Styles Font Alignment Number A17 Loss from operations B D 1 2 23 CONSOUDATED STATEMENTS OF OPERATIONS Years Ended December 31, 2019 2018 2017 $ 5 6 7 8. Revenue: 9 Collaboration revenue To Collaboration revenue from related party (Note 14) 1 Grant revenue 2 Total revenue 3 Operating expenses: 4 Research and development General and administrative Total operating expenses Loss from operations 42,803 $ 5,233 12,173 60,209 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 (413,266) 410,459 64,722 475,181 (269,356) Instructions Income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Ratio Analysis Type here to search o 08 G21 X > f A B C D E $ $ 658,364 863,063 12,585 28,399 595 -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 Onnistinenseititine non erant 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 1,563,006 172,990 211,977 11,532 2,644 $ 1,962,149 $ $ $ 7,090 67,652 63,310 5,063 143,115 138,995 02:55 Horizontal Analysis 31,210 79,073 109,056 3,464 222,803 165,352 Ratio Anal Consolidated Balance Sheets Vertical Analysis Ready Type here to search O RE * Calibri Wrap Text General la Paste w BT - A- Merge & Center - $ % 9.99 Conditional Formatting Clipboard Font Alignment Number IM G21 B C D E 67,652 63,310 5,063 143,115 138,995 93,675 38,689 79,073 109,056 3,464 222,803 165,352 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 10,006 33,489 258 431,908 138 414,612 34 2,669,426 1,804 11,496,454) 1,174,810 1,589,422 33 2,538,155 (1.320) (1,006,627) 1,530,241 $ 1,962,149 43 45 46 Instructions Ratio Income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Read Formatting Clipboard Font Alignment Number SU 614 fo A B C D E 4 5 6 Years Ended December 31, 7 2019 2018 Dollar Change Percent Change 8 Revenue: 9 Collaboration revenue $ 42,803 $ 76,519 $ (33,716) 44.1% 10 Collaboration revenue from related party (Note 14) 5,233 45,993 $ (40,760) -88,6%6 11 Grant revenue 12,173 12 556 $ (383) 3.196 12 Total revenue 60,209 135,068 $ (74,859) -55.44% 13 Operating expenses: 14 Research and development 496,309 454,082 $ 42,227 9.396 15 General and administrative 109,620 94,2521 15,368 16.3% 16 Total operating expenses 605,929 548,334 $ 57,595 10.5% 17 Loss from operations (545x720) (413 266 $ (132,454) 32.1% 18 19 20 21 22 23 24 25 Instructions Income Statement Consolidated Balance Sheets Horizontal Analysis Vertical Analysis Ratio Analys Read Type here to search A Creat mut Cube 14. 51.6 44 w [chert we 4.4% o el 0.54% 0.64% torrait C.CAX - % & CALE Hola! Ci web wester Cune Tropy and poet wa tult the ture 31.6 10.04% yax 12.68% 16.0 X 4.43 *-46% 57% . 100% 100 % Ad Stockfoto wat all Account payable C.AZ 4.0 % Al Al 4.86% 2.c Djevuld 5.98% C G bilo 0-38% -2 el til 9.% 1o.si 1 6.52437 Det om uit 9-89% Farig Hame Liabilt Plud teme obligus Lease senting obligatti the Cavtat Du 0.001 tal kaba 2009 - Steckeldi equity Cetak pile tools 34. Ce - Capital 34 Acid Mer.comporlewe w 164-16%29.367 Co Cool (+60% -9, se lekel 73.71% 71.995 Moal labreches and stock. holded equity 100 Nabi Alone divided by mulut 6 got ht Medvidual aset Alb Al Badi And y die katted shelbund fly
