You are considering a project that will supply an automobile production facility with 35,000 tonnes of machine screws annually for five years. To get the project started, you will need an initial $1,500,000 investment in threading equipment. The project will last for five years. The accounting department estimates that annual fixed costs will be $300,000 and that variable costs should be $200 per tonne. The CCA rate for treading equipment is 20%. Accounting estimates a salvage value of $500,000 after costs of dismantling. The marketing department estimates that the auto makers will accept the contract at a selling price of $230 per tonne. The engineering department estimates you will need an initial net working capital investment of $450,000. You require a 13% return and face a marginal tax rate of 38% on this project.

a. What is the NPV for this project? Should you pursue this project?

b. Suppose you believe that the accounting departments initial cost and salvage projections are accurate only to within 15%; the marketing departments price estimate is accurate only to within 10%; and the engineering departments net working capital estimate is accurate only to within 5%. What is your worst-case scenario for this project? Your best-case scenario?

for a)IF I could get the step by step formula to use and not Excel that would be great. If it were straight line I'd use the OCF=((P-v)Q-FC)(1-t)+(t)(D) but since the CCA is 20% I cannot remember what formula to use. If I use PVCCATs then I get 263,083.6373 can I use that as D? (It is the depreciation value its just not straight line)