Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i do profit formulas | Excel Worksheet Functions | |||
Net profit | Excel Discussion (Misc queries) | |||
gross profit | Excel Worksheet Functions | |||
Profit only if B2=33 and C2=18, please help | Excel Discussion (Misc queries) | |||
Calculating net profit | Excel Worksheet Functions |