Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Codeman" wrote in message
...
I need a formula for the following;

Two people buy a house and own it for many years. One decides to split
and
the other continues the payments on the house until sold to someone else
at a
later date. How do you determine the profit split between the two at the
time of sale knowing that the one staying in the house should get a larger
portion of the profit if any profit is aquired?

Assume:
A. = number of years the two paid on the house as a couple.
B. = number of years/months or days the one who stayed in the house made
the
mortgage payments after the split.
C. = profit after all closing cost and sale of the house.
D. = profit to the one who stayed the shortest time in the house
E. = profit to the one who stayed the longest time in the house.

I will convert days to decimal equivalent in years when number of days is
between or less than a year.

Thank you for any help.