I need help doing a discounted Cash Flow (DCF) valuation! Information is in the pictures

Valuing the Enterprise: Acquisitions and Buyouts Part Eight 600 I Ferrari Forecast (millions of euro, except as noted) EXHIBIT 46.8 2019 2018 2017 2016 2015 2014 4.0 % 5.0 % 3.0 % 6.0 % 3.0 % 4.0 % Assumptions 5.0 % 7.0 % 3.6 % 5.0 % Growth in cars shipped 5.0 % 5.0 % 3.0 % 5.0% Growth in revenue/car 3.0 % 6.0 % 3.0% 3.0% Growth in engine revenue 6.0 % 6.0 % 3.0 % Growth in other revenue 14.0 % 14.0 % 10.0 % 14.0 % 13.5 % 13.0 % 12.5% Operating margin-Cars Operating margin-Engines Operating margin-All other revenue 10.0 % 100 % 30.0 % 10.0 % 27.0 % 10.0 % 25.0 % 9.1% 30.0 % 28.0 % 24.9% 2.2 22 2.2 2.1 2.0 1.9 Net working capital turnover Net fixed asset turnover 3.7 3.8 3.5 3.3 3.2 3.2 34 % 34% 34% 34 % 34% 34% Deprec and amort/PPE Financial forecast 9.08 8.82 8.48 7.76 8.15 7.26 Car shipments (000s) 342 326 310 295 268 281 Avg revenue per car (Euro 000s) 3,105 2.871 2,629 2,408 1,944 2,184 Car revenues 361 350 330 340 311 320 Engine revenue 660 587 623 507 523 554 All other revenue 4,126 3,556 3,844 2,762 3,027 3,292 Total revenue 435 Operating profit-Cars 402 243 284 325 368 36 28 32 33 34 35 Operating profit-Engines 198 126 131 187 Operating profit-All other revenues 150 164 669 Total operating profit 398 447 508 567 624 1,875 Net working capital Net PP&E and int. assets 1,425 1,513 1.568 1,747 1,617 1,086 369 851 932 1,039 998 1,016 Dep and amort 289 317 353 339 345 Source: Created by author bosed on author estimates. Case 46 Ferrari: The 2015 Initial Public Offering EXHIBIT 46.4I Ferrari Balance Sheet (millions of euro) 30-Jun-2015 31-Dec-2014 31-Dec-2013 258 1,077 798 Cash and cash equivalents 154 184 206 Trade receivables 1,181 1,224 863 Receivables from financing activities 352 296 238 Inventories 100 64 115 Other current assets 2,045 2,845 2,219 Total current assets 48 47 37 Investments and other financial assets 149 112 42 Deferred tax assets 589 585 568 Property, plant, and equipment 283 265 242 Intangible assets" 787 787 787 Goodwill 3,900 4,641 3,895 Total assets 578 536 486 Trade payables 182 110 104 Current tax payables 836 774 475 Other current liabilities 1,595 1,420 1,065 Total current liabilities 2,267 510 317 Long-term debt 239 197 233 Other liabilities -201 2,478 2,316 Total equity 3,900 4,641 3,895 Total liabilities and equity Source: Company prospectus. Costs incurred for car project development are recognized as asset following the conditions of IAS38. Capitalized development costs are amortized on a straight-line basis over the estimated life of the model (generally four to eight years). | FCA Car Shipments by Brand (thousands of units) EXHIBIT 46.5 2013 2014 Mass-market vehicle brands 2,500 2,100 NAFTA (U.S., Canada, Mexico) 800 90 LATAM 0 atim t Valuing the Enterprise: Acquisitions and Buyouts Ferrari Income Statement (millions of euro) EXHIBIT 46.3I First Half 2015 2014 2013 2012 Sales 1,007 1,944 1,655 1,695 Cars and spare parts 121 188 311 77 Engines 212 417 412 Sponsorship, commercial and brand" Other 385 46 91 80 69 1,387 2,762 2,335 2,225 Total sales 592 1,217 964 961 Cost of sales excluding dep and amort 130 289 270 238 Depreciation and amortization expense 152 300 260 243 Selling, general, and admin. expense 291 541 479 431 Research and development. 4 26 -2 17 Other operating expense 218 389 364 335 Operating income (EBIT) Net financial income (Expense) -27 -1 191 398 366 335 Profit before tax 65 133 120 101 Income tax expense 126 265 246 233 Net profit 151 271 330 258 Capital expenditures Source: Company prospectus. Includes the net revenues generated from shipments of our cars, including any personalization revenue generated on these cars and sales of spare parts. 2Includes the net revenues generated from the sale of engines to Maserati for use in their cars, and the revenues generated from the rental of engines to other Formula 1 racing teams includes the net revenues earned by our Formula 1 racing team through sponsorship agreements and our share of the Formula 1 World Championship commercial revenues and net revenues generated through the Ferrarl brand, including merchandising, licensing and royalty income. 4Primarily includes interest income generated by the Ferrari Financial Services group and net revenues from the management of the Mugello racetrack. Valuing the Enterprise: Acquisitions and Buyouts Part Eight 600 I Ferrari Forecast (millions of euro, except as noted) EXHIBIT 46.8 2019 2018 2017 2016 2015 2014 4.0 % 5.0 % 3.0 % 6.0 % 3.0 % 4.0 % Assumptions 5.0 % 7.0 % 3.6 % 5.0 % Growth in cars shipped 5.0 % 5.0 % 3.0 % 5.0% Growth in revenue/car 3.0 % 6.0 % 3.0% 3.0% Growth in engine revenue 6.0 % 6.0 % 3.0 % Growth in other revenue 14.0 % 14.0 % 10.0 % 14.0 % 13.5 % 13.0 % 12.5% Operating margin-Cars Operating margin-Engines Operating margin-All other revenue 10.0 % 100 % 30.0 % 10.0 % 27.0 % 10.0 % 25.0 % 9.1% 30.0 % 28.0 % 24.9% 2.2 22 2.2 2.1 2.0 1.9 Net working capital turnover Net fixed asset turnover 3.7 3.8 3.5 3.3 3.2 3.2 34 % 34% 34% 34 % 34% 34% Deprec and amort/PPE Financial forecast 9.08 8.82 8.48 7.76 8.15 7.26 Car shipments (000s) 342 326 310 295 268 281 Avg revenue per car (Euro 000s) 3,105 2.871 2,629 2,408 1,944 2,184 Car revenues 361 350 330 340 311 320 Engine revenue 660 587 623 507 523 554 All other revenue 4,126 3,556 3,844 2,762 3,027 3,292 Total revenue 435 Operating profit-Cars 402 243 284 325 368 36 28 32 33 34 35 Operating profit-Engines 198 126 131 187 Operating profit-All other revenues 150 164 669 Total operating profit 398 447 508 567 624 1,875 Net working capital Net PP&E and int. assets 1,425 1,513 1.568 1,747 1,617 1,086 369 851 932 1,039 998 1,016 Dep and amort 289 317 353 339 345 Source: Created by author bosed on author estimates. Case 46 Ferrari: The 2015 Initial Public Offering EXHIBIT 46.4I Ferrari Balance Sheet (millions of euro) 30-Jun-2015 31-Dec-2014 31-Dec-2013 258 1,077 798 Cash and cash equivalents 154 184 206 Trade receivables 1,181 1,224 863 Receivables from financing activities 352 296 238 Inventories 100 64 115 Other current assets 2,045 2,845 2,219 Total current assets 48 47 37 Investments and other financial assets 149 112 42 Deferred tax assets 589 585 568 Property, plant, and equipment 283 265 242 Intangible assets" 787 787 787 Goodwill 3,900 4,641 3,895 Total assets 578 536 486 Trade payables 182 110 104 Current tax payables 836 774 475 Other current liabilities 1,595 1,420 1,065 Total current liabilities 2,267 510 317 Long-term debt 239 197 233 Other liabilities -201 2,478 2,316 Total equity 3,900 4,641 3,895 Total liabilities and equity Source: Company prospectus. Costs incurred for car project development are recognized as asset following the conditions of IAS38. Capitalized development costs are amortized on a straight-line basis over the estimated life of the model (generally four to eight years). | FCA Car Shipments by Brand (thousands of units) EXHIBIT 46.5 2013 2014 Mass-market vehicle brands 2,500 2,100 NAFTA (U.S., Canada, Mexico) 800 90 LATAM 0 atim t Valuing the Enterprise: Acquisitions and Buyouts Ferrari Income Statement (millions of euro) EXHIBIT 46.3I First Half 2015 2014 2013 2012 Sales 1,007 1,944 1,655 1,695 Cars and spare parts 121 188 311 77 Engines 212 417 412 Sponsorship, commercial and brand" Other 385 46 91 80 69 1,387 2,762 2,335 2,225 Total sales 592 1,217 964 961 Cost of sales excluding dep and amort 130 289 270 238 Depreciation and amortization expense 152 300 260 243 Selling, general, and admin. expense 291 541 479 431 Research and development. 4 26 -2 17 Other operating expense 218 389 364 335 Operating income (EBIT) Net financial income (Expense) -27 -1 191 398 366 335 Profit before tax 65 133 120 101 Income tax expense 126 265 246 233 Net profit 151 271 330 258 Capital expenditures Source: Company prospectus. Includes the net revenues generated from shipments of our cars, including any personalization revenue generated on these cars and sales of spare parts. 2Includes the net revenues generated from the sale of engines to Maserati for use in their cars, and the revenues generated from the rental of engines to other Formula 1 racing teams includes the net revenues earned by our Formula 1 racing team through sponsorship agreements and our share of the Formula 1 World Championship commercial revenues and net revenues generated through the Ferrarl brand, including merchandising, licensing and royalty income. 4Primarily includes interest income generated by the Ferrari Financial Services group and net revenues from the management of the Mugello racetrack