|
Setup
|
Buyer
|
Seller
|
HUD-1
|
TRANSACTION DETAILS
Paid by or on behalf of Buyer
FILL IN YELLOW FIELDS ONLY
Earnest Money Deposit
Program Advisor:
Settlement Date
Current Year Property Taxes
Additional Down Payment
PITI
Contract Sales Price
Taxes paid year to date by seller prior to closing
Total Down Payment
DP=
Loan To Value
Month
Quarter
Half Year
Year
Tax Proration Periods
Base Loan Amount
FHA Minimum Down
Conventional:
Personal Property (Normally 0)
Association Fees Monthly
Conventional
FHA
DVA
Sele
ct the Type of Loan
Mortgage Insurance Monthly Premium=
Seller PD points, close costs & ppds.
Seller Paid HOA fees (in period of closing)
Upfront MIP Mortgage Insurance Premium on FHA Mortgage
Annual FHA (Paid
Monthly)
Month
Quarter
Year
HOA Proration Periods
Upfront DVA Funding Fee=
DVA TIM
E USED
Active First
Active Subsequent
Reserves/Guard First
Reserves/Gaurd Subsequent
About the Sellers:
Lender Name
Loan Amount with FHA MIP or DVA Funding Fee
Seller(s) Name(s)
Address
Loan Origination Fees
Address
City State Zip
Origination Fee:
0.25%
0.50%
0.75%
1%
Override % & enter flat fee?
YES
NO
City State Zip
Loan Officer Name
Loan Term in Years
P&I=
Total Payment =
About the Buyers
File Number
Interest Rate:
Points Calculator:
equ
als:
Pay Point
s?
YES
NO
Borrower(s) Name(s)
Loan Number
Your credit or charge (points) for the specific interest rate chosen
Address
Mortgage Insurance Case #
Arm or Balloon Endorsement Fee
City State Zip
Settlement Agent Name
Lender Commitment Fee
About the Subject Property:
Place of Settlement
Underwriting Fee
Number of Credit Reports
1
2
3
4
5
6
Property Location
City State Zip
Appraisal fee to
City State Zip
Credit report to
Paid By Seller
Tax service fee to
1st Mortgage Owed Enter actual if known
Seller NET:
To Net Zero:
Flood Certification
% Rate 1st Mortgage
0
1
2
3
Months to close (use zero if actual is entered above)
Title Fees
Estimated Mortgage Payoff to
Lenders Title Insurance
Actual
Estimate
0.18%
0.19%
0.20%
0.21%
0.22%
0.23%
0.24%
0.25%
0.26%
0.27%
Input Actual If Known
2nd Mortgage Owed Enter actual if known
Title Insurance to
Name of Title Insurance company
% Rate 2nd Mortgage
0
1
2
3
Months to close (use zero if actual is entered above)
Owners Title
Insurance
Actual
Estimate
0.20%
0.13%
0.14%
0.15%
0.16%
0.17%
0.18%
0.19%
0.20%
0.21%
0.22%
0.23%
0.24%
0.25%
0.26%
Input Actual If Known
Estimated Mortgage Payoff to
Plat Drawing Inspection
3rd Mortgage Owed Enter actual if known
Recording Service Fees
% Rate 3rd Mortgage
0
1
2
3
Months to close (use zero if actual is entered above)
Title Company Closing / Settlement Fee
Estimated Mortgage Payoff to
Fees Paid to Others
Listing Broker Total Commission Percentage
Fees paid to a private inspector (Paid outside of Closing)
YES
NO
Commission Paid on seller paid buyer closing costs?
Buyer Broker Administrative Compliance Fee
Payout percentage to buyer broker
Home Warranty
Listing Broker Commission
Hazard Insurance
Buyer Broker Commission
1st Yr Hazard Insurance
Actual
Estimate
0.005
0.006
0.007
0.008
0.009
0.01
0.011
0.012
0.013
0.014
0.015
0.016
0.017
0.018
0.019
Input Actual If Known
Listing Broker Administrative Compliance Fee
Override?
YES
NO
Government Taxes and Fees
Special Assessments Levied
Number of Documents to file
1
2
3
4
5
6
7
8
9
10
Special Assessments Pending
Registration Information
Local Preferences
Abstracting / Searches
Override?
YES
NO
Your Full Name
% Deed Tax Seller
Title Company Closing / Settlement Fee
Override?
YES
NO
Company Name
% Mortgage Registration Tax
Recording and Service Fee
YES
NO
11118 Minnetonka Blvd.
Address
Conservation Fee each side of transaction
Well/Septic/Soil/Tests/Truth in Housing Fees
Hopkins MN 55305
City State Zip
Recording Fee to County per document filed
Phone Number
Service Fee per document filed
Cell Number
Cost of Credit Reports
Other Recording Fees (Well, Probate, etc. if any)
team@heubach.com
Email Address
Name & Judgment Search
Instructions:
You can change all of the fields with Yellow highlights.
The fields that have a green highlighted description are the most important fields, and will change the most from transaction to transaction.
After filling in this Form, see the results on the Buyer, Seller, or HUD-1 tabs at the bottom of the page.
This software requires Microsoft Excel to Run.
Only the HTML version runs without Microsoft Excel.
http://www.WestRealty.com
Web Site
Title Closing Fee
BETA 2.0
Your Serial Number
Plat Drawing Fee
Abstracting
Real Estate Professional Transaction Estimating Software.
Real Estate Buyer Closing Cost & Seller Net Estimator Software, Featuring 2010 HUD-1 Form
Copyright 2009, Linda & Charles Heubach & Salon Rental, Inc.
All Rights Reserved.
Not Intended as Settlement Software.
Use For Buyer Estimates, Seller Nets, and Short Sale Calculations.
|
Setup
|
Buyer
|
Seller
|
HUD-1
|
Estimate of Buyer's Closing Costs
Prepared for:
Type of Loan
1
SALE PRICE OF HOME
Personal Pro
perty:
(Should normally be Zero)
2
DOWN PAYMENT INCLUDING EARNEST MONEY %
3
MORTGAGE AMOUNT (BASE)
4
DVA Funding Fee Paid at Closing. Added to Loan
5
FHA Mortgage Insurance Premium (MIP) Paid at closing.
Added To Loan
6
Mortgage Amount with included FHA MIP or DVA Funding Fee (Upfront Mortgage Insurance)
LOAN FEES
7
Origination or Assumption Fee
8
Points you have elected to pay for the specific interest rate chosen
(
)
9
Credit Report
10
Appraisal Fee
11
Arm or Balloon Endorsement Fee
12
Commitment Fee
13
Underwriting Fee
14
Flood Certification
15
Tax Service Fee
TITLE INSURANCE & CLOSING FEES
16
Lenders Title Insurance
17
Title Insurance (Owner) or Attorney Opinion.
18
Plat Drawing Inspection
19
Recording Fees
20
Name & Judgment Search
21
Other Taxes
22
Mortgage Registration Tax.
23
Settlement / Closing Fee
ADDITIONAL PREPAID OR OTHER SERVICES FEES
24
Interim Interest
Number of days
@
per day
25
Home Warranty
(Paid Outside of Closing)
26
1st Yr Hazard Insurance (Paid Directly to your Insurer outside of closing)
27
Fees Paid to a Private Inspector (Paid Outside of Closing)
28
Real Estate Broker Administrative Fee
29
Total Closing Costs
ESCROW ACCOUNT
30
Homeowners Insurance Cushion (2 Months)
31
Mortgage Insurance Cushion
(2 Months)
32
Property Tax Proration
33
Home Owners Association Fee Proration
34
Property Tax Cushion
(4 Months)
35
Total Expenses Including Escrow Account and Down Payment
36
LESS: Sellers Paying Buyer's Closing Costs, Points, or Pre-Paids
(must not exceed line 32)
MONTHLY PAYMENT BREAKDOWN
37
Principal & Interest
38
Homeowners Insurance
39
Mortgage Insurance (Conventional)
40
Mortgage Insurance (FHA)
41
Taxes
42
Homeowner Association Fees
(HOA)
43
Total Monthly Payment
44
Total Cash Required to Close, including down Payment:
45
Total of Payments over 30 Years:
46
Total Interest over 30 Years:
47
APR :
These estimates are based upon information available at this date & may not agree with actual charges determined at closing. Also see your lenders good faith estimate, which should be provided to you by the loan officer. Take time to review these services
Buyer Signature
Date
Buyer Signature
Date
|
Setup
|
Buyer
|
Seller
|
HUD-1
|
Seller's Estimate of Net Proceeds
Your Agent is:
Insert Logo Here
Settlement Date:
Sale Price
Estimated First Mortgage Payoff
Estimated 2nd Mortgage Payoff
Estimated 3rd Mortgage Payoff
SUBTOTAL:
Payoff of Mortgages
Listing Real Estate Brokerage Fee
Selling Real Estate Brokerage Fee
Real Estate Brokerage Administrative Fee
State Deed Tax ($3.30 per $1000.00 of sale price)
Closing/Settlement Fee
Recording & Service Fees
Property Tax Pro-ration
Seller Paid Buyers Points, Closing Costs, or Pre-Paid Expenses
Association Fees
Other Recording Fees (Well, Probate, etc. if any)
Conservation Fee
Total of Closing costs
Total Estimated Selling Expenses including mortgage payoffs
Less any Contract for Deed or Mortgage Held By Seller
ESTIMATED NET PROCEEDS TO SELLER
Seller(s) acknowledge receipt of a copy of this Seller(s) Estimate Selling Expense and understand that the figures are based upon those available as of this date and may not be totally accurate or complete as of the date of closing.
Seller Signature
Date
Seller Signature
Date
|
Setup
|
Buyer
|
Seller
|
HUD-1
|
OMB Approval No. 2502-0265
A.
Settlement Statement (HUD-1)
PRELIMINARY
B. Type of Loan
1
FHA
2
RHS
3
Conv Unins
6. File Number
7. Loan Number
8. Mortgage Insurance Case Number
""
""
""
4
VA
5
Conv Ins
C. Note: This form is furnished to give you a statement of actual settlement costs. Amounts paid to and by the settlement agent are shown. Items marked "(p.o.c)" were paid outside closing: they are shown here for informational purposes and are not included in the totals.
D. Name and Address of Borrower:
E: Name and Address of Seller:
F: Name and Address of Lender
G: Property Location
H: Settlement Agent
I: Settlement Date
"-"
Place of Settlement:
J. Summary of Borrower's Transaction
J. Summary of Seller's Transaction
100
Gross Amount Due From Borrower
400
Gross Amount Due to Seller
101
Contract sales price
401
Contract sales price
102
Personal Property
402
Personal Property
103
Settlement charges to borrower (line 1400)
403
104
404
105
405
Adjustments for items paid by seller in advance
Adjustments for items paid by seller in advance
106
City/town taxes
to
406
City/town taxes
to
107
County taxes
to
407
County taxes
to
108
Assessments
to
408
Assessments
to
109
HOA Fees
to
409
HOA Fees
to
110
410
111
411
112
412
120
Gross Amount Due From Borrower
420
Gross Amount Due to Seller
200
Amounts Paid for or in Behalf of Borrower
500
Reductions in Amount Due to Seller
201
Deposits or earnest money
501
Excess deposit (see instructions)
202
Principal amount of new loan
502
Settlement charges to seller (line 1400)
203
Existing loan(s) taken subject to
503
Existing loan(s) taken subject to
204
504
Payoff of first mortgage loan
205
505
Payoff of second mortgage loan
206
506
207
Seller Paid Buyer Closing Costs
507
Seller Paid Buyer Closing Costs
208
508
209
509
Adjustments for items unpaid by seller
Adjustments for items unpaid by seller
210
City/town taxes
to
510
City/town taxes
to
211
County taxes
to
511
County taxes
to
212
Assessments
to
512
Assessments
to
213
HOA Fees
to
513
HOA Fees
to
214
514
215
515
216
516
217
517
218
518
219
519
220
Total Paid by/for Borrower
520
Total Reduction Amount Due Seller
300
Cash at Settlement from/to Borrower
600
Cash at Settlement to/from Seller
301
Gross Amount Due From Borrower (line 120)
601
Gross amount due to seller (line 420)
302
Less amounts paid by/for borrower (line 220)
602
Less reductions in amount due seller (line 520)
303
Cash
To
To Borrower
"-"
603
Cash
To
From Seller
"-"
The Public Reporting Burden for this collection of information is estimated at 35 minutes per response for collecting, reviewing, and reporting the data. This agency may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number.
No confidentiality is assured, this disclosure is mandatory. This is designed to provide the parties to a RESPA covered transaction with information during the settlement process.
Previous editions are obsolete
Page 1 of 3
HUD-1
L. Settlement Charges
700
Total Real Estate Broker Fees
@
Paid From Borrower's Funds at Settlement
Paid From Seller's Funds at Settlement
Division of commission (line 700) as follows:
701
to
702
to
703
Commission paid at settlement
704
Administrative Compliance Fees
800
Items payable in Connection with Loan
801
Our origination charge
(from GFE #1)
802
Your credit or charge (points) for the specific interest rate chosen
(from GFE #2)
803
Your adjusted origination fees
(from GFE A)
804
Appraisal fee to
(from GFE #3)
805
Credit report to
(from GFE #3)
806
Tax service fee to
(from GFE #3)
807
Flood Certification
(from GFE #3)
808
Commitment Fee & Underwriting Fee
900
Items Required by Lender to Be Paid in Advance
901
Daily interest charges from
to
@$
/day
days
(from GFE #10)
902
Mortgage Insurance Premium
for
2
months to
(from GFE #3)
903
Homeowner's insurance
for
1
years to
(from GFE #11)
904
1000
Reserves Deposited with Lender
1001
Initial Deposit for your escrow account
(from GFE #9)
1002
Homeowner's insurance
months @$
per month
1003
Mortgage Insurance
months @$
per month
1004
Property Taxes
months @$
per month
1005
months @$
per month
1006
months @$
per month
1007
Aggregate Adjustment
-$
1100
Title Charges
1101
Title Services and lender's title insurance
(from GFE #4)
1102
Settlement or closing fee
1103
Owner's title insurance
(from GFE #5)
1104
Lenders title insurance
1105
Lenders title policy limit $
1106
Owner's title policy limit $
1107
Agent's portion of the total title insurance premium
1108
Underwriter's portion of the total title insurance premium
1109
Name & Judgment Search
1110
Plat Drawing
1111
1113
1200
Government Recording and Transfer Charges
1201
Government recording charges
(from GFE #7)
1202
Deed $
Mortgage $
Releases $
1203
Transfer taxes
(from GFE #8)
1204
City/County t
ax stamps
Deed $
Mortgage $
1205
State tax/stamps
Deed $
Mortgage $
1206
1300
Additional Settlement Charges
1301
Required Services that you can shop for
(from GFE #6)
1302
Warranty
$
1303
Private Inspection Fee
$
1304
Survey to
1305
Document Handling Fee to
1306
Recording Service Fee to
1307
Water Bill to
1308
Sellers Closing Fee to
1309
Current Year Real Estate Taxes Paid in Full to
1310
1311
1312
1313
1400
Total Settlement Charges (enter on lines 103, Section J and 502, Section K
Previous editions are obsolete
Page 2 of 3
HUD-1
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.