EXHIBITS. Parts Co: Consolidated Financial Statements Smillion Income statement Balance sheet Prior year Current year Revenue Cost of sales Selling costs Depreciation Operating profit Prior year Current year 7826 9000 (5087) 15120) 1156 58 (1710) 1270 (313) 90.4 857 Working cash Accounts receivable Inventory Current assets 150 85B 697 170.5 123 1110 75.5 1988 interest Faming before taxes (50) 85.4 Property and equipment Total assets (75) 782 5261 7056 7200 9188 Tanes Net Income 543 13089 474 337 Liabilities and equity Accounts payable Short-term debe Current liabilities Long-term debt Shareholders' equity Liabilities and equity 461 194 635 337 1700 5829 2150 5403 9188 1) Calculate the following Liqudity Ratios Current ratio in prior year Current ratio in current year Quick ratio in prior year Quick ratio in current year 1) Calculate the following Liqudity Ratios Current ratio in prior year= Current ratio in current year Quick ratio in prior year Quick ratio in current year 2) Calculate the following Solvency Ratios Debt to Solvency ratios in prior year Debt to Solvency ratios in current year Times interest Earned Ratios in prior year = Times interest Eamed Ratios in current year= 2) Calculate the following Profitability Ratios Return on Invested Capital (ROIC) ratio in prior year Return on Invested Capital (ROIC) ratio in current year Return on Owner's Equity (ROE) ratio in prior year Return on Owner's Equity (ROE) ratio in year = current Profit as Percentage of Sales ratio in prior year = Profit as Percentage of Sales ratio in current year Eormula Sheet Profit as a Percentage of Sales Ratio - Income before Taxes / Total Sales RETURN ON INVESTED CAPITAL (ROIC) Income before Taxes / Total Assets RETURN ON EQUITY (ROE) Income before Taxes / Total Owners 'Equity . . CURRENT RATIO Current Assets Current Liabilities QUICK RATIO = (Current assets - inventory/current liabilities ACID TEST RATIO=Cash/current liabilities . ACCOUNTS RECEIVABLE TURNOVER=Credit Sales Accounts Receivable DAY'S RECEIVABLE = 365 Days Accounts Receivable Tumover ACCOUNTS PAYABLE TURNOVER=Purchases on Credit Accounts Payable DAY'S PAYABLE = 365 Days Accounts Payable Tumover . AVERAGE DAY'S SALES = Net Annual Sales / 365 Days INVENTORY TURNOVER = Cost of Goods Sold (COGS) Inventory Level DAY'S INVENTORY = 365 Days / Inventory Tumover . DEBT TO ASSETS RATIO= Total Liabilities/Total Assets DEBT TO EQUITY RATIO = Total Liabilities / Total Equity TIMES INTEREST EARNED RATIO = (Income before taxes + Interest Expenses ) / Interest Expenses TC=CC+OC = (0/2) xPxCHR/0) xS Carrying Cost (CC) = 0/2 *p.c Ordering Cost (OC) = R/Q'S E0Q=V2RS/PC ROP=(R/360 days) * (number of days to get an order)