Question
Figure 1 Phelps Toy Company Year Sales Net Income 1997.................................................................................................... $??150,000 $??(16,000 ) 1998.................................................................................................... 240,000 (5,000 ) 1999.................................................................................................... 756,000 72,000 2000.................................................................................................... 1,340,000 91,000 2001.................................................................................................... 2,680,000
Figure 1 Phelps Toy Company | Year |
| Sales | Net Income |
|
| 1997.................................................................................................... | $??150,000 | $??(16,000 | ) | |
| 1998.................................................................................................... | 240,000 | (5,000 | ) | |
| 1999.................................................................................................... | 756,000 | 72,000 |
| |
| 2000.................................................................................................... | 1,340,000 | 91,000 |
| |
| 2001.................................................................................................... | 2,680,000 | 175,000 |
| |
| 2002.................................................................................................... | 3,320,000 | 198,000 |
| |
| 2003.................................................................................................... | 5,580,000 | 248,000 |
| |
| 2004.................................................................................................... | 6,792,000 | 387,000 |
| |
| 2005.................................................................................................... | 5,941,000 | 291,000 |
| |
| 2006.................................................................................................... | 9,237,000 | 439,000 |
| |
| 2007.................................................................................................... | 11,622,000 | 566,000 |
| |
| 2008.................................................................................................... | 12,140,000 | 621,000 |
| |
| 2009.................................................................................................... | 17,165,000 | 850,000 |
| |
| 2010.................................................................................................... | 22,838,000 | 1,221,000 |
| |
| 2011.................................................................................................... | 27,762,000 | 1,437,000 |
| |
| 2012.................................................................................................... | 32,437,000 | 1,628,000 |
| |
| 2013.................................................................................................... | 38,911,000 | 1,762,000 |
| |
| 2014.................................................................................................... | 39,750,000 | 2,002,000 |
| |
| 2015.................................................................................................... | 39,860,000 | 1,950,000 |
|
For example, the 1968 rookie card of Nolan Ryan was selling for $2,000 in early 2015. The 1963 Pete Rose rookie card was valued at $500 and, finally, the first Topps card of Mickey Mantle issued in 1952 at 1 cent carried a trading value of $30,000 five decades later. While the card manufacturer did not directly participate in this price appreciation, the hope for such gains in the future keeps youngsters and adults continually active in buying cards as they come out.
To convince management that the manufacturing and selling of baseball cards was a suitable activity for his firm, Mr. Barnes had to make a thorough capital budgeting analysis for the executive committee of Phelps Toy Company.
The Analysis | In evaluating the market potential, Mr. Barnes determined that there was no way he could firmly predict the market penetration potential for a new set of baseball cards. |
The sales for the set, which would be called Baseball Stars, would depend on the quality of the final product as well as the effectiveness of the promotional activities. There is also the danger of a number of errors when a set is initially issued. With approximately 750 cards in the set, there is the possibility of misquoting batting averages, misspelling names, and so on. When Fleer and Donruss introduced their new sets in 1995, they were highly criticized by collectors for the numerous errors. Mr. Barnes hoped to avoid this fate for the Baseball Stars set by making heavy expenditures on quality control. He also intended to hire a number of employees from other card companies so he would have experienced people who could identify potential problems at a very early stage.
Over the years, Phelps Toy Company had developed a manual to evaluate capital budgeting projects. As a first step, Ike Barnes was required to predict anticipated sales over the next six years. While he thought this was too short a time period to evaluate the full potential of the project, he knew he had no choice but to go along with company policy. He decided to project a range for potential sales in 2016 (the first new year of business) and assign probabilities to the outcomes. The information is shown in Figure 2.
Figure 2 Projected first-year sales | Assumption | Sales | Probability |
| Pessimistic..................................................................................... | $1,100,000?? | 0.25 |
| Normal........................................................................................... | 2,000,000 | 0.40 |
| Optimistic....................................................................................... | 3,750,000 | 0.20 |
| Highly optimistic............................................................................. | 4,500,000 | 0.15 |
|
|
| 1.00 |
It was his intention to determine the expected value for sales for the first year and then project a 20 percent growth rate for the next three years and 10 percent for the final two years. Operating expenses, which were expected to average 70 percent of sales, would then be subtracted to determine earnings before depreciation and taxes. The primary investment to be made was in printing and production equipment, which would fall into the five-year MACRS depreciation category. The equipment, which represents the investment for the project, costs $2.8 million.
Mr. Barnes looked into the capital budgeting manual to determine the appropriate discount rate (as shown in Figure 3). The discount rate for the project is based on the coefficient of variation of the first years sales. One of the accounting assistants informed him that the standard deviation of first years sales was $1,226,000. He knew he could easily determine the expected value from the data previously presented (in Figure 2).
Mr. Barnes thought that it was now time to call his assistants together to do the appropriate analysis.
Figure 3 Discount rate determination | Coefficient of Variation | Discount Rate |
| ?0.20 | 8% |
| .21.40 | 10 |
| .41.60 | 14 |
| .61.80 | 16 |
| Over .80 | 20 |
Assignment Tips: Requirement #1 requires several systematic steps to arrive at the answer:
Determine the expected value of the first year's sales. You will need to consider the assumption, sales, and the probabilities.
Project sales for the next 5 years. Year 2 is calculated using the answer from (1).
Then determine operating expenses and EBDT for 6 years. Note: operating expenses are 70% of sales from (2).
Determine the annual depreciation for six years using the five-year MACRS table on page 398 of your text.
Combine the data from (3) and (4) into a table like Table 12-14 on page 400.
Required | 1. Use the basic data in the case to put together an analysis similar to Table 12-14 in the text. To determine earnings before depreciation and taxes (EBDT), subtract projected operating expenses from projected sales. Use a tax rate of 34 percent. 2. Determine the appropriate discount rate for the firm. 3. Make a decision on whether the project is feasible, based on net present value analysis. 4. What is the drawback to using a six-year time horizon for the project?
|
Step 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