Cash Flw, Ratios, Equa tabs


Question Description:

33

Document Preview: Equa Ratios Cash Flw Bal Sht Inc Stmt Instructions Page Prepaid Expense Total Current Assets Other Assets Goodwill Property, Plant & Equip. Land Plant & Equip & C-I-P Gross P. P. & E. Less: Accum Depreciation = Days in Period/Inventory Turnover Ratio Current Liabilities Accounts Payable Accrued Liabilities Current Portion L-T-Debt Total Current Liabilities Long-Term Debt Deferred Income Taxes = (Net Income + Interest Expense, Net of Tax)/Avg Tot Assets = (Net Income – Pref Div)/Avg Common Stockholders’ Equity = Net Operating Profit After Tax – (Capital Employed * WACC) = Net Sales/Average Total Assets = Net Sales/Number of Employees Net P. P. & E. Total Assets Incr(Decr) Deferred Tax Incr(Decr) Employee Ben Accrued Employee Benefits Total Liabilities Stockholders’ Equity Incr(Decr) Cur L-T Debt Net (Incr) P.P.&E. (Capital Expenditures) Proceeds, P.P.&E. Sale (Gain)Loss P.P.&E. Sale Incr(Decr) L-T Debt Cash, Financing Activities Net Incr(Decr) in Cash Because P.P.&E. was bought and sold during each year, use the following information concerning Capital Expenditures, Proceeds and (Gain)loss. Liquidity Analysis Working Capital Current Ratio Acid-Test Ratio Days’ Sales in Receivables Inventory Turnover Ratio Days’ Sales in Inventory Cash-to-Cash Operating Cycle Acc Receivable Turnover Ratio Solvency Analysis Debt-to-Equity Ratio Profitability Analysis Gross Margin Profit Margin Asset Turnover Ratio Return on Equity Ratio Weighted Avg Share Oustanding Employees at Year End Return on Assets Ratio The Inc Stmt, Bal Sht, Cash Flw tabs will be used for EOC 11. The Inc Stmt, Bal Sht, Ratios, Equa tabs will be used for EOC 12. Print all of the tabs: Inc Stmt, Bal Sht, Cash Flw, Ratios, Equa Average Market Price Per Share Sales Per Employee Cash, Beginning of Year Cash, End of Year Consolidated Statements of Cash Flows Financial Statement Analysis Net Income Per Employee … Attachments: cashflow_proj….xls

Answer

33