Calculate Closing And Prorations — Calculate closing costs,...

SECTION 1

Historical Context & Motivation

Real estate closings have existed in some form since societies began recording property transfers, but the modern settlement process — with its detailed accounting of prorations, debits, and credits — is largely a product of regulatory evolution in the United States. As real estate transactions grew in complexity during the twentieth century, so did the need for standardized methods of dividing shared expenses and computing what each party ultimately owes or receives at the closing table. Understanding this history clarifies why today's settlement calculations follow specific conventions that appear on the national real estate licensing examination.

1862

Homestead Act

The federal government's mass transfer of public land introduced millions of Americans to property ownership and created the need for organized title transfer procedures and rudimentary cost-splitting at conveyance.

1968

Truth-in-Lending Act (Regulation Z)

Congress mandated disclosure of borrowing costs, foreshadowing the formal settlement statement framework. Lenders began itemizing charges that would later appear on closing documents.

1974

RESPA Enacted

The Real Estate Settlement Procedures Act required a Uniform Settlement Statement (HUD-1) detailing every closing cost, proration, and adjustment — standardizing how debits and credits are presented.

2015

TRID (TILA-RESPA Integrated Disclosure)

The CFPB's 'Know Before You Owe' rule replaced the HUD-1 and GFE with the Closing Disclosure (CD) and Loan Estimate (LE), consolidating settlement cost presentation into a clearer format while retaining the core proration and debit/credit logic.

Today

National Licensing Exams

Every state real estate licensing exam tests the candidate's ability to compute prorations, assign debits and credits, and derive net proceeds or net cost — skills rooted in the disclosure framework developed over the past half century.

The central problem these regulations address is straightforward yet arithmetically demanding: when a property changes hands on a date that does not coincide with the start or end of a billing cycle, how should recurring expenses — property taxes, insurance premiums, HOA dues — be fairly divided between buyer and seller? And once those allocations are combined with one-time closing costs (loan origination fees, title insurance, transfer taxes, commissions), what is the net amount the buyer must bring to closing and the net amount the seller walks away with? This lesson equips you with the mathematical framework to answer both questions with precision.

SECTION 2

Core Principles & Definitions

Before diving into calculations, it is essential to internalize the vocabulary and the logical architecture of a closing settlement. Every financial item at closing is classified as either a debit (a charge — money owed) or a credit (an offset — money received or an allowance). These designations are assigned independently to the buyer's column and the seller's column on the settlement sheet. A single item may be a debit to one party and a credit to the other, or it may affect only one side.

Debit (Charge)

An amount owed by a party. Debits increase the buyer's cash due at closing or reduce the seller's net proceeds. Example: the purchase price is a debit to the buyer.

Credit (Offset)

An amount that reduces what a party owes or increases what they receive. The earnest money deposit is a credit to the buyer because it offsets money already paid.

Proration

The proportional division of a shared recurring expense (e.g., property tax, insurance) between buyer and seller based on their respective days of ownership within the billing period.

Day-of-Closing Convention

Exam convention: the day of closing belongs to the seller unless stated otherwise. The seller is responsible for expenses through (and including) the closing date, and the buyer assumes costs from the day after closing.

Net to Buyer / Net to Seller

After summing all debits and credits for each party, the net figure represents either what the buyer must bring (cash to close) or what the seller receives (net proceeds).

✦ KEY TAKEAWAY

Think of the closing statement like splitting a restaurant bill among friends who arrive and leave at different times. The person who was at the table longer (the seller) pays for the appetizers already consumed (prepaid or accrued expenses up to the closing date), while the newcomer (the buyer) picks up the tab for everything ordered from that point forward. A proration is simply the mechanism that converts calendar days into dollar amounts to ensure each diner pays only for the time they occupied the seat.

⚠️ Exam Convention: 360-Day vs. 365-Day Year

The national exam may specify either a statutory (banker's) year of 360 days (12 months × 30 days) or a calendar year of 365 days. Always read the problem stem carefully. If the problem says '30-day month' or '360-day year,' use 30 days per month. If it says 'actual days' or '365-day year,' use the real calendar count. If nothing is stated, the safe default for most exam prep is the 365-day (actual) method.

SECTION 3

Visual Explanation — The Settlement Statement Structure

The diagram below illustrates the logical flow of a real estate settlement statement. Each financial item enters either the buyer's column or the seller's column (or both) as a debit or credit. The final step aggregates all entries to derive the net figures for each party.

The settlement statement is organized into two parallel columns. Each item is posted as a debit (charge) or credit (offset). Prorations feed into both columns. The buyer's net is total debits minus total credits; the seller's net is total credits minus total debits.

Notice the symmetry in the diagram: an item that is a credit to the buyer is often a corresponding debit to the seller, and vice versa. For example, when the seller has prepaid property taxes beyond the closing date, those prepaid days represent value the buyer will enjoy. The buyer must reimburse the seller, so the proration is a debit to the buyer and a credit to the seller. Conversely, if taxes are accrued (owed but not yet paid) through the closing date, the seller has benefited from the property without paying — a credit to the buyer and a debit to the seller. This mirroring principle is the conceptual backbone of all proration math.

SECTION 4

Mathematical Framework

The calculations at closing can be decomposed into three sequential stages: (1) compute each proration, (2) classify every item as a debit or credit to buyer and/or seller, and (3) aggregate to find net figures. The equations below formalize each stage.

DAILY RATE

Daily Rate = Annual Amount ÷ Days in Year

Use 365 for a calendar-year proration or 360 for a statutory/banker's-year proration. For monthly items, divide the monthly amount by the number of days in that month (actual or 30).

PRORATION AMOUNT

Proration = Daily Rate × Number of Days Owed by Party

Count the seller's days from the start of the billing period through and including the closing date (unless the problem states otherwise). The buyer's days run from the day after closing through the end of the billing period.

NET DUE FROM BUYER

Net to Buyer = Σ (Buyer Debits) − Σ (Buyer Credits)

A positive result means the buyer must bring that amount (cash to close). The largest debit is typically the purchase price; the largest credit is the new mortgage loan amount plus the earnest money deposit.

NET TO SELLER

Net to Seller = Σ (Seller Credits) − Σ (Seller Debits)

A positive result is the seller's check at closing. The seller's primary credit is the sale price; major debits include mortgage payoff, broker commission, and transfer taxes.

💡 Prepaid vs. Accrued — The Decision Rule

If an expense has been prepaid by the seller (e.g., taxes paid in advance for the full year), the seller has overpaid relative to their ownership period and is owed a reimbursement → Credit Seller / Debit Buyer. If an expense has accrued (the seller used the service but hasn't paid yet, e.g., taxes owed in arrears), the buyer will eventually foot the bill → Credit Buyer / Debit Seller.

SECTION 5

Detailed Breakdown — Common Closing Items

The table below catalogues the most frequently tested closing items on the national real estate exam and identifies how each one is classified on the settlement statement. Memorizing this mapping is essential because many exam questions test whether candidates can correctly assign debits and credits before performing any arithmetic.

Common Settlement Statement Items — Debit/Credit Classification

Closing Item	Buyer Effect	Seller Effect
Purchase / Sale Price	Debit (charge)	Credit (receipt)
Earnest Money Deposit	Credit (already paid)	—
New Mortgage Loan	Credit (funds received)	—
Seller's Existing Mortgage Payoff	—	Debit (charge)
Broker Commission	—	Debit (charge)
Title Insurance (Owner's Policy)	Debit (if buyer pays)	Debit (if seller pays)
Loan Origination Fee	Debit (charge)	—
Transfer Tax / Doc Stamps	—	Debit (charge, varies by state)
Prepaid Property Taxes (proration)	Debit (reimburse seller)	Credit (reimbursement)
Accrued Property Taxes (proration)	Credit (seller owes)	Debit (owes buyer)
Prepaid Insurance (assumed policy)	Debit (reimburse seller)	Credit (reimbursement)
Accrued Rent (income property)	Credit (share of rent)	Debit (rent owed buyer)

This timeline shows a property tax proration for a September 15 closing. With taxes paid in arrears (not yet paid), the seller has accrued 258 days of tax liability. The $2,580 proration appears as a credit to the buyer and a debit to the seller on the settlement statement.

SECTION 6

Worked Example — Full Closing Calculation

Consider the following scenario, which is representative of the complexity you will encounter on the national exam. Work through each step methodically; the key is to categorize every item before computing totals.

📋 Problem Setup

Sale price: $280,000. Closing date: April 15 (seller owns the day of closing). Earnest money deposit: $5,000. Buyer obtains a new mortgage of $224,000. Loan origination fee: 1% of loan. Seller's existing mortgage payoff: $142,500. Broker commission: 6% of sale price. Annual property taxes: $4,380, paid in arrears (use a 365-day year). Recording fee: $250 (buyer's expense). Transfer tax: $1,120 (seller's expense). Title insurance: $1,200 (split equally). Find: Net due from buyer and net to seller.

Full Closing Settlement Calculation

Step 1 — Prorate Property TaxesTaxes are paid in arrears, meaning they have accrued but not been paid. The seller owes for January 1 through April 15 (the day of closing). Count the days: January = 31, February = 28, March = 31, April 1–15 = 15. Total seller days = 31 + 28 + 31 + 15 = 105 days. Daily rate = $4,380 ÷ 365 = $12.00 per day. Seller's accrued tax = 105 × $12.00 = $1,260.00. This is a credit to buyer / debit to seller.

Tax proration: $1,260.00 — Credit Buyer, Debit Seller

Step 2 — Calculate Broker CommissionCommission = 6% × $280,000 = $16,800. This is entirely a debit to the seller.

Commission: $16,800.00 — Debit Seller

Step 3 — Calculate Loan Origination FeeOrigination fee = 1% × $224,000 = $2,240. This is a debit to the buyer (a cost of obtaining the loan).

Origination fee: $2,240.00 — Debit Buyer

Step 4 — Split Title InsuranceTitle insurance = $1,200 ÷ 2 = $600 each. Debit buyer $600 and debit seller $600.

Title insurance: $600 Debit Buyer, $600 Debit Seller

Step 5 — Compile Buyer's SideBuyer Debits: Purchase price $280,000 + Origination fee $2,240 + Recording fee $250 + Title insurance $600 = $283,090. Buyer Credits: Earnest money $5,000 + New mortgage $224,000 + Tax proration credit $1,260 = $230,260.

Net Due from Buyer = $283,090 − $230,260 = $52,830.00

Step 6 — Compile Seller's SideSeller Credits: Sale price $280,000. Seller Debits: Mortgage payoff $142,500 + Commission $16,800 + Transfer tax $1,120 + Title insurance $600 + Tax proration debit $1,260 = $162,280.

Net to Seller = $280,000 − $162,280 = $117,720.00

✓ VERIFICATION CHECK

A useful sanity check: the buyer's net ($52,830) plus the seller's net ($117,720) plus the mortgage payoff ($142,500) plus all third-party fees (commission $16,800, transfer tax $1,120, recording fee $250, origination $2,240, title insurance $1,200, minus the tax proration which is an internal transfer) should account for the full purchase price flow. Always verify that your numbers balance against the sale price when time permits on the exam.

SECTION 7

Common Pitfalls & Exam Strategies

The arithmetic itself is straightforward — the real difficulty lies in correctly identifying each item and applying the right convention. The table below summarizes the most common mistakes candidates make on the national exam and the corresponding strategies to avoid them.

Top 5 Exam Pitfalls in Closing Calculations

Common Pitfall	Why It Happens	Strategy to Avoid
Reversing prepaid vs. accrued	Candidates confuse who is owed money; they credit the wrong party	Ask: 'Who has already paid more than their share?' That party gets the credit.
Miscounting days	Forgetting to include or exclude the closing date itself	Default rule: seller owns the closing day. Count through the closing date for the seller unless told otherwise.
Using wrong year basis	Using 365 when the problem says 360, or vice versa	Highlight the year/month basis in the problem stem before computing anything.
Omitting items from one side	Prorations are dual-entry; forgetting to post to both columns	Every proration creates exactly one debit and one credit — always ask which side gets which.
Calculating commission on wrong base	Using the loan amount instead of the sale price	Commission is always on the sale price unless explicitly stated otherwise.

✦ THE T-ACCOUNT METHOD

If you have studied double-entry bookkeeping in your finance coursework, leverage that knowledge: treat the settlement statement as two T-accounts — one for the buyer and one for the seller. Debits go on the left, credits on the right. For each closing item, post the entry to the appropriate account(s). When finished, the difference in each T-account gives you the net figure. This systematic approach prevents the most common error of accidentally omitting an entry.

SECTION 8

Connections to Advanced Real Estate Finance

The proration and settlement concepts tested on the national exam form the foundation of more sophisticated real estate finance topics you will encounter in advanced coursework and professional practice. Understanding how these basic principles scale is valuable for contextualizing the exam material within the broader discipline.

From Exam Basics to Professional Practice

Exam-Level Concept	Advanced Application
Daily tax proration (single-family)	Multi-property portfolio closings with staggered tax jurisdictions; escrow impound analysis for CMBS servicing
Rent proration for residential income property	Commercial lease proration with CAM (Common Area Maintenance) charges, percentage rent, and tenant improvement amortization
Seller's mortgage payoff	Defeasance or yield maintenance calculations on commercial loans; prepayment penalty analysis
Single closing statement (HUD-1 / Closing Disclosure)	Waterfall structures in joint venture closings; allocation of acquisition costs among limited partners
Net to seller as simple subtraction	After-tax net proceeds analysis incorporating capital gains, depreciation recapture (§1250), and 1031 exchange boot calculations

The key insight is that the debit/credit framework and the proration methodology remain identical at every level of complexity — only the number of line items and the specificity of the allocation basis change. A candidate who masters the foundational calculations for the licensing exam is building a skill set that transfers directly into commercial brokerage, mortgage banking, and real estate investment analysis.

SECTION 9

Practice Problems

PROBLEM 1 — CONCEPTUAL

A seller paid the full year's property taxes of $5,475 on January 1. The property closes on August 20. The day of closing belongs to the seller. Explain, without performing a calculation, whether the tax proration should be a credit to the buyer or a credit to the seller, and why.

PROBLEM 2 — BASIC CALCULATION

Annual property taxes are $7,300. Closing is on October 10. Taxes are paid in arrears (not yet paid). Use a 365-day year and assume the seller owns the day of closing. What is the seller's tax proration, and how is it posted?

PROBLEM 3 — INTERMEDIATE

A property closes on June 15. The seller prepaid the annual hazard insurance premium of $1,800 on March 1 (the policy runs March 1 to February 28 of the following year). Use actual days (365-day year). Seller owns the day of closing. Calculate the insurance proration and state the debit/credit entries.

PROBLEM 4 — APPLIED

Sale price: $350,000. Closing: July 20. Earnest money: $7,500. Buyer's new loan: $280,000 (1.5% origination fee). Seller's mortgage payoff: $195,000. Commission: 5.5%. Annual taxes: $5,840 (paid in arrears, 365-day year). Recording fee: $200 (buyer). Transfer tax: $1,400 (seller). Title search: $800 (seller). Seller owns the closing day. Calculate the net due from buyer and net to seller.

PROBLEM 5 — CRITICAL THINKING

A property closes on November 1. Annual taxes of $6,000 are paid in arrears but the county uses a fiscal year of July 1 – June 30. The seller has already made a partial tax payment of $2,000 covering July 1 – October 31. Using a 360-day year (30-day months), determine the tax proration and explain the debit/credit entries for both parties, carefully distinguishing between the accrued and prepaid portions.

SUMMARY

Lesson Summary

Closing calculations revolve around the correct assignment of debits (charges) and credits (offsets) to the buyer's and seller's columns on the settlement statement. The purchase price is the buyer's largest debit and the seller's largest credit. Prorations divide shared expenses proportionally by calculating a daily rate (annual amount ÷ 365 or 360) and multiplying by each party's days of ownership. Prepaid items generate a credit to the party who overpaid, while accrued items generate a credit to the party who will eventually pay the accumulated bill.

The net due from the buyer equals total buyer debits minus total buyer credits — this is the cash the buyer must bring to closing. The net to the seller equals total seller credits minus total seller debits — this is the seller's proceeds. On the exam, always confirm the day-of-closing convention (seller owns closing day unless stated otherwise), the year basis (360 vs. 365), and whether expenses are prepaid or accrued before assigning any debit or credit.