Share monthly care costs

What do these figures show?

Enter the monthly cost, choose a split method and enter each person's money contribution. The complete formulas remain below.

How can you work out the split?

1. Use one month throughout Use the care cost, cash, hours, things and income weights for the same month. This worksheet does not spread a purchase across later months.
2. Choose the terms for discussion Your family chooses the split method, hourly value and value of things. The worksheet does not choose a rate or create an agreement.
3. Split equal targets The equal method gives every displayed person the same weight. Entered contributions do not change the target shares.
4. Use entered income weights The income method divides the monthly cost in proportion to the entered monthly incomes. Enter every income weight. At least one must be positive. Other methods ignore income fields.
5. Enter all agreed percentages The percentage method requires every share and a total of exactly 100.00%. Other methods ignore percentage fields.
6. Allocate every cent once First take the whole-cent floor of cost times each weight divided by total weight. Award remaining cents by largest remainder, breaking ties in displayed person order. Targets add exactly to the monthly cost.
7. Keep bill funding separate Cash gap equals monthly cost minus total actual cash, with a minimum of zero. Cash above cost is shown separately. Time and things never reduce the cash gap.
8. Count each contribution once Do not count the same purchase as both a cash contribution and a thing. Enter only this month's chosen value. No amortization is added automatically.
9. Value hours at your chosen rate Hours allow two decimal places. Multiply each person's exact hours by the one chosen hourly dollar value. Round that person's hours value once half up to cents before totals.
10. Keep unknown entries unknown An explicit zero is known. Blank cash is unknown, so a complete cash total or gap is not shown. Blank hours and things remain unvalued. Zero hours have zero value even when the hourly rate is blank.
11. Label incomplete discussion figures A discussion figure is target minus cash minus known hours and things values. It is partial when unvalued noncash entries are excluded, and it lists those exclusions. Unknown cash or targets withhold that figure.
12. Use the figures for a conversation A negative discussion figure means known contribution value exceeds the chosen target. It does not mean money is owed, require a transfer or form an agreement. Print this worksheet for your family to talk over.
13. Share only when you choose Copying a link requires explicit consent. Anyone with it can read the monthly cost, chosen hourly rate, labels, active income or percentage weights and contributions. Inactive method fields are left out. No link is updated while you type.
14. Keep the software limits visible Use 2 to 12 people. Money entries are limited to $1,000,000,000,000.00 each. Hours are limited to 10,000.00 per person. Percentages allow two decimal places. These are software limits, not suggested figures.