p&g ratio analysis for year 2011

Upload: swati-pugalia

Post on 14-Jan-2016

19 views

Category:

Documents


1 download

DESCRIPTION

P&G ratio analysis

TRANSCRIPT

Sheet1Ratio AnalysisFormulaCalculation2011Profit Margin(PAT/Net Sales )*10015.0838097947
Author: Swati.Pugalia: Used net sales = gross sales - Excise duty15.08%Asset TurnoverNet Sales/Average total assets1.75433070981.75Return On Assets(PAT/Average total assets)*10026.461990743226.46%Return On Equity(PAT/Average shareholder's equity)*10026.579794417126.58%Earnings per Share(PAT/Weighted average number of equity shares)*100Current RatioCurrent Assets / Current Liabilities2.47833732512.48Quick Ratio(Current Assets - Inventory) / Current Liabilities2.24010205542.24Debtor TurnoverSales/Average DebtorsAverage debt Collection PeriodInventory TurnoverDebt-to-Equity RatioInterest CoverPrice-earning RatioDividend YieldPrice-to-Book RatioLiabilities-to-equity ratioFixed Asset Turnover Ratio Net Sales/Average Fixed Assets5.06648311945.07

Sheet2