Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Use Excel to answer the questions. Pappy's Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). It
Use Excel to answer the questions. Pappy's 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. The fixed costs associated with this will be $179,000 per year, and variable costs will amount to 22 percent of sales. The equipment necessary for production of the Potato Pet will cost $1,040,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 $10,500 at the beginning. Pappy's is in a 35 percent tax bracket and has a required return of 14 percent. 1. Compute the NPV and Payback Period of the project. Is the project acceptable? 2. Do the following scenario analyses: a. What if the sales level is 50% higher than the current estimate? Compute the NPV and IRR of the project. b. What if the sales level is 75% higher than the current estimate? Compute the NPV and IRR of the project. c. What if the sales level is 50% lower than the current estimate? Compute the NPV and IRR of the project. d. What if the sales level is 75% lower than the current estimate? Compute the NPV and IRR of the project. 3. What is the breakeven price of the equipment? (What price of the equipment will make the NPV equal zero?)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started