spaniard25
New Member
- Joined
- Apr 27, 2007
- Messages
- 42
Hello,
I have what seems to be a fairly straightforward problem, but I have searched the forums and found limited information on the topic. The problem:
I need to do the reverse of the function =IRR(), which is to spit out the annual cash flow required to meet a target IRR. The initial capital outlay is provided, and the cash flows are 15 constant, annual payments. For a given IRR target (24% in this case), I need to determine what cash flow is necessary (15 periodic annual payments) to hit that target.
Is this possible? Currently I am manually using goal seek. Is a goal seek macro my only option?
Thanks,
spaniard25
I have what seems to be a fairly straightforward problem, but I have searched the forums and found limited information on the topic. The problem:
I need to do the reverse of the function =IRR(), which is to spit out the annual cash flow required to meet a target IRR. The initial capital outlay is provided, and the cash flows are 15 constant, annual payments. For a given IRR target (24% in this case), I need to determine what cash flow is necessary (15 periodic annual payments) to hit that target.
Is this possible? Currently I am manually using goal seek. Is a goal seek macro my only option?
Thanks,
spaniard25