Through the given information on the balance sheet, complete the ratio analysis spreadsheet.

Note: Please use excel, thank you.

Ratio Analysis Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: 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 ASSET MANAGEMENT RATIOS Inventory Turnover Days Sales Outstanding (DSO) Total Assets Turnover formula formula formula formula formula fornula formula formula formula formula formula formula DEBT MANAGEMENT RATIOS formula Debt Ratio Equity Multiplier Times Interest Earned Ratio formula formula formula formula formula formula II IIIIIIIIIIIII formula formula formula formula PROFITABILITY RATIOS Gross Profit Margin Operating Profit Margin Net Profit Margin Return On Total Assets (ROA) Return On Equity (ROE) Basic Earning Power Earnings Per Share Book Value Per Share formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula forinula formula formula formula 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 5,695 3,185 36,719 2,704 1,000 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 7,358 $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 $1,000 6,945 3,622 40,791 3,099 1,000 7,542 3,000 $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 543 3,000 624 195 3,218 820 2,111 47,750 186 3,902 1,582 2,111 51,785 Income Statement Exercise: Prepare both consolidated income statement and common-size income statement for JACOB for years 2015 through 2018 based on the following scrambled information. Use the format provided on the following page. (All figures in millions except the tax rate) Year 2015 2016 2017 2018 $860 628 7,200 $860 595 7,591 Common Dividends Interest Expenses Selling & Administrative Expenses Cost Of Goods Sold Other Operating Expenses Tax Rate Sales Common Shares Outstanding Depreciation $750 628 7,075 14,050 2,871 40% 31,000 1,000 170 2,904 40% 33,000 1,000 184 3,002 40% 36,000 1,000 193 $920 615 7,619 17,200 2,995 40% 39,000 1,200 195 Earnings per share (EPS) = Net Income/Common Shares Outstanding Dividends per share (DPS) = Common Dividends/Common Shares Outstanding Ratio Analysis Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: 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 ASSET MANAGEMENT RATIOS Inventory Turnover Days Sales Outstanding (DSO) Total Assets Turnover formula formula formula formula formula fornula formula formula formula formula formula formula DEBT MANAGEMENT RATIOS formula Debt Ratio Equity Multiplier Times Interest Earned Ratio formula formula formula formula formula formula II IIIIIIIIIIIII formula formula formula formula PROFITABILITY RATIOS Gross Profit Margin Operating Profit Margin Net Profit Margin Return On Total Assets (ROA) Return On Equity (ROE) Basic Earning Power Earnings Per Share Book Value Per Share formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula forinula formula formula formula 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 5,695 3,185 36,719 2,704 1,000 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 7,358 $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 $1,000 6,945 3,622 40,791 3,099 1,000 7,542 3,000 $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 543 3,000 624 195 3,218 820 2,111 47,750 186 3,902 1,582 2,111 51,785 Income Statement Exercise: Prepare both consolidated income statement and common-size income statement for JACOB for years 2015 through 2018 based on the following scrambled information. Use the format provided on the following page. (All figures in millions except the tax rate) Year 2015 2016 2017 2018 $860 628 7,200 $860 595 7,591 Common Dividends Interest Expenses Selling & Administrative Expenses Cost Of Goods Sold Other Operating Expenses Tax Rate Sales Common Shares Outstanding Depreciation $750 628 7,075 14,050 2,871 40% 31,000 1,000 170 2,904 40% 33,000 1,000 184 3,002 40% 36,000 1,000 193 $920 615 7,619 17,200 2,995 40% 39,000 1,200 195 Earnings per share (EPS) = Net Income/Common Shares Outstanding Dividends per share (DPS) = Common Dividends/Common Shares Outstanding