presentation report格式 case study Summary范文 PEST分析法 literature review Research Proposal Reference格式

Disney Case Study-资本预算案:巴西利亚迪斯尼主题公园

论文价格: 免费 时间:2019-09-06 10:47:30 来源:www.ukassignment.org 作者:留学作业网
Paulus Bon博士
Capital Budgeting CASE
Walt Disney Theme Park Brasilia
Week 2-2018 FINC 5880
Dr. Paulus Bon
In the news…
Read the Case carefully
Ask questions if anything is unclear:
The feasibility study by McKinsey is a sunk cost it is rather $500 M USD than $500K USD
The sunk cost will be depreciated 10 years SL with no salvage value…
Note there are 2 investments ( $3 B USD and $1.5 B USD)and 3 Revenue generators…(Magic Kingdom, Epcot and the Resorts)
The 2 investments are depreciated with MACRS…
For the Revenues of year 1-10 specific growth rates are provided after year 10 a flat perpetual growth rate…
What if analysis needs to be performed on total revenues assuming a margin of -15% to +15% however the +15% is more for MKT purposes
Expenses…WC and…
Due to considerable uncertainty the expenses need to be considered in a what if as well…
The MACRS % depreciation and the maintenance CAPEX are provided for each year t=0 to t=10
The non cash WC is calculated depending on Revenues (5%) in the base case
WC is uncertain and significant and thus a what if analysis is also provided for this part of the future cash flows
Detailed assumptions for the calculation of the WACC% that you will need to use for discount factor is given
How to Start?
You will do this in EXCEL (spreadsheet)
You will provide NOPAT (Revenues – Expenses) excluding Sunk Costs
You will provide capital invested (including Sunk Costs)…to make sure that your depreciation $ is correct
You will provide calculation of the non cash WC and the CHANGE in WC yearly…
You will provide maintenance Capex y.o.y and thus free cash flow in t=0 to t=10
You will discount future cash flows at the WACC%
After year t=10 you will calculate a Terminal Value using a perpetual growth rate of 2%
You will provide 3 what if scenarios
Revenues +/- 15%
Expenses % of revenues
Non cash WC % of revenues
The scenarios are calculated one by one THUS if Revenues are assumed -15% the Expenses and non cash WC stay unchanged (as calculated in the base case)
This rule will also be followed if the % Expenses or non cash WC is changed (the other 2 stay the same as in the base case)
After this you can start to combine to see what happens to NPV and IRR% if BOTH revenues and expenses are different from the base case, BOTH expenses and WC % are different or both Revenues and % WC are different 
The worst case would of course be if all 3 are unfavorable in comparison to the base case but you will need to consider that the chance for this to happen may be small? 
It all starts with a clear forecast of future sales revenues…and direct expenses based on provided %
Next is Depreciation…
The Sunk costs are depreciated over 10 years straight line… ($ 50 M each year)
The investments follow MACRS (the table is provided in the case take this % of the starting value of the investments and get:
Here is help if you could not get the depreciation amount…
SG&A as % of revenues…and you can calculate NOPAT…
FCF=NOPAT + DEP+/- change in WC –maintenance capex…
You have got NOPAT and Depreciation already
The non cash WC is a % of sales and the annual change can be calculated easily
Maintenance capex is a % of the depreciation and so this is easy to generate…
Note that SG&A is partly fixed 
If you are still unclear about the WACC%...
Now the WORST CASE scenarios:
Lower the Revenues with 15% … what is the NPV and IRR% after that? (CP=consider all other to be unchanged) call this scenario 1
Now higher the direct expenses as given in the case…what is the NPV and IRR% after that? (CP) scenario 2
Now change the non cash WC % as indicated in the case…what is the NPV and IRR% % after that? (CP) scenario 3
After this combine lower revenues and higher expenses…what is the NPV and IRR% after you change both ?(CP) combi-scenario 1
After this combine higher WC and higher expenses ….what is the NPV and IRR% after you change these? (CP) combi-scenario 2
Then lower revenues and higher WC …. combi-scenario 3
Then lower revenues, higher expenses and higher WC… final scenario
After you calculated NPV $ and IRR% for all these scenarios…provide an overview
Estimated Likelihoods: Risk Paragraph 10K -2017
Check the Risk Management Paragraph in the last 10K of Walt Disney 2017
The company mentions several risks that they can “control” and “not control”
Consider the uncontrollable risks and their likelihood to come up with a likelihood in the scenario table…
Add the statements to your final report and comment on them so that the BoD can understand your assumed likelihoods…
The final part…edit your report!
Review your data and results
Form an opinion about what to recommend to the BoD…
Based on your estimated likelihood of each scenario come to a final conclusion
Think about “exit-strategies” if this project goes SOUTH…
What is your contingency-plan?
How will you manage risks that can be managed?
1. Review your data and results查看您的数据和结果
The detail of the result is present in the Excel Sheet.
The Base Case, Worst Cases 1, 2, 3; Worst Cases Combination 1, 2 and 3. Each of the Scenario has its likelihood, meaning the probability of occurrence.  
The details of the result calculated in each case would be referred to in the Excel sheet. 
2. Form an opinion about what to recommend to the BoD对向董事会推荐什么形成意见
The NPV of the project is negative, and the IRR% is negative for the Base Case and also for the various Worst Cases.
3. Based on your estimated likelihood of each scenario come to a final conclusion根据你对每个场景的估计,得出最终结论
Please refer to the table above for the Final Conclusion, the NPV = -$2173 million and the IRR = -8.78% overall.
4. Think about “exit-strategies” if this project goes SOUTH
(1) To sell the Theme Park business segments of Disney to other companies. The disposals of such business with less profit making would increase the total revenue of the Group.
(2) To separate out the Theme Park business segments of Disney and make it IPO
(3) To replace the current CEO with a better candidate who would run more the company more efficiently and profitably.#p#分页标题#e#
5. What is your contingency-plan?
Having enough insurance covered for the properties, i.e. the theme park, and other entertainment properties and also covered for the employees in the company.
6. How will you manage risks that can be managed?
(1) FX CurrencyRisk Management
To use currency risk instruments like the FX swap or FX forward derivatives between the USD and the Brazilian Real BRL currency pair to mitigate the risk. 
(2) Operational Risk Management
As Disney, being such a big organization with different and diversified business segments individually, risk can be identified, defined and quantified at each individual Business Unit. 
Risk Management strategies and policies can be developed and implemented with the leaders of different business units and being reported to the Management and Board of Directors for review and approval.
(3) Concentration Risk Management
As Disney has a large presence in the United States and the business is running in the single concentrated markets, there is possibility of concentrated business models. As such, concentrated risk management could be mitigated by having more business presence all over the world in different regions. 


  • 案例分析case study...


  • Case Study ana...


  • PEST分析案例样本


  • 斯巴达赌场衍生品案例


  • Case Study怎么写?...

    学习商科,CS和医化学科的同学们应该对Case Study,即案例研究,并不陌生。Case Study是一种研究方法(Research Method)。一篇有深......

  • Case study:丰田营...