Net Wealth Tax: Taxable Assets, Debts, Allowances & Brackets
This lesson is part of the course
In this lesson
You add up the Valdemars' taxable assets with SUMIFS, deduct debts and a per-person allowance, and calculate a progressive wealth tax with the differential-rate SUMPRODUCT method.
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
- Property Tax: Assessment Ratios, Exemptions & Mill Rates Locked
- Reassessments & Capped Increases: A Six-Year Projection Locked
- Net Wealth Tax: Taxable Assets, Debts, Allowances & Brackets Locked
- Imputed Rental Value: Living in Your Own Home & the Mortgage Effect Locked
- Gift Tax: Annual Exclusions, Lifetime Exemption & Running Totals Locked
- Estate Distribution: Residue, Class Shares & Equalising Advances Locked
- Inheritance Tax per Heir: Class Allowances & Rates with XLOOKUP Locked
- Give Now or Inherit Later: After-Tax Value per Heir Locked