I would like to solve for the IRR of a stream of payments that are constant, but do not begin immediately. Is there a way to do so using a formula rather than listing the payments in a column and then using the IRR function? Here is the scenario:
An initial outlay of X, followed by no payments until Y months later, followed by Z payments for a period of AA months. If there were no skip payments, using Rate would obviously work, but I am wondering if there is a formula when a skip period is involved ?
Thanks!
An initial outlay of X, followed by no payments until Y months later, followed by Z payments for a period of AA months. If there were no skip payments, using Rate would obviously work, but I am wondering if there is a formula when a skip period is involved ?
Thanks!
