I'm trying to create a spreadsheet to calculate a distribution of funds after the sale of two properties.
in the attached spreadsheet B2 is a constant value and so is A2
C2 will change depending on the sale price of the property.
In short this is what I want to do.
There are 3 siblings, my sister will get lot 5 from the sale of the estate, the lot is valued at 150K
My brother and I will split the profits of the land sale B2 or portion will be 87.5K as you can see my sister will have the largest share.
The sale of the next property lot 1 has not happened yet.
I'm trying to create a formula to say "if the total sale value of lot 1 (C2) and land sale from Brad (B2) were to exceed the $150k that was originally given to my sister, then the profit should be divided equally among the three of us.
For example At point of property sale, Judy gets lot 5 valued at 150k, Matt and Dave split the 175k which equals 87.5k leaving Matt and Dave 62.5k short of being equal to the value of Judy's share.
The sale of lot 1 if it were 125k we would all break even, Judy would get none of the profits, Dave and Matt would split the 125K and all three would have a value of 150k.
The value is likely to be more than 125k so any excess would then have to be distributed evenly among the three.
I hope that makes sense.
Please see attached.
Bookmarks