If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I calculate the final pmt required to meet a target IRR?
|
#2
|
|||
|
|||
Can you elaborate?
-- Vasant "Alex" wrote in message ... |
#3
|
|||
|
|||
An investor will be investing 2,500 in year 1, not taking any return for 5
years, but at the end of year 6 wants a payment so that his IRR upon receiving that payment will equal 25%. Help! "Vasant Nanavati" wrote: Can you elaborate? -- Vasant "Alex" wrote in message ... |
#4
|
|||
|
|||
I can use goal seek to determine the number, but what I need is a tool that
will change that answer as I change the variables, e.g. the amount of the original investment. "Alex" wrote: An investor will be investing 2,500 in year 1, not taking any return for 5 years, but at the end of year 6 wants a payment so that his IRR upon receiving that payment will equal 25%. Help! "Vasant Nanavati" wrote: Can you elaborate? -- Vasant "Alex" wrote in message ... |
#5
|
|||
|
|||
Alex wrote:
An investor will be investing 2,500 in year 1, not taking any return for 5 years, but at the end of year 6 wants a payment so that his IRR upon receiving that payment will equal 25%. If I understand you correctly, you simply want the future value (FV) a 6-year investment of $2500 at 25% per year. =FV(25%,6,,-2500) |
#6
|
|||
|
|||
Yes, that is exactly what I need. Thank you.
" wrote: Alex wrote: An investor will be investing 2,500 in year 1, not taking any return for 5 years, but at the end of year 6 wants a payment so that his IRR upon receiving that payment will equal 25%. If I understand you correctly, you simply want the future value (FV) a 6-year investment of $2500 at 25% per year. =FV(25%,6,,-2500) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2003: track changes opens in final view instead of final sho. | JenniferLee | General Discussion | 2 | April 19th, 2005 06:25 PM |
Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 08:04 PM |
Must # of fields in the 2 tables in an Append Query be equal? | CreativeImages | Running & Setting Up Queries | 3 | October 1st, 2004 05:16 PM |
Make Field Required | jh | Using Forms | 4 | September 11th, 2004 01:33 PM |
required rate of return | Phillip | Worksheet Functions | 1 | March 11th, 2004 02:36 AM |