The Bracket Table: Slicing Income, Tax per Bracket & the Rate-Step Shortcut
This lesson is part of the course
In this lesson
You split Theo's taxable income of 64,500 across five brackets, tax each slice, add the slices up and confirm the total with a one-cell SUMPRODUCT rate-step formula.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Bracket Table: Slicing Income, Tax per Bracket & the Rate-Step Shortcut Locked
- Marginal, Average & Effective Rates – and Why a Raise Never Lowers Net Income Locked
- From Gross to Taxable Income: Adjustments, Itemised vs Standard Deduction Locked
- Allowance Phase-Out: The Taper and Its Hidden 60% Marginal Rate Locked
- Filing Status: Picking the Right Bracket Table with XLOOKUP Locked
- Tax Credits: Non-Refundable vs Refundable and What Reaches the Bank Account Locked
- The Effective-Rate Curve: Tax, Effective and Marginal Rates Across Incomes Locked
- Capstone: Take-Home Summary from Gross Income to Refund, with Check Cells Locked