雷恩一大 會員中心 TAG標簽
網站地圖 RSS
PEST分析法 literature review Research Proposal 參考文獻格式case study presentation report格式 Summary范文
雷恩一大
當前位置: 雷恩一大 > 論文格式 > case study >

雷恩vs布雷斯特:Disney Case Study-資本預算案:巴西利亞迪斯尼主題公園

時間:2019-09-06 10:47來源:未知 作者:anne 點擊:
資本預算案:巴西利亞迪斯尼主題公園 Paulus Bon博士 在新聞里 仔細閱讀這個箱子 如果有什么不清楚的地方,可以提問: 麥肯錫的可行性研究是一項沉沒成本,與其說是5億美元,不如說是5億美元
資本預算案:巴西利亞迪斯尼主題公園
 
Paulus Bon博士
在新聞里…
仔細閱讀這個箱子
如果有什么不清楚的地方,可以提問:
麥肯錫的可行性研究是一項沉沒成本,與其說是5億美元,不如說是5億美元
沉沒成本將折舊10年,無殘值…
注:共有2項投資(30億美元和15億美元)和3個創收機構……(魔幻王國、愛普科特和度假村)
這兩項投資用macrs折舊…
對于第1-10年的收入,在第10年之后提供固定的永久增長率…
如果需要對總收入進行分析,假設利潤率在-15%到+15%之間,但是+15%更適合市場
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查看您的數據和結果
結果的詳細信息顯示在excel工作表中。
The detail of the result is present in the Excel Sheet.
基本情況,最壞情況1,2,3;最壞情況組合1,2和3。每個場景都有其可能性,也就是說發生的可能性。
在每種情況下計算結果的細節將在excel表中提及。
 
2。對向董事會推薦什么形成意見
項目的凈現值為負,基本情況和各種最壞情況的內部收益率均為負。
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根據你對每個場景的估計,得出最終結論
最終結論見上表,凈現值為-21.73億美元,內部收益率為-8.78%。
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.


推薦內容
  • 英國作業
  • 新西蘭作業
  • 愛爾蘭作業
  • 美國作業
  • 加拿大作業
  • 代寫英國essay
  • 代寫澳洲essay
  • 代寫美國essay
  • 代寫加拿大essay
  • MBA Essay
  • Essay格式范文
  • 澳洲代寫assignment
  • 代寫英國assignment
  • 新西蘭代寫assignment
  • Assignment格式
  • 如何寫assignment
  • 代寫英國termpaper
  • 代寫澳洲termpaper
  • 英國coursework代寫
  • PEST分析法
  • literature review
  • Research Proposal
  • 參考文獻格式
  • case study
  • presentation
  • report格式
  • Summary范文
  • common application
  • Personal Statement
  • Motivation Letter
  • Application Letter
  • recommendation letter