Skip to main content

Limited time: save up to 25% on spreadsheet models and templates.

Explore templates
10XSheets

Free calculator

Property tax calculator

Estimate annual and monthly property tax from a taxable base (assessed value, cadastral base, or any figure your notice uses) and an effective annual rate % you enter—or flip to implied rate when you already know the annual tax amount. Optional market value × assessment ratio fills the taxable base when you leave taxable blank. This is transparent spreadsheet math, not a county or ZIP lookup like large portals. For P&I plus optional monthly tax in a loan context, see the mortgage payment calculator (linked below).

Educational illustration only. This is not tax, legal, or appraisal advice, not an official assessment, and not a substitute for your tax bill, assessor, or qualified professionals. Rates combine many local layers; exemptions, caps, and reassessments are not modeled—adjust the base or rate you type to reflect them.

When to use this calculator

Quick base × rate checks for budgeting, escrow planning, and spreadsheet rows when you already pulled numbers from a notice or portal—without pretending we know your ZIP.

  • Turn an effective % and assessed value into annual and monthly lines for a model.
  • Back-solve implied % from known annual tax and taxable base to compare jurisdictions or years.
  • Use market × assessment ratio when your assessor publishes both and you want the same taxable base the rate applies to.
  • Cross-check portal estimates by typing their implied base and rate here for transparent Sheets/Excel parity.
How should property tax be estimated here?

Most jurisdictions follow a base × rate pattern on a taxable value, even though the names (assessed, cadastral, Messbetrag, valeur locative) and the number of overlapping levies differ. This page keeps that core identity visible.

Pick the base your rate applies to

Use the figure your notice or assessor applies the combined mill or percent to—often assessed value, sometimes after ratio or exemptions. We do not fetch that base for you.

Enter one effective annual percent

Roll state, county, school, and special layers into one effective annual % on that base, or use the implied rate tab when you know annual tax ÷ base.

Monthly for escrow-style math

Monthly here means annual ÷ 12 for accrual illustrations—your county may bill semi-annual or annual; match your servicer schedule in a spreadsheet when needed.

We intentionally do not ship ZIP, county, or state rate tables—those products need ongoing data and legal maintenance beyond a free transparent calculator.

Mill rate reminder: if your bill shows mills per $1,000 of assessed value, convert carefully to the same base your assessor uses before entering a percent here.

For mortgage P&I plus optional monthly tax you type yourself, open the mortgage payment calculator.

For NOI when property tax is an operating expense line, see the NOI calculator.

Google Sheets & Excel

Treat annual tax as =taxableBase*(ratePercent/100) and monthly escrow accrual as =annualTax/12 when you keep rate as a decimal fraction in the formula (divide percent by 100 in the cell).

Annual property tax
=B2*(C2/100)

B2 = taxable base; C2 = effective annual percent (e.g. 1.2 for 1.2%).

Monthly accrual
=D2/12

D2 = annual property tax from the line above or your bill.

More tools in Planning

Browse all tools

Frequently asked questions

Why don’t you ask for my county or ZIP like other calculators?

Accurate local rates need curated geo data and frequent refresh. We focus on transparent base × rate math you control—ideal for spreadsheet planning once you have numbers from an official or portal source.

What is taxable base vs market value?

Market value is a sale-oriented estimate. Assessed or taxable value is what your levy applies to—sometimes a fraction of market via an assessment ratio, sometimes after exemptions. Enter the base your rate applies to; use the optional ratio helper when you only have market × percent.

How do I convert mills to a percent?

Definitions vary by state—always confirm with your assessor. A common teaching pattern: mills per $1,000 of assessed value → annual taxassessed × (mills / 1000); dividing that tax by assessed gives a decimal rate you can express as percent in this tool.

Is monthly the same as what my lender withholds?

Often servicers accrue 1/12 of an estimated annual tax for escrow, then true up at reconciliation—use your statement for binding amounts. We show annual ÷ 12 as a simple accrual illustration.

Does this replace Germany or France official property tax tools?

No. Germany’s Grundsteuer (reform-era models, Messbetrag, Hebesatz) and France’s taxe foncière (valeur locative, local taux, reforms) need jurisdiction-specific engines. Use this calculator when you already have a taxable base and effective annual % (or annual tax to imply %) for spreadsheet checks—not as a substitute for Finanzamt, commune, or DGFiP-grade simulators.

How does this relate to the mortgage payment calculator?

The mortgage tool’s optional monthly property tax field is the same idea: a monthly line item you enter. This page starts from annual math and rates on a base—use both when modeling PITI-style totals in Sheets.

Where does property tax go in a rental model?

Many owners treat it as an operating expense before NOI (check your accounting policy). Our NOI calculator lets you roll expenses into one opex line—pair it with this page to sanity-check the tax piece.

Is this tax or legal advice?

No. It is a free math helper. Use qualified professionals and official notices for decisions, appeals, and filings.