Home |
Search |
Today's Posts |
#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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
calculate future date | Excel Worksheet Functions | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |