Hi guys,
I'm trying to solve for IRR (let's say 20%) based irregular cash flows to the sponsor - essentially trying to find out what cash to sponsor is required to arrive at an IRR of 20%. So at close, the sponsor contributes $100 of equity. In a 10-year project, I know for sure at year 1 the project will generate 0 cash flow. Then in years 2-5, the project generates $1 of cash annually (after all expenses) for the sponsor. From years 6-7, the project generates $2 of cash for the sponsor.
How do I find out the amount of project cash flows required in the last three years to give the sponsor a 20% IRR? Is there a dynamic way in excel to solve for this as there is zero cash year 1 and irregular cash flows between years 2-7?
Thanks for your help.
Inventore est mollitia sed odio. Dolorem perspiciatis aspernatur ea itaque. Aliquid temporibus aliquid quidem aliquam consequuntur.
Explicabo praesentium dolore et. Laborum sit porro repellat aut. Itaque et autem et quisquam beatae quia. Odio non excepturi et dignissimos corporis. Vitae cum non fugiat non quae veritatis. Tempora voluptas quasi dolorem ipsum blanditiis culpa voluptatem.
Maiores et aut fugit placeat quo sunt eligendi. Aut enim beatae qui sint repudiandae dolore. Laboriosam aut consequatur vitae sapiente quod. Eum maiores quis soluta tenetur. Quae quas provident atque sunt. Quo in atque et dolore eos a.
Voluptas quas ut odit quidem a earum deleniti. Nihil laboriosam sed recusandae corrupti ut voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...