Calculate the net present value of profit

Assignment Help Financial Management

Reference no: EM132011754

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.

a. Develop a spreadsheet model to calculate the net present value of profit over a 3-year period, assuming a 4% discount rate.

b. Construct a tornado chart and explain the sensitivity of each of the model’s parameters on the NPV of profit.

c. Suppose that the first-year sales volume is normally distributed with a mean of 100,000 units and a standard deviation of 10,000. Use the NORM.INV function and a one-way data table to conduct a Monte Carlo simulation to find the distribution of the net present value profit over the 3-year period.

Reference no: EM132011754

Questions Cloud

Covered interest arbitrage : How much profit can be made with covered interest arbitrage, by borrowing 1 million USD?

Prepare a paper about organizational change : Your Project Assignment (due Week Four) is to prepare a paper about Organizational Change. You can talk about the reasons for change, resistance to change.

Which learning theory would you use to design : Which learning theory would you use to design it and why would you use that one? Describe two or three specific actions would you take to make help employees.

Cash flows are also known as non-simple cash flows : Conventional cash flows are also known as non-simple cash flows. If the projects are independent, the AW at the MARR is calculated.

Calculate the net present value of profit : Develop a spreadsheet model to calculate the net present value of profit over a 3-year period, assuming a 4% discount rate.

Isolate the effect of reading on student achievement : how what can we do in terms of experimental and non-experimental methods to isolate the effect of reading on student achievement?

Your expectations of exchange rate change : If you conduct a speculative trade on your expectations of exchange rate change,

Cost of capital estimate be before your purchase decision : Prepare an NPV profile of the purchase. How far off could? OpenSeas' cost of capital estimate be before your purchase decision would? change?

Submitted bid for large consulting contract : You work for a consulting firm, and have submitted a bid for a large consulting contract.

User Account

All Pages