Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pappys Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). It is expected that Potato Pet will

Pappys Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). It is expected that Potato Pet will generate sales of $575,000 per year over next four years. The fixed costs associated with this will be $179,000 per year, and variable costs will amount to 20 percent of sales. The equipment necessary for production of the Potato Pet will cost $960,000 and will be depreciated to zero in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). The equipment will require an increase in working capital (spare parts inventory) of $8,000 at the beginning. Pappys is in a 35 percent tax bracket and has a required return of 14 percent.

[Use Excel to answer the questions. Without Excel worksheet, no credit will be earned.]

1. What is the NPV and IRR of the project? Is the project acceptable?

2. What is the breakeven price of the equipment? (What price of the equipment will make the NPV equal zero?)

Please show excel formulas!

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions

Question

What is time famine?

Answered: 1 week ago