Fill in the debt management ratios using excel.

Debt Management Ratios Debt Ratio Equity Multiplier Times Interest Earned Ratio Total debt - Total assets Total assets + Total equity Earnings before interest and taxes - Interest expenses Profitability Ratios 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 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 $750 628 7,075 Common Dividends Interest Expenses Selling & Administrative Expenses Cost Of Goods Sold Other Operating Expenses Tax Rate Sales Common Shares Outstanding Depreciation 14,050 2,871 40% 31,000 1,000 170 $860 628 7,200 15,000 2,904 40% 33,000 1,000 184 $860 595 7,591 16,400 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 Debt Management Ratios Debt Ratio Equity Multiplier Times Interest Earned Ratio Total debt - Total assets Total assets + Total equity Earnings before interest and taxes - Interest expenses Profitability Ratios 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 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 $750 628 7,075 Common Dividends Interest Expenses Selling & Administrative Expenses Cost Of Goods Sold Other Operating Expenses Tax Rate Sales Common Shares Outstanding Depreciation 14,050 2,871 40% 31,000 1,000 170 $860 628 7,200 15,000 2,904 40% 33,000 1,000 184 $860 595 7,591 16,400 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