Do Ratio Analysis Spreadsheet. and show me the calculation details.

Ratio Analysis Spreadsheet Example 4 Module III Name: Date: Jacob Corporation Ratio Analysis 2015 2016 2017 2018 11 Liquidity Ratios 12 13 Current Ratio 14 Quick Ratio 15 16 Asset Management Ratios 17 18 Inventory Turnover 19 Days Sales Outstanding 20 Total Assets Turnover 21 22 23 Debt Management 25 Debt Ratio 26 Equity Multiplier 27 Times Interest Earned Ratio 28 29 Profitablitlity Ratios 30 31 Gorss Profit Margin 32 Operationg Profit Margin 33 Net Profit Margin 34 Return On Total Assets (ROA) 35 Return On Equity (ROE) 36 Basic earning Power 37 Earnings Per Share 38 Book Value Per Share 39 40 Graph Current Ratio over 2001-2004 41 42 2015 43 Current Ratio 0.00 44 ... Statement of CF Financial Ratios 2018 2016 0.00 2017 0.00 0.00 Time Value Risk & Return Bonds Jacob Corporation Income Statement 2015-2018 Sales Cost Of Goods Sold Gross Profit 2015 $ 31,000.00 14050 $ 16,950.00 2016 2017 2018 $ 33,000.00 $ 36,000.00 $ 39,000.00 15000 16400 17200 $ 18,000.00 $ 19,600.00 $ 21,800.00 JUUD Selling & Administrative Expenses Depreciation Other Operating Expenses Total Operating Expenses 195 7075 170 2871 $ 10,116.00 7200 7591 7619 184 193 2904 3002 2995 $ 10,288.00 $ 10,786.00 $ 10,809.00 Earnings Before Interest & Taxes(EBIT) Interest Expense Earnings Before Taxes(EBT) Taxes@40% Net Income $ 6,834.00 $ 7,712.00 $ 8,814.00 $ 10.991.00 628 628 595 615 6206 7084 8219 10376 2482 2834 3 288 4150 $ 3,723.60 $ 4,250.40 $ 4,931.40 $ 6,225.60 750 Common Dividends Paid Addition to Retained Earnings $ 2,973.60 $ 860 860 920 3,390.40 $ 4,071.40 $ 5,305.60 Common Shares Outstanding Earnings Per Share(EPS) Dividends Per Share $ $ 1000 3.72 $ 0.75 $ 1000 4.25 0.86 $ $ 1000 4.93 $ 0.86 $ 1200 5.19 0.77 Jacob Corporation Balance Sheet 2015-2018 $ $ Cash Marketable Securities Accounts Receivable Inventories Total Current Assets 2015 3,000.00 $ 330 2534 2184 $8,048.00 2016 2017 3,000.00 $ 3,000.00 820 1582 3218 3902 2704 3099 $9,742.00 $11,583.00 2018 3,000.00 1385 4200 3400 $11,985.00 Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Intangible Assets Total Assets 46659 7179 39480 200 $47,728.00 47750 7358 40392 195 $50,329.00 51785 7542 44243 54690 7731 46959 180 $59,124.00 186 $56,012.00 $ $ $ $ 685.00 3800 Notes Payable Accounts Payable Accruals Total Current Liabilities 1,466.00 3125 656 $5,247.00 995.00 3185 624 $4,804.00 1,000.00 3622 543 $5,165.00 499 $4,984.00 Long Term Debt Total Liabilities 6041 $11,288.00 5695 $10,499.00 6945 $12,110.00 4452 $9,436.00 Common Stock # Shares @Par $1.00 Additional Paid In Capital Retained Earnings Total Shareholders' Equity $1,000 2,111 33,329 $36,440.00 $1,000 2 ,111 36,719 $39,830.00 $1,000 2,111 40,791 $43,902.00 $1,200 2,392 46,096 $49,688.00 Total Liabilities & Shareholders' Equit $47,728.00 $50,329.00 $56.012,00 $59.124.00