Estate Distribution: Residue, Class Shares & Equalising Advances
This lesson is part of the course
In this lesson
You work out Henrik Valdemar's residual estate, split it by relationship class with XLOOKUP and COUNTIF, and equalise the children's shares for advances they received during his life.
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