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

    Jan 7, 2010, 03:18 AM
    How to calculate npv in excel 2007
    .expain how to calculate NPV in excel sheet by using inbuit formula
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Jan 7, 2010, 02:53 PM

    By typing...

    =NPV(

    ... in a cell then clicking on the fx button just left of the formula bar to open the Function Arguments window. This will help you understand what data to put in each field.

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 NPV using an excel spreadsheet [ 1 Answers ]

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

Calculate Npv [ 1 Answers ]

a machine manufactring tiles costs r120 000 to install. Life expectancy of machn=20yrs,it costs r15000 to maintain p.a. Annual net income is expected to be r25 000 pa. Use a 10%pa interest rate.the bank intrests for deposits is 8.5%. What is the npv,and is this project viable?

How do you calculate NPV and PI [ 3 Answers ]

My question is find the NPV and PI of an annuity that pays $500 per year for 8 years and costs $2,500. Assume a discount rate of 6%. I'm lost! How do I even calculate this?

How do you calculate the NPV? [ 6 Answers ]

What is the NPV for a project if the cost capital is 12% and the initial after-tax cost is $5,000,000 and is expected to provide after-tax operating cash flows of $1,800,000 in year 1, $1,900,000 is year 2, $1,700,000 in year 3, and ($1,300,000) in year 4?


View more questions Search