II Numeric 0003 Historical Pro'ected 2012 2013 2016 2017 2013 Sales $4,132.5 $7,491.2 $110000 $132000 $134300 $231000 $233750 $360933 0033 (excluding...
how to find the NPV and the NPV of 5 years for FCF?
II Numeric 0003 Historical Pro'ected2012 2013 2016 2017 2013 Sales $4,132.5 $7,491.2 $110000 $132000 $134300 $231000 $233750 $3609330033 (excluding depr.) $13034 $10327 $23975 $33000 $40200 $57750 $7,213.75 $9,023.44Gross Profit $23231 $50535 $36025 $39000 $133600 $173250 $210563 $270703SG&A $24432 $43425 $6,376.49 $7,575.27 $10,499.33 $12,992.92 $16,073.74 $19,397.44R&D Exp. $0.0 $0.0 $0.0 $13.20 $13.43 $23.10 $23.33 $36.09EBITDA $379.9 $1,516.0 $22260 $23115 $33422 $40090 $5,543.6 $7,136.3Depreciation $41.3 $149.0 $34.34 $39.03 $93.5 $93.2 $103.1 $103.3Amortization $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0EBIT $333.1 $1,367.0 $21412 $22224 $32437 $42103 $54455 $70235Taxes $113.34 $473.44 $749.42 $777.36 $1,137.03 $1,473.77 $1,905.93 $2,459.97Tax-effected EBIT $219.3 $333.5 $1,391.3 $1,444.6 $21115 $27370 $35336 $45635Depreciation and Amortization $41.3 $149.0 $34.3 $39.1 | $93.5 | $93.2 | $103.1 | $103.3 |Capital Expenditures $142.2 $1.194.4 $33.0 $10000 $55.44 $69.30 $36.63 $103.23Additions to Intangibles $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0Change in working oapitai $10.3 $271.2 $63.0 $31.6 $114.2 $142.3 $173.5 $223.1 Free Cash Flow $66.8 ($577.1) $1.290.8 $363.0 $1,941.9 $2,524.9 $3.274.5 $4,237.1
Show more
