Institutional Sign In

Go

IKEA Czech Republic

IKEA CR's Cash & Cash Equivalents fell 49.6% yoy to CZK 630 mil in 2017

By Helgi Library - April 2, 2020

IKEA Czech Republic's total assets reached CZK 3,445 mil at the end of 2017, down 17.3% compared to the previous year. ...

Profit Statement 2015 2016 2017
Sales CZK mil 8,539 9,305 9,893
Gross Profit CZK mil 1,997 2,252 2,767
EBITDA CZK mil 1,173 1,269 1,546
EBIT CZK mil 754 842 1,111
Financing Cost CZK mil 2.89 2.99 25.9
Pre-Tax Profit CZK mil 751 839 1,085
Net Profit CZK mil 599 675 865
Dividends CZK mil 367 1,000 ...
Balance Sheet 2015 2016 2017
Total Assets CZK mil 4,092 4,166 3,445
Non-Current Assets CZK mil 2,658 2,320 1,987
Current Assets CZK mil 1,388 1,797 1,403
Working Capital CZK mil -180 -259 -118
Shareholders' Equity CZK mil 2,718 2,794 1,946
Liabilities CZK mil 1,374 1,372 1,498
Total Debt CZK mil 73.6 24.5 0
Net Debt CZK mil -799 -1,227 -630
Ratios 2015 2016 2017
ROE % 23.0 24.5 36.5
ROCE % 23.0 29.7 44.0
Gross Margin % 23.4 24.2 28.0
EBITDA Margin % 13.7 13.6 15.6
EBIT Margin % 8.83 9.05 11.2
Net Margin % 7.01 7.25 8.74
Net Debt/EBITDA -0.680 -0.967 -0.408
Net Debt/Equity % -29.4 -43.9 -32.4
Cost of Financing % 2.81 6.09 211
Cash Flow 2015 2016 2017
Total Cash From Operations CZK mil ... ... 1,212
Total Cash From Investing CZK mil ... ... -139
Total Cash From Financing CZK mil ... ... -1,695
Net Change In Cash CZK mil ... ... -621
Cash Conversion Cycle days -10.7 -14.2 -10.8
Cash Earnings CZK mil 1,018 1,102 1,300
Free Cash Flow CZK mil ... ... 1,074

Get all company financials in excel:

Download Sample   $19.99

summary Unit 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
income statement                            
Sales CZK mil               6,874 7,217 7,365 7,747 8,539    
Gross Profit CZK mil               1,421 1,512 1,575 1,765 1,997    
EBIT CZK mil               341 338 242 478 754    
Net Profit CZK mil               254 235 176 367 599    
ROE %               10.5 9.94 7.58 15.4 23.0    
EBIT Margin %               4.97 4.68 3.29 6.17 8.83    
Net Margin %               3.69 3.26 2.39 4.74 7.01    
Employees               954 1,179 1,225 1,259 1,157    
balance sheet                            
Total Assets CZK mil               4,030 4,344 3,864 3,804 4,092    
Non-Current Assets CZK mil               3,513 3,655 3,269 2,918 2,658    
Current Assets CZK mil               509 644 554 843 1,388    
Shareholders' Equity CZK mil               2,373 2,354 2,296 2,487 2,718    
Liabilities CZK mil               1,657 1,990 1,568 1,318 1,374    
Non-Current Liabilities CZK mil               513 411 253 161 81.3    
Current Liabilities CZK mil               963 1,039 1,039 1,082 1,179    
Net Debt/EBITDA               0.642 0.796 0.437 -0.277 -0.680    
Net Debt/Equity %               18.8 24.5 12.7 -9.98 -29.4    
Cost of Financing % ...             3.45 5.27 2.54 3.90 2.81    
cash flow                            
Total Cash From Operations CZK mil               717 651 ... ... ... ...  
Total Cash From Investing CZK mil               -269 -528 ... ... ... ...  
Total Cash From Financing CZK mil               -455 37.7 ... ... ... ...  
Net Change In Cash CZK mil               -7.52 161 ... ... ... ...  
income statement Unit 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
income statement                            
Sales CZK mil               6,874 7,217 7,365 7,747 8,539    
Cost of Goods & Services CZK mil               5,453 5,705 5,789 5,981 6,542    
Gross Profit CZK mil               1,421 1,512 1,575 1,765 1,997    
Staff Cost CZK mil               560 617 604 684 699    
Other Cost CZK mil               166 172 305 186 125    
EBITDA CZK mil               695 723 666 896 1,173    
Depreciation CZK mil               354 386 424 418 420    
EBIT CZK mil               341 338 242 478 754    
Financing Cost CZK mil               18.9 33.4 15.2 10.6 2.89    
Extraordinary Cost CZK mil               0 0 0 0 0    
Pre-Tax Profit CZK mil               322 304 227 467 751    
Tax CZK mil               68.4 69.2 50.8 99.8 152    
Minorities CZK mil               0 0 0 0 0    
Net Profit CZK mil               254 235 176 367 599    
Dividends CZK mil               254 0 254 176 367   ...
growth rates                            
Total Revenue Growth % ...             -0.824 4.99 2.04 5.19 10.2    
Operating Cost Growth % ...             1.59 8.76 15.2 -4.41 -5.22    
EBITDA Growth % ...             -14.8 4.06 -7.92 34.6 31.0    
EBIT Growth % ...             -25.8 -1.10 -28.2 97.1 57.9    
Pre-Tax Profit Growth % ...             -25.7 -5.67 -25.3 106 60.8    
Net Profit Growth % ...             -24.7 -7.49 -24.9 108 63.0    
ratios                            
ROE %               10.5 9.94 7.58 15.4 23.0    
ROCE % ...             7.88 7.34 5.58 12.7 23.0    
Gross Margin %               20.7 21.0 21.4 22.8 23.4    
EBITDA Margin %               10.1 10.0 9.04 11.6 13.7    
EBIT Margin %               4.97 4.68 3.29 6.17 8.83    
Net Margin %               3.69 3.26 2.39 4.74 7.01    
Payout Ratio %               100 0 144 48.0 61.3   ...
Cost of Financing % ...             3.45 5.27 2.54 3.90 2.81    
Net Debt/EBITDA               0.642 0.796 0.437 -0.277 -0.680    
balance sheet Unit 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
balance sheet                            
Non-Current Assets CZK mil               3,513 3,655 3,269 2,918 2,658    
Property, Plant & Equipment CZK mil               3,513 3,655 3,269 2,918 2,658    
Intangible Assets CZK mil               0 0 0 0 0    
Goodwill CZK mil               0 0 0 0 0    
Current Assets CZK mil               509 644 554 843 1,388    
Inventories CZK mil               361 392 394 420 449    
Receivables CZK mil               28.3 32.5 34.5 37.1 46.9    
Cash & Cash Equivalents CZK mil               42.4 205 122 380 872    
Total Assets CZK mil               4,030 4,344 3,864 3,804 4,092    
Shareholders' Equity CZK mil               2,373 2,354 2,296 2,487 2,718    
Of Which Minority Interest CZK mil               0 0 0 0 0    
Liabilities CZK mil               1,657 1,990 1,568 1,318 1,374    
Non-Current Liabilities CZK mil               513 411 253 161 81.3    
Long-Term Debt CZK mil               263 193 123 82.8 24.5    
Deferred Tax Liabilities CZK mil               239 195 127 78.4 42.7    
Current Liabilities CZK mil               963 1,039 1,039 1,082 1,179    
Short-Term Debt CZK mil               226 588 291 49.1 49.1    
Trade Payables CZK mil               752 829 629 638 676    
Provisions CZK mil               24.5 21.7 55.0 74.3 114    
Equity And Liabilities CZK mil               4,030 4,344 3,864 3,804 4,092    
growth rates                            
Total Asset Growth % ...             -3.44 7.79 -11.1 -1.54 7.56    
Shareholders' Equity Growth % ...             -3.39 -0.801 -2.49 8.31 9.31    
Net Debt Growth % ...             -19.8 29.0 -49.5 -185 222    
Total Debt Growth % ...             -19.4 59.7 -47.1 -68.1 -44.2    
ratios                            
Total Debt CZK mil               489 781 413 132 73.6    
Net Debt CZK mil               446 576 291 -248 -799    
Working Capital CZK mil               -363 -404 -201 -181 -180    
Capital Employed CZK mil               3,150 3,251 3,068 2,737 2,477    
Net Debt/Equity %               18.8 24.5 12.7 -9.98 -29.4    
Cost of Financing % ...             3.45 5.27 2.54 3.90 2.81    
cash flow Unit 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
cash flow                            
Net Profit CZK mil               254 235 176 367 599    
Depreciation CZK mil               354 386 424 418 420    
Non-Cash Items CZK mil ...             48.0 -10.7 ... ... ... ...  
Change in Working Capital CZK mil ...             60.9 41.2 ... ... ... ...  
Total Cash From Operations CZK mil               717 651 ... ... ... ...  
Capital Expenditures CZK mil               -271 -529 ... ... ... ...  
Other Investments CZK mil               1.59 1.09 ... ... ... ...  
Total Cash From Investing CZK mil               -269 -528 ... ... ... ...  
Dividends Paid CZK mil               -254 0 ... ... ... ...  
Issuance Of Shares CZK mil ... ... ... ... ... ... ... ... ... ... ... ... ...  
Issuance Of Debt CZK mil ...             -118 292 ... ... ... ...  
Total Cash From Financing CZK mil               -455 37.7 ... ... ... ...  
Net Change In Cash CZK mil               -7.52 161 ... ... ... ...  
ratios                            
Days Sales Outstanding days               1.50 1.64 1.71 1.75 2.01    
Days Sales Of Inventory days               24.2 25.1 24.8 25.6 25.0    
Days Payable Outstanding days               50.4 53.0 39.7 38.9 37.7    
Cash Conversion Cycle days               -24.7 -26.3 -13.1 -11.5 -10.7    
Cash Earnings CZK mil               608 621 600 786 1,018    
Free Cash Flow CZK mil               447 123 ... ... ... ...  
other data Unit 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
other data                            
ROA %               6.19 5.61 4.30 9.58 15.2    
Gross Margin %               20.7 21.0 21.4 22.8 23.4    
Employees               954 1,179 1,225 1,259 1,157    
Cost Per Employee USD per month               2,764 2,231 2,100 2,117 2,109    
Cost Per Employee (Local Currency) CZK per month               48,880 43,636 41,083 45,248 50,334    
Staff Cost (As % Of Total Cost) %               8.57 8.97 8.48 9.40 8.98    
Effective Tax Rate %               21.2 22.7 22.4 21.4 20.3    
Capital Expenditures (As % of Sales) %               3.94 7.33 ... ... ... ...  

Get all company financials in excel:

Download Sample   $19.99

IKEA Česká republika is a Czech Republic-based subsidiary of Sweden's IKEA Group. Similar to the Group, the Czech IKEA operates department stores selling furniture and household equipment. In 2013, there were two stores in Prague and one in Ostrava and Brno in the the Czech Republic. The IKEA Group is a Swedish company registered in the Netherlands that designs and sells ready-to-assemble furniture (such as beds, chairs and desks), appliances and home accessories. Founded in Sweden in 1943 by 17-year-old, Ingvar Kamprad, the company's name is an acronym that consists of the initials of, Ingvar Kamprad, Elmtaryd (the farm where he grew up), and Agunnaryd (his hometown in Småland, south Sweden). In 2013, IKEA operated 349 stores in 43 countries

IKEA Czech Republic Logo

Finance

IKEA Czech Republic has been growing its sales by a year on average in the last 5 years. EBITDA has grown on average by 16.4% a year during that time to total of CZK 1,546 mil in 2017, or 15.6% of sales. That’s compared to 12.7% average margin seen in last five years.

The company netted CZK 865 mil in 2017 implying ROE of 36.5% and ROCE of 44.0%. Again, the average figures were 21.4% and 23.0%, respectively when looking at the previous 5 years.

IKEA Czech Republic’s net debt amounted to CZK -630 mil at the end of 2017, or -32.4% of equity. When compared to EBITDA, net debt was -0.408x, down when compared to average of -0.379x seen in the last 5 years.