Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. mcgilla golf has decided to sell a new line of gol

McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell...

Free

60.1K

Verified Solution

Question

Finance

McGilla Golf has decided to sell a new line of golf clubs. Theclubs will sell for $793 per set and have a variable cost of $426per set. The company has spent $195392 for a marketing study thatdetermined the company will sell 5540 sets per year for sevenyears. The marketing study also determined that the company willlose sales of 975 sets of its high-priced clubs. The high-pricedclubs sell at $1144 and have variable costs of $684. The companywill also increase sales of its cheap clubs by 1064 sets. The cheapclubs sell for $448 and have variable costs of $206 per set. Thefixed costs each year will be $923933. The company has also spent$106620 on research and development for the new clubs. The plantand equipment required will cost $2889108 and will be depreciatedon a straight-line basis. The new clubs will also require anincrease in net working capital of $131019 that will be returned atthe end of the project. The tax rate is 29 percent, and the cost ofcapital is 8 percent. What is the sensitivity of the NPV to changesin the quantity of the new clubs sold?

Answer & Explanation Solved by verified expert
3.8 Ratings (653 Votes)

McGilla 0 1 2 3 4 5 6 7
Investment -$2,889,108
NWC -$131,019 $131,019
Sales $4,393,220 $4,393,220 $4,393,220 $4,393,220 $4,393,220 $4,393,220 $4,393,220
VC -$2,360,040 -$2,360,040 -$2,360,040 -$2,360,040 -$2,360,040 -$2,360,040 -$2,360,040
FC -$923,933 -$923,933 -$923,933 -$923,933 -$923,933 -$923,933 -$923,933
Cannibalization -$191,012 -$191,012 -$191,012 -$191,012 -$191,012 -$191,012 -$191,012
Depreciation -$412,730 -$412,730 -$412,730 -$412,730 -$412,730 -$412,730 -$412,730
EBT $505,505 $505,505 $505,505 $505,505 $505,505 $505,505 $505,505
Tax (29%) -$146,597 -$146,597 -$146,597 -$146,597 -$146,597 -$146,597 -$146,597
Net Income $358,909 $358,909 $358,909 $358,909 $358,909 $358,909 $358,909
Cash Flows -$3,020,127 $771,638 $771,638 $771,638 $771,638 $771,638 $771,638 $902,657
NPV $1,073,756.74

The above is the base case NPV.

In order to calculate the sensitivity, we need to find the new NPV with 1 unit of sales higher, i.e. 5541.

New NPV = $1,075,113.36

Sensitivity = Difference in NPV = $1,356.62
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1. Suppose we are forming committees within the US Senate. We know there are 100 members...

Basic Math
Q

Compare and contrast the mechanisms of how populations evolve over time. Discuss how new species can...

Biology
Q

Which literary device s would be best to include as the topic of this excerpt...

Biology
Q

please make me understand I am not getting understand Please explain in detail so that...

Physics
Q

and h 0 a Does f 3 1 f 3 f 1 Yes No b...

Basic Math
Q

Find the y intercept 2x 1 x 7 x 3 x 4 y 123 Enter...

Algebra
Q

Question 25 of 60 The buyer and the seller have agreed that the seller will...

Algebra
Q

Match the function with the correct domain a f x x b f x x...

Algebra
Q

E16.17 (EPS: Simple Capital Structure) SCR Company had 600,000 shares of common stock outstanding on...

Accounting
Q

Andretti Company has a single product called a Dak. The company normally produces and sells...

Accounting
Q

Prepare vertical common-size balance sheets and income statements for 3 years Republic Services, Inc. ...

Accounting
Q

ssts sinde0 258120 11sece

Accounting