mulligan company balance sheet for 2018 & 2017.

Need the formulas for the Profitability sheet and Solvency Sheet. Thank You.

Company Analysis- Part 2 of S Profitability Improved/ 2018 2017 Profitability Ratios Comments Year Year Deteriorated Profit Margin Total Asset Turnover Return on Assets Return on C/S Holder Equity Earnings per Share (EPS) Payout Ratio Summary: Provide a 100 word minimum discussion on the purpose of profitability analysis, and the conclusion you reached on the state of your company's profitability position. Solvency 2018 2017 Improved/ Deteriorated Solvency Ratios Comments Year Year Debt to Total Assets Times Interest Earned Provide a 100 word minimum discussion on the purpose of solvency analysis, and the conclusion you reached on the state of your company's solvency position. Summary: Balance Sheet Assets 12/31/18 12/31/17 12/31/16 Cash $15,000 $14,000 6,200 33,000 84,000 1,100 $138,000 $15,000 6,400 40,000 68,000 1,000 $130,400 Marketable Securities 6,000 Accounts Receivable 42,000 51,000 1,200 $115,200 Inventory Prepaid Rent Total Current Assets $286,000 $401,200 $270,000 $408,300 $260,000 $390,400 Net Long-Term Assets Total Assets Liabilities $50,000 13,000 $48,000 15,000 6,000 $69,000 Accounts Payable Notes Payable 57,000 13,000 5,000 $75,000 4,000 $67,000 Accruals Total Current Liabilities $160,000 172,200 $401.200 Long-Term Debt Common Stockholder Equity Total Liabilities and Equity 145,000 150,000 183,300 $408.300 178,400 $390,400 The company has 25,000 shares of its common stock outstanding Income Statement Year Ending for 12/31/18 Year Ending for 12/31/17 Sales (all on credit) Less: Cost of Goods Sold Gross Profit Less: Operating Expenses $600,000 (460,000) Sales (all on credit) Less: Cost of Goods Sold Gross Profit Less: Operating Expenses General & Administrative Depreciation Expense Income Before Interest & Taxes Less: Interest Expense $650,000 (498,000) $152,000 $140,000 General & Administrative $30,000 30,000 $30,000 30,000 Depreciation Expense Income Before Interest & Taxes Less: Interest Expense (560,000) $80,000 (560.000) $92,000 (12.000) $80,000 (31,000) $49,000 (31,100) $17.900 (10,000) $70,000 (27,100) $42,900 (31,800) $11.100 Income Before Income Taxes Less: Income Taxes Net Income Available to Stockholders Less: Cash Dividends Change in Retained Earnings Income Before Income Taxes Less: Income Taxes Net Income Available to Stockholders Less: Cash Dividends Change in Retained Earnings