Recursive logic problem

[AZDJedi]

Hey,

I've been working on this for hours and am no closer to a solution. I need help creating a recursive function. I've upload an image to help you visualize the problem.

I have a table of records (the bottom part of the image) that determines which splits occur and what percentage goes to each "account". The first column is the Master, the second is what it splits into, and the third is what percentage the split has.

All that matters to me is when an account can't be split anymore. I've circled them in red for clarity. What I need is something that will tell me what the bottom percentages are.

For example, A splits into B at 75% and B splits into C at 50%. That means C gets 50% of 75% which is 37.5%.