Q5 fx A B C D F 1 Account Name 2 this year last standards below Ratio Name year as a % 3 Cash and equivalents 15 130 8.00% Current Ratio 4 Accounts receivable 585 500 20.00% Cash Ratio 5 Inventory 500 500 25.00% Total Debt Ratio 6 Prepaid expenses 7 Other current assets 7.00% 8 Total Current Assets 1,100 1,130 60.00% Debt to Equity Equity Multiplier Times Interest Earned 9 Long-term assets 1,640 1,330 40.00% Cash Coverage 10 Total Assets 2,740 2,460 100.00% Days' Sales in Inventory 11 Accounts payable 46 75 26.50% Days' Sales in Receivables 12 Accrued payroll 38 39 13 Taxes payable 50 46 14 Other current liabilities 96 100 15 Total Current Liabilities 230 260 26.50% 16 Long-term debt 1,000 1,000 7.00% 17 Other long-term liabilities 16.00% Total Asset Turnover Profit Margin Return on Assets Return on Euity Price to Sales Market to Book Value 10 Total Long-term Liabilities 1,000 1,000 23.00% Enterprise Value to EBITDA 13 Total Liabilities 1,230 1,260 49.50% 20 Equity 1,510 1,200 50.50% Dividend Payout Ratio Retention Razio 21 Total Liabilities and Equity 2,740 2,460 100.00% 22 Internal Growth Rate Sustainable Growth Rate 23 Net Sales 5,000 4,500 100.00% 24 Cost of Sales 3,300 3,100 70.00% 25 Operating Exp (Sales,General,Admin). 936 917 20.00% Quick Analysis 26 Depreciation Expense 164 133 27 Interest Expense 80 80 2.50% 28 Tax Expense 150 90 2.55% 29 Net Income 30 370 180 4.95% Would you work there? Would you lend them money? 31 EBITDA 764 483 Would you invest? 32 Stock Price 6.00 3.00 33 Number of Shares Outstanding 1,000 1,000 34 Market Value 6,000 3,000 35 Cash Dividends Paid 90 50 36 37 38 Sheet1 G Computation (This Year) Yes or No H