Develop spreadsheet model to calculate net present value

Assignment Help Operation Management

Reference no: EM131785356

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.

Reference no: EM131785356

Questions Cloud

What interest rate compounded semiannually : Suppose you made a single investment with principal equal to the amount paid in part (a), and after 3 years you received a single lump sum return equal.

Drysdale dairy produces a variety of dairy products : Drysdale Dairy produces a variety of dairy products. In Department 12, cream (transferred in from Department 6) and other materials

Determine the charges to the COMM sector : Exercise - Service department charges and activity bases, Determine the charges to the COMM sector for the four CCS service categories for April

Legal powers of an individual : is an entity created by law they have the legal powers of an individual in that it can sue and be sued, make and be party to contracts, and acquire property

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

Determine the equivalent single shaft system : Determine the equivalent single shaft system and establish the natural frequencies.

How much did kevin have in the account : Kevin Patrick paid off the loan he took out to buy his car, but once the loan was paid, he continued to deposit $400 on the first of each month in an account.

Create operating activity section of statement of cash flows : Thornton Company's income statement contained the condensed. Create the operating activities section of the statement of cash flows using the indirect method.

Pitfalls posed by inequalities of one cognitive accounting : How would you avoid the pitfalls posed by the inequalities of one’s cognitive accounting?

User Account

All Pages