Underwriting worksheet — No. 07
Property tax proration splitter
Set the tax period, the day-count convention, and who owns the day of closing. The sheet states the credit or debit that lands on the settlement statement, and the arithmetic behind it.
Credit at closing
----
--
Schedule of assumptions
Adjust any line; every figure on this page restates immediately.
Closing
Proration convention
State convention
Selecting a state sets the period and the payment timing to the local norm. Override either line above if your county reads differently.
Supplemental bill
Off unless the switch above is on. When on, this amount is added to the annual tax before the daily rate is struck.
Settlement position
Rounded to the cent, the way a settlement statement reads.
Tax year timeline
The filled portion is the stretch of the tax period the seller held. The remainder belongs to the buyer.
What happens at settlement
Month by month
The same proration, broken out by calendar month across the selected period.
| Month | Days | Tax | Seller | Buyer |
|---|
Proration estimates for planning and deal modeling only. Every county and title company handles day counts, billing cycles, and closing-day ownership a little differently, so treat the settlement statement from your closing agent as the real number. Not tax, legal, or investment advice.
← All tools