| Exhibit 8 | ||||||||
| FERRARI: THE 2015 INITIAL PUBLIC OFFERING | ||||||||
| Ferrari Forecast (Millions of Euro, except as noted) | ||||||||
| Assumptions | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | ||
| Growth in Cars Shipped | 3.6% | 7.0% | 5.0% | 4.0% | 4.0% | 3.0% | ||
| Growth in Revenue/Car | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | |||
| Growth in Engine Revenue | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
| Growth in Other Revenue | 3.0% | 6.0% | 6.0% | 6.0% | 6.0% | |||
| Operating Margin - Cars | 12.5% | 13.0% | 13.5% | 14.0% | 14.0% | 14.0% | ||
| Operating Margin - Engines | 9.1% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | ||
| Operating Margin - All Other Revenue | 24.9% | 25.0% | 27.0% | 28.0% | 30.0% | 30.0% | ||
| Net Working Capital Turnover | 1.9 | 2.0 | 2.1 | 2.2 | 2.2 | 2.2 | ||
| Net Fixed Asset Turnover | 3.2 | 3.2 | 3.3 | 3.5 | 3.7 | 3.8 | ||
| Deprec. & Amort./PP&E | 34% | 34% | 34% | 34% | 34% | 34% | ||
| Financial Forecast | ||||||||
| Car Shipments (000s) | 7.26 | 7.76 | 8.15 | 8.48 | 8.82 | 9.08 | ||
| Avg Revenue per Car (Euro 000s) | 268 | 281 | 295 | 310 | 326 | 342 | ||
| Car Revenue | 1,944 | 2,184 | 2,408 | 2,629 | 2,871 | 3,105 | ||
| Engine Revenue | 311 | 320 | 330 | 340 | 350 | 361 | ||
| All Other Revenue | 507 | 523 | 554 | 587 | 623 | 660 | ||
| Total Revenue | 2,762 | 3,027 | 3,292 | 3,556 | 3,844 | 4,126 | ||
| Operating Profit - Cars | 243 | 284 | 325 | 368 | 402 | 435 | ||
| Operating Profit - Engines | 28 | 32 | 33 | 34 | 35 | 36 | ||
| Operating Profit - All Other Revenue | 126 | 131 | 150 | 164 | 187 | 198 | ||
| Total Operating Profit | 398 | 447 | 508 | 567 | 624 | 669 | ||
| Net Working Capital | 1,425 | 1,513 | 1,568 | 1,617 | 1,747 | 1,875 | ||
| Net PP&E and Int. Assets | 851 | 932 | 998 | 1,016 | 1,039 | 1,086 | ||
| Deprec. & Amort. | 289 | 317 | 339 | 345 | 353 | 369 | ||
| Total Revenue Growth | 18% | 10% | 9% | 8% | 8% | 7% | ||
| EBITDA Margin | 25% | 25% | 26% | 26% | 25% | 25% | ||
Although the financial forecast seems to be prudent and on the conservative side, I have my reservation on the fact that it is shown there is a sales growth and and an expansion in the operating margin at the same time. Usually revenue growth is accomplished by increase in marketing expense, expense in new product development etc which tends to impact operating margins.
Also revenue growth shown above is not correct. For example for year 2 revenue growth is 3027/2762 -1 = 9.5% and not 18% as shown
Do you agree with the financial forecast in Exhibit 8? If so, why? If not, what...
Must know the Ferrari 2015
case
Do you agree with the financial forecast in Exhibit 8? If so,
why? If not, what specific concerns do you have?
Exhibit 8 Ferrari: The 2015 Initial Public Offering Ferrari Forecast (millions of euro, except as noted) Assumptions Growth in Cars Shipped 2017 2014 2015 2016 2018 2019 7.0% 3.6% 5.0% 4.0% 3.0% 4.0% Growth in Revemue/Car 5.0% 5.0% 5.0% 5.0% 5.0% Growth in Engine Revenue 3.0% 3.0% 3.0% 3.0% 3.0% Growth in Other...
Perform a DCF valuation of Mary Washington Pediatrics using the
projections in Exhibit 3. Feel free to use the attached spreadsheet
for your calculations. Be sure to show the Free Cash Flow, Terminal
Value and discounting calculations. Use the 9% rate in the case for
WACC. Decide whether to use traditional discounting or the mid-year
convention. Please show all work in Excel.
Exhibit 3 Mary Washington Pediatrics Atwood's Financial Forecast for Mary Washington Pediatrics (financial figures in thousands of US...
Instructions:
Complete the 2006 forecast using the assumptions below. If a
line does not have an explicit assumption, you should be able to
figure it out through logic (using the structure of the financial
statements and/or some simple math). Your forecast
should result in entries in all the green-shaded cells below.
The firm does not pay any dividends, so all net income will flow
to Net Worth on the Balance Sheet.
We will plug the cash account on the balance sheet...
please
see the problem and set it in the excel. please provide the formula
in every cell in the excel so i understand how it is done.
thank you very much.
the last pic is what i did so far. so please refer to the
problem and complete it with all formulas provided for me( for
every cell)
thank you!
2. Medina werks, a manufacturing company headquartered in Canada, has a competitive advantage that will probably deteriorate over time. analyst...
According to Case 06 Exhibit 6.1, what is Company P Operating
Margin? Enter percentage, round to 2 decimal places.
Retail Airlines A B Beer C D Computers E F Hospitality G H Newspaper I J Pharmaceuticals K L Power M N Assets % O P 72 25 35 5 25 8 30 103 2 16 25 Cash & ST Investments Receivables Inventory Current Assets-Other Current Assets-Total Net Property. Plant, & Equipment Long-Term Marketable Securities Goodwill & Intangibles Assets-Other Assets-Total 6...
What evidence of underperformance do you see in your analysis of the financial statements for Bob’s and is this suggestive that the management team is doing poorly? 2016 2017 2018 2019 2020 Revenue 191 186 210 248 272 Cost of Goods Sold 137 136 157 189 212 Gross Profit 54 50 53 59 60 Selling and General Expenses 19 29 38 48 47 Operating Profit 35 21 15 12 13 Net Interest Expense 1 0 7 6...
a. Suppose Sora's revenue and free cash flow are expected to
grow at a 5.9% rate beyond year four. If Sora's weighted average
cost of capital is 14.0%, what is the value of Sora stock based on
this information?
b. Sora's cost of goods sold was assumed to be 67% of sales.
If its cost of goods sold is actually 70% of sales, how would the
estimate of the stock's value change?
c. Return to the assumptions of part
(a)...
Why are Fossil Inc. and Gap Inc.'s 2016 and 2017 current and quick ratios based on the latest available financial statements? What can you say about the companies' liquidity position in 2016, 2017? English (Us Period Ending: Trend 2r3/2018 1/28/2017 1/30/2016 GAP Inc Liquidity Ratios 186% 104% 72% 15796 83% 54% 196% 176% 101% 73% Current Ratio | 98% Quick Ratio Cash Ratio Profitability Ratios Gross Margin Operating Margin Pre-Tax Margin Profit Margin Pre-Tax ROE After Tax ROE i 63%...
Thank you so much! Please help me solve the problem b, c,
d.
Sora Industries has 67 million outstanding shares, $127 million in debt, $47 million in cash, and the following projected free cash flow for the next four years : a. Suppose Sora's revenue and free cash flow are expected to grow at a 4.9% rate beyond year 4. If Sora's weighted average cost of capital is 120%, what is the value of Sora's stock based on this information?...
I need to match these ten industries using Exhibit 3: For
example, Electrical Utility is #8 and Retail Grocery is #7. Please
help! Thanks. I have 7 confirmed these are:
Each of the 10 publicly traded companies in Exhibit 3 is drawn
from one of the following industries (listed below in random
order):
I have 7 confirmed these are:
1. Management consulting services
2.
3. Data processing and camera
applications services
4. Electronic, aerospace, communication, sensor
systems
5. Hospital and...