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:

NPV Calculation, Net Present Value

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!

Related Posts with Thumbnails

People who arrived at this page were looking for:

 How to Calculate Discount Factor, rumus net present value, rumus present value, net present value, pengiraan NPV daripada cash flow, rumus discont faktor, yhs-fh_lsonswrow

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
    • March 20, 2011 at 10:19 am
      Papa Bear
  2. March 20, 2011 at 2:15 am
    meo
    • March 20, 2011 at 10:20 am
      Papa Bear
  3. March 20, 2011 at 5:44 am
    Behrad
    • March 20, 2011 at 10:24 am
      Papa Bear
  4. March 20, 2011 at 9:20 am
    Jerung Gergasi
    • March 20, 2011 at 10:30 am
      Papa Bear
  5. March 20, 2011 at 10:52 am
    lankapo
    • March 20, 2011 at 11:06 am
      Papa Bear
  6. March 20, 2011 at 11:42 am
    teaqah
    • March 20, 2011 at 5:53 pm
      Papa Bear
  7. 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
  8. 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
  9. March 20, 2011 at 11:20 pm
    airaniez
    • March 21, 2011 at 11:52 am
      Papa Bear
  10. March 21, 2011 at 3:33 pm
    mie
  11. March 21, 2011 at 5:26 pm
    teaqah
    • March 21, 2011 at 5:37 pm
      Papa Bear
  12. March 21, 2011 at 6:06 pm
    bungaoren
    • March 21, 2011 at 10:58 pm
      Papa Bear
  13. March 21, 2011 at 6:18 pm
    teaqah
    • March 21, 2011 at 11:02 pm
      Papa Bear
  14. March 22, 2011 at 9:04 am
    sufian
    • March 22, 2011 at 10:07 am
      Papa Bear
  15. March 22, 2011 at 5:09 pm
    ardina
    • March 22, 2011 at 11:58 pm
      Papa Bear

Leave a Reply




XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



Please Note: Your comment maybe under moderation. There is no need to resubmit your comments. Subscribe to this post comment rss feeds for future updates. Thank you! This is a Gravatar-enabled blog. To get your own globally-recognized-avatar, please register at Gravatar.

CommentLuv badge

Notify me of followup comments via e-mail. You can also subscribe without commenting.