Ask Experts Questions for FREE Help !
Ask
    Freda's Avatar
    Freda Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 21, 2007, 03:41 PM
    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's Avatar
    ton_ty2275 Posts: 41, Reputation: 6
    Junior Member
    		  
    #2

    Jun 29, 2007, 09: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's Avatar
    croketizame Posts: 3, Reputation: 2
    New Member
    		  
    #3

    Aug 25, 2007, 03: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
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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,...

View more questions Search