CASE: THE SOUND'S ALIVE COMPANY

Marissa Jones is the president and CEO of Sound's Alive, a company that manu­factures and sells a line of speakers, CD players, receivers, high-definition televi­sions, and other items geared for the home entertainment market. Respected throughout the industry for bringing many high-quality, innovative products to market, Marissa is considering adding a speaker system to her product line.

The speaker market has changed dramatically during the last several years. Originally, high-fidelity aficionados knew that to reproduce sound covering the fullest range of frequencies-from the lowest kettle drum to the highest violin-a speaker system had to be large and heavy. The speaker had various drivers: a woofer to reproduce the low notes, a tweeter for the high notes, and a mid-range driver for the broad spectrum of frequencies in between. Many speaker systems had a minimum of three drivers, but some had even more. The trouble was that such a system was too large for anything but the biggest rooms, and consumers were reluctant to spend thousands of dollars and give up valuable wall space to get the excellent sound these speakers could reproduce.

The trend has changed during the past several years. Consumers still want good sound, but they want it from smaller boxes. Therefore, the satellite system became popular. Consisting of two small boxes that house either one driver (to cover the mid-range and high frequencies) or two (a mid-range and tweeter), a satellite system can easily be mounted on walls or shelves. To reproduce the low notes, a separate subwoofer that is approximately the size of a cube 18 inches on a side is also needed. This subwoofer can be placed anywhere in the room. Taking up less space than a typical large speaker system and sounding almost as good, yet costing hundreds of dollars less, these satellite systems are hot items in the high-fidelity market.

Recently, the separate wings of home entertainment-high fidelity (receivers, speakers, CD players, CDs, cassettes, and so on), television (large screen monitors, video cassette recorders, laser players), and computers (games with sounds, vir­tual reality software, and so on)-have merged into the home theater concept. To simulate the movie environment, a home theater system requires the traditional stereo speaker system plus additional speakers placed in the rear of the room so that viewers are literally surrounded with sound. Although the rear speakers do not have to match the high quality of the front speakers and, therefore, can be less expensive, most consumers choose a system in which the front and rear speakers are of equal quality, reproducing the full range of frequencies with equal fidelity.

It is this speaker market that Marissa wants to enter. She is considering having Sound's Alive manufacture and sell a home theater system that consists of seven speakers. Three small speakers-each with one dome tweeter that could reproduce the frequency range of 200 Hertz to 20,000 Hertz (upper-low frequencies to the highest frequencies)-would be placed in front, and three similar speakers would be placed strategically around the sides and back of the room. To reproduce the lowest frequencies (from 35 Hertz to 200 Hertz), a single subwoofer would also be part of the system. This subwoofer is revolutionary because it is smaller than the ordinary subwoofer, only 10 inches per side, and it has a built-in amplifier to power it. Consumers and critics are thrilled with the music from early prototype systems, claiming that these speakers have the best balance of sound and size. Marissa is extremely encouraged by these early reviews, and although her company has never produced a product with its house label on it (having always sold systems from established high-fidelity companies), she believes that Sound's Alive should enter the home theater market with this product.

Phase One: Projecting Profits

Marissa decides to create a spreadsheet that will project profits over the next several years. After consulting with economists, market analysts, employees in her own company, and employees from other companies that sell house brand components, Marissa is confident that the gross revenues for these speakers in 2004 would be around $6 million. She must also figure that a small percentage of speakers will be damaged in transit, or some will be returned by dissatisfied customers shortly after the sales. These returns and allowances (R&As) are usually calculated as 2% of the gross revenues. Hence, the net revenues are simply the gross revenues minus the R&As. Marissa believes that the 2004 labor costs for these speakers will be $995,100. The cost of materials (including boxes to ship the speakers) should be $915,350 for 2004. Finally, her overhead costs (rent, lighting, heating in winter, air conditioning in summer, security, and so on) for 2004 should be $1,536,120. Thus, the cost of goods sold is the sum of labor, material, and overhead costs.

Marissa figures the gross profit as the difference between the net revenues and the cost of goods sold. In addition, she must consider the selling, general, and administrative (SG&A) expenses. These expenses are more difficult to estimate, but the standard industry practice is to use 18% of the net revenues as the nominal per­centage value for these expenses. Therefore, Marissa's profit before taxes is the gross profit minus the SG&A value. To calculate taxes, Marissa multiplies her profits before taxes times the tax rate, currently 30%. If her company is operating at a loss, however, no taxes would have to be paid. Finally, Marissa's net (or after tax) profit is simply the difference between the profit before taxes and the actual taxes paid.

To determine the numbers for 2005 through 2007, Marissa assumes that gross revenues, labor costs, material costs, and overhead costs will increase over the years. Although the rates of increase for these items are difficult to estimate, Marissa figures that gross revenues will increase by 9% per year, labor costs will increase by 4% per year, material costs will increase by 6% per year, and overhead costs will increase by 3% per year. She figures that the tax rate will not change from the 30% mark, and she assumes that the SG&A value will remain at 18%.

The basic layout of the spreadsheet that Marissa creates is shown in soundtem.xls on the course website. Construct the spreadsheet and determine the values for the years 2004 through 2007.

Marissa not only wants to determine her net profits for 2004 through 2007, she also must justify her decisions to the company's Board of Trustees. Should she even consider entering this market, from a financial point of view? One way to answer this question is to find the net present value (NPV) of the net profits for 2004 through 2007. Use Excel's NPV capability to find the NPV, at the current interest rate of 5%, of the profit values for 2004 through 2007. To avoid large values in the spreadsheet, enter all dollar calculations in thou­sands. For example, enter labor costs as 995.10 and overhead costs as 1536.12.

Phase Two: Bringing Competition into the Mode1

With her spreadsheet complete, Marissa is confident that entering the home the­ater speaker market would be lucrative for Sound's Alive. However, she has not considered one factor in her calculations-competition. The current market leader and company she is most concerned about is the Bose Corporation. Bose pio­neered the concept of a satellite speaker system, and its AMT series is very suc­cessful. Marissa is concerned that Bose will enter the home market, cutting into her gross revenues. If Bose does enter the market, Marissa believes that Sound's Alive would still make money; however, she would have to revise her gross rev­enues estimate from $6 million to $4 million for 2004.

To account for the competition factor, Marissa revises her spreadsheet by adding a Competitive Assumptions section. Cell F4 will contain either a 0 (no competition) or a 1 (if Bose enters the market). Cells F5 and F6 provide the gross revenue estimates (in thousands of dollars) for the two possibilities. Modify your spreadsheet to take these options into account. Use the IF( ) function for the gross revenues for 2004 (cell B12). If Bose does enter the market, not only would Marissa's gross revenues be lower, but the labor, materials, and overhead costs would also be lower because Sound's Alive would be making and selling fewer speakers. Marissa thinks that if Bose enters the market, her 2004 labor costs would be $859,170; 2004 material costs would be $702,950; and 2004 overhead costs would be $1,288,750. She believes that her growth rate assumptions would be the same whether or not Bose enters the market. Add these possible values to your spreadsheet using the IF( ) function in the appropriate cells.

Look at the net profits for 2004 through 2007. In particular, examine the NPV for the two scenarios: Bose does or does not enter the home theater speaker market.

Phase Three: Bringing Uncertainty into the Model

Jim Allison, the chief of operations at Sound's Alive and a quantitative methods specialist, plays a key role in providing Marissa with estimates for the various revenues and costs. He is uneasy about the basic estimates for the growth rates. For example, although market research indicates that a 9% gross revenue increase per year is reasonable, Jim knows that if this value is 7%, for example, the profit values and the NPV would be quite different. Even more troublesome is a potential tax increase, which would hit Sound's Alive hard. Jim believes that the tax rate could vary around the expected 30% figure. Finally, Jim is uncomfortable with the industry's standard estimate of 18% for the SG&A rate. Jim thinks that this value could be higher or even lower. .

The Sound's Alive problem is too complicated for solving with what-if analysis because seven assumed values could change: the growth rates for gross revenues, labor, materials, overhead costs, tax rate, SG&A percent, and whether or not Bose enters the market. Jim believes that a Monte Carlo simulation would be a better approach. Jim thinks that the behavior of these variables can be modeled as follows:

Gross Revenues (%): normally distributed, mean = 9.9, std dev = 1.4

Labor Growth (%): normally distributed, mean = 3.45, std dev = 1.0

Materials (%)	Probability		Overhead (%)	Probability
4	0.10		2	0.20
5	0.15		3	0.35
6	0.15		4	0.25
7	0.25		5	0.20
8	0.25
9	0.10
Tax Rate (%)	Probability		SG&A (%)	Probability
30	0.15		15	0.05
32	0.30		16	0.10
34	0.30		17	0.20
36	0.25		18	0.25
			19	0.20
			20	0.20

Finally, Jim and Marissa agree that there is a 50/50 chance that Bose will enter the market.

1. Use simulation to analyze the Sound's Alive problem. Based on your results, what is the expected net profit for the years 2004 through 2007, and what is the expected NPV for this business venture?

2.The Board of Trustees told Marissa that the stockholders would feel comfort­able with this business venture if its NPV is at least $5 million. What are the chances that Sound's Alive home theater venture will result in an NPV of $5 million or more?

Answer rating: 100% (QA)

Rev Growth Labor Growth Average Materials Growth 40 50 60 70 80 90 Overhead Growth 20 30 40 50 Prob ... View the full answer