Ratios to calculate operating taxes competitor

This preview shows page 54 - 55 out of 59 pages.

Ratios to calculate operating taxesCompetitorAverageTrendMost RecentDeferred taxes/Net PPE#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Average tax rate (Taxes/EBT)#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Marginal tax rate#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Dividend and debt ratiosCompetitorAverageTrendMost RecentDividend policy: growth rate#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ALong-term debt / market value of firm#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/APreferred stock / market value of firm#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ACoupon rate on preferred stock#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ALong-term debt / market value of firm#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ACompetitorAverageTrendMost RecentNonop. inc. / Sales#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Extr. inc. / Sales#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Long-term investments / Sales#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Other long-term liab. / Sales#N/A#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Year1899189918991899189918991899189918991899NOPAT/Sales#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#N/A42#N/A31Payout ratio 32Annual sales growth rate33Quick ratio 34Current ratio 35LT debt to equity 36Total debt to equity 37Interest coverage (Times-interest-earned)38Gross margin 39EBITD margin 40Operating margin 41Pre-tax margin 42Net profit margin 43Return on assets 44Receivable turnover 45Inventory turnover 46Asset turnover 51Sales growth rate52COGS / Sales53SGA / Sales54Depreciation / Net PPE56Cash / Sales57Inventory/ Sales58Accts. rec. / Sales59Other short term operating assets/Sales60Net PPE / Sales61Other long-term op. A. / Sales62Accts. pay./ Sales63Accruals / Sales64Other current liabilities / Sales66Deferred taxes/Net PPE67Average tax rate (Taxes/EBT)68Marginal tax rate70Dividend policy: growth rate71Long-term debt / market value of firm72Preferred stock / market value of firm73Coupon rate on preferred stock74Long-term debt / market value of firm76Nonop. inc. / Sales77Extr. inc. / Sales78Long-term investments / Sales79Other long-term liab. / Sales9 NOPAT/Sales16Operating capital/Sales18Free cash flow from ongoing operations22ROIC (NOPAT/ Beginning capital)26Economic profitAnalysis of Historical Financial StatementsEnter inputs in yellow cells for comparative analysis.Click "buttons" in column B to change graph.Number of years of historical data you want to analyze (3 to 10 years).Traditional Ratio Analysis: Fill in yellow cells with ratios for industry or for closest competitor for most recent year.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture