Using the FINANCIAL worksheet, do a five-year projection for Dell’s Executive PC
ID: 2596471 • Letter: U
Question
Using the FINANCIAL worksheet, do a five-year projection for Dell’s Executive PC using market shares obtained from PERCEPTOR, Current market share analysis- Seg 1 = 15.96%; Seg 2 = 26.93%; Seg 3 = 19.03%; total market share =22.37%.
The Computer Industry
The market for personal computers has been growing rapidly for several years with little end in sight. As of the end of the year 2000, approximately 120 million PCs were sold worldwide. Projections for the next five years of industry sales are as shown below:
Year
2001
2002
2003
2004
2005
Market Size (in millions)
136
152
168
184
200
Competition
The PC industry has four major competitors: IBM, Dell, Compaq, and Hewlett-Packard (HP). All four make and sell competitive mid-range performance PCs, with the typical configuration for home or small business use costing approximately $1000. Dell’s variable costs per unit total about $800, and it is believed that competitors face a similar variable cost structure. The Executive would be priced competitively, at about the same price level of $1000.
A recent study of the home/small-business PC market found that most customers considered two important non-price attributes when selecting a PC, flexibility and performance. Flexibility refers in this situation to a PC’s ability to run several different kinds of software, to be easily connected to printers and other peripherals, suitability for business as well as educational or game use, and so forth. Performance, by contrast, referred to speed of internet connection and internal calculations, support of the highest-end software programs, and reliability and accuracy of calculations (the study was done soon after the infamous Pentium “bug” was found, which caused a very small percentage of numerical calculations to be slightly wrong). Using familiar customer survey methods, the consultants conducting the study found the perceived positions of each of the four major brands on the two key non-price attributes. In the same survey, customer preferences were also gathered, and these were used to identify “ideal brands” and assess the number and size of customer benefit segments in the marketplace. Three segments were identified. Segment 1 (about 20% of the market) prefers highly flexible PCs, Segment 2 (about 50% of the market) likes high-performance machines, and Segment 3 (about 30% of the market) values a combination of the two attributes. The results of the study are summarized below.
Attribute 1
(Performance)
Attribute 2
(Flexibility)
Size of Segment Relative to Market
Ideal Brands by Segment
Segment 1
-0.5
3
0.2
Segment 2
2
-1
0.5
Segment 3
1.5
1.5
0.3
Brand Positions
Dell
1
-1
IBM
2
-1.5
HP
1
3
Compaq
0.5
0.5
Dell’s Marketing Budget
As its product line has expanded and competition has continued to be fierce, Dell has allocated significant budgets to both advertising and distribution. Considering first its distribution policies, Dell uses two principal channels. First is the lower-end channel, used to target PC users who need simple, stand-alone solutions to their PC needs. These users include a large number of both home users and small businesses, and are primarily targeted through superstores and discount clubs as well as through on-line shopping. Users with more complex needs are targeted via specialty computer stores that can provide more high-touch customer solutions. This target group also comprises both home and business customers.
If Dell is to launch its new Executive PC, the extensive, multiple distribution channel arrangement is expected to cost in the order of $500 million yearly. The advertising budget is similarly in the range of about $500 million as extensive consumer advertising across multiple media and vehicles is complemented with substantial trade advertising to all dealer sizes and types. In preparation for a financial analysis, Dell’s consultants developed the following set of estimates regarding the impacts of the advertising and distributional expenditures on Executive PC sales. Note: in this durable-goods context, certain terms need to be redefined carefully. “Switching” refers to a current non-Dell user switching to a Dell Executive PC the next time he or she purchases a PC, and “repurchasing” refers to a current Dell user purchasing a Dell Executive. Note also that sales promotions such as coupons are irrelevant for this particular firm, so sales promotion budget should be left at zero and the “probability of trying a received sample” line should be ignored, as it has no effect on the calculations.
Long-Run Trial Probability (F)
0.7
Prob. of Trying a Received Sample (U)
0
Prob. of Switching to New Brand (Qkz)
0.8
Prob. of Repurchasing New Brand (Qzz)
0.8
Financial Evaluation of the Executive PC
Dell wants to do a financial analysis of the Executive PC to assess the proposed new product’s value. Much of the information presented or calculated above can be used in making this assessment, though the consultant team had to estimate some additional figures with the help of top management. Estimates and managerial input useful for the financial analysis include the following:
Fixed (indirect) production costs = $100,000,000 yearly.
Corporate overheads (exclusive of R&D) charged to the new product = $100,000,000 yearly.
R&D to be charged to the new product: 2% of dollar sales, beginning in Year 1.
Cannibalization: negligible.
Project abandonment: negligible.
Tax rate: 34%, with no applicable tax credits.
Cost of capital: 15%.
Working capital:
Cash as percent of sales: 10%.
Inventory as percent of sales: 10%.
Accounts Receivable as percent of sales: 15%.
Working capital recovery in Year 5:
Percent of cash: 100%.
Percent of inventory: 80%.
Percent of accounts receivable: 100%.
Investment in production facilities: one-time-only $100,000,000 charge in Year 0 (now), depreciated over five years using the straight line method.
Year
2001
2002
2003
2004
2005
Market Size (in millions)
136
152
168
184
200
Explanation / Answer
Projection for Dells Executive Seg1 Seg2 Seg3 Total Market share Market share 15.96% 26.93% 19.03% 22.37% If Dell is to launch its new Executive PC, Projection for Sale Year 2001 2002 2003 2004 2005 distribution cost $500,000,000 Market Size 136000000 152000000 168000000 184000000 200000000 Advertising Cost $500,000,000 FixedCost $1,000 Variable Cost $800 Attribute 1 Attribute 2 Size of Segment Relative to Market (Performance) (Flexibility) Market share no. current market share Ideal Brands by Segment Seg1 of 20% Segment 1 -0.5 3 24000000 15.96% 4284302.4 Seg2 of 50% Segment 2 2 -1 60000000 26.93% 7229089.2 Seg3 of 30% Segment 3 1.5 1.5 36000000 19.03% 5108413.2 Brand Positions 100% 22.37% 26844000 26844000 Dell 1 -1 IBM 2 -1.5 26844000 HP 1 3 Compaq 0.5 0.5 a currentnon-Dell user switching to a Dell Executive PC repurchasing refers to a current Dell user purchasing a Dell Executive. Probabality Long-Run Trial Probability (F) 0.7 Prob. of Trying a Received Sample (U) 0 Prob. of Switching to New Brand (Qkz) 0.8 Prob. of Repurchasing New Brand (Qzz) 0.8 Estimates and managerial input useful for the financial analysis include the following: Fixed (indirect) production costs = $100,000,000 yearly. Corporate overheads (exclusive of R&D) charged to the new product = $100,000,000 yearly. R&D to be charged to the new product: 2% of dollar sales, beginning in Year 1. Cannibalization: negligible. Project abandonment: negligible. Tax rate: 34%, with no applicable tax credits. Cost of capital: 15%. Working capital: Cash as percent of sales: 10%. Inventory as percent of sales: 10%. Accounts Receivable as percent of sales: 15%. Working capital recovery in Year 5: Percent of cash: 100%. Percent of inventory: 80%. Percent of accounts receivable: 100%. Investment in production facilities: one-time-only $100,000,000 charge in Year 0 (now), depreciated over five years using the straight line method. Fixed Indirect cost $100,000,000 Corporate Overhead cost $100,000,000 Year 2001 2002 2003 2004 2005 Sales (Unit sales*price $1000) $30,423,200,000 $34,002,400,000 $37,581,600,000 $41,160,800,000 $44,740,000,000 Cost of capital R&D Cost $ 2,720,000 $ 3,040,000 $ 3,360,000 $ 3,680,000 $ 4,000,000 Fixed Indirect cost $100,000,000 $100,000,000 $100,000,000 $100,000,000 $100,000,000 Depreciation on investment facilitits $100,000,000/5 $20,000,000 $20,000,000 $20,000,000 $20,000,000 $20,000,000 Corporate Overhead cost $100,000,000 $100,000,000 $100,000,000 $100,000,000 $100,000,000 Distribution cost $500,000,000 $500,000,000 $500,000,000 $500,000,000 $500,000,000 Advertising Cost $500,000,000 500000000 500000000 500000000 500000000 Total Cost $1,222,720,000 $1,223,040,000 $1,223,360,000 $1,223,680,000 $1,224,000,000 Profit $29,200,480,000 $32,779,360,000 $36,358,240,000 $39,937,120,000 $43,516,000,000 Tax rate 34% $9,928,163,200 $11,144,982,400 $12,361,801,600 $13,578,620,800 $14,795,440,000 PAT $19,272,316,800 $21,634,377,600 $23,996,438,400 $26,358,499,200 $28,720,560,000 Working Capital Cash $3,042,320,000 $3,400,240,000 $3,758,160,000 $4,116,080,000 $4,474,000,000 Inventory $3,042,320,000 $3,400,240,000 $3,758,160,000 $4,116,080,000 $4,474,000,000 Account Receivables $4,563,480,000 $5,100,360,000 $5,637,240,000 $6,174,120,000 $6,711,000,000 A $10,648,120,000 $11,900,840,000 $13,153,560,000 $14,406,280,000 $15,659,000,000 Working Capital recovery in 5 years Cash $3,042,320,000 $3,400,240,000 $3,758,160,000 $4,116,080,000 $4,474,000,000 Inventory $2,433,856,000 $2,720,192,000 $3,006,528,000 $3,292,864,000 $3,579,200,000 Account Recivables $4,563,480,000 $5,100,360,000 $5,637,240,000 $6,174,120,000 $6,711,000,000 B $10,039,656,000 $11,220,792,000 $12,401,928,000 $13,583,064,000 $14,764,200,000 1000 Profit on investment (A-B) $608,464,000 $680,048,000 $751,632,000 $823,216,000 $894,800,000 Cost Of Capital 15% =Profit on investsment/ PAT 3% 3% 3% 3% 3% 15.00% Prject =120,000,000*22.37% 136000000 152000000 168000000 184000000 200000000 22.37% 30423200 34002400 37581600 41160800 44740000 Total Market Share $21,475,200,000 $30,423,200,000 $34,002,400,000 $37,581,600,000 $41,160,800,000 $44,740,000,000 Seg 1 share $3,427,441,920.00 $4,855,542,720.00 $5,426,783,040.00 $5,998,023,360.00 $6,569,263,680.00 $7,140,504,000.00 Seg2 share $5,783,271,360.00 $8,192,967,760.00 $9,156,846,320.00 $10,120,724,880.00 $11,084,603,440.00 $12,048,482,000.00 seg3 share $4,086,730,560.00 $5,789,534,960.00 $6,470,656,720.00 $7,151,778,480.00 $7,832,900,240.00 $8,514,022,000.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.