Question
In this report, you will discuss factors that may affect current and future performance of the Walt Disney Co. Based on what you know about
In this report, you will discuss factors that may affect current and future performance of the Walt Disney Co. Based on what you know about the organization?s financial health and performance, you will then forecastfuture performanceof the company for each of the next three years.
Prompt: After having evaluated the Walt Disneyco.financialhealth, you should research and assess the company?s strategic priorities and behavior. You should investigate internal risks and non-monetary factors that may affect current and future performance and decisions. To justify your findings and projections, you will need to produce accurate and relevant data tables, explaining how the numbers were informed by existing information and modeling different scenarios.
IV. Success Factors and Risks. Use this section to discuss the factors that may affect current and future performance. Specifically:
How do the organization?s financial and strategic priorities affect accounting procedures and business decisions? How might that affect business ?success? For example, is management growth-oriented or efficiency-oriented? What is the organization?s approach to risk and short- versus ?long-term planning horizons? ?
Project the organization?s likely consolidated financial performance for each of the next three years. Support your analysis with an appendix spreadsheet showing actual results for the most recent year, along with your projections and assumptions. Remember, your supervisor is interested in fresh perspectives, so you should not just replicate existing financial statements, but should add other relevant calculations or disaggregations to help inform decisions. ?
Modify your projections for the coming year to show a best- and worst-case scenario, based on the potential success factors and risks you identified. As with your initial projections, support your analysis with an appendix spreadsheet, specifying your assumptions and including relevant calculations and disaggregations beyond those in existing financial reports. ?
Discuss how your assumptions, forecasting methodology, and information gaps affect your projections. Why are your projections appropriate? For example, are they consistent with the organization?s mission and priorities? Aggressive but achievable? How would changing your assumptions change your projections? ?
2-4 pages, APA style
The file "Home Depot Projection Template(1).xlsx " is "Projections" example.
1.) Prior year's revenue growth averaged 6% - assumed same for projection 2.) Assumed no changes in equity other than Retained Earnings 3.) COGS as % of Revenue same as prior year 2015 4.) For the Period Ending Total Revenue As a % of Total 2/1/2015 Revenue $ 83,176,000 100% Cost of Revenue Gross Profit OPERATING EXPENSES SG&A 54,787,000 28,389,000 66% 34% 16,280,000 20% Other Operating Operating Income 1,640,000 10,469,000 2% 13% Add'l income/expense items EBIT 337,000 10,806,000 0% 13% Interest Expense EBT 830,000 9,976,000 1% 12% Income Tax Net Income Applicable to Common Shareholders 3,631,000 6,345,000 4% 8% http://www.nasdaq.com/symbol/hd/financials?query=income-statement Projected Yr 1 6% Rev Growth $ 88,519,002 58,306,369 30,212,633 17,325,783 1,745,349 11,141,500 358,648 11,500,148 883,317 10,616,831 3,864,246 6,752,586 For the Period Ended CURRENT ASSETS Cash & Cash Equivalents Net Receivables inventory Other Current Assets Total Current Assets LONG-TERM ASSETS Fixed Assets Goodwill Other Assets Total Assets CURRENT LIABILITIES Accounts Payable 2/1/2016 % of Total $1,723,000 1,484,000 11,079,000 1,016,000 15,302,000 11.26% 9.70% 72.40% 6.64% 22,720,000 1,353,000 571,000 39,946,000 92.19% 5.49% 2.32% $9,473,000 84.06% 328,000 2.91% Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities 1,468,000 11,269,000 16,869,000 1,844,000 13.03% Deferred Liability Charges Total Liabilities EQUITY Common Stock Capital Surplus Retained Earnings Treasury Stock 642,000 30,624,000 3.32% ST Debt / Current Portion of LT Debt Other Equity Total Equity TOTAL LIABILITIES & EQUITY Balance Check $ % of Revenue % Change Prior Year 18.40% 87.16% 9.53% 88,000 8,885,000 26,995,000 (26,194,000) (452,000) 9,322,000 39,946,000 - http://www.nasdaq.com/symbol/hd/financials?query=balance-sheet 8.00% YR 1 Projection (Using % Change YR 1 Projection (Using CA as % of Prior Year) Revenue) 2016 1,860,840 1,833,681 Allocated total CA according to corresponding % of total C 1,602,720 1,579,328 11,965,320 11,790,685 1,097,280 1,081,265 16,526,160 16,284,959 16,284,959 - $ 88,000 8,885,000 *Notes: Also known as Additional Paid In Capital, these ar 33,747,586 **Remember - this is the accumulation of Net Incom (26,194,000) (452,000) 16,074,586 16,074,586 210,373 rresponding % of total CA for each row Paid In Capital, these are the $ above par value collected at the time of equity offering cumulation of Net Income/Loss from the Income Statement for all years in business In this report, you will discuss factors that may affect current and future performance of the Walt Disney Co. Based on what you know about the organization's financial health and performance, you will then forecast future performance of the company for each of the next three years. Prompt: After having evaluated the Walt Disney co. financial health, you should research and assess the company's strategic priorities and behavior. You should investigate internal risks and nonmonetary factors that may affect current and future performance and decisions. To justify your findings and projections, you will need to produce accurate and relevant data tables, explaining how the numbers were informed by existing information and modeling different scenarios. IV. Success Factors and Risks. Use this section to discuss the factors that may affect current and future performance. Specifically: A. How do the organization's financial and strategic priorities affect accounting procedures and business decisions? How might that affect business success? For example, is management growthoriented or efficiencyoriented? What is the organization's approach to risk and short versus longterm planning horizons? B. How might the organization better capitalize on nonfinancial factors such as market share, reputation, human resources, physical facilities, or patents? Support your response with relevant research and analysis. C. What are the most significant internal risks to the company's financial performance? Give evidence to support your response. For example, is the company vulnerable to technological changes or cyberattacks? Loss of hightalent personnel? Production disruptions? V Projections. Based on what you know about the organization's financial health and performance, forecast its future performance. In particular, you should: A. Project the organization's likely consolidated financial performance for each of the next three years. Support your analysis with an appendix spreadsheet showing actual results for the most recent year, along with your projections and assumptions. Remember, your supervisor is interested in fresh perspectives, so you should not just replicate existing financial statements, but should add other relevant calculations or disaggregations to help inform decisions. B. Modify your projections for the coming year to show a best and worstcase scenario, based on the potential success factors and risks you identified. As with your initial projections, support your analysis with an appendix spreadsheet, specifying your assumptions and including relevant calculations and disaggregations beyond those in existing financial reports. C. Discuss how your assumptions, forecasting methodology, and information gaps affect your projections. Why are your projections appropriate? For example, are they consistent with the organization's mission and priorities? Aggressive but achievable? How would changing your assumptions change your projectionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started