Pantaloon Retail Final

PANTALOON RETAIL LTD. SUBMITTED BY: LOVISH ANAND MANAS PRADHAN MANUJ KATHIL MD EQUBAL ELAM M S NEGI

FINANCIAL PERFORMANCE RATIOS FINANCIAL PERFORMANCE

JUNE-03 JUNE-04 JUNE-05 JUNE-06 JUNE-07

COGS/NET SALES

68.23%

66.54%

66.52%

66.53%

68.26%

MANPOWER COST/ TOTAL INCOME

4.29%

4.17%

4.80%

5.99%

6.19%

ADVERTISING & SELLING COST/TOTAL INCOME

2.65%

2.84%

3.08%

2.72%

2.80%

INTEREST/TOTAL INCOME

3.97%

3.64%

2.60%

1.97%

2.70%

PBDIT/INTEREST

2.16

2.39

3.42

4.05

3.43

COST OF GOODS SOLD OPENING STOCK + PURCHASES CLOSING STOCK INSURANCE CLAIM

NET SALES SALES VAT/SALES TAX + OTHER OPERATING INCOME

TOTAL INCOME SALES & OTHER OPERATING INCOME + OTHER INCOME

INTEREST INTEREST: ON DEBENTURES & FIXED LOANS ON OTHER LOANS + BILL DISCOUNTING CHARGES + BANK CHARGES INTEREST INCOME ON FIXED DEPOSITS/OTHERS EXCHANGE FLUCTUATION GAIN/LOSS

PBDIT SALES & OPERATING INCOME + OTHER INCOME COGS PERSONNEL COST MANUFACTURING & OTHER EXPENSES

PROFITABILITY INDICATOR RATIOS Profitabil ity

Jun-03

Jun-04

Jun-05

Jun-06

Jun-07

PBDIT/Tot 8.57% al Income

8.66%

8.89%

7.99%

9.24%

PBDT/Tota 4.60% l Income

5.03%

6.29%

6.02%

6.54%

Net 2.56% Profit/Tota l Income

3.00%

3.65%

3.43%

3.60%

RONW (Average Networth)

18.92%

24.47%

24.42%

17.15%

14.82%

ROCE (Average Capital employed)

20.31%

21.03%

22.41%

18.30%

17.48%

RONW(%) (PAT- PREFERENCE DIVIDEND) * 100 EQUITY SHAREHOLDER’S FUND ‘OR’ NET WORTH NET WORTH= EQUITY CAPITAL + RESERVE & SURPLUS – MISCELLANEOUS EXPENSES AND LOSSES ALSO KNOWN AS ROE =

ROCE(%) =

NET INCOME CAPITAL EMPLOYED CAPITAL EMPLOYED = NET WORTH + SECURED/LONG TERM LOAN

Balance- sheet ratios

Formula

Ratio(for june 07)

Interpetation

Debt-equity ratio

Debt(including current liability) / Owners' Equity

0.79

indicates the relative mix of the company's investor-supplied capital. A company is generally considered safer if it has a low debt to equity ratio—that is, a higher proportion of ownersupplied capital—though a very low ratio can indicate excessive caution. In general, debt should be between 50 and 80 percent

.

of equity

Debtor turnover ratio

Receivables/averag e daily sales

7 Days

Debtor turnover ratio suggests the total amount of debtor to sales. Less the ratio is the more efficient company’s management is.

Inventory turnover ratio

Cost of goods sold/average inventory

99 Days

Inventory turnover ratio tells us the rapidity with which the inventory is turned over into recievables through sales.Higher the inventory turnover,the more efficient the more efficient is the inventory of the firm

Current ratio

Current assets/current Liability

2.19

it is a ratio which suggests the ability of the bank to pay its current obligation the formulae for it is : current assets/current liability. The higher the ratio is the more good company is doing.

Quick ratio

Quick Assets (cash, marketable securities, and receivables) / Current Liabilities

1.08

provides a stricter definition of the company's ability to make payments on current obligationsthe company may keep too much cash on hand or have a poor collection program for accounts receivable. If it is lower, it may indicate that the company relies too heavily on inventory to meet its obligations.

Assets- turnover ratio (total income/total assets)

Total assets/ sales

1.96

This ratio suggests the total no. of times the assets of the company has been used over a given period of time as compare to the total sales of the company.

Key Financial Parameter

Amount (June 06) Rs in Crore

Amount (June 07) Rs in Crore

Total Revenue

1871.98

3328.76

Profit Before Interest , Tax And Depreciation

149.64

307.62

Profit After Tax

64.16

119.99

Cash Profit

99.85

184.78

PER SHARE DATA Per share data

formula

Jun-03 Jun04

Jun- Jun05 06

Jun07

Earning per share

PAT Outstanding shares

1.13

1.84

3.31

5.06

8.71

0.20

0.30

0.50

0.50

0.50

7.39

9.87

20.12 39.20

Dividend(Rs)

Book value(Rs)

Asset- liability Outstanding shares

74.42

THANK YOU