Institutional Sign In

Go

Microsoft Czech Republic

Microsoft CR's Cash & Cash Equivalents fell 100% yoy to CZK 0 mil in 2016

By Helgi Library - April 2, 2020

Microsoft Czech Republic's total assets reached CZK 727 mil at the end of 2016, up 10.6% compared to the previous year. ...

Profit Statement 2014 2015 2016
Sales CZK mil 1,319 1,477 1,716
Gross Profit CZK mil 777 821 987
EBITDA CZK mil 156 174 274
EBIT CZK mil 148 130 223
Financing Cost CZK mil 3.31 -0.724 1.21
Pre-Tax Profit CZK mil 145 131 222
Net Profit CZK mil 112 89.4 170
Dividends CZK mil 82.4 89.4 ...
Balance Sheet 2014 2015 2016
Total Assets CZK mil 432 657 727
Non-Current Assets CZK mil 26.3 306 367
Current Assets CZK mil 380 322 321
Working Capital CZK mil 127 273 297
Shareholders' Equity CZK mil 126 104 184
Liabilities CZK mil 306 553 543
Total Debt CZK mil 0 97.7 62.9
Net Debt CZK mil -1.51 97.7 62.9
Ratios 2014 2015 2016
ROE % 76.5 77.7 118
ROCE % 79.0 24.4 27.3
Gross Margin % 58.9 55.6 57.5
EBITDA Margin % 11.9 11.8 16.0
EBIT Margin % 11.2 8.81 13.0
Net Margin % 8.49 6.05 9.88
Net Debt/EBITDA -0.010 0.560 0.230
Net Debt/Equity % -1.20 94.1 34.2
Cost of Financing % ... -1.48 1.50
Cash Flow 2014 2015 2016
Total Cash From Operations CZK mil 140 202 272
Total Cash From Investing CZK mil -8.17 -268 -109
Total Cash From Financing CZK mil -152 10.4 -123
Net Change In Cash CZK mil -20.2 -56.2 39.4
Cash Conversion Cycle days 27.5 52.3 56.4
Cash Earnings CZK mil 120 134 220
Free Cash Flow CZK mil 132 -66.6 162

Get all company financials in excel:

Download Sample   $19.99

summary Unit 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
income statement                            
Sales CZK mil ... ...           1,163 1,241 1,233 1,275 1,319    
Gross Profit CZK mil ... ...           610 699 669 705 777    
EBIT CZK mil ... ...           116 138 141 153 148    
Net Profit CZK mil ... ...           89.2 80.6 108 102 112    
ROE % ... ...           42.9 41.6 45.5 49.8 76.5    
EBIT Margin % ... ...           9.99 11.1 11.5 12.0 11.2    
Net Margin % ... ...           7.67 6.50 8.80 7.99 8.49    
Employees               226 214 211 209 208    
balance sheet                            
Total Assets CZK mil ... ...           424 545 523 433 432    
Non-Current Assets CZK mil ... ...           31.4 27.4 25.0 27.8 26.3    
Current Assets CZK mil ... ...           376 499 474 384 380    
Shareholders' Equity CZK mil ... ...           154 234 243 166 126    
Liabilities CZK mil ... ...           270 311 280 267 306    
Non-Current Liabilities CZK mil ... ...           28.9 40.6 37.3 23.4 26.8    
Current Liabilities CZK mil ... ...           242 271 243 244 279    
Net Debt/EBITDA ... ...           -0.151 -0.285 -0.079 -0.037 -0.010    
Net Debt/Equity % ... ...           -12.3 -17.5 -4.78 -3.50 -1.20    
Cost of Financing % ... ... ... ... ...     45.3 ... ... ... ...    
cash flow                            
Total Cash From Operations CZK mil ... ... ... ...       250 123 83.1 121 140    
Total Cash From Investing CZK mil ... ... ... ...       -2.21 -2.63 -6.78 -8.17 -8.17    
Total Cash From Financing CZK mil ... ... ... ...       -352 0 -100 -178 -152    
Net Change In Cash CZK mil ... ... ... ...       -104 120 -23.7 -65.3 -20.2    
income statement Unit 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
income statement                            
Sales CZK mil ... ...           1,163 1,241 1,233 1,275 1,319    
Cost of Goods & Services CZK mil ... ...           553 542 564 570 542    
Gross Profit CZK mil ... ...           610 699 669 705 777    
Staff Cost CZK mil ... ...           516 550 534 558 619    
Other Cost CZK mil ... ...           -29.8 5.78 -11.5 -11.4 1.14    
EBITDA CZK mil ... ...           125 144 146 158 156    
Depreciation CZK mil ... ...           8.38 6.13 5.06 5.09 8.54    
EBIT CZK mil ... ...           116 138 141 153 148    
Financing Cost CZK mil ... ...           6.08 30.1 -1.70 20.2 3.31    
Extraordinary Cost CZK mil ... ...           0 0 0 0 0    
Pre-Tax Profit CZK mil ... ...           110 108 143 133 145    
Tax CZK mil ... ...           21.0 26.9 34.6 30.8 32.6    
Minorities CZK mil ... ...           0 0 0 0 0    
Net Profit CZK mil ... ...           89.2 80.6 108 102 112    
Dividends CZK mil ... ...           ... ... ... ... 82.4   ...
growth rates                            
Total Revenue Growth % ... ... ...         -13.0 6.71 -0.653 3.38 3.46    
Operating Cost Growth % ... ... ...         -3.29 14.4 -5.88 4.57 13.5    
EBITDA Growth % ... ... ...         -45.4 15.4 1.85 7.88 -0.983    
EBIT Growth % ... ... ...         -45.7 18.4 2.71 8.14 -3.27    
Pre-Tax Profit Growth % ... ... ...         -58.7 -2.41 33.1 -7.27 8.97    
Net Profit Growth % ... ... ...         -55.0 -9.58 34.5 -6.13 9.94    
ratios                            
ROE % ... ...           42.9 41.6 45.5 49.8 76.5    
ROCE % ... ... ...         30.8 63.2 93.3 79.8 79.0    
Gross Margin % ... ...           52.5 56.3 54.3 55.3 58.9    
EBITDA Margin % ... ...           10.7 11.6 11.9 12.4 11.9    
EBIT Margin % ... ...           9.99 11.1 11.5 12.0 11.2    
Net Margin % ... ...           7.67 6.50 8.80 7.99 8.49    
Payout Ratio % ... ...           ... ... ... ... 73.6   ...
Cost of Financing % ... ... ... ... ...     45.3 ... ... ... ...    
Net Debt/EBITDA ... ...           -0.151 -0.285 -0.079 -0.037 -0.010    
balance sheet Unit 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
balance sheet                            
Non-Current Assets CZK mil ... ...           31.4 27.4 25.0 27.8 26.3    
Property, Plant & Equipment CZK mil ... ...           31.4 27.4 25.0 27.8 26.3    
Intangible Assets CZK mil ... ...           0 0 0 0 0    
Goodwill CZK mil ... ...           0 0 0 0 0    
Current Assets CZK mil ... ...           376 499 474 384 380    
Inventories CZK mil ... ...           0 0 0 0 0    
Receivables CZK mil ... ...           148 130 139 122 146    
Cash & Cash Equivalents CZK mil ... ...           18.8 41.0 11.6 5.82 1.51    
Total Assets CZK mil ... ...           424 545 523 433 432    
Shareholders' Equity CZK mil ... ...           154 234 243 166 126    
Of Which Minority Interest CZK mil ... ...           0 0 0 0 0    
Liabilities CZK mil ... ...           270 311 280 267 306    
Non-Current Liabilities CZK mil ... ...           28.9 40.6 37.3 23.4 26.8    
Long-Term Debt CZK mil ... ...           0 0 0 0 0    
Deferred Tax Liabilities CZK mil ... ...           0 0 0 0 0    
Current Liabilities CZK mil ... ...           242 271 243 244 279    
Short-Term Debt CZK mil ... ...           0 0 0 0 0    
Trade Payables CZK mil ... ...           32.0 49.8 39.5 19.3 19.1    
Provisions CZK mil ... ...           3.00 11.8 1.21 1.08 0.990    
Equity And Liabilities CZK mil ... ...           424 545 523 433 432    
growth rates                            
Total Asset Growth % ... ... ...         -23.0 28.6 -4.16 -17.1 -0.252    
Shareholders' Equity Growth % ... ... ...         -41.5 52.5 3.62 -31.5 -24.0    
Net Debt Growth % ... ... ...         -843 118 -71.7 -49.8 -74.1    
Total Debt Growth % ... ... ... ... ... ...   -100 ... ... ... ... ...  
ratios                            
Total Debt CZK mil ... ...           0 0 0 0 0    
Net Debt CZK mil ... ...           -18.8 -41.0 -11.6 -5.82 -1.51    
Working Capital CZK mil ... ...           116 80.3 99.7 103 127    
Capital Employed CZK mil ... ...           148 108 125 131 153    
Net Debt/Equity % ... ...           -12.3 -17.5 -4.78 -3.50 -1.20    
Cost of Financing % ... ... ... ... ...     45.3 ... ... ... ...    
cash flow Unit 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
cash flow                            
Net Profit CZK mil ... ...           89.2 80.6 108 102 112    
Depreciation CZK mil ... ...           8.38 6.13 5.06 5.09 8.54    
Non-Cash Items CZK mil ... ... ... ...       -126 0.221 -11.1 17.3 43.2    
Change in Working Capital CZK mil ... ... ... ...       278 35.9 -19.4 -2.97 -23.9    
Total Cash From Operations CZK mil ... ... ... ...       250 123 83.1 121 140    
Capital Expenditures CZK mil ... ... ... ...       -3.36 -2.21 -2.63 -6.78 -8.17    
Other Investments CZK mil ... ... ... ...       1.14 -0.411 -4.15 -1.39 0    
Total Cash From Investing CZK mil ... ... ... ...       -2.21 -2.63 -6.78 -8.17 -8.17    
Dividends Paid CZK mil ... ... ... ...       -198 ... ... ... ...    
Issuance Of Shares CZK mil ... ... ... ...       0 0 0 0 0    
Issuance Of Debt CZK mil ... ... ... ...       -26.9 0 0 0 0    
Total Cash From Financing CZK mil ... ... ... ...       -352 0 -100 -178 -152    
Net Change In Cash CZK mil ... ... ... ...       -104 120 -23.7 -65.3 -20.2    
ratios                            
Days Sales Outstanding days ... ...           46.5 38.3 41.2 34.9 40.3    
Days Sales Of Inventory days ... ...           0 0 0 0 0    
Days Payable Outstanding days ... ...           21.1 33.5 25.6 12.4 12.9    
Cash Conversion Cycle days ... ...           25.4 4.74 15.6 22.6 27.5    
Cash Earnings CZK mil ... ...           97.6 86.8 114 107 120    
Free Cash Flow CZK mil ... ... ... ...       247 120 76.3 113 132    
other data Unit 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
other data                            
ROA % ... ...           18.3 16.6 20.3 21.3 25.9    
Gross Margin % ... ...           52.5 56.3 54.3 55.3 58.9    
Cost Per Employee USD per month ... ...           9,946 12,104 10,789 11,376 11,613    
Cost Per Employee (Local Currency) CZK per month ... ...           190,087 214,070 211,036 222,572 248,184    
Staff Cost (As % Of Total Cost) % ... ...           49.2 49.8 48.9 49.8 52.9    
Effective Tax Rate % ... ...           19.0 25.0 24.2 23.2 22.6    
Revenues From Abroad CZK mil               967 1,024 1,014 1,077 1,104 ... ...
Revenues From Abroad (As % Of Total) % ... ...           83.2 82.5 82.3 84.5 83.7 ... ...

Get all company financials in excel:

Download Sample   $19.99

Microsoft Czech Republic is a Czech Republic-based subsidiary of US multinational technology company. The Company develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems. The Microsoft was founded by Paul Allen and Bill Gates in,1975, to develop and sell BASIC interpreters for Altair 8800. Since the 1990s, it has increasingly diversified from the operating system market and has made a number of corporate acquisitions.

Microsoft Czech Republic Logo

Finance

Microsoft Czech Republic has been growing its sales by a year on average in the last 5 years. EBITDA has grown on average by 13.7% a year during that time to total of CZK 274 mil in 2016, or 16.0% of sales. That’s compared to 12.8% average margin seen in last five years.

The company netted CZK 170 mil in 2016 implying ROE of 118% and ROCE of 27.3%. Again, the average figures were 73.5% and 60.8%, respectively when looking at the previous 5 years.

Microsoft Czech Republic’s net debt amounted to CZK 62.9 mil at the end of 2016, or 34.2% of equity. When compared to EBITDA, net debt was 0.230x, up when compared to average of 0.133x seen in the last 5 years.