Through the information given in the balance sheet, solve for the liquify ratios.

Note: Please use excel, thank you.

Balance Sheet Exercise: Prepare both consolidated balance sheet and common-size balance sheet for Jacob Corporation for years 2015 through 2018 based on the following scrambled information. Use the format provided on the following page. (All figures in millions) 2015 2016 2017 2018 $995 Notes Payable Long-Term Debt Accounts Payable Retained Earnings Inventories Common Stock Accumulated Depreciation Cash Accruals Intangible Assets Accounts Receivable Marketable Securities Additional Paid-In Capital Gross Fixed Assets $1,466 6,041 3,125 33,329 2,184 1,000 7,179 3,000 656 200 2,534 330 2,111 46,659 5,695 3,185 36,719 2,704 1,000 7,358 3,000 624 195 3,218 820 2,111 47,750 $1,000 6,945 3,622 40,791 3,099 1,000 7,542 3,000 543 186 3,902 1,582 2,111 51,785 $685 4,452 3,800 46,096 3,400 1,200 7,731 3,000 499 180 4,200 1,385 2,392 54,690 JACOB CORPORATION RATIO ANALYSIS 2015 2016 2017 2018 LIQUIDITY RATIOS Current Ratio Quick or Acid Test Ratio formula formula formula formula formula formula formula formula