For a new product, sales volume in the first year is estimated to be 80,000 units and
Question:
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $ 12 and will increase by $ 0.50 each year. Per unit variable costs are $ 3, and annual fixed costs are $ 400,000. Per unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. Develop a spreadsheet model to calculate the net present value of profit over a 3 year period, assuming a 4% discount rate.
Net Present ValueWhat is NPV? The net present value is an important tool for capital budgeting decision to assess that an investment in a project is worthwhile or not? The net present value of a project is calculated before taking up the investment decision at...
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: