Directions Forecast & Analysis Assignment
Starbucks Corporation
Forecast & Analysis Assignment 1
FINC 430 6380 Financial Management
University of Maryland University College
Jeffrey Peyton
January 17, 2017
Introduction
Starbucks Corporation, who trades its common stock as “SBUX” on the NASDAQ, is “the premier roaster, marketer and retailer of specialty coffee in the world” (Starbucks, 2016). The company is comprised of seven brands, which include: Starbucks Coffee, Teavana, Tazo, Seattle’s Best Coffee, Evolution Fresh, La Boulange and Ethos (Starbucks, 2016). Starbucks operates both company-owned, and licensed stores, and also operates a sizeable business by selling its products through third-party accounts. The company has five segments of business in which it operates 23,043 stores in 68 different countries, and in fiscal year 2015 those segments represented the following, as a percentage of total revenues: Americas (69%), China/Asia Pacific (13%), Europe, Middle East and Africa (6%), Channel Development (9%), and all other segments (3%) (Starbucks, 2016).
McDonalds and Dunkin Donuts, two of Starbucks’ main competitors, have not seen the same positive growth across their key performance indicators in recent years. “Not surprisingly, investors have caught onto the fact that McDonald’s and Dunkin’ may be hurting one another – and not Starbucks – as evidenced by recent moves in Starbucks, Dunkin’, and McDonald’s shares” (Lim, 2014). However, some challenges that Starbucks faces in the near future are the rising price of coffee beans, higher wage payments and the continuing increase in the price of its products (Team, 2016). With these challenges, it will be necessary for Starbucks to be strategic in its future business decisions to protect the historical positive trending sales growth. The following paper will analyze the outcome of an eVal financial forecast completed on Starbucks, and will detail future growth rates, projected financial statements, financial ratios and other assumptions.
Explanation of Growth Rates
Starbucks has seen positive year-over-year sales growth of 12 %, 10.6%, 16.5% in 2013, 2014, and 2015 respectively, and eVal forecasts that the company will continue to see positive growth into 2026. The terminal growth rate forecasted for Starbucks by eVal is 3%, which is a solid financial outlook for the company. In the short-term, the company should continue the process of “leveraging its consumer loyalty and lack of elasticity among its consumers by continuously passing on increases in costs…to its customers” (Team, 2016). By continuously raising the price of its products, the company can protect its operating margins, and not sacrifice the quality of its product and/or locations. When the price of products becomes too high for the consumer, Starbucks can move to maximize the atmosphere, and offer an experience even better than previously offered, to offset the price of the product with an experience.
The eVal forecasts sales growth in 2016 to have an increase of 15.3% compared to a forecasted increase of only 4.2% in 2025. The next 10 years are forecasted to be positive, but not as positive as the previous, leading to a plateau in business. According to a recent financial press release, Starbucks plans to “add 12,000 stores globally –to a total of 37,000 – by 2021” (Starbucks, 2016). The expansion of stores internationally is the biggest opportunity to for the company. With the planned expansion, Starbucks will gain forecasted net sales of more than $29 billion from 2015 to 2025 according to the eVal.
Explanation of All Other Assumptions
Table 1: eVal Assumptions for Financial Forecast Using eVal
As mentioned previously, sales growth is forecasted by eVal to continue to remain positive into 2025, but slowly decrease in its velocity from 16.5% to 3% in 2015 and 2025 respectively. The eVal assumes all other indicators above, referenced in table 1, to remain constant into the future. Cost of goods sold are forecasted at 68.7% constantly over the next 10 years, showing investors that Starbucks will be able to maintain healthy relationships with its suppliers, and that buyers and negotiators will be able to maintain stability as it relates to costs. In addition, the ending operating cash/sales ratio remains forecasted at a constant 8.4%, informing investors that Starbucks will continue to turn the sales it earns into cash to use for business. Shareholders should also notate the constant 36.9% dividend payout ratio forecasted, as this informs them to expect a continuous growth of their investment. This high pay-out ratio will most likely hold true based on the recent announcement of its intent to open 12,000 stores globally (Starbucks, 2016). It should also be noted that the eVal forecast did not take into account this announcement, and the financing assumptions will most likely change. With the planned expansion of stores, Starbucks will most likely incur increases in its long-term debt as a result of additional leases. According to Starbucks’ Form 10k, the company currently has about “12,235 company-operated stores, almost all of which are leased” (Starbucks, 2016).
Explanation and Interpretation of Projected Financial Statements
Net sales of Starbucks were $19 billion in 2015, and are forecasted by eVal to reach $48 billion by 2025, more than double its current sales. This large increase in sales will most likely occur as a result of the company’s expanded footprint globally, and over the past 5 years, the company has seen similar growth, increasing net sales from $11 billion in 2011 to $19 billion in 2015. Net income aligns with net sales, forecasted at a continuous positive increase. The company also is forecasted to continue with a healthy 20% EBITDA. The non-operating income forecasted may be offset by a large litigation charge of $2,784 million to Kraft that posted to the company’s income statement in 2013 (Starbucks, 2016). In developing a strategy for the future, Starbucks should limit its partnerships with third-party companies on large scale agreements to diversify its financial risk.
On the historical balance sheet of Starbucks, the company maintained operating cash of $2 billion in 2011, yet is only forecasted for $1.8 billion in 2016. The company is forecasted to eventually reach its 2011 operating cash flow in 2017, with $2.1 billion, and continue on its positive trend. Other current liabilities also were also affected by the Kraft litigation payment, and may have skewed the forecast. When the 2013 other current liabilities were adjusted to reflect no litigation payment, the eVal forecast was not affected.
Explanation and Interpretation of Overall Forecast Results & Financial Ratio
Starbucks’ positive sales performance has a trickle effect on the financial ratios forecasted using eVal. As it relates to annual growth rates, sales, assets and common equity continue into 2025 positively trending, although slightly decrease year-over-year. In 2016, a 15.3% sales, asset and common equity growth is forecasted compared with a 4.2% growth in 2025. Earnings are about (0.1)% off of sales every year. Free cash flow to investors is forecasted as a huge spike in 2016, to 153.2% and then decreases to 19% the following year in 2017. This is most likely a skewed forecast due to the $2.8 billion arbitration payment made to Kraft Foods in 2014, as a result of breach of contract (Starbucks, 2016). Starbucks should invest heavily in its legal and risk departments to avoid future legal proceedings that may result in similar negative financial consequences.
As it relates to profitability, the eVal forecasts that Starbucks will remain consistent with its return on equity at 0.497 in 2015, and forecasted at 0.470 in 2025. The company is doing well with generating profits from shareholder’s equity, and in order to continue this trend, the executive leadership team should continue their growth strategy of expanding the company’s footprint of stores internationally. From 2015 to 2025, the gross margin, EBITDA margin and net operating margin are all forecasted at a constant. This forecast will likely be true for Starbucks if coffee bean prices align with top line sales. One of the challenges faced by Starbucks is the rising price of coffee beans, which can be attributed to weather conditions in the countries where it does business. “The primary contributor towards the rise in prices of coffee beans is the drought in Brazil and Vietnam, the largest producers of coffee beans” (Team, 2016). In order to maintain the constant healthy margins, Starbucks should seek out alternate, back-up locations for similar quality beans.
Short-term liquidity is an important aspect of any organization, as one needs to be able to pay its debts quickly in order to continue doing business. The current ratio of Starbucks increased from 2013 to 2015 from 1.017 to 1.191 respectively. The eVal forecasts that the current ratio will continue to remain at 1.91 until 2025. The quick ratio seen a slight decrease from 2013 to 2015 from 0.706 to 0.638 respectively. According to the eVal forecast, the quick ratio is also to remain constant through 2025. The consistency in the positive leverage that Starbucks is forecasted at, allows the company to continue its current daily operation while being able to protect itself from any financial need that should arise without notice, such as the Kraft arbitration.
From a profitability standpoint, Starbucks hits all the marks, showing effective maximization of assets, equity and investments. Management should take notice of the company’s liquidity, as the company has become less liquid over the past five years. Starbucks has increased its long-term debt but reduced its overall debt, and indicates to investors that it can pay its interest payments on time. Starbucks may have found its most effective asset management strategies as asset management ratios have maintained relatively neutral over the past five years. Historically Starbucks has had stellar financial performance, and is forecasted to continue the trend. With the expansion of its stores globally, the company is likely to see record sales and growth over the next 10 years.
Appendix
Appendix A – Income Statement Assumptions eVal
Appendix B – Balance Sheet Assumptions eVal
Appendix C – Financing Assumptions eVal
Appendix D – Short-Term Liquidity eVal
Appendix E – Financial Ratios eVal
Lim, P. (2014). Dunkin’, Mickey D’s, or Starbucks? The surprising winner of the coffee war.
Time. Retrieved online from: http://time.com/money/3028578/dunkin-donuts-mcdonalds-starbucks-coffee-wars/.
Starbucks. (2016). Starbucks presents its five-year plan for strong global growth fueled by a
Robust pipeline of innovation at biennial investor conference. Starbucks Investor Relations. Retrieved online from: http://investor.starbucks.com/press-releases/financial-release/2016/Starbucks-Presents-Its-Five-Year-Plan-for-Strong-Global-Growth-Fueled-by-a-Robust-Pipeline-of-Innovation-at-Biennial-Investor-Conference/default.aspx.
Starbucks. (2016). Starbucks fiscal 2015 form 10-k. Retrieved online from:
http://investor.starbucks.com/phoenix.zhtml?c=99518&p=irol-reportsAnnual.
Starbucks. (2016). Starbucks fiscal 2015 form 10-k. Retrieved online from:
http://investor.starbucks.com/phoenix.zhtml?c=99518&p=irol-reportsAnnual.
Team, T. (2016). Starbucks’ challenges and how it can overcome them. Forbes. Retrieved
online from: http://www.forbes.com/sites/greatspeculations/2016/12/05/starbucks-challenges-and-how-it-can-overcome-them/#4165625f71ed.
Table 1
eVal Assumptions for Financial Forecast Using eVal
Company Name Starbucks Corporation
Current Year Forecast Explanation of Assumptions Income Statement Assumptions Sales Growth 16.5% 3.0% Decreases year-over-year but still remains Cost of Goods Sold/Sales 68.7% 68.7% Remains Constant R&D/Sales 0.0% 0.0% Remains Constant SG&A/Sales 8.9% 8.9% Remains Constant Dep&Amort/Avge PP&E and Intang. 17.2% 17.2% Remains Constant Net Interest Expense/Avge Net Debt 3.2% 3.2% Remains Constant Non-Operating Income/Sales 3.2% 3.2% Remains Constant Effective Tax Rate 29.3% 29.3% Remains Constant Minority Interest/After Tax Income 0.1% 0.1% Remains Constant Other Income/Sales 0.0% 0.0% Remains Constant Ext. Items & Disc. Ops./Sales 0.0% 0.0% Remains Constant Pref. Dividends/Avge Pref. Stock 0.0% 0.0% Remains Constant
Balance Sheet Assumptions Working Capital Assumptions Ending Operating Cash/Sales 8.4% 8.4% Remains Constant Ending Receivables/Sales 3.8% 3.8% Remains Constant Ending Inventories/COGS 9.9% 9.9% Remains Constant Ending Other Current Assets/Sales 3.7% 3.7% Remains Constant Ending Accounts Payable/COGS 5.2% 5.2% Remains Constant Ending Taxes Payable/Sales 1.4% 1.4% Remains Constant Ending Other Current Liabs/Sales 14.1% 14.1% Remains Constant Other Operating Asset Assumptions Ending Net PP&E/Sales 21.3% 21.3% Remains Constant Ending Investments/Sales 3.5% 3.5% Remains Constant Ending Intangibles/Sales 10.9% 10.9% Remains Constant Ending Other Assets/Sales 6.5% 6.5% Remains Constant Other Operating Liability Assumptions Other Liabilities/Sales 2.9% 2.9% Remains Constant Deferred Taxes/Sales 0.4% 0.4% Remains Constant Financing Assumptions Current Debt/Total Assets 0.0% 0.0% Remains Constant Long-Term Debt/Total Assets 18.9% 18.9% Remains Constant Minority Interest/Total Assets 0.0% 0.0% Remains Constant Preferred Stock/Total Assets 0.0% 0.0% Remains Constant Dividend Payout Ratio 36.9% 36.9% Remains Constant
Table 1
eVal Assumptions for
Financial Forecast Using eVal
Company NameStarbucks Corporation
Current YearForecast Explanation of Assumptions
Income Statement Assumptions
Sales Growth 16.5%3.0%
Decreases year-over-year but still remains
Cost of Goods Sold/Sales 68.7%68.7%
Remains Constant
R&D/Sales 0.0%0.0%
Remains Constant
SG&A/Sales 8.9%8.9%
Remains Constant
Dep&Amort/Avge PP&E and Intang.17.2%17.2%
Remains Constant
Net Interest Expense/Avge Net Debt3.2%3.2%
Remains Constant
Non-Operating Income/Sales 3.2%3.2%
Remains Constant
Effective Tax Rate 29.3%29.3%
Remains Constant
Minority Interest/After Tax Income 0.1%0.1%
Remains Constant
Other Income/Sales 0.0%0.0%
Remains Constant
Ext. Items & Disc. Ops./Sales 0.0%0.0%
Remains Constant
Pref. Dividends/Avge Pref. Stock 0.0%0.0%
Remains Constant
Balance Sheet Assumptions
Working Capital Assumptions
Ending Operating Cash/Sales 8.4%8.4%
Remains Constant
Ending Receivables/Sales 3.8%3.8%
Remains Constant
Ending Inventories/COGS 9.9%9.9%
Remains Constant
Ending Other Current Assets/Sales3.7%3.7%
Remains Constant
Ending Accounts Payable/COGS 5.2%5.2%
Remains Constant
Ending Taxes Payable/Sales 1.4%1.4%
Remains Constant
Ending Other Current Liabs/Sales14.1%14.1%
Remains Constant
Other Operating Asset Assumptions
Ending Net PP&E/Sales 21.3%21.3%
Remains Constant
Ending Investments/Sales 3.5%3.5%
Remains Constant
Ending Intangibles/Sales 10.9%10.9%
Remains Constant
Ending Other Assets/Sales 6.5%6.5%
Remains Constant
Other Operating Liability Assumptions
Other Liabilities/Sales 2.9%2.9%
Remains Constant
Deferred Taxes/Sales 0.4%0.4%
Remains Constant
Financing Assumptions
Current Debt/Total Assets 0.0%0.0%
Remains Constant
Long-Term Debt/Total Assets 18.9%18.9%
Remains Constant
Minority Interest/Total Assets 0.0%0.0%
Remains Constant
Preferred Stock/Total Assets 0.0%0.0%
Remains Constant
Dividend Payout Ratio 36.9%36.9%
Remains Constant
Estimated Price/Share=$47.48 Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast
Fiscal Year End Date 2011/10/02 2012/09/30 2013/09/29 2014/09/28 2015/09/27 2016/09/27 2017/09/27 2018/09/27 2019/09/27 2020/09/27
Implied Return on Equity 0.292 0.002 0.424 0.497 0.500 0.496 0.493 0.490 0.487
Income Statement Assumptions Sales Growth 13.5% 12.0% 10.6% 16.5% 15.3% 14.1% 12.8% 11.6% 10.4% Cost of Goods Sold/Sales 72.5% 73.1% 71.5% 69.7% 68.7% 68.7% 68.7% 68.7% 68.7% 68.7% R&D/Sales 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% SG&A/Sales 9.8% 9.1% 9.2% 8.8% 8.9% 8.9% 8.9% 8.9% 8.9% 8.9% Dep&Amort/Avge PP&E and Intang. 19.4% 17.4% 16.7% 17.2% 17.2% 17.2% 17.2% 17.2% 17.2% Net Interest Expense/Avge Net Debt 6.0% 1.9% 3.8% 3.2% 3.2% 3.2% 3.2% 3.2% 3.2% Non-Operating Income/Sales 2.6% 2.3% -16.3% 2.6% 3.2% 3.2% 3.2% 3.2% 3.2% 3.2% Effective Tax Rate 31.1% 32.8% 103.8% 34.6% 29.3% 29.3% 29.3% 29.3% 29.3% 29.3% Minority Interest/After Tax Income 0.2% 0.1% 5.7% 0.0% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% Other Income/Sales 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Ext. Items & Disc. Ops./Sales 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Pref. Dividends/Avge Pref. Stock 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
Estimated Price/Share=$47.48
ActualActualActualActualActualForecastForecastForecastForecastForecast
Fiscal Year End Date 2011/10/022012/09/302013/09/292014/09/282015/09/272016/09/272017/09/272018/09/272019/09/272020/09/27
Implied Return on Equity 0.2920.0020.4240.4970.5000.4960.4930.4900.487
Income Statement Assumptions
Sales Growth 13.5%12.0%10.6%16.5%15.3%14.1%12.8%11.6%10.4%
Cost of Goods Sold/Sales 72.5%73.1%71.5%69.7%68.7%68.7%68.7%68.7%68.7%68.7%
R&D/Sales 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
SG&A/Sales 9.8%9.1%9.2%8.8%8.9%8.9%8.9%8.9%8.9%8.9%
Dep&Amort/Avge PP&E and Intang. 19.4%17.4%16.7%17.2%17.2%17.2%17.2%17.2%17.2%
Net Interest Expense/Avge Net Debt 6.0%1.9%3.8%3.2%3.2%3.2%3.2%3.2%3.2%
Non-Operating Income/Sales 2.6%2.3%-16.3%2.6%3.2%3.2%3.2%3.2%3.2%3.2%
Effective Tax Rate 31.1%32.8%103.8%34.6%29.3%29.3%29.3%29.3%29.3%29.3%
Minority Interest/After Tax Income 0.2%0.1%5.7%0.0%0.1%0.1%0.1%0.1%0.1%0.1%
Other Income/Sales 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Ext. Items & Disc. Ops./Sales 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Pref. Dividends/Avge Pref. Stock 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Estimated Price/Share=$47.48 Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast
Fiscal Year End Date 2011/10/02 2012/09/30 2013/09/29 2014/09/28 2015/09/27 2016/09/27 2017/09/27 2018/09/27 2019/09/27 2020/09/27
Implied Return on Equity 0.292 0.002 0.424 0.497 0.500 0.496 0.493 0.490 0.487 Balance Sheet Assumptions Working Capital Assumptions Ending Operating Cash/Sales 17.5% 15.3% 21.8% 11.2% 8.4% 8.4% 8.4% 8.4% 8.4% 8.4% Ending Receivables/Sales 3.3% 3.7% 3.8% 3.8% 3.8% 3.8% 3.8% 3.8% 3.8% 3.8% Ending Inventories/COGS 11.4% 12.8% 10.4% 9.5% 9.9% 9.9% 9.9% 9.9% 9.9% 9.9% Ending Other Current Assets/Sales 3.3% 3.3% 3.8% 3.7% 3.7% 3.7% 3.7% 3.7% 3.7% 3.7% Ending Accounts Payable/COGS 6.4% 4.1% 4.6% 4.7% 5.2% 5.2% 5.2% 5.2% 5.2% 5.2% Ending Taxes Payable/Sales 0.9% 1.0% 0.8% 1.7% 1.4% 1.4% 1.4% 1.4% 1.4% 1.4% Ending Other Current Liabs/Sales 12.2% 12.6% 32.0% 13.6% 14.1% 14.1% 14.1% 14.1% 14.1% 14.1% Other Operating Asset Assumptions Ending Net PP&E/Sales 20.1% 20.0% 21.5% 21.4% 21.3% 21.3% 21.3% 21.3% 21.3% 21.3% Ending Investments/Sales 4.1% 4.3% 3.7% 5.1% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% Ending Intangibles/Sales 3.7% 4.1% 7.7% 6.9% 10.9% 10.9% 10.9% 10.9% 10.9% 10.9% Ending Other Assets/Sales 2.5% 1.8% 7.8% 6.7% 6.5% 6.5% 6.5% 6.5% 6.5% 6.5% Other Operating Liability Assumptions Other Liabilities/Sales 3.0% 2.5% 2.3% 2.3% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% Deferred Taxes/Sales 0.0% 0.1% 0.1% 0.0% 0.4% 0.4% 0.4% 0.4% 0.4% 0.4%
Estimated Price/Share=$47.48
ActualActualActualActualActualForecastForecastForecastForecastForecast
Fiscal Year End Date 2011/10/022012/09/302013/09/292014/09/282015/09/272016/09/272017/09/272018/09/272019/09/272020/09/27
Implied Return on Equity 0.2920.0020.4240.4970.5000.4960.4930.4900.487
Balance Sheet Assumptions
Working Capital Assumptions
Ending Operating Cash/Sales 17.5%15.3%21.8%11.2%8.4%8.4%8.4%8.4%8.4%8.4%
Ending Receivables/Sales 3.3%3.7%3.8%3.8%3.8%3.8%3.8%3.8%3.8%3.8%
Ending Inventories/COGS 11.4%12.8%10.4%9.5%9.9%9.9%9.9%9.9%9.9%9.9%
Ending Other Current Assets/Sales 3.3%3.3%3.8%3.7%3.7%3.7%3.7%3.7%3.7%3.7%
Ending Accounts Payable/COGS 6.4%4.1%4.6%4.7%5.2%5.2%5.2%5.2%5.2%5.2%
Ending Taxes Payable/Sales 0.9%1.0%0.8%1.7%1.4%1.4%1.4%1.4%1.4%1.4%
Ending Other Current Liabs/Sales 12.2%12.6%32.0%13.6%14.1%14.1%14.1%14.1%14.1%14.1%
Other Operating Asset Assumptions
Ending Net PP&E/Sales 20.1%20.0%21.5%21.4%21.3%21.3%21.3%21.3%21.3%21.3%
Ending Investments/Sales 4.1%4.3%3.7%5.1%3.5%3.5%3.5%3.5%3.5%3.5%
Ending Intangibles/Sales 3.7%4.1%7.7%6.9%10.9%10.9%10.9%10.9%10.9%10.9%
Ending Other Assets/Sales 2.5%1.8%7.8%6.7%6.5%6.5%6.5%6.5%6.5%6.5%
Other Operating Liability Assumptions
Other Liabilities/Sales 3.0%2.5%2.3%2.3%2.9%2.9%2.9%2.9%2.9%2.9%
Deferred Taxes/Sales 0.0%0.1%0.1%0.0%0.4%0.4%0.4%0.4%0.4%0.4%
Estimated Price/Share=$47.48 Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast
Fiscal Year End Date 2011/10/02 2012/09/30 2013/09/29 2014/09/28 2015/09/27 2016/09/27 2017/09/27 2018/09/27 2019/09/27 2020/09/27
Implied Return on Equity 0.292 0.002 0.424 0.497 0.500 0.496 0.493 0.490 0.487 Financing Assumptions Current Debt/Total Assets 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Long-Term Debt/Total Assets 7.5% 6.7% 11.3% 19.0% 18.9% 18.9% 18.9% 18.9% 18.9% 18.9% Minority Interest/Total Assets 0.0% 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Preferred Stock/Total Assets 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Dividend Payout Ratio 0.0% 39.3% 8055.4% 40.0% 36.9% 36.9% 36.9% 36.9% 36.9% 36.9%
Estimated Price/Share=$47.48
ActualActualActualActualActualForecastForecastForecastForecastForecast
Fiscal Year End Date 2011/10/022012/09/302013/09/292014/09/282015/09/272016/09/272017/09/272018/09/272019/09/272020/09/27
Implied Return on Equity 0.2920.0020.4240.4970.5000.4960.4930.4900.487
Financing Assumptions
Current Debt/Total Assets 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Long-Term Debt/Total Assets 7.5%6.7%11.3%19.0%18.9%18.9%18.9%18.9%18.9%18.9%
Minority Interest/Total Assets 0.0%0.1%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Preferred Stock/Total Assets 0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Dividend Payout Ratio 0.0%39.3%8055.4%40.0%36.9%36.9%36.9%36.9%36.9%36.9%
Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast Fiscal Year End Date 2011/10/02 2012/09/30 2013/09/29 2014/09/28 2015/09/27 2016/09/27 2017/09/27 2018/09/27 2019/09/27 2020/09/27 Analysis of Leverage - Short-Term Liquidity Current Ratio 1.828 1.900 1.017 1.372 1.191 1.191 1.191 1.191 1.191 1.191 Quick Ratio 1.174 1.142 0.706 0.814 0.638 0.638 0.638 0.638 0.638 0.638 EBIT Interest Coverage 78.185 54.639 125.415 43.566 47.702 46.954 46.650 46.343 46.031 45.717 EBITDA Interest Coverage 106.390 72.394 162.665 55.242 60.948 61.113 60.809 60.502 60.190 59.876
Fiscal Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
ActualActualActualActualActualForecastForecastForecastForecastForecast
Fiscal Year End Date 2011/10/022012/09/302013/09/292014/09/282015/09/272016/09/272017/09/272018/09/272019/09/272020/09/27
Analysis of Leverage
- Short-Term Liquidity
Current Ratio 1.8281.9001.0171.3721.1911.1911.1911.1911.1911.191
Quick Ratio 1.1741.1420.7060.8140.6380.6380.6380.6380.6380.638
EBIT Interest Coverage 78.18554.639125.41543.56647.70246.95446.65046.34346.03145.717
EBITDA Interest Coverage 106.39072.394162.66555.24260.94861.11360.80960.50260.19059.876
Fiscal Year 2011201220132014201520162017201820192020
Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast Fiscal Year End Date 2011/10/02 2012/09/30 2013/09/29 2014/09/28 2015/09/27 2016/09/27 2017/09/27 2018/09/27 2019/09/27 2020/09/27
Annual Growth Rates Sales 13.5% 12.0% 10.6% 16.5% 15.3% 14.1% 12.8% 11.6% 10.4% Assets 11.7% 40.1% -6.6% 15.7% 15.3% 14.1% 12.8% 11.6% 10.4% Common Equity 16.5% -12.3% 17.7% 10.4% 15.3% 14.1% 12.8% 11.6% 10.4% Earnings 11.1% -99.4% 24816.9% 33.3% 13.5% 13.9% 12.7% 11.4% 10.2% Free Cash Flow to Investors -156.8% #N/A 111.1% 153.2% 19.0% 17.6% 16.2% 14.9% Sustainable Growth Rate -13.8% 25.5% 31.4% 31.5% 31.3% 31.1% 30.9% 30.7%
Profitability Return on Equity 0.292 0.002 0.424 0.497 0.500 0.496 0.493 0.490 0.487 Return on Equity (b4 non-recurring) 0.248 (0.018) 0.366 0.419 0.420 0.417 0.415 0.412 0.409 Return on Net Operating Assets 0.265 0.001 0.322 0.363 0.363 0.360 0.358 0.356 0.353
Basic Dupont Model Net Profit Margin 0.106 0.104 0.001 0.126 0.144 0.142 0.141 0.141 0.141 0.141 x Total Asset Turnover 1.704 1.507 1.477 1.652 1.649 1.641 1.632 1.624 1.616 x Total Leverage 1.641 2.058 2.284 2.092 2.139 2.139 2.139 2.139 2.139 = Return on Equity 0.292 0.002 0.424 0.497 0.500 0.496 0.493 0.490 0.487
ActualActualActualActualActualForecastForecastForecastForecastForecast
Fiscal Year End Date 2011/10/022012/09/302013/09/292014/09/282015/09/272016/09/272017/09/272018/09/272019/09/272020/09/27
Annual Growth Rates
Sales 13.5%12.0%10.6%16.5%15.3%14.1%12.8%11.6%10.4%
Assets 11.7%40.1%-6.6%15.7%15.3%14.1%12.8%11.6%10.4%
Common Equity 16.5%-12.3%17.7%10.4%15.3%14.1%12.8%11.6%10.4%
Earnings 11.1%-99.4%24816.9%33.3%13.5%13.9%12.7%11.4%10.2%
Free Cash Flow to Investors -156.8%#N/A111.1%153.2%19.0%17.6%16.2%14.9%
Sustainable Growth Rate -13.8%25.5%31.4%31.5%31.3%31.1%30.9%30.7%
Profitability
Return on Equity 0.2920.0020.4240.4970.5000.4960.4930.4900.487
Return on Equity (b4 non-recurring) 0.248(0.018)0.3660.4190.4200.4170.4150.4120.409
Return on Net Operating Assets 0.2650.0010.3220.3630.3630.3600.3580.3560.353
Basic Dupont Model
Net Profit Margin 0.1060.1040.0010.1260.1440.1420.1410.1410.1410.141
x Total Asset Turnover 1.7041.5071.4771.6521.6491.6411.6321.6241.616
x Total Leverage 1.6412.0582.2842.0922.1392.1392.1392.1392.139
= Return on Equity 0.2920.0020.4240.4970.5000.4960.4930.4900.487