Loading...

Free Cash Flow Build Up

Illumina Inc.

Illumina Inc. (ILMN)

Healthcare

Year
A/P
2013
Actual
2014
Actual
2015
Projected
2016
Projected
2017
Projected
2018
Projected
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 1,421.181,861.322,437.773,192.744,181.545,476.567,172.659,394.0212,303.3416,113.6921,104.10
EBITDA 296.88603.07649.66850.871,114.381,459.501,911.512,503.513,278.844,294.305,624.24
EBIT 198.96490.46491.94644.30843.831,105.171,447.441,895.712,482.813,251.744,258.81
Tax Rate 21.35%21.26%21.30%21.29%33.46%11.94%21.86%21.86%21.86%21.86%21.86%
EBIAT 156.50386.18384.41507.09561.52973.211,131.041,481.321,940.092,540.943,327.86
Depreciation 97.92112.61157.72206.57270.55354.33464.07607.79796.031,042.561,365.44
Accounts Receivable --50.53-105.00-122.16-159.99-209.53-274.43-359.42-470.73-616.51-807.45
Inventories --37.10-66.27-79.73-104.42-136.75-179.11-234.58-307.22-402.37-526.99
Accounts Payable -9.0334.6136.3147.5662.2981.58106.85139.94183.28240.04
Capital Expenditure -51.6828.6852.9269.3190.78118.90155.72203.94267.11349.83
UFCF 254.41471.86434.16601.02684.541,134.321,342.051,757.692,302.053,014.993,948.73
WACC
PV UFCF 434.16601.02684.541,134.321,342.051,757.692,302.053,014.993,948.73
SUM PV UFCF 15,945.83