Property, Wealth & Inheritance Taxes: Assessed Values, Mill Rates & Estate Shares

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn market values into assessed values with a class lookup, subtract the homestead exemption without going below zero, apply the mill rate and compare the effective tax rate of six parcels.
• Project six years of assessments for the Valdemar home, apply a 3% annual cap that resets when the market falls, and measure what the cap saves in tax – then chart full vs capped values.
• 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.
• Add an imputed rental value to income, deduct mortgage interest and the better of flat or actual maintenance, compare three mortgage scenarios and find the balance at which the effect is zero.
• Apply a per-recipient, per-year exclusion to Elsa's gift log with running SUMIFS, track how much of her lifetime exemption is used, find the gift tax once it runs out and plan the next gift.
• 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.
• Look up each heir's allowance and rate by relationship class, tax only the part above the allowance, total the estate's inheritance tax and highlight who actually pays.
• Compare two ways of passing money to three heirs – a gift taxed today that grows in the heir's hands, or an inheritance taxed in year N after growing in the estate – and chart the after-tax result per heir.