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

    Oct 4, 2009, 12:55 PM
    How to calculate NPV using an excel spreadsheet
    I want to use an excel spreadsheet to calculate the value of a flow of net income at a certain rate. Lets say the net income (revenues less expenses) is for 10 years. Ex; value of a commercial building with a purchase price, a stream of revenue and expenses over ten years discounted a certain rate
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 4, 2009, 08:11 PM

    NPV() is a standard Excel Function.

    Enter =NPV( into a cell, then click on the Insert Function icon (just to the left of the formula bar) and fill in the parameters.

    Press F1 in Excel and read up directly on NPV as a function.
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!

How to calculate total hours scheduled in excel spreadsheet [ 8 Answers ]

Hi, I am trying to create a schedule for my employees and at the same time being able to calculate (or forcast for myself) the total hours that will be worked. e.g. A B C D E F G H I... P 1 NAME MONDAY...

MS Excel spreadsheet changing numbers [ 4 Answers ]

I have a spreadsheet where I enter credit card numbers, 16 digits. One note, I have the field setup as a custom format, that displays in the custom format as ####-####-####-####. This way it automatically adds the 4 dashes. For some reason, it always changes the last digit to zero. For...

Displaying formulas in Excel Spreadsheet [ 1 Answers ]

Formula currently appears in the cell rather than formula result value. I want the result value to appear in the cell and the formula to appear only in the formula bar. How do I make this change? I am working in Excel 2003.

Excel Spreadsheet [ 1 Answers ]

I need a macro or something for a website that has a excel spreadsheet. My client has a excel spreadsheet out on a website. They have invoice # on the excel spreadsheet and want to be able to scan the invoice and have it linked to the invoice on the website so clients can see the scanned document....

Excel Spreadsheet [ 2 Answers ]

Does anyone know how I can get an Excel spreadsheet to open at start-up? Thanks!

View more questions Search