Description
This is a spreadsheet on financial analysis of DLF.
RATIO ANALYSIS
Balance sheet of DLF
------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities
12 mths
12 mths
12 mths
12 mths
3.51 3.51 0 0 380.42 0 383.93 630.15 2.95 633.1 1,017.03 Mar '05
37.77 37.77 0 0 607.16 0 644.93 3,010.93 2.99 3,013.92 3,658.85 Mar '06
305.88 305.88 0 0 346.92 0 652.8 6,242.81 526.48 6,769.29 7,422.09 Mar '07
340.96 340.96 0 0 10,928.19 0 11,269.15 4,945.91 3,440.49 8,386.40 19,655.55 Mar '08
339.44 339.44 0 0 12,035.39 0 12,374.83 7,979.97 1,635.00 9,614.97 21,989.80 Mar '09
12 mths
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses
12 mths
12 mths
12 mths
12 mths
3.51 3.51 0 0 380.42 0 383.93 630.15 2.95 633.1 1,017.03 Mar '05 0 1,287.20 58.62 1,345.82 364.57 0
37.77 37.77 0 0 607.16 0 644.93 3,010.93 2.99 3,013.92 3,658.85 Mar '06 0 1,197.33 169.61 1,366.94 1,725.17 0
305.88 305.88 0 0 346.92 0 652.8 6,242.81 526.48 6,769.29 7,422.09 Mar '07 0 3,059.67 723.25 3,782.92 5,659.33 0
340.96 340.96 0 0 10,928.19 0 11,269.15 4,945.91 3,440.49 8,386.40 19,655.55 Mar '08 0 2,531.21 1,255.16 3,786.37 14,559.56 0
339.44 339.44 0 0 12,035.39 0 12,374.83 7,979.97 1,635.00 9,614.97 21,989.80 Mar '09 0 1,699.75 1,458.64 3,158.39 15,560.22 0
Total Assets Contingent Liabilities Book Value (Rs)
1,017.03 502.91
3,658.85 1,643.36
7,422.10 3,818.81
19,655.56 3,047.92
21,989.80 4,875.99
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover
0.002292 0.002497 0.172071 1.359227 0.961906 0.002292 0.002497 0.172071 1.359227 0.961906 1.648999 4.673251 10.36962 0.744191 0.776978
3.928939 3.380226 2.740996 8.151592 3.323723
MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio #DIV/0! #DIV/0! #DIV/0! Debtor turnover ratio 1.073711 1.478393 1.687592 Fixed asset turnover ratio 1.073711 1.478393 1.687592 Asset turnover ratio 0.405327 0.26059 0.14843 PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
#DIV/0! #DIV/0! 0.487788 0.22852 0.487788 0.22852 0.279665 0.128601
32.34359 16.42287 17.63342 192.9875
52.22243 89.49404 66.09017 97.88076 23.85417 36.8326 46.83316 54.73213 35.26584 62.15839 22.84467 12.5074 60.22029 2.653096 15.1006 9.078719
Profit & Loss account of DLF
------------------ in Rs. Cr. ----------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturing Expenses Selling and Admin Expenses Miscellaneous Expenses Preoperative Exp Capitalised Total Expenses
12 mths
12 mths
12 mths
12 mths
412.23 0 412.23 66.21 -3.07 475.37 0 0 33.32 256.22 46.08 6.42 0 342.04 Mar '05
953.46 0 953.46 191.32 -2.58 1,142.20 0 0 16.76 577.64 43.65 6.23 0 644.28 Mar '06
1,101.66 0 1,101.66 327.48 -8.72 1,420.42 0 0 44.82 237.75 136.16 15.77 0 434.5 Mar '07
5,496.96 0 5,496.96 560.9 -6.06 6,051.80 0 0 103.78 2,141.29 146.06 27.72 0 2,418.85 Mar '08
2,827.90 0 2,827.90 1,004.57 0 3,832.47 0 0 71.12 778.34 159.03 56.01 0 1,064.50 Mar '09
12 mths
Operating Profit PBDIT Interest PBDT Depreciation Other Written Off Profit Before Tax Extra-ordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax 67.12 133.33 33.07 100.26 3.4 0 96.86 0.02 96.88 29.18 67.7 342.04 0 1.4 0.18
12 mths
306.6 497.92 146.15 351.77 3.9 0 347.87 1.11 348.98 120.47 227.44 644.27 0 1.55 0.22
12 mths
658.44 985.92 356.25 629.67 9.44 0 620.23 1.24 621.47 214.56 405.77 434.5 0 340.97 57.95
12 mths
3,072.05 3,632.95 447.65 3,185.30 25.68 41.79 3,117.83 0.36 3,118.19 543.52 2,574.40 2,418.85 0 681.93 115.89
12 mths
1,763.40 2,767.97 809.86 1,958.11 114.08 37.86 1,806.17 33.05 1,839.22 261 1,547.77 1,064.51 0 339.44 28.91
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
35.08 192.98 40 1,094.43
377.68 60.22 40 170.76
15,294.21 2.65 100 4.27
17,048.33 15.1 200 66.1
17,048.33 9.08 100 72.59
RATIO ANALYSIS PROFITABILITY RATIO Current ratio Quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
This ratio is around .96,however it increased from .002292 in '04 .IT had a over all increase . This ratio shows the true current assets that is current asset minus inventory.Since quick and current ratio are same , they are This ratio is decreased from 04 to 09 so the firm has started using its equity more.
This ratio is decreased for the period 04 to 09, it will be not better for the company because it will increase the inventory co
no inventiry , no turnover . overall decreasing .Dos will increase. It shows the sales on each rupee of fixed assets of a company.however it decreased from 04 to 09 peroid which shows that c it shows the sales on each rupee of total assets of a company.it is decreasing which is not good for the company in long term.
it shows the total profitability of a company without taking into account taxes and depriciation.it increased overall. it shows the net profitability of a company .it is increased recently which is good for the company to sustain its operations in it is decreasing ,which is not a good sign. this ratio is decreasing tremendously.
atio are same , they are not keeping any inventories.
crease the inventory conversion period.
oid which shows that company was not able to achieve sales targets or market condition was not good. company in long term.
ased overall. ustain its operations in long term.
doc_274107766.xls
This is a spreadsheet on financial analysis of DLF.
RATIO ANALYSIS
Balance sheet of DLF
------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities
12 mths
12 mths
12 mths
12 mths
3.51 3.51 0 0 380.42 0 383.93 630.15 2.95 633.1 1,017.03 Mar '05
37.77 37.77 0 0 607.16 0 644.93 3,010.93 2.99 3,013.92 3,658.85 Mar '06
305.88 305.88 0 0 346.92 0 652.8 6,242.81 526.48 6,769.29 7,422.09 Mar '07
340.96 340.96 0 0 10,928.19 0 11,269.15 4,945.91 3,440.49 8,386.40 19,655.55 Mar '08
339.44 339.44 0 0 12,035.39 0 12,374.83 7,979.97 1,635.00 9,614.97 21,989.80 Mar '09
12 mths
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses
12 mths
12 mths
12 mths
12 mths
3.51 3.51 0 0 380.42 0 383.93 630.15 2.95 633.1 1,017.03 Mar '05 0 1,287.20 58.62 1,345.82 364.57 0
37.77 37.77 0 0 607.16 0 644.93 3,010.93 2.99 3,013.92 3,658.85 Mar '06 0 1,197.33 169.61 1,366.94 1,725.17 0
305.88 305.88 0 0 346.92 0 652.8 6,242.81 526.48 6,769.29 7,422.09 Mar '07 0 3,059.67 723.25 3,782.92 5,659.33 0
340.96 340.96 0 0 10,928.19 0 11,269.15 4,945.91 3,440.49 8,386.40 19,655.55 Mar '08 0 2,531.21 1,255.16 3,786.37 14,559.56 0
339.44 339.44 0 0 12,035.39 0 12,374.83 7,979.97 1,635.00 9,614.97 21,989.80 Mar '09 0 1,699.75 1,458.64 3,158.39 15,560.22 0
Total Assets Contingent Liabilities Book Value (Rs)
1,017.03 502.91
3,658.85 1,643.36
7,422.10 3,818.81
19,655.56 3,047.92
21,989.80 4,875.99
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover
0.002292 0.002497 0.172071 1.359227 0.961906 0.002292 0.002497 0.172071 1.359227 0.961906 1.648999 4.673251 10.36962 0.744191 0.776978
3.928939 3.380226 2.740996 8.151592 3.323723
MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio #DIV/0! #DIV/0! #DIV/0! Debtor turnover ratio 1.073711 1.478393 1.687592 Fixed asset turnover ratio 1.073711 1.478393 1.687592 Asset turnover ratio 0.405327 0.26059 0.14843 PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
#DIV/0! #DIV/0! 0.487788 0.22852 0.487788 0.22852 0.279665 0.128601
32.34359 16.42287 17.63342 192.9875
52.22243 89.49404 66.09017 97.88076 23.85417 36.8326 46.83316 54.73213 35.26584 62.15839 22.84467 12.5074 60.22029 2.653096 15.1006 9.078719
Profit & Loss account of DLF
------------------ in Rs. Cr. ----------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturing Expenses Selling and Admin Expenses Miscellaneous Expenses Preoperative Exp Capitalised Total Expenses
12 mths
12 mths
12 mths
12 mths
412.23 0 412.23 66.21 -3.07 475.37 0 0 33.32 256.22 46.08 6.42 0 342.04 Mar '05
953.46 0 953.46 191.32 -2.58 1,142.20 0 0 16.76 577.64 43.65 6.23 0 644.28 Mar '06
1,101.66 0 1,101.66 327.48 -8.72 1,420.42 0 0 44.82 237.75 136.16 15.77 0 434.5 Mar '07
5,496.96 0 5,496.96 560.9 -6.06 6,051.80 0 0 103.78 2,141.29 146.06 27.72 0 2,418.85 Mar '08
2,827.90 0 2,827.90 1,004.57 0 3,832.47 0 0 71.12 778.34 159.03 56.01 0 1,064.50 Mar '09
12 mths
Operating Profit PBDIT Interest PBDT Depreciation Other Written Off Profit Before Tax Extra-ordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax 67.12 133.33 33.07 100.26 3.4 0 96.86 0.02 96.88 29.18 67.7 342.04 0 1.4 0.18
12 mths
306.6 497.92 146.15 351.77 3.9 0 347.87 1.11 348.98 120.47 227.44 644.27 0 1.55 0.22
12 mths
658.44 985.92 356.25 629.67 9.44 0 620.23 1.24 621.47 214.56 405.77 434.5 0 340.97 57.95
12 mths
3,072.05 3,632.95 447.65 3,185.30 25.68 41.79 3,117.83 0.36 3,118.19 543.52 2,574.40 2,418.85 0 681.93 115.89
12 mths
1,763.40 2,767.97 809.86 1,958.11 114.08 37.86 1,806.17 33.05 1,839.22 261 1,547.77 1,064.51 0 339.44 28.91
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
35.08 192.98 40 1,094.43
377.68 60.22 40 170.76
15,294.21 2.65 100 4.27
17,048.33 15.1 200 66.1
17,048.33 9.08 100 72.59
RATIO ANALYSIS PROFITABILITY RATIO Current ratio Quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
This ratio is around .96,however it increased from .002292 in '04 .IT had a over all increase . This ratio shows the true current assets that is current asset minus inventory.Since quick and current ratio are same , they are This ratio is decreased from 04 to 09 so the firm has started using its equity more.
This ratio is decreased for the period 04 to 09, it will be not better for the company because it will increase the inventory co
no inventiry , no turnover . overall decreasing .Dos will increase. It shows the sales on each rupee of fixed assets of a company.however it decreased from 04 to 09 peroid which shows that c it shows the sales on each rupee of total assets of a company.it is decreasing which is not good for the company in long term.
it shows the total profitability of a company without taking into account taxes and depriciation.it increased overall. it shows the net profitability of a company .it is increased recently which is good for the company to sustain its operations in it is decreasing ,which is not a good sign. this ratio is decreasing tremendously.
atio are same , they are not keeping any inventories.
crease the inventory conversion period.
oid which shows that company was not able to achieve sales targets or market condition was not good. company in long term.
ased overall. ustain its operations in long term.
doc_274107766.xls