Child education expenses shared between caregivers · Calculation guide

Split eligible education expenses after scholarships and compare each share with amounts already paid.

Calculation guide

Two caregivers agree the percentage split. The first caregiver’s advance is already included in total costs. A negative settlement means the first caregiver has overpaid.

one = max(0,total-aid)*share/100 · two = max(0,total-aid)-one · due = one-advance

Inputs

Eligible expenses

Example entry 10000 (in the selected currency).

Scholarships and aid

Example entry 2000 (in the selected currency).

First caregiver’s share

Example entry 60 %. Allowed range 0 to 100.

Paid by first caregiver

Example entry 1000 (in the selected currency).

Worked example

InputValue
Eligible expenses10,000
Scholarships and aid2,000
First caregiver’s share60%
Paid by first caregiver1,000
ResultValue
First caregiver’s cost4,800
Second caregiver’s cost3,200
First caregiver’s balance due3,800

Calculation steps

First caregiver’s cost = ((max(0, (Eligible expenses − Scholarships and aid)) × First caregiver’s share) ÷ 100)

((max(0, (10,000 − 2,000)) × 60) ÷ 100) = 4,800

Second caregiver’s cost = (max(0, (Eligible expenses − Scholarships and aid)) − First caregiver’s cost)

(max(0, (10,000 − 2,000)) − 4,800) = 3,200

First caregiver’s balance due = (First caregiver’s cost − Paid by first caregiver)

(4,800 − 1,000) = 3,800

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Eligible expenses10,00011,000First caregiver’s cost4,8005,400
Scholarships and aid2,0002,200First caregiver’s cost4,8004,680
First caregiver’s share60%66%First caregiver’s cost4,8005,280
Paid by first caregiver1,0001,100First caregiver’s balance due3,8003,700
Child education expenses shared between caregivers →

Sources