Learn / Mortgage Math · Chapter 13 of 14

Prorations and Cash to Close

Splitting property taxes between buyer and seller at closing, and adding up the cash a buyer needs to bring to the closing table.

The short version

Prorating property taxes

Property taxes cover a whole year, but a home usually sells partway through it. Each party should pay only for the days they own the home.

Daily tax = Annual tax ÷ 365 (actual-day method)

Daily tax = Annual tax ÷ 360 (30-day month, or “banker’s year,” method)

Proration = Daily tax × Number of days

Who owns the closing day?

It depends on the purchase contract and local custom. Many contracts charge the day of closing to the buyer. The exam will tell you. In the examples below, the buyer owns the day of closing, so the seller pays through the day before.

Worked example 1: taxes paid in arrears (365-day year)

Annual taxes are $3,650, paid in arrears for the calendar year. Closing is March 15 (not a leap year). The buyer owns the closing day.

  1. Seller’s days = January 1 through March 14
  2. Days = 31 (Jan) + 28 (Feb) + 14 (Mar) = 73
  3. Daily tax = $3,650 ÷ 365 = $10
  4. Seller’s share = $10 × 73 = $730
  5. Answer: $730 credit to the buyer, $730 debit to the seller

Worked example 2: taxes paid in advance (365-day year)

The seller paid the full year’s taxes of $4,380 in advance. Closing is September 20. The buyer owns the closing day.

  1. Buyer’s days = September 20 through December 31
  2. Days = 11 (Sep 20–30) + 31 (Oct) + 30 (Nov) + 31 (Dec) = 103
  3. Daily tax = $4,380 ÷ 365 = $12
  4. Buyer’s share = $12 × 103 = $1,236
  5. Answer: $1,236 debit to the buyer, $1,236 credit to the seller

Worked example 3: 360-day year (30-day months)

Annual taxes are $3,600, paid in arrears. Closing is June 16. Use a 360-day year. The buyer owns the closing day.

  1. Seller’s days = January 1 through June 15
  2. Days = 5 full months × 30 + 15 = 165
  3. Daily tax = $3,600 ÷ 360 = $10
  4. Seller’s share = $10 × 165 = $1,650 (credit to the buyer)

Check it by months: monthly tax = $3,600 ÷ 12 = $300; $300 × 5 + $10 × 15 = $1,650. ✔

Cash to close

The Closing Disclosure’s “Cash to Close” is the money the buyer must bring. At its simplest:

Cash to close = Down payment + Closing costs + Prepaids and initial escrow deposit − Earnest money deposit − Seller credits − Lender credits − Other credits (such as a tax proration credit)

Where:

Worked example: cash to close

Price $300,000. Loan $270,000. Closing costs $8,500. Prepaids and escrow deposits $3,200. Earnest money deposit $5,000. The seller agreed to pay $3,000 of the buyer’s costs. The buyer also gets a $730 tax proration credit.

  1. Down payment = $300,000 − $270,000 = $30,000
  2. Money owed = $30,000 + $8,500 + $3,200 = $41,700
  3. Credits = $5,000 + $3,000 + $730 = $8,730
  4. Cash to close = $41,700 − $8,730 = $32,970

Seller concessions (interested party contributions)

Programs limit how much a seller (or other interested party) can contribute toward the buyer’s costs, as a percent of the price (or value):

Program Limit
Conventional (Fannie Mae), primary home, LTV over 90% 3%
Conventional (Fannie Mae), primary home, LTV 75.01%–90% 6%
Conventional (Fannie Mae), primary home, LTV 75% or less 9%
Conventional (Fannie Mae), investment property 2%
FHA 6%
VA (seller concessions, not counting normal closing costs) 4%

Worked example: concession limit

A buyer is purchasing a $300,000 primary home with a conventional loan at 95% LTV.

  1. Limit for LTV over 90% = 3% = 0.03
  2. Maximum seller contribution = $300,000 × 0.03 = $9,000

Numbers to memorize

Item Number or rule
Daily proration (actual days) Annual ÷ 365
Daily proration (banker’s year) Annual ÷ 360 (30-day months)
Taxes paid in arrears Credit buyer, debit seller
Taxes paid in advance Credit seller, debit buyer
Fannie Mae seller contribution limits 3% / 6% / 9% (by LTV); 2% investment
FHA seller contribution limit 6%
VA seller concession limit 4%

Memory tricks

Watch out on the exam