+ Reply to Thread
Results 1 to 2 of 2

Reverse IRR

  1. #1
    Registered User
    Join Date
    08-16-2007
    Posts
    8

    Reverse IRR

    I am working on financial model. I am having problem with the IRR function. i would like to enter the IRR value and resulted in the capex value.

    Example:
    year 0 1 2 3 4 5
    cash -25 5 5 6 7 8
    with discounted rate (or guess) is 0.08

    The IRR is 7%

    Now my question is
    year 0 1 2 3 4 5
    cash X 5 5 6 7 8
    with discounted rate (or guess) is 0.08

    The IRR is 10%

    What function or formula i can use to solve X


    Any help and input is greatly appreciated. Thank you in advance.

  2. #2
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298
    hi yuli.tan,

    you could try using goal seek under the tools menu, if you have use the IRR formula to calculate the capex,then goal seek can be used to calculate the prime by using the product.

    thanks reg

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1