Bear, Diah and Pasha

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!

People who arrived at this page were looking for:

 How to Calculate Discount Factor, rumus net present value, net present value, rumus present value, how to calculate discount factors, how to count discount factors, Guillermo net present value, npv guillermo, how to calculate discount rate for present value, formula mengira revenue, artikel rumus npv, BAGAIMANA MENGIRA PRESENT VALUE, yhs-geneiotransfer, how to find sum of discounting factor in excel, Rumus present value dan future value, guillermo npv future cash flows, help me calcualte npv for guillermo, how to calculate discount factor accounting, rumus present value cash outflow, how to calculate discount rate for npv, rumus future value, how to calculate the discount factor, RUMUS DISCOUNT, npv for guillermo, kira present value, how to find guillermo discount rate, cara formula nak kira warrant invest, cara kira npv, calculate net present value of a project, macam mana nak kira government tax guna excell, macam mana nak kira rupiah ke rm, macamana nak kira net price, mcm mana nak kene nobor ekor, mengira times value of money, microsoft sponsored links present value, calculate net present value school, Net Present Value Formula, net present value guillermo, net present value how to get discount factor, npv calculation guillermo, how to count discount rate, macam mana nak kira commission coway, how to count discount rate for my project, How to find Discount factor at 10% of Net present value calculation?, calculating guillermos npv, free calculate net present value guillermo, how to find the discount factor, how to work out discount factor, how tocalculate discount factors in accounts, IN EXCEL HOW DO YOU CALCULATE THE NET PRESENT VALUE/, kira npv, kira percent guna excel, calculate the discount factor, kira rupiah ke RM, macam mana nak guna sum excel, npv cash flow guillermo, calculate net present value guillermo, rumus nett present value, rumus not present value, bagaimana nak kira npv guna financial calculator, bagaimana nak guna microsoft excel, bagaimana guna microsoft groove, Rumus pv cash flows, sum of npv, tip mengira discount?, weaknesses of net present value, what is the net present value of future cash flows for guillermo, where to find npv in guillermo, work out discount factor, work out discount factors, rumus net present world, belajar kira persent, calculate net present value, npv of guillermo, present value caculation, present value formula, question of net present value, rumus cash flow in project, rumus dari discount factor, calculate discount rate in excel, rumus discount faktor excel, calculate discount factor npv, rumus net ocf, rumus net operating cash flow, rumus net presen value, nak wat kira kira npv, cara mengira net present value (NPV), discount rate used in Guillermo, discounting factor for npv, excel guillermo npv, Figure Net Present Value, find the net present value of a project, formula for calculating npv, Formula for Net Present Value, formula in calculating total discounting factor in excel, formula kira avtc, formula kira NPV, formula mengira future value, cara masuki rumus gauss ke microsoft excel, discount rate for npv 2011