Strategy #28 · HUD Tool v3 (Investor)

Last Modified: 11/22/24

LLC Name:

EIN:

Property Street:

Property City, State, Zip:

Property Type:

Purchase Date:

Placed in Service Date:

Contract Purchase Price:

Source & Download Instructions

Source:

The formulas in the navy cells should NOT be edited. Edits may result in inaccurate information.

This document is in view-only mode. You can download a copy to be edited by following the instructions below:

File > Download > Microsoft Excel
Save a copy to your computer to begin editing

Once downloaded, the formula cells will no longer be locked, which means you could accidentally change them, resulting in inaccurate results.

Bodner & Clark LLC will continue to update this HUD tool overtime, so it may not look exactly the same from when you first saw it.

Property Tax Card Information

Land Value:

Building Value:

Total Value:

$0.00

Land Value %:

0.00%

Building Value %:

0.00%

1 - FACILITATIVE COSTS - Added to Basis of Building

Recording Fees
Broker Fees
Commissions
Owner's Title
Closing Protection Coverage
Title Settlement
Closing Fee
Doc Preparation
Endorsement / Guaranty Fees
Notary Fees
Title Insurance - Owner
Courier Fee
Tax Certificate
Title
Deed Search
Title Update Fee
Govt Recording Fee
E-Recording Fee
Attorney
Legal Fees
City
County Tax Stamps
State Tax Stamps
Transfer Taxes
Wire Fee
Survey Fee
Title Examination
Title Insurance Binder
Appraisal (not required by lender)
Inspection
Pest Inspection
Estoppel Fee
Lien Fees
Endorsement Fees
Environmental Assessment Fee
Hazard Insurance Fee
Other
TOTAL BUILDING BASIS COSTS	$0.00

2 - LOAN COSTS - Added to Basis of Loan

Loan Points
Origination Fee
Processing Fee
Tax Service Fee
Appraisal Fee
Credit Report Fee
Final Inspection
Flood Report
Determination
Flood Life of Loan
Environmental Review Fee
Property Tax Tracking Fee
ID Verification Fee
Escrow Fee
Application Fee
Title Insurance
Binder - Lender
Title Restrictions - Lender
Title Environmental Lien - Lender
Survey Coverage - Lender
Loan Policy Premium
Loan Services Fee
Special Tax Search
Underwriter Fees to Lender
Loan Settlement Fee
Mortgage - Documentary Stamps
Mortgage - Intangible Taxes
Loan Policy Restrictions
Lender Legal Fees
Other
TOTAL LOAN COSTS	$0.00

3 - OPERATING COSTS - Expensed Immediately

Property Taxes Paid
Prorated Interest (Daily Interest)
Homeowners Insurance Premium
HOA/Condo Fees Paid
TOTAL OPERATING COSTS	$0.00

4 - ESCROW COSTS - Deposits to Escrow Account

Homeowners Insurance
Mortgage Insurance
Property Taxes
Adjustment
TOTAL ESCROW COSTS	$0.00

Actual Land v. Building Amounts

Land Value:

$0.00

Building Value:

$0.00

Total Value:

$0.00

Building Depreciation Life

Residential:

27.5 years

Non-Residential:

39 years

Summary Reconciliation

Purchase Price:

$0.00

Land Value:

$0.00

Building Value:

$0.00

Adjustments + Seller Credits:

$0.00

Facilitative Costs:

$0.00

Paid Outside Closing (Building):

$0.00

Paid Outside Closing (Loan):

$0.00

Operating Costs:

$0.00

Property Taxes Paid (Expensed):

$0.00

Interest Paid (Expensed):

$0.00

Insurance Premiums Paid (Expensed):

$0.00

HOA Fees Paid (Expensed):

$0.00

Paid Outside of Closing & Added to Basis of Building

Appraisal:
Inspection:
Survey:
Title - Owners Coverage Premium:
TOTAL PAID OUTSIDE OF CLOSING:	$0.00

Paid Outside of Closing & Added to Basis of Loan

Appraisal:
Inspection:
Survey:
Title - Owners Coverage Premium:
TOTAL PAID OUTSIDE OF CLOSING:	$0.00

Estimated Depreciation / Amortization

Building:

$0.00

Loan:

$0.00

Final Amounts

Building Value (Depreciated):

$0.00

Land Value:

$0.00

Loan Costs (Amortized):

$0.00

Acquisition Loan Details

Rate:
Years:

Closing Summary

TOTAL DUE FROM BUYER AT CLOSING:

$0.00

Pull from Settlement Statement

Reconciliation (should be $0):

$0.00

TOTAL PAID BY BUYER AT CLOSING:

$0.00

Pull from Settlement Statement

Reconciliation (should be $0):

$0.00

CASH TO CLOSE FROM / (TO) BUYER:

$0.00

Pull from Settlement Statement

Reconciliation (should be $0):

$0.00

Reductions to Amount Due

Down Payment / Earnest Money:
Loan Funds:
Prorated Property Taxes prior to Close:
Deposit to Escrow:
Security Deposits:
Prorated Rental Income:
Lender Credit:
Seller Credit:
TOTAL REDUCTIONS TO AMOUNT DUE:	$0.00

Journal Entry - Acquisition

Account	Debit	Credit
Building (Fixed Asset)	$0.00
Land (Fixed Asset)	$0.00
Loan Costs (Fixed Asset)	$0.00
Lender Reserve Escrow (Current Asset)	$0.00
Property Taxes Paid (Expense)	$0.00
Interest Paid (Expense)	$0.00
Insurance Premiums Paid (Expense)	$0.00
HOA/Condo Fees paid (Expense)	$0.00
Down Payment / Equity (Current Asset or Equity)	$0.00
Real Estate Mortgage (Long Term Liability)		$0.00
Tenant Security Deposits (Current Liability)		$0.00
Property Taxes Payable (Current Liability)		$0.00
Rental Income (Income)		$0.00
Bank Account / Equity (Asset or Equity)		$0.00
Total	$0.00	$0.00

Journal Entry - Adjusting

Account	Debit	Credit
Building (Fixed Asset)	$0.00
Loan Costs (Fixed Asset)	$0.00
Funds Paid Prior to Close (Building) (Current Asset)		$0.00
Funds Paid Prior to Close (Loan) (Current Asset)		$0.00
Total	$0.00	$0.00

DISCLAIMER: This tool is for educational purposes only and should not be relied upon as tax or legal advice. The accuracy of the numbers presented from this tool are solely dependent upon the accuracy of the information provided. All calculations should be verified for accuracy by a qualified advisor.

This tool is for informational purposes only. Consult with your tax advisor for specific guidance.