Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS



Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord







Analyst Estimates

Financial Health





StockDividendMarket Cap (B)PEPrice ($)

PHG Income Statement

Total revenues30,221 M25,878 M18,243 M18,333 M21,344 M20,824 M19,242 M20,993 M19,513 M19,122 M
Cost of sales15,771 M14,515 M9,359 M8,953 M10,294 M9,744 M8,872 M9,739 M9,856 M9,687 M
Gross operating profit12,832 M9,927 M7,829 M8,352 M9,820 M9,345 M8,325 M8,921 M7,677 M7,717 M
Selling Gen & administrative expense7,964 M7,358 M5,419 M5,055 M5,998 M5,907 M5,294 M5,571 M5,390 M5,644 M
Research & development expense2,280 M1,978 M1,696 M1,756 M2,118 M2,021 M2,009 M2,209 M2,054 M2,256 M
Operating income2,588 M592 M650 M1,543 M1,706 M1,902 M1,561 M1,703 M709 M-183 M
floaterest income0000000000
floaterest expense0000000000
Other income net-38 M-4 M97 M-13 M192 M77 M50 M-16 M25 M-1,458 M
Pre-tax Income (EBT)2,096 M224 M357 M1,088 M1,653 M1,727 M1,400 M1,469 M579 M-1,857 M
Income taxes640 M31 M183 M214 M419 M222 M290 M257 M-117 M-121 M
Net income from total operations1,611 M497 M694 M1,569 M2,246 M1,261 M1,316 M1,449 M3,780 M-1,722 M
Minority floaterest0000000000
Total net income1,607 M502 M677 M1,524 M1,989 M1,253 M1,310 M1,439 M3,775 M-1,725 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common1,421 M267 M174 M874 M1,234 M1,505 M1,111 M1,211 M696 M-1,736 M
Depreciation1,618 M1,436 M1,055 M1,027 M1,230 M1,251 M1,507 M1,773 M1,505 M1,718 M
Operating income before depreciation (EBITDA)4,263 M2,162 M1,904 M2,430 M3,176 M3,212 M3,152 M3,478 M2,282 M138 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total1.720.530.721.632.091.331.421.594.17-1.95
Diluted EPS total1.710.530.721.612.061.311.411.564.15-1.95
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today