Filing Status: Picking the Right Bracket Table with XLOOKUP
This lesson is part of the course
In this lesson
You look up each client's standard deduction and bracket thresholds by filing status, calculate the tax for five returns and measure what Ava and Ben save by filing jointly.
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