Question: Please use excel and show work on how you get your answers! 4. For a new product, sales volume in the first year is estimated

Please use excel and show work on how you get your answers!
4. For a new product, sales volume in the first year is estimated to be 122,000 units and is projected to grow at a rate of 5.5% per year. The selling price is $18 and will increase by $1 each year. Per-unit variable costs are $2.80 and annual fixed costs are $425,000. Per-unit costs are expected to increase 3.2% per year. Fixed costs are expected to increase 6% per year. Develop a spreadsheet model to predict the net present value of profit over a three- year period, assuming a 4% discount rate. What will be the NPV if sales volume in year 1 is 130,000 units
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
