Enrollment usually requires a one-time registration fee plus a deposit (often one or two weeks of tuition) that’s held or applied to the final bill. The total due at sign-up is the sum.
The example
$75 fee, 2-week deposit, $300/wk.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 75 + 2×300 | — |
| 3 | Due at sign-up | → $675 |
The formula
The formula:
How it works
How it works:
- Deposit = deposit weeks × weekly tuition (often 1–2 weeks).
- Add the registration fee (usually non-refundable) for the total due.
- If the deposit applies to the last weeks, the final invoice is reduced by it.
- Per-child fees scale: multiply by the number of children enrolling.
Spell out what the deposit does. A deposit can be (a) held and refunded at withdrawal with notice, or (b) applied to the last weeks of care — very different for the family’s final bill and your cash flow. State the policy, and if it’s applied, reduce the final invoice by the deposit so it isn’t double-charged. The registration fee is typically separate and non-refundable.
Try it: interactive demo
Registration fee, deposit weeks, weekly tuition.
Variations
Deposit only
Weeks × tuition:
Final invoice (deposit applied)
Net of deposit:
Per family (multi-child)
Scale the fee:
Pitfalls & errors
Deposit policy. Held-and-refunded vs applied-to-last-weeks — state it.
Avoid double-charging. If applied, reduce the final invoice by the deposit.
Fee usually non-refundable. Keep it separate from the deposit.
Practice workbook
Frequently asked questions
How do I calculate enrollment cost in Excel?
What's the deposit usually?
How do I avoid double-charging an applied deposit?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class