|
| 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
October 9th, 2005, 02:47 AM
|
|||
|
|||
How do I calculate the final pmt required to meet a target IRR?
|
|
#2
October 9th, 2005, 03:22 AM
|
|||
|
|||
|
Can you elaborate?
-- Vasant "Alex" wrote in message ...
|
|
#3
October 9th, 2005, 03:29 AM
|
|||
|
|||
|
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
October 9th, 2005, 03:43 AM
|
|||
|
|||
|
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
October 9th, 2005, 03:45 AM
|
|||
|
|||
|
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
October 9th, 2005, 03:58 AM
|
|||
|
|||
|
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 |
Linear Mode
