Spreadsheet model to calculate net present value of profit

Assignment Help Financial Management

Reference no: EM131917937

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.

Also how do I do the calculations on execel?

Reference no: EM131917937

Questions Cloud

Calculate the financial ratios below for the year : omplete the financial ratios for the company in the 2014 column. Calculate the financial ratios below for the year 2014.

Difference between underwriting and market making : What is the difference between underwriting and market making ?

Net profit margin gross margin operating margin return : Net Profit Margin Gross Margin Operating Margin Return on Assets Return on Equity Liquidity Ratios:

Net present value method and project is unacceptable : Cyan Inc. uses the net present value (NPV) method and determines that the project is unacceptable.

Spreadsheet model to calculate 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.

Two other combinations of loans : Suggest two other combinations of loans, options and the underlying stock that would give the person the same payoffs

How much money will shareholders have after three years : How much money will shareholders have after 3 years under each of George's alternatives and what should he do?

Which offers accounting rate of return : n alternative (mutually exclusive) project is available which offers an accounting rate of return of 8%, a classical payback period of 5 years

Calculate the project internal rate of return : Calculate the project's internal rate of return. What is the aftertax salvage value of this manufacturing plant?

User Account

All Pages