Question: Build a DCF model for Ferrari based on the projected financials from the case. Your model should ultimately calculate the intrinsic stock price for Ferrari

Build a DCF model for Ferrari based on the projected financials from the case. Your model should ultimately calculate the intrinsic stock price for Ferrari in US dollars.

Ferrari Forecast (Millions of Euro, except as noted)
Assumptions 2014 2015 2016
Operating Margin - Cars 12.5% 13.0% 13.5%
Operating Margin - Engines 9.1% 10.0% 10.0%
Operating Margin - All Other Revenue 24.9% 25.0% 27.0%
Net Working Capital Turnover 1.9 2.0 2.1
Net Fixed Asset Turnover 3.2 3.2 3.3
Deprec. & Amort./PP&E 34% 34% 34%
Financial Forecast
Car Shipments (000s) 7.26 7.76 8.15
Avg Revenue per Car (Euro 000s) 268 281 295
Car Revenue 1,944 2,184 2,408
Engine Revenue 311 320 330
All Other Revenue 507 523 554
Total Revenue 2,762 3,027 3,292
Operating Profit - Cars 243 284 325
Operating Profit - Engines 28 32 33
Operating Profit - All Other Revenue 126 131 150
Total Operating Profit 398 447 508
Net Working Capital 1,425 1,513 1,568
Net PP&E and Int. Assets 851 932 998
Deprec. & Amort. 289 317 339
Total Revenue Growth 18% 10% 9%
EBITDA Margin 25% 25% 26%
WACC 5%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!