Find the cash flow

Assignment Help Other Subject
Reference no: EM131240136

Find the cash flow of those 3 scenarios and recommendations for the 3 decisions.

NEW HAMPSHIRE RACING, INC.

The Situation

In June of 2000, Bryan D'Ander was hired by New Hampshire Racing, Inc. (NHR), and assigned to work in the finance department. NHR, located in New Hampshire and founded in 1990, is a producer of racing collectibles and memorabilia, specializing in personalizing clothing accessories such as hats, shirts, and jackets. Racing has always been a popular sport, but, over the last decade, racing had become one of the largest nationwide spectator sports. In New Hampshire, the mid-size Loudon speedway, which was on the NASCAR circuit, held two major racing events each year. Each race was drawing well over 100,000 high-spirited fans, and there was a growing demand for racing items sold at the tracks on race day. NHR's success had risen along With the sport's popularity and the good economic times of the last 10 years.

Bryan had recently graduated from a large university in the Northeast with a B.S. in Finance and Economics. During his senior year in college, Bryan had taken, as required by his major, a corporate finance course where he learned about capital budgeting and assessing and valuing projects. In addition, Bryan had been a Learning Center tutor, working with other students who needed help with their Accounting and Finance courses. So Bryan was one of the fortunate ones. Not only did he get a job soon after graduating, but he also was assigned to a department where he could use his education and training.

NHR's Chief Financial Officer, Ms. Miles, was aware of Bryan's background, and thought a good first assignment for him would be to examine six recently proposed projects-three pairs of mutually exclusive projects, to be exact The NHR staff barely had started the analyses on these projects, so it would not be difficult for Bryan to come up to speed. That said, however, a decision on these projects would have to be made soon. NHR's CEO, Mr. LaBlanc, was scheduled to meet with Ms. Miles later in the week. Bryan did not have much time.

Bryan gathered up the data collected so far on these projects, headed back to his desk, and started in. He wanted to make a good impression, so he was determined to have a proper valuation completed and recommendation written before his boss' meeting with Mr. LaBlanc.

A. New T-Shirt Orders                   

The first set of projects consisted of two new t-shirt orders that NHR recently had received. Since NIIR's screen printing production facilities were operating close to full capacity and the customers needed their first deliveries quickly, only one of the projects could be accepted. There just was not time to order and install new machinery to meet the combined demand of the new orders.

The first order was from Illinois Speedway. This speedway had been around for 25 years, and was one of NHR's loyal and regular customers. Since the speedway was built so long ago, it did not have all the amenities of the newer, more modern racing tracks. Consequently, a new racing track was to be built, and was slated to open in about four years. Once the new race track was up and running, the current speedway would be closed down. The owners of the Illinois Speedway wanted to have t-shirts commemorating the historic speedway to sell at races over the next four years. Projected sales of the commemorative t-shirts were expected to decline over the four years leading up to the opening of the new race track.

Table 1 - Projected Sales to Illinois Speedway

Year

0

1

2

3

4

 

 

$1,000,000

$850,000

$500,000

$275,000

The second order was from North Carolina based Smith Racing. The race car team recently had added a new driver, John Jones, who was catching on very quickly. The Smith Racing order called for delivery of t-shirts over the next four years, as that is how long Jones had signed on to race for Smith Racing. Given the growing demand for "JJ" t-shirts, the projected sales were expected to increase dramatically over the next four years.

What's more, many people were projecting that Jones would be the next major star in auto racing. There already had been talk in racing circles that Jones was going to sign on for another 4 years, and that his contract renewal was almost certain. If this happened, there was also a potential for future, major "JP collectibles and memorabilia orders.

Table 2 - Projected Sales to Smith Racing

Year

0

1

2

3

4

 

 

$275,000

$400,000

$925,000

$1,500,000

The two orders had the same costs.

a. Cost of goods sold would be 70% of sales.

b. Administrative costs would be 10% of sales.

c. Start up costs would be $25,000, and would be expensed immediately.

d. New folding/packaging machine would cost $150,000, and have a salvage value of $10,000 at end of 4 years.

e. The MACRS 3-year depreciation schedule would be used.

Modified Accelerated Cost Recovery System (MACRS)

Year 1

33%

Year 2

45%

Year 3

15%

Year 4

7%

Total

100%

f. NHR's effective tax rate was 27%.

g. Appropriate discount rate would be 10%.

B. Additional Screen Printing Machine

 The second set of projects involved the purchase of a new t-shirt screen printing machine. NHR had been receiving a large number of new orders, yet the company had to turn down the majority of the orders. As evidenced by the Illinois Speedway and Smith Racing orders, NHR just did not have enough production capacity to meet demand.

There was no doubt that NI-IR needed an additional screen printing machine. The question was what size machine to purchase. A smaller machine would have a lower initial cost, and would allow MR to accept the majority of the new orders it had been receiving. On the other hand, a larger machine would cost substantially more, true, but a larger machine would not only allow NHR to accept all the orders it had been turning down, but also would allow for a substantial increase in production. Given auto racing was more popular than ever before, as well as the potential future orders for "ll" t-shirts, NHR just might need the additional production capacity. Moreover, Mr. LaBlanc had been hinting that he would like to expand beyond auto racing and into additional sport markets.

The smaller printing machine would cost $600,000 to purchase, deliver, and install. This machine would produce sales of $1,150,000 a year, and would have an 8 year life and an estimated $20,000 salvage value,

The larger printing machine would cost $1,000,000 to purchase, deliver, and install. This machine would produce sales of $1,750,000 a year, and would have an 8 year life and an estimated $45,000 salvage value.

An additional issue here, for both the smaller and the larger new screen printing machines, is that some of the sales attributed to the new machines actually would come from orders that could be completed using NFIR's existing machine. These "duplicated" sales were estimated to be $100,000 per year for the remaining four year lives of NFIR's existing printing machine. The cost of goods sold for these duplicated sales would be the same for all machines-old and new, small and large.

The two printing machines had the same following costs,

a. Cost of goods sold would be 70% of sales.

b. Administrative costs would be 10% of net sales.

c. The MACRS 5-year depreciation schedule would be used.

Modified Accelerated Cost Recovery System (MACRS)

Year 1

20%

Year 2

32%

Year 3

19%

Year 4

12%

Year 5

11%

Year 6

6%

Total

100%

d. NHR's effective tax rate was 27%.

e. Appropriate discount rate would be 14%.

C. Replacement Embroidery Machine

The last set of projects Bryan was to examine consisted of two alternatives for replacing an existing, and old, embroidery machine. The existing machine was not only old, but was also outdated when compared to the newer machines now on the market. Embroidery machine technology had certainly advanced in the last few years. The old machine, not surprisingly, was fully depreciated, but still had an estimated $2,000 salvage value. NHR was considering one of two new machines to replace the existing one.

The first embroidery machine under consideration would cost $130,000 to purchase, deliver, and install, and would have a 5 year life and an estimated $2,500 salvage value.

The embroidery second machine would cost $200,000 to purchase, deliver, and install, and would have a 10 year life and an estimated $4,000 salvage value.

The two machines under consideration had the same following savings and costs.

a. Savings would be $50,000 per year.

b. The MACRS 5-year depreciation schedule again would be used.

c. NHR's effective tax rate was 27%.

d. Appropriate discount rate would be 14%.

Reference no: EM131240136

Questions Cloud

What is the value of a derivative : Explain why a regular European call option is the sum of a down-and-out European call and a down-and-in European call.
Calculate the return on assets and average collection : Calculate the following ratios for 2013. The 2012 results are given for comparative purposes. Comment on the changes between the two years
How many pounds of peaches paula had to buy : division equations ... Paula is baking peach pies for a bake sale. each pie requires 2 pounds of peaches. She bakes 6 pies. Write and solve an equation to find out how many pounds of peaches Paula had to buy.
Definition of a perfect square predicate : a. Using the language of predicate logic, show how to fill in the blank to get a complete definition of a Perfect Square predicate that matches the definition for a natural number being a perfect
Find the cash flow : Find the cash flow of those 3 scenarios and recommendations for the 3 decisions. The first set of projects consisted of two new t-shirt orders that NHR recently had received. Since NIIR's screen printing production facilities were operating close t..
What is the value of a regular call option on silver futures : Explain how the option works and calculate its value. - What is the value of a regular call option on silver futures with the same terms?
Compare and contrast the leadership styles : Using the six key dimensions of strategic leadership, compare GM's CEO, Roger Smith with Southwest's Herb Kelleher and Colleen Barrett. Compare and contrast the leadership styles.Which do you prefer and why?
Network nodes to perform name resolution : Link-Local Multicast Name Resolution (LLMNR) (defined by RFC 4795), is a protocol based on the DNS packet format. LLMNR allows IPv4 and IPv6 network nodes to perform name resolution for other devices connected to the same local link. How is it sim..
Estimate the value of a new 6 month european style : The current level of the index is 400, the risk-free rate is 6% per annum, the dividend yield on the index is 4% per annum, and the volatility of the index is 20%. Use DerivaGem to value the option.

Reviews

len1240136

10/12/2016 7:02:12 AM

There are three parts in the case study it should be done in excel sheet all three parts and the solutions is needed for the case study. It gives different types of scenarios and we have to find the cash flow of those three scenarios and recommendations for the three decisions.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd