Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to find the NPV and the NPV of 5 years for FCF? II Numeric 0003 Historical Pro'ected 2012 2013 2016 2017 2013 Sales $4,132.5

how to find the NPV and the NPV of 5 years for FCF?

image text in transcribedimage text in transcribed
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 depr.) $13034 $10327 $23975 $33000 $40200 $57750 $7,213.75 $9,023.44 Gross Profit $23231 $50535 $36025 $39000 $133600 $173250 $210563 $270703 SG&A $24432 $43425 $6,376.49 $7,575.27 $10,499.33 $12,992.92 $16,073.74 $19,397.44 R&D Exp. $0.0 $0.0 $0.0 $13.20 $13.43 $23.10 $23.33 $36.09 EBITDA $379.9 $1,516.0 $22260 $23115 $33422 $40090 $5,543.6 $7,136.3 Depreciation $41.3 $149.0 $34.34 $39.03 $93.5 $93.2 $103.1 $103.3 Amortization $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 EBIT $333.1 $1,367.0 $21412 $22224 $32437 $42103 $54455 $70235 Taxes $113.34 $473.44 $749.42 $777.36 $1,137.03 $1,473.77 $1,905.93 $2,459.97 Tax-effected EBIT $219.3 $333.5 $1,391.3 $1,444.6 $21115 $27370 $35336 $45635 Depreciation 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.23 Additions to Intangibles $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Change 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 Per tui Growth Method WACC Terminal Growth Rate Year Years into the future FCF NPV NPV of 5-years FCF Terminal Value of FCF PV of TV Enterprise Value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Corporate Finance

Authors: Lawrence J. Gitman, Sean M. Hennessey

2nd Canadian Edition

0321452933, 978-0321452931

More Books

Students also viewed these Finance questions