How this instrument works
The CARES Act, signed March 27, 2020, set up the first federal stimulus payment on a two-tier scale instead of one flat number: $1,200 per adult listed on the return, $500 per qualifying child who had not yet turned 17. A dependent who had already crossed that birthday — a teenager finishing high school, a son or daughter away at college, a parent claimed on someone else's return — brought in nothing at all under this round, a blind spot Congress closed only when it wrote the payments that came after.
Past a certain income, the base payment does not vanish all at once; the formula shaves it down gradually. Every dollar of AGI sitting above the applicable line costs the household a nickel of payment, so a wide stretch of income separates the full amount from nothing at all. Because the actual 2020 thresholds were only three fixed figures — $75,000 for a single return, $112,500 for head of household, $150,000 for a joint return — this sheet lets a user type the matching number straight into Phase-out threshold, $ (filing-status dependent) rather than picking a filing status from a menu.
Most people running this calculation now are checking old paperwork, not expecting new money: a preparer checking whether a client's old bank deposit lines up with what the AGI on that 2020 return implies, or someone weighing whether a payment that never arrived is still worth chasing down. One quirk worth knowing before treating the result as untouchable — unlike the two rounds that followed, this first payment carried no blanket federal shield against garnishment by a private debt collector, so an amount the formula returns as owed was not always the amount that actually reached an account with old debt attached.
- Enter Eligible adults with the number of adults on the return — 1 for a single filer, 2 for a married joint return.
- Enter Qualifying children (under 17) — only dependents who were under age 17 at the end of 2020 count toward the $500 add-on.
- Set Adjusted gross income, $ to the AGI line from the 2020 return being checked.
- Set Phase-out threshold, $ (filing-status dependent) to $75,000, $112,500, or $150,000, matching the filing status on that return.
- Compare Base payment before phase-out, $ against Estimated payment, $ to see how much the 5% reduction removed.
Worked example — a joint return right at the $150,000 threshold
Take a return filed jointly, claiming 2 qualifying children under 17, with $150,000 in adjusted gross income — precisely the joint-filer's threshold line. Enter adults = 2, dependents = 2, agi = 150000, and phaseoutThreshold = 150000. Multiplying out the base payment gives $1,200 twice plus $500 twice, or $3,400, and since AGI lands exactly on the threshold, nothing is left to trim from that figure — Estimated payment, $ also lands at $3,400.
Move the same math to a single filer with no children and $80,000 AGI against the $75,000 single threshold instead, and the picture changes: the base payment is $1,200, but $5,000 of AGI sits above the threshold, so 5% of that excess — $250 — comes off, leaving $950. Push that same filer's AGI up to $99,000 and the $24,000 excess costs the full $1,200, phasing the payment out to exactly zero — the point where the reduction has caught up with the entire base amount.
Questions
Why is the payment $1,200 per adult but only $500 per child?
That split came from the CARES Act's original text: $1,200 for each adult listed on the return and $500 for each qualifying child under 17, rather than one flat amount per person. It also meant a dependent who had turned 17 — a high-schooler on the edge of that age, a college student, an adult claimed as a dependent — added nothing at all, an asymmetry the payments that followed corrected by paying every dependent the same rate as an adult.
Did an adult dependent, like a college student, qualify for anything?
No. The first round paid $500 only for a qualifying child under age 17 at the end of 2020; anyone older than that — a dependent finishing their teens, an adult child, or a parent someone else supported — added zero to the total regardless of how long that person had lived in the household. That age cutoff belongs only to this first round among the pandemic-era payments.
Where do the three phase-out threshold numbers come from?
$75,000, $112,500 and $150,000 are the actual 2020 AGI thresholds Congress set for single filers, heads of household, and married joint filers under the CARES Act. This sheet asks for the number directly in Phase-out threshold, $ (filing-status dependent) instead of offering a filing-status list, so entering the wrong figure for an actual filing status will quietly shift where the 5% reduction begins.
Could a debt collector take this payment?
In many cases, yes — unlike the second and third rounds, the first CARES Act payment carried no federal protection against garnishment by a private creditor or debt collector, only against certain federal debts. Some banks and states stepped in with their own protections, but the formula here returns the amount owed before any account-level garnishment, not necessarily the amount that reached a bank account with existing debt attached.
Can a missed first-round payment still be claimed?
Only by amending the 2020 return's Recovery Rebate Credit line, and that door is now shut. The IRS applies the usual three-year refund statute to that return, a deadline that landed on May 17, 2024, so a payment never collected by then generally cannot be recovered, no matter what figure this sheet computes as owed.
Why does this sheet ask for a dollar threshold instead of a filing-status dropdown?
Because the CARES Act phase-out only ever needed three flat numbers — $75,000, $112,500, or $150,000 — typing the one matching an actual filing status does the same job as a dropdown with one fewer field to define. Entering any other figure runs the same 5% reduction against a hypothetical threshold instead, useful for comparing filing statuses side by side.
References
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.