Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual cash receipts resulting from this machine are predicted to be $45,000. The companys required rate of return is 15 percent.

a) Use Excel to calculate the net present value.

( b) Use Excel to calculate the internal rate of return.