For a new product, sales volume in the first year is estimated to be 120,500 units and is projected to grow at a rate of 5.4% per year. The selling price is $16 and will increase by $1 each year. Per-unit variable costs are $2.75 and annual fixed costs are $420,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 125,000 units?

Answer rating: 100% (QA)

To predict the net present value NPV of profit over a threeyear period we can use the following step... View the full answer