Hi there,
Here is a simple (I think) problem that I have trying to figure out. I have attached an example of an investment scenario that I am trying to model out. I think the spreadsheet is self explanatory. I also posted an earlier spreadsheet, but think it was overly complicated. The assumptions are as follows:
Investors invest into a partnership. The terms are as follows:
100% Principle paid back to the investors first
Investors then receive a preferred rate of interest (e.g. 12%. Don't worry about simple vs. compound, IRRs, etc. I can figure that out)
Anything left over after the principle & preferred interest rate is split between the managers of the partnership and the investors (e.g. 50%)
What are the forumulas that belong in the cells with the "?"s?
Ideally the blue shaded fields can be any $# amounts so we can run what if scenarios.
Thanks so much!
Here is a simple (I think) problem that I have trying to figure out. I have attached an example of an investment scenario that I am trying to model out. I think the spreadsheet is self explanatory. I also posted an earlier spreadsheet, but think it was overly complicated. The assumptions are as follows:
Investors invest into a partnership. The terms are as follows:
100% Principle paid back to the investors first
Investors then receive a preferred rate of interest (e.g. 12%. Don't worry about simple vs. compound, IRRs, etc. I can figure that out)
Anything left over after the principle & preferred interest rate is split between the managers of the partnership and the investors (e.g. 50%)
What are the forumulas that belong in the cells with the "?"s?
Ideally the blue shaded fields can be any $# amounts so we can run what if scenarios.
Thanks so much!
