## Calculate the Net Present Value

Posted on the March 19th, 2011 under Work by Papa Bear

On Friday I received a question. Should a project be accepted or not? A simple question and should be peanuts for some people. Here are the information related to the project.

1. Investment: RM 1,000,000

2. Revenues: Year 1 – RM 250,000, Year 2 – RM 420,000 and Year 3 – RM 420,000.

3. Total Revenue is RM 1,090,000. Net Revenue is RM 90,000.

4. Discount rate = 10%

What do you think? Simple, right?

The thing is I did not study Accounting and I hardly paid attention during my Engineering Economics 101 in school. This should have been a breeze if otherwise..

It took me about an hour to figure this out. I am rusty all over when it comes to something such as this. Firstly, how do you determine whether this project is attractive or not? I hope you would not say based on the Net Revenue because that will be wrong. From school, the answer would be to find out the Net Present Value (NPV) of the project over the 3 years cycle. So, the next thing to do is look for the formula!

Present Value (PV) = FV / (1 + i)t where FV – the Future Value,  t – the time of the cash flow and i – the annual interest rate

Based on that we need to calculate the Future Value (FV). So, NPV would be the Sum of FV minus the Initial Investment. Since the information provided the discount rate and not interest rate, therefore,

Discount Factor = 1 / (1 + i)t. Discount factor refers to the rate used to discount future cash flows to the present value. So, we then have, FV = PV (1 / (1 + i)t). With all the above information in place, just use MS Excel and run the calculations:

Based on the calculation above, the sum of the Future Value is only RM 889,932.38. As such, the Net Present Value will be -RM 110,067.62, a negative figure. The negative NPV makes this project unattractive. We should not accept this project.

So, if you do not understand this, don’t worry. Just don’t do the kind of job that I do.. Peace!

How to Calculate Discount Factor, rumus net present value, rumus present value, net present value, how to compute discount factor, how to find the discount factor, formula to calculate net present value, NPV Discount Factor, rumus discount factor, engineering economy calculating npv, rumus NVP, economics npv formula pplugin

### 39 Responses to 'Calculate the Net Present Value'

1. March 20, 2011 at 12:43 am
sengkangbabies
• March 20, 2011 at 10:18 am
Papa Bear
2. March 20, 2011 at 1:41 am
KNizam
• March 20, 2011 at 10:19 am
Papa Bear
3. March 20, 2011 at 2:15 am
meo
• March 20, 2011 at 10:20 am
Papa Bear
4. March 20, 2011 at 5:44 am
• March 20, 2011 at 10:24 am
Papa Bear
5. March 20, 2011 at 9:20 am
Jerung Gergasi
• March 20, 2011 at 10:30 am
Papa Bear
6. March 20, 2011 at 10:52 am
lankapo
• March 20, 2011 at 11:06 am
Papa Bear
7. March 20, 2011 at 11:42 am
teaqah
• March 20, 2011 at 5:53 pm
Papa Bear
8. March 20, 2011 at 2:13 pm
yas
• March 20, 2011 at 5:55 pm
Papa Bear
• March 21, 2011 at 3:21 pm
yas
• March 21, 2011 at 5:33 pm
Papa Bear
9. March 20, 2011 at 2:34 pm
Juan
• March 20, 2011 at 5:57 pm
Papa Bear
• March 20, 2011 at 6:38 pm
Juan
• March 20, 2011 at 10:02 pm
Papa Bear
• March 21, 2011 at 2:22 pm
suri
• March 21, 2011 at 2:49 pm
Papa Bear
10. March 20, 2011 at 11:20 pm
airaniez
• March 21, 2011 at 11:52 am
Papa Bear
11. March 21, 2011 at 3:33 pm
mie
• March 21, 2011 at 5:34 pm
Papa Bear
12. March 21, 2011 at 5:26 pm
teaqah
• March 21, 2011 at 5:37 pm
Papa Bear
13. March 21, 2011 at 6:06 pm
bungaoren
• March 21, 2011 at 10:58 pm
Papa Bear
14. March 21, 2011 at 6:18 pm
teaqah
• March 21, 2011 at 11:02 pm
Papa Bear
15. March 22, 2011 at 9:04 am
sufian
• March 22, 2011 at 10:07 am
Papa Bear
16. March 22, 2011 at 5:09 pm
ardina
• March 22, 2011 at 11:58 pm
Papa Bear