+ Reply to Thread
Results 1 to 1 of 1

how to calculate rate of return needed to accumulate a specified dollar amount

  1. #1
    Registered User
    Join Date
    01-26-2011
    Location
    boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    1

    how to calculate rate of return needed to accumulate a specified dollar amount

    here is what i'm looking to do..I want a cell to calculate the rate of return necessary to equal a certain amount found in a neighboring cell.

    so in cell A31 is where i want my calculation to appear, in cell I3 i have the yearly contribution (this will stay the same for the 30 year calculation) and in cell J33 I've got the ending dollar amount.

    so what i want to happen, if possible, is for cell A31 to calculate, based on the yearly amount contributed ( cell I3) and the ending dollar amount (cell J33) the rate of return necessary to achieve that end amount.

    hope this makes sense, thank you so much in advance for your help!
    Last edited by daquimo; 01-26-2011 at 05:44 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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