Multiples.xlsx
Sheet1
| Item | fnd | | Low | HD | Average |
| Rev | 3,433,533 | | 96,250,000 | 151,157,000 |
| ebit | 338,992 | | 12,105,000 | 23,084,000 |
| ebitda | 457,188 | | 13,987,000 | 25,946,000 |
| debt | 1,423,457 | | 29,384,000 | 46,269,000 |
| Equity | 8,571,000 | | 131,940,000 | 311,664,000 |
| Cash | 139,444 | | 1,404,000 | 2,343,000 |
| EV | 9,855,013 | | 159,920,000 | 355,590,000 |
| eps | 2.64 | | 12.04 | 15.53 |
| Price | 80.97 | | 199.57 | 301.60 |
| SO | 105,850 |
| | EV | | | | | Equity | PRICE |
| EV/EBIT | $4,850,169.71 | 29.0715208618 | 13.2110698059 | 15.4041760527 | 14.3076229293 | $3,566,156.71 | $33.69 |
| EV/EBITDA | $5,746,504.93 | 21.5557123109 | 11.4334739401 | 13.7050026979 | 12.569238319 | $4,462,491.93 | $42.16 |
| EV/Sales | $6,891,034.17 | 2.870225217 | 1.6615064935 | 2.3524547325 | 2.006980613 | $5,607,021.17 | $52.97 |
| EV/EBIT |
| EV/EBITDA | | | 11.31 | 13.65 | 12.48 |
| EV/Sales | | | 1.64 | 2.34 | 1.99 |
| P/E | 47.514796418 | | 16.5755813953 | 19.4204764971 | 17.9980289462 |
henry0427
