The benefits and costs of an investment project the

Reference no: EM13374047

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?

End of Year Investment Revenue NE PV Coefficient 1/(1+0.5)n PVNR

0 1000 ----

1 200 600

2 300 800

3 300 800

4 400 800

4 --- 200 (salvage value)

Reference no: EM13374047

Questions Cloud

3 make a list of common fallacies and generalizations : 3. make a list of common fallacies and generalizations abouta. men f. reagaetonb. women g. secretariesc. police

Write a research paper on no child left behind write it in : write a research paper on no child left behind write it in total 1200 words and it should properly

Using a spreadsheet like the following entering formulas : using a spreadsheet like the following entering formulas for the total revenue and consumers surplus and given the

Assignment goal practice thinking critically about research : assignment goal practice thinking critically about research topics and sources. post your completed worksheet on

The benefits and costs of an investment project the : the benefits and costs of an investment project the purchase of a piece of machinery are those given in the following

Spreadsheet 2 an individual is considering two investment : spreadsheet 2. an individual is considering two investment projects. project a will return a zero profit if conditions

1as we look at and identify several examples of material : 1.as we look at and identify several examples of material culture that have been positive and negative one question

Problem 1 an individual has to choose between investment a : problem 1. an individual has to choose between investment a and investment b. the individual estimates that the income

You need to hire some new employees to staff your startup : you need to hire some new employees to staff your startup venture. you know that potential employees are distributed

User Account

All Pages