p&g ratio analysis for year 2011
Post on 14-Jan-2016
19 Views
Preview:
DESCRIPTION
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
top related