Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help calculating Part 2: the NPV and IRR. please explain. Information from Part one is already calculated and included below. Thank you for the

image text in transcribedimage text in transcribed

Need help calculating Part 2: the NPV and IRR. please explain. Information from Part one is already calculated and included below. Thank you for the help!

Part 2:

Later, the company is considering the purchase of machinery and equipment to set up a line to produce a combination washer-dryer. They have given you the following information to analyze the project on a 5-year timeline:

  • Initial cash outlay is $150,000, no residual value.
  • Sales price is expected to be $2,250 per unit, with $595 per unit in labor expense and $795 per unit in materials.
  • Direct fixed costs are estimated to run $20,750 per month.
  • Cost of capital is 8%, and the required rate of return is 10%.
  • They will incur all operational costs in Year 1, though sales are expected to be 55% of break-even.
  • Break-even (considering only direct fixed costs) is expected to occur in Year 2.
  • Variable costs will increase 2% each year, starting in Year 3.
  • Sales are estimated to grow by 10%, 15%, and 20% for years 3 - 5.

They have asked you to calculate:

  • The product's contribution margin = 860 (already calculated)
  • Break-even quantity = 290 (already Calculated)
  • NPV ???? (Need Help)
  • IRR???? (need Help)

Information from part 1 (Already Done):

image text in transcribedimage text in transcribedimage text in transcribed
\fBreakeven Qty Yearly: Particulars High End Economical a. Direct Fixed Cost 25000 16500 b. Allocated Fixed Cost 85000 85000 c. Total Fixed Costs/Month 110000 101500 d. Total Fixed Costs / Year 110000*12 = 1,320,000 101500*12= 1,218,000 e. Contribution Margin 1225 450 Break-even qty (d/e) 1077.5 - 1078 units 2706.6 - 2707 units Breakeven 500k, 300K: Particulars High End (500k) Low End (300k) a. Total Fixed Costs /YR 1,320,000 1,218,000 b. Desired Profit 500000 300000 C. Total (a+b) 1,820,000 1,518,000 d. Contribution margin per 1225 450 unit Break Even qty (c / d) 1,485.7 - 1486 units 3,373.3 - 3,374 units1. For your first assignment, management has provided the following revenue and cost information: High-End Set Economical Set Sales price $3,500 per unit $1,000 per unit Labor $875 per unit $250 per unit Materials $1400 per unit $300 per unit Direct fixed costs $25,000 per month $16,500 per month Allocated fixed costs $85,000 per month $85,000 per month They want a better understanding of their business to make budgeting and sales goals decisions and have asked you to determine their: 1. Contribution Margins for each product line 2. Break-even quantities for each product line 3. Break-even quantities to earn $500,000 per year margin on the high-end line (at the current sales price) 4. Break-even quantities to earn $300,000 per year margin on the economical line (at the current sales price) They expect the product lines to fully absorb the costs allocated to them. They have also asked that you show each step in your calculations so that they can understand your analysis. (Note: you will be graded on your intermediary values.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra C. Jeter, Paul K. Chaney

7th edition

1119373204, 9781119373254 , 978-1119373209

More Books

Students also viewed these Accounting questions

Question

How does an audit increase the credibility of financial statements?

Answered: 1 week ago

Question

What do you need to know about your students to motivate them?

Answered: 1 week ago