# How do you calculate net present value NPV

How do you calaulate NPV

NPV = \$60 + \$60
__________ - \$100
(1+r) (1 +r)2

investment cost \$100
expected result in revenues of \$60 in 2 years
r = 0.10

 ton_ty2275 Posts: 41, Reputation: 41 Junior Member #2 Jun 29, 2007, 10:21 PM
Quote:
 Originally Posted by Freda How do you calaulate NPV NPV = \$60 + \$60 __________ - \$100 (1+r) (1 +r)2 investment cost \$100 expected result in revenues of \$60 in 2 years r = 0.10
Hello,

NPV can also be calculated using the popular "MS Excel" software or you can enter calculations manually via an appropriate NVP calculator. There are also Net Present Value Tables for calculating the NVP as well.

Using Excel’s NPV function you can fill in the cost of capital and annual cash flows, and Excel does the rest---these days

The general perpetuity formula is: (when the investment period is unknown/infinite)

NPV = Cash Flow / rate

You can also calculate the NPV of an investment by using a discount rate (specified rate of return aka similar to interest) and a series of future payments (negative values) and income (positive values). NPV is based on "future cashflow" estimates and payments over a specified period.

Here's a website for using an online NVP calculator.
Net present value Calculator

Here's a website for using Excel spreadsheets and NVP.
Calculating Net Present Value and IRR Using Excel

I must say with the problem you have indicated above---it is likely that it will end up on the minus/ or negative side.

Hope this helps.
Tomy M. Hall, MS
 croketizame Posts: 3, Reputation: 5 New Member #3 Aug 25, 2007, 04:09 PM
The NPV is nothing else but a sum of all the cashflows of a project discounted to the present time. If you want to calculate one, you can use this webpage:

NPV Calculator

## Check out some similar questions!

Net Present Value Analysis [ 3 Answers ]

In eight years, Kent Duncan will retire. He is exploring the possibility of opening a self-service car wash. The car wash could be managed in the free time he has available from his regular occupation, and it could be closed easily when he retires. After careful study, Mr Duncan has detrmined the...

Net sales, cost of goods, net profit [ 2 Answers ]

Les Fleurs, a boutique in Paris, France, had the following accounts in its accounting records at December 31, 20X2 (amounts in Euros, denoted as "E") Purchases………………... E250,000 Freight In……………… E8,000 Sales discounts…………. 4,000 Purchase returns…….. 7,000 Inventory Sales…………………. ...

Net Present Value [ 1 Answers ]

Your company plans to acquire one of two assets. Asset A costs \$162,500, and has expected annual cash savings of \$37,500. Asset B costs \$225,000, and has expected annual cash savings of \$77,500. You'll use straight-line depreciation for both assets over their estimated useful lives of 5 years,...

Net Present Value and Internal Rate of Return Method [ 1 Answers ]

I want to know if an investment during the past four years have earned at least a 12% return. a) A small building was purchased for \$50,000.00. Received rental income of \$8,000.00 for each of the four years and sold the building this year for \$55,000.00. Using the net present value method,...