+ Reply to Thread
Results 1 to 2 of 2

Thread: ROI and NPV formulas

  1. 11-10-2010, 02:31 PM #1
    marmar1958
    marmar1958 is offline
    Registered User
    Join Date
    11-10-2010
    Location
    galway ireland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Smile ROI and NPV formulas

    I am looking for the correct formulas to determine ROI and NPV on an investment.
    We have an inital investment and yearly repayments on the investment.
    The investment generates a yearly cashflow.
    What are the correct formula to determine the above.
    Regards
    Reply With Quote Reply With Quote
  2. 11-10-2010, 04:53 PM #2
    alansidman
    alansidman is offline
    Valued Forum Contributor alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Lake County, Illinois
    MS-Off Ver
    MS Office 2010, 2007 and 2002
    Posts
    1,165

    Re: ROI and NPV formulas

    Here is the formula of Internal Rate of Return

    http://www.techonthenet.com/excel/formulas/irr.php

    and here is the NPV formula

    http://www.techonthenet.com/excel/formulas/npv.php

    Alan
    Alan

    Click the * below to say thanks.
    Database Principles
    Pivot Table Tips
    Good Excel Video Tutorials
    Sumifs or SumProduct
    DataPig Access Tutorials
    MS Query Tutorial
    Worst Pie Chart Ever?
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0