The benefits and costs of an investment project (the purchase of a piece of machinery) are those given in the following table. In Excel, calculate net revenue, or the revenue from the investment minus the costs; the present value coefficient for every year; and the present value of the net revenue. Add together column F to get the net present value of the project. Should the firm purchase the machine?

Transcribed Image Text:

Present Value Present End of Investment Revenue Net (Year O_ and Cost Coefficient Value of Year Revenue 1/(1+0.5)n Net Revenue 1000 1. 200 600 300 800 800 3 300 400 800 200* 2. 4) 4,