costco b

pdf

School

University of Texas, San Antonio *

*We aren’t endorsed by this school

Course

3023

Subject

Finance

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by MasterBatMaster846

C ASE : A-186B D ATE : 06/19/03 Brian Tayan prepared this case under the supervision of Professor Maureen McNichols as the basis for class discussion rather than to illustrate either effective or ineffective handling of an administrative situation. Copyright © 2003 by the Board of Trustees of the Leland Stanford Junior University. All rights reserved. To order copies or request permission to reproduce materials, e-mail the Case Writing Office at: cwo@gsb.stanford.edu or write: Case Writing Office, Stanford Graduate School of Business, 518 Memorial Way, Stanford University, Stanford, CA 94305-5015. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means –– electronic, mechanical, photocopying, recording, or otherwise –– without the permission of the Stanford Graduate School of Business. C OSTCO W HOLESALE C ORPORATION F INANCIAL S TATEMENT A NALYSIS (B) I NTRODUCTION Margarita Torres had just completed her analysis of Costco’s financial performance over the previous five years. She had concluded that the company had grown at a manageable rate, using internally generated funds rather than debt or equity to finance expansion. In 2001, operations had suffered slightly from the rapid introduction of stores. Nevertheless, the financial ratios indicated that there was not a significant deterioration in operational efficiency. Asset and inventory turnover remained at steady levels, indicating that the company had not overbuilt capacity in relation to customer demand. Both gross and operating margins remained healthy. From an investment standpoint she was concerned about the future performance of the business. As an experienced investor, she knew that there were two components of judging the value of her stock holdings: the future performance of the business and the potential for continued returns from the current price level. She decided therefore that it was appropriate to evaluate her investment in two steps. First she would forecast the company’s operations several years out to understand what the business would look in terms of number of stores, sales per store, and profitability. Second, she would value the business using a discounted cash flow model to get a better understanding of what rate of future return she should expect, given the current stock price. H ISTORY OF C OSTCO AS AN I NVESTMENT Costco Wholesale went public in November 1985 at a price of $10 per share. At the time, it had 15 warehouses in operation. Investors who bought into the company at its initial public offering profited richly over the next 17 years. However, as with most investments, gains were not made evenly year over year. For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 2 The years 1985 to 1992 were a time of extreme appreciation in the stock price, well in excess of the company’s operational success. During the years 1992 to 1995, the company’s stock price corrected itself to be more in line with reasonable valuations, and investors who held it from peak to trough saw a loss of 70 percent in their investment. This was also the time of the Costco- Price Club merger, which caused short-term disruptions in operations. By the late 1990s, the company regained steam operationally, and the price of the stock increased almost ten-fold by May of 2000. By July 2002, the stock was off its all-time high, trading at around $35 per share. Investors who put $1,000 in Costco stock at the time of its IPO saw their holdings grow to $21,000 by July 2002, a compounded return of over 19 percent per year for almost 17 years. The company’s stock traded on the NASDAQ under the symbol COST. F ORECAST To determine a financial forecast for Costco, Torres went through the following four-step process: 1. She listed the fundamental factors that would drive growth. Keeping in mind Albert Einstein’s statement that “things should be made as simple as possible but not any simpler,” she set an objective of isolating the four or five drivers that had the largest impact on Costco’s future. She considered the constraints associated with each factor. 2. Second, she forecasted Costco’s income statement and computed a rough estimate of free cash flow based on her determinations in step one. 3. Third, she ran a quantitative check on the numbers, comparing key ratios to the historical results to consider the feasibility of her projections. 4. Fourth, she ran a qualitative check on the numbers to understand whether her projections were conservative or aggressive. In carrying out her analysis, she relied on diverse sources of information: industry reports such as those compiled by Standard and Poor’s, research analyst reports, web casts with company management archived on the investor relations section of company websites, and business periodicals. Growth Drivers The first factor she considered was the number of warehouses that the company would operate in the U.S. She had read in business periodicals that analysts thought the saturation point in the U.S. market was 1500 warehouses shared among all competitors. Costco management, in its third quarter 2002 conference call with analysts, said that it expected to operate between 500 and 600 stores in the U.S. by 2010 1 . Management considered 500 conservative, 580 assertive, and 600 aggressive. With 289 U.S. warehouses in 2002, Costco had approximately a 30 percent market share. Torres knew that there was intense competition among Costco, SAM’S, and BJ’s 1 Forward-looking comments made by management, here and throughout the case, taken from: Costco Wholesale Corporation, “Audio Events: Q3 2002 Costco Wholesale Corporation Earnings Conference Call,” May 30, 2002, http://www.costco.com (31 July 2002). For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 3 to expand in the U.S. SAM’S had announced plans to aggressively increase its own new store openings. The second factor she considered was sales per store. In more established warehouses, Costco had U.S. sales per store of approximately $100 million, compared to $60 million for SAM’S, and $45 million for BJ’s. All three companies felt that fresh food, luxury items such as fine wines and jewelry, and ancillary products helped to increase same-store sales over time. Costco management had stated that they would like to get U.S. store sales up to $125 million or even $150 million per store. Was that possible? Also, with the companies increasingly entering each other’s markets, what pressure would be placed on Costco’s store sales? Which company, if any, would come out dominant? The third important growth driver was the membership base. Costco located warehouses in areas with a population of around 500,000 in a 15-mile radius. They expected to sign up approximately 10 percent of those people as members. Torres was not sure whether membership per store would increase or decrease, especially given the effects of competition. She did feel, however, that Costco could raise the membership fee over time. The basic annual membership fee was $25 in the mid-1980s. By now it was $45. Costco also had an executive membership, which was $100. She felt that as customers spent more money on sales merchandise, the more valuable they would perceive the membership to be and the more, in turn, Costco could charge. Costco management reported that recent increases in the membership fee did not materially change membership renewal rates, which average 86 percent. The fourth important factor to consider was operating margins. Costco management had recently stated that they felt they deserved to make more money from their business, given the value they delivered to customers. Management noted that pretax margin had peaked at 3.3 percent in 2000 and fell to 2.9 percent in 2001. Costco wanted to increase their pretax margin to 3.4 percent to 3.6 percent over the next five years (Wal-Mart’s pretax margin was almost 6 percent). Torres did not know how much of this increase would come from improved gross margin, resulting from a change in pricing strategy, and how much from improved operating margins, where operations were already very efficient. The fifth main factor she considered was international expansion. Management had already stated that its emphasis was on U.S. growth, but that it would grow internationally where it felt it could do so profitably. Plans were to open four to eight warehouses per year internationally over the next five years, and 10 to 15 per year over the subsequent five years. Forecast Financial Statements The next step was to forecast the financial statements based on her assumptions about the five main growth drivers, using 2010 as a terminal year. She built the model in the following steps: Merchandise Sales 1. Assumption: number of U.S. stores 2. Assumption: number of international stores 3. Assumption: sales per store 4. Output: merchandise sales For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 4 Because the 20 stores Costco operated in Mexico were accounted for using the equity method (based on 50 percent ownership), she kept track of them separately. Pro rata share of earnings from the Mexican stores were disclosed on Costco’s income statement under “interest income and other”; capital invested in these stores was listed on the balance sheet under “other assets.” Membership Revenue 1. Assumption: members per store 2. Assumption: revenue booked per member 3. Output: membership revenue Operating Ratios 1. Assumption: cost of goods sold as a percent of merchandise sales 2. Assumption: SG&A as a percent of merchandise sales 3. Assumption: pre-opening expense per store 4. Assumption: interest expense 5. Output: income statement line items After projecting the income statement for Costco, she projected year-end balance sheet amounts in the following simplified manner: Net Operating Working Capital 1. Assumption: net working capital required per store 2. Output: net operating working capital Net Operating Long-Term Assets 1. Assumption: net PP&A required per store 2. Assumption: other long-term assets required per store 3. Assumption: non-interest bearing long-term liabilities 4. Output: net operating long-term assets Invested Capital 1. Assumption: long-term debt 2. Output: shareholder’s equity 3. Output: free cash flow She calculated shareholder’s equity by subtracting net debt from total net assets. She calculated free cash flow to equity holders as net income, less the increase in operating working capital, less the increase in net long-term assets, plus the increase in long-term debt. Beyond the terminal year of 2010, she was not sure whether free cash would increase at the same rate as U.S. GDP, a higher rate or lower rate. This would depend on a variety of factors, including whether the saturation point for warehouses had been reached, whether the company would continue to steal market share from competitors, and whether the company would be able to grow outside the U.S.. For now, she assumed growth at 5 percent, her estimate of long-term nominal increase in GDP. Finally, she divided earnings and free cash flow by the number of shares outstanding. She had noticed that Costco’s shares were increasing at a rate of 1 percent to 2 percent per year because For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 5 of its employee stock option plan and assumed the company would continue earnings dilution at a similar rate. Quantitative Check To check her model quantitatively she compared her results with management’s five-year targets: x± Sales growth of 10 percent to 12 percent x± Earnings growth of 16 percent x± Earnings per share growth of 15 percent Other quick checks that she ran included: x± Member count as a percent of the U.S. population x± Sales per member x± Return on equity Qualitative Check One final check of her model involved asking whether her assumptions about the future were realistic, aggressive, or conservative. She realized that retailing was very competitive and companies’ financial results usually reverted to industry mean figures, particularly in margins and ROE. However, she knew that Costco had strong competitive advantages based on its low- cost business model. She was not sure when competitive pressures would catch up with them. She saw Wal-Mart as an example of a company that performed above average for a considerable time. Wal-Mart would be one of Costco’s main competitors as the company grew. V ALUATION Having completed a forecast for Costco, Torres found the task of calculating valuation to be relatively simple. She put together a discounted cash flow model using her projections of free cash. Discounted Cash Flow Model The discounted cash flow model involved listing free cash flow figures through 2010 and calculating a present value of the free cash flows after 2010 based on her long-term rate of growth assumption. She then discounted these figures back using an assumed discount rate. The most difficult step of the discounted cash flow model was determining this discount rate. Some analysts advocated using the weighted average cost of capital (WACC). They used interest rates on long-term corporate bonds to determine the cost of debt and assumptions about volatility and market rates of return to determine the cost of equity. Torres decided to postpone calculating the company’s WACC and instead use a discount rate of 8 percent, slightly higher than the average historical yield on 30-year U.S. Treasuries. For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 6 S TUDY Q UESTIONS 1. How appropriate are the five factors that Torres chooses to determine the future performance of Costco? 2. What other relevant factors might be included in a forecast of the business? To what extent are they covered in the factors above? 3. Review Torres’ assumptions in Exhibit 2. Which assumptions would represent a change from Costco’s historical performance? Do you feel her assumptions are appropriate, and if not, which ones would you change? 4. Review Torres’ forecasted income statement and common-size income statement. Do you feel these are achievable results for Costco? 5. Review Torres’ forecast in Exhibit 5. How does the rate of expansion (i.e. new store openings) affect the balance sheet and free cash flow? Do you agree with her terminal value assumptions? 6. How does Costco’s use of the equity method to account for its ownership of the 20 warehouses in Mexico effect the income statement forecast, the balance sheet forecast, and the discounted cash flow model? 7. Review Torres’ quantitative checks. Compare her projections with management’s forward- looking comments. Based on these and other constraints (e.g. the effect of competition, historical performance, etc.) do you feel that her forecast is realistic, conservative, or aggressive? What does the theory of reversion to the mean say about Torres’ projections? Which do you agree with? 8. Would you recommend that Torres buy, hold, or sell her Costco’s shares at the price of $35? For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 7 Exhibit 1 Costco Wholesale Corp. Stock Price (1997 – 2002) Source: DataStream 0 10 20 30 40 50 60 Mar- 97 Sep- 97 Mar- 98 Oct- 98 Apr- 99 Oct- 99 Apr- 00 Oct- 00 May- 01 Nov- 01 May- 02 Price For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 8 Exhibit 2 Margarita Torres: Assumptions Underlying Costco Forecast (2001 - 2010) Assumptions 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Merchandise Sales U.S. store openings during year 27 28 28 28 28 30 30 30 30 30 Number of US stores, yr-end count 264 292 320 348 376 406 436 466 496 526 Intl. store openings (excluding Mexico) 7 3 6 6 6 6 12 12 12 12 Number of intl. stores, yr-end count 81 84 90 96 102 108 120 132 144 156 Total stores, consolidated 345 376 410 444 478 514 556 598 640 682 Number of Mexico stores, equity 20 20 20 20 20 20 20 20 20 20 Annual increase in store sales 2% 2% 2% 2% 2% 2% 2% 2% 2% Sales per store ($mm, yr-end count) 99 101 103 105 107 109 111 114 116 118 Membership Revenue Members per store (th.) 50 50 50 50 50 50 50 50 50 50 Total members (th.) 17,095 18,800 20,500 22,200 23,900 25,700 27,800 29,900 32,000 34,100 Revenue booked per member per year 39 39 39 40 40 40 41 41 41 41 Operating Ratios Cost of goods sold as a percent of sales 89.63% 89.55% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% SG&A as a percent of sales 9.17% 9.07% 8.97% 8.87% 8.77% 8.67% 8.60% 8.60% 8.60% 8.60% Pre-opening expense per new store ($mm) 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 Interest expense ($mm) (32) (32) (32) (32) (32) (32) (32) (32) (32) (32) For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 9 Exhibit 3 Margarita Torres: Forecast Income Statement Costco (2001 - 2010) Income Statement (millions) 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Revenue Net sales 34,137 37,948 42,208 46,622 51,196 56,153 61,956 67,969 74,197 80,648 Membership fees and other 660 726 791 888 956 1,028 1,140 1,226 1,312 1,398 Total revenues 34,797 38,674 42,999 47,510 52,152 57,181 63,096 69,195 75,509 82,046 Operating expenses Merchandise costs 30,598 33,983 37,776 41,727 45,820 50,257 55,450 60,832 66,407 72,180 SG&A 3,129 3,442 3,786 4,135 4,490 4,868 5,328 5,845 6,381 6,936 Pre-opening expenses 60 47 51 51 51 54 63 63 63 63 Provision for impaired assets / closings 18 20 20 20 20 20 20 20 20 20 Total operating expenses 33,805 37,491 41,633 45,933 50,381 55,199 60,862 66,760 72,870 79,198 Operating income 992 1,183 1,366 1,577 1,771 1,982 2,234 2,434 2,639 2,847 Other income (expenses) Interest expense (32) (32) (32) (32) (32) (32) (32) (32) (32) (32) Interest income and other 43 43 43 43 43 43 43 43 43 43 Provision for merger and restructuring 0 0 0 0 0 0 0 0 0 0 Income continuing ops before taxes 1,003 1,194 1,377 1,588 1,782 1,993 2,245 2,445 2,650 2,858 Provision for income taxes 401 478 551 635 713 797 898 978 1,060 1,143 Income before cumulative effect of acct. change 602 716 826 953 1,069 1,196 1,347 1,467 1,590 1,715 Cumulative effect of acct., net of tax 0 0 0 0 0 0 0 0 0 0 Income from continuing operations 602 716 826 953 1,069 1,196 1,347 1,467 1,590 1,715 Discontinued operations Income (loss), net of tax 0 0 0 0 0 0 0 0 0 0 Loss on disposal 0 0 0 0 0 0 0 0 0 0 Net Income (loss) 602 716 826 953 1,069 1,196 1,347 1,467 1,590 1,715 For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 10 Exhibit 4 Margarita Torres: Forecast Common-Size Income Statement Costco (2001 - 2010) Income Statement (millions) 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Revenue Net sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Membership fees and other 1.93% 1.91% 1.88% 1.90% 1.87% 1.83% 1.84% 1.80% 1.77% 1.73% Total revenues 101.93% 101.91% 101.88% 101.90% 101.87% 101.83% 101.84% 101.80% 101.77% 101.73% Operating expenses Merchandise costs 89.63% 89.55% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% 89.50% SG&A 9.17% 9.07% 8.97% 8.87% 8.77% 8.67% 8.60% 8.60% 8.60% 8.60% Pre-opening expenses 0.18% 0.12% 0.12% 0.11% 0.10% 0.10% 0.10% 0.09% 0.08% 0.08% Provision for impaired assets / closings 0.05% 0.05% 0.05% 0.04% 0.04% 0.04% 0.03% 0.03% 0.03% 0.02% Total operating expenses 99.03% 98.80% 98.64% 98.52% 98.41% 98.30% 98.23% 98.22% 98.21% 98.20% Operating income 2.91% 3.12% 3.24% 3.38% 3.46% 3.53% 3.61% 3.58% 3.56% 3.53% Other income (expenses) Interest expense -0.09% -0.08% -0.08% -0.07% -0.06% -0.06% -0.05% -0.05% -0.04% -0.04% Interest income and other 0.13% 0.11% 0.10% 0.09% 0.08% 0.08% 0.07% 0.06% 0.06% 0.05% Provision for merger and restructuring 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Income continuing ops before taxes 2.94% 3.15% 3.26% 3.41% 3.48% 3.55% 3.62% 3.60% 3.57% 3.54% Provision for income taxes 1.17% 1.26% 1.31% 1.36% 1.39% 1.42% 1.45% 1.44% 1.43% 1.42% Income before cumulative effect of acct. change 1.76% 1.89% 1.96% 2.04% 2.09% 2.13% 2.17% 2.16% 2.14% 2.13% Cumulative effect of acct., net of tax 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Income from continuing operations 1.76% 1.89% 1.96% 2.04% 2.09% 2.13% 2.17% 2.16% 2.14% 2.13% Discontinued operations 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Income (loss), net of tax 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Loss on disposal 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Net Income (loss) 1.76% 1.89% 1.96% 2.04% 2.09% 2.13% 2.17% 2.16% 2.14% 2.13% For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 11 Exhibit 5 Margarita Torres: Forecast Abbreviated Balance Sheet Costco (2001 - 2010) Balance Sheet (millions) 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Net working capital required per store 0 0 0 0 0 0 0 0 0 0 Net operating working capital (230) 0 0 0 0 0 0 0 0 0 Net PP&A required per store 18 18 18 18 18 18 18 18 18 Other long-term assets required per store 1 1 1 1 1 1 1 1 1 Non-interest bearing long-term liabilities (0.35) (0.35) (0.35) (0.35) (0.35) (0.35) (0.35) (0.35) (0.35) Net operating long-term assets per store 18.65 18.65 18.65 18.65 18.65 18.65 18.65 18.65 18.65 Net operating long-term assets 6,089 7,012 7,647 8,281 8,915 9,586 10,369 11,153 11,936 12,719 Net long-term debt 860 860 860 860 860 860 860 860 860 860 Minority interest 115 115 115 115 115 115 115 115 115 115 Shareholder’s equity 4,884 6,037 6,672 7,306 7,940 8,611 9,394 10,178 10,961 11,744 Free Cash Flow Net income 716 826 953 1,069 1,196 1,347 1,467 1,590 1,715 (-) Increase in working capital 230 0 0 0 0 0 0 0 0 (-) Increase in long-term assets 923 634 634 634 671 783 783 783 783 (+) Increase in long-term debt 0 0 0 0 0 0 0 0 0 Free cash flow to equity holders (437) 192 319 435 524 564 684 807 932 Annual increase in shares outstanding 1% 1% 1% 1% 1% 1% 1% 1% 1% Shares outstanding, diluted basis 475,827 480,585 485,391 490,245 495,147 500,099 505,100 510,151 515,252 520,405 Earnings per share 1.29 1.49 1.70 1.94 2.16 2.39 2.67 2.88 3.09 3.30 Free cash flow per share (0.91) 0.40 0.65 0.88 1.05 1.12 1.34 1.57 1.79 Terminal Value Information Growth in free cash flow, perpetuity 5% Discount rate 8% Annual free cash flow, 2011 978 For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 12 Exhibit 6 Margarita Torres: Quantitative Check on Forecast (2001 - 2010) Quantitative Check Model – thru 2010 Model – thru 2006 Mgt – thru 2006 Sales growth 10.0% 10.5% 10% - 12% Earnings growth 12.3% 14.7% 16% EPS growth 11.0% 13.1% 15% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 U.S. population (th.), 1% / yr growth 260,000 262,600 265,226 267,878 270,557 273,263 275,995 278,755 281,543 284,358 U.S. members as % of the U.S. population 5.0% 5.6% 6.0% 6.5% 6.9% 7.4% 7.9% 8.4% 8.8% 9.2% Sales per member, U.S. ($) 2,610 2,599 2,638 2,679 2,723 2,766 2,842 2,917 2,992 3,066 Return on equity 12.3% 11.9% 12.4% 13.0% 13.5% 13.9% 14.3% 14.4% 14.5% 14.6% For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Costco Wholesale Corp.: Financial Statement Analysis (B) A-186B p. 13 Exhibit 7 Margarita Torres: Discounted Cash Flow Model, Costco (2001 - 2010) Discounted Cash Flow Model 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Year 1 2 3 4 5 6 7 8 9 Discount rate 8% 8% 8% 8% 8% 8% 8% 8% 8% Discount factor 0.92593 0.85734 0.79383 0.73503 0.68058 0.63017 0.58349 0.54027 0.50025 Discounted free cash flow (405) 165 253 320 357 355 399 436 466 Present value of free cash, 2002 - 2010 2,346 Terminal Value Value of perpetuity, $1 g=5%, r=8% 33 Value of perpetuity, free cash flow 32,611 Year 9 Discount factor 0.500249 Present value of free cash 16,314 Model Value Present value of Costco Corp. 18,659 Present per share value 41 Current Value Current market cap 15,900 Current per share price 35 For the exclusive use of A. Hurtado, 2024. This document is authorized for use only by Andrea Hurtado in Spring 2024 - Fin 3023 taught by Vipin Agrawal, University of Texas at San Antonio from Jan 2024 to Jul 2024.