Thread: Profit sharing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jatman jatman is offline
external usenet poster
 
Posts: 88
Default Profit sharing

you owned the house for 10 years (8 with the spouse, 2 on your own)
your spouse owned the house for 8 years

total ownership time is 18 years. 8/18=44.4% of share value; 10/18=55.5%
share value;


"Codeman" wrote:

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.