> NPV with straight line depreciation?

NPV with straight line depreciation?

Posted at: 2014-12-05 
I calculated the same answer. My calculations with formulas below.



Creighton Industries is considering the purchase of a new strapping machine, which will cost $120,000, plus an additional $7,500 to ship and install. The new machine will have a 5-year useful life and will be depreciated to zero using the straight-line method. The machine is expected to generate new sales of $25,000 per year and is expected to save $17,000 in labor and electrical expenses each year over the next 5-years. The machine is expected to have a salvage value of $30,000. Creighton uses a 13.5% discount rate for capital budgeting purposes and the firm's income tax rate is 40%. What is the machine's NPV?

I worked this problem out on my excel program and got an answer of $5062 but I am unable to set the problem up and solve it by hand and get the same answer. If anyone could show me how to correctly set the problem up I would really appreciate it. Thanks