Investment cash flow financial calculation

Scenario:
An investor invested $7 and we have a promote arrangement of 90% (investor/LP) 10% (GP) and in year 3 of project (5 year hold) there is a positive cash flow of $10, how can I make a formula to take the $10 cash flow from year 3 deduct ($3) the amount on top of the initial $7 investors equity and then multiply remaining (which would be $7 multiplied 90%).

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. 'll change it for you on this occasion but note for the future

In adition please upload the workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.