jump to content of this page Bized logo linked to homepage
You are here: Home > Company Information > Financial Ratio Analysis > Advanced Profitability - Activity 5 - Carphone Warehouse

Company Info
Bookmark and Share

Advanced


Advanced Profitability - Activity 5 - Carphone Warehouse

Here are the sales and profit data for the Carphone Warehouse, mobile communications company, for the latest two years. What we want to know is whether the Carphone Warehouse is a profitable company ... and how do we know?

Following the Profit and Loss Account for the Carphone Warehouse, below is the profitability section of our ratio table and we have included the name of the ratio, the formula and the workings for the year ended 31 March 2001.

Carphone Warehouse
Consolidated Profit and Loss Account31 March 2001 25 March 2000
for the year ended£'000£'000
Turnover1,110,678697,720
Cost of sales-830,126-505,738
Gross profit280,552191,982
Operating expenses-176,960-129,359
Operating profit66,01641,389
Other costs/income-21,004-16,089
Profit before interest and taxation45,01225,300
Net interest receivable (payable)2,385-196
Profit on ordinary activities before taxation47,39725,104
Tax on profit on ordinary activities-8,675-8,831
Profit on ordinary activities after taxation38,72216,273
Equity minority interests-56354
Profit for the financial period38,15916,327
Dividends00
Retained profit38,15916,327

Here is a list of the profitability ratios for the year ended 31 March 2001 for the Carphone Warehouse. Read down this page and make sure you can follow where all the figures come from as we work through these ratios... and make sure that you agree with the answers you see here... then you should repeat the calculations for the year ended 25 March 2000.

Note: we don't have any administration and overhead costs so we can't calculate those ratios; but we do have interest and operating costs so we can report those instead.

Here are the figures for the year ended 31 March 2001, put into ratio format, that you should have extracted from the Profit and Loss Accounts and that you will then have used to calculate the ratio values... check that you agree with them and then repeat what you see there for the year ended 25 March 2000.

Carphone WarehouseFor the year ended
Basic Ratios31 Mar 0125 Mar 00
Gross profit margin280,552/1,110,678 * 100 = 
Operating profit margin 660,16/1,110,678 * 100 = 
Net profit margin45,012/1,110,678 * 100 = 
Retained profit margin38,159/1,110,678 * 100 =  
Profit mark up280,552/830,126 * 100 =  
Additional Ratios  
Profit before interest and taxation %45,012/11,10,678 * 100 = 
Profit before taxation %47,397/11,10,678 * 100 = 
Profit for the year %38,159/11,10,678 * 100 = 
Operating costs %176,960/1,110,678 * 100 = 
Interest costs %2,385/1,110,678 * 100 = 

Here are the ratio answers for the year ended 31 March 2001

Carphone WarehouseFor the year ended
Basic Ratios31 Mar 0125 Mar 00
Gross profit margin25.26% 
Operating profit margin 5.94% 
Net profit margin4.05% 
Retained profit margin3.44% 
Gross profit mark-up33.80% 
Additional Ratios  
Profit before interest and taxation %4.05% 
Profit before taxation %4.27% 
Profit for the year %3.44% 
Operating costs %15.93% 
Interest costs %0.21% 

Did you get this?

Now we need to interpret what we've found: what do all of these ratio results mean? In fact, these results are remarkably consistent from year to year. Follow through our analysis of the Carphone Warehouse as it unfolds in this section of this site and keep referring back to these profitability ratios to see how they fit in with our overall view of this business.

You can try some advanced profitability questions or move on to the Rate of Return section.

Section Index | Previous | Next | Next Section | Section Map