English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

3 answers

Use MS Excel to do this extremely simple exercise in project analysis:

1.Forecast the earnings (after tax) per year of the project over the next five years then lay it out on the worksheet from right to left.

2. Increase it at a reasonable rate such as 5% or inflation every year.

3. At the last cash flow (at the fifth year), divide it by 12% and call this terminal value.

4. Now, use this formula by selecting all the cells of the cash flows

=NPV(12%,array of cells)

If the number is positive, then you can go choose this project. If it is negative, then it is a bad investment.

2006-09-04 12:56:24 · answer #1 · answered by J 4 · 0 0

First of all you have to do your homework. You need to do a cost benefit analysis and determine if you will get a return on money invested in the project and in what time frame. Also, you need to determine if the project will be in line with the company's core business and strategic plans. Here is a power Point example: http://www.gagta.com/Project_Selection.ppt

http://www.bright.net/~jpmart/Project_Selection.html

The following link will take you to some project management methods.

http://www.comptechdoc.org/man/begin/manprojintro.html

2006-09-04 17:59:15 · answer #2 · answered by Coleen W 4 · 0 0

Usually ROI.

2006-09-04 15:17:36 · answer #3 · answered by Anonymous · 0 0

fedest.com, questions and answers