Phelps Toy Company Accounting Case Study Assignment

Anonymous
timer Asked: Apr 16th, 2019
account_balance_wallet $19.99

Question Description

Assignment requirements: Please answer all questions. You may use Excel and/or Word to complete the assignment. SHOW ALL WORK! Points will be deducted for not providing detailed calculations. When fulfilling a requirement that asks for a recommendation, please write in complete sentences.

Assignment Tips: Requirement #1 requires several systematic steps to arrive at the answer:

  1. Determine the expected value of the first year's sales. You will need to consider the assumption, sales, and the probabilities.
  2. Project sales for the next 5 years. Year 2 is calculated using the answer from (1).
  3. Then determine operating expenses and EBDT for 6 years. Note: operating expenses are 70% of sales from (2).
  4. Determine the annual depreciation for six years using the five-year MACRS table on page 398 of your text.
  5. Combine the data from (3) and (4) into a table like Table 12-14 on page 400.

Unformatted Attachment Preview

CASE 19 Phelps Toy Company The Phelps Toy Company was considering the advisability of adding a new product to its line. Ike Barnes was in charge of new product development. Since the founding of the company in 1995, he had seen sales grow from $150,000 a year to almost $40 million in 2015. Although the firm had initially started out manufacturing toy trucks, it had diversified into such items as puzzles, stuffed animals, wall posters, miniature trains, and board games. In 2009, it developed the third most popular board game for the year, based on a popular television quiz show, but the show was canceled two years later. Nevertheless, the firm learned its lesson well and continued to produce board games related not only to quiz shows but to situation comedies and even a popular detective series. However, by January of 2016, the need to generate new products was becoming evident. As can be seen in Figure 1, sales and net income were beginning to level off after the previously cited phenomenal growth. After doing a market analysis of possible products, Mr. Barnes decided that the baseball card market was a good area for potential new sales. Baseball cards were a popular product not only among youngsters but also among adults who were trying to recapture the experience of their youth. A market survey by Ikes Barnes indicated that the Topps Chewing Gum Company was the largest competitor in the industry. The company actually had a public distribution of its common stock in 2001. Other major sellers in 2016 were Upper Deck, Fleer, Leaf, and Donruss. All produce millions of baseball cards on an annual basis. The cards can be purchased in packs of 15–20 cards for $3.00–$8.00 at drug or convenience stores* or in boxes of 700-800 cards for $40 and up. These larger quantities of cards were usually purchased from sport card specialty stores or at baseball card conventions (over 1,000 such conventions throughout the country took place a year). In doing his analysis, Mr. Barnes discovered that the appeal of baseball cards was not only in opening a wrapper and finding a favorite player enclosed but also that any baseball cards initially purchased for pennies had gained substantially in value. Once a player achieved star status, his rookie card (first issued) might greatly increase in worth. *Some packs are more expensive than others due to quality and buyer preference. Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. Case 19 Figure 1 Phelps Toy Company Year 1997............................................................... 1998............................................................... 1999............................................................... 2000............................................................... 2001............................................................... 2002............................................................... 2003............................................................... 2004............................................................... 2005............................................................... 2006............................................................... 2007............................................................... 2008............................................................... 2009............................................................... 2010............................................................... 2011............................................................... 2012............................................................... 2013............................................................... 2014............................................................... 2015............................................................... Sales $ 150,000 240,000 756,000 1,340,000 2,680,000 3,320,000 5,580,000 6,792,000 5,941,000 9,237,000 11,622,000 12,140,000 17,165,000 22,838,000 27,762,000 32,437,000 38,911,000 39,750,000 39,860,000 Net Income $ (16,000) (5,000) 72,000 91,000 175,000 198,000 248,000 387,000 291,000 439,000 566,000 621,000 850,000 1,221,000 1,437,000 1,628,000 1,762,000 2,002,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. Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. Phelps Toy Company 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 .......................................... Normal ................................................ Optimistic ............................................ Highly optimistic .................................. $1,100,000 2,000,000 3,750,000 4,500,000 0.25 0.40 0.20 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 year’s sales. One of the accounting assistants informed him that the standard deviation of first year’s 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 .21–.40 .41–.60 .61–.80 Over .80 8% 10 14 16 20 Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. Case 19 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? Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. ...
Purchase answer to see full attachment

Tutor Answer

Super_Teach12
School: University of Virginia

Hi, ;). here is your assignment :). it was done through excel :). Let me know if you need more help okay :). Goodluck ;)

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.
Answer:
Phelps Toy Company
First, let us determine the expected value for the first year
Supposed
Pessimist
Normal
Optimistic
Highly Optimistic

Year 2
Year 3
Year 4
Year 5
Year 6

Sales
$1,100,000
$2,000,000
$3,750,000
$4,500,000

Costs Effectiveness
0.25
0.4
0.2
0.15
Total

After Sales Projected for the next 5 years
$2,500,000
$3,000,000
$3,600,000
$4,320,000
$4,752,000

1.20%
1.20%
1.20%
1.2...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors