ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Key:
4
Blue
Input figures here
5
6
7
8
Step 1: Closing Disclosure Form Cost AnalysisStep 2: Property Basis and Depreciation Calcuation
9
10
Property AddressPurchase DateImprovement Basis AnalysisProperty Tax Card Information
11
[Street]6/1/2022Improvement Ratio#DIV/0!Land Value$0.00
12
[City][State][ZIP]Building Value#DIV/0!Improvement Value$0.00
13
Purchase Price$0.00Land Value#DIV/0!Total Value$0.00
14
Depreciation Analysis
15
Expenses That Increase Loan Cost BasisAnnual#DIV/0!
16
Monthly#DIV/0!
17
Loan Origination Fee$0.00First Month (1/2 Monthly Depr.)#DIV/0!
18
Loan Discount$0.00First Year#DIV/0!
19
Appraisal (Required by Lender)$0.00Loan Details
20
Credit Report$0.00Rate0.00%
21
Mortgage Insurance$0.00Years0
22
Assumption Fee$0.00Monthly Payment#NUM!
23
Application Fee$0.00Amortization of Loan Costs Analysis
24
Other$0.00Annual #DIV/0!
25
TOTAL LOAN COST$0.00Monthly #DIV/0!
26
Expenses that Increase Property Cost BasisPaid Outside of ClosingFirst Month (1/2 Monthly Amort)#DIV/0!
27
First Year#DIV/0!
28
Title Insurance - Lender$0.00Appraisal$0.00
29
Title Insurance - Owner$0.00Inspection$0.00
30
Title Search$0.00Survey$0.00
31
Gov't Recording Charges$0.00Other$0.00
32
Attorney Fees$0.00TOTAL POC$0.00NOTES
33
State/City/County Tax Stamps$0.00
34
Transfer Taxes$0.00
35
Appraisal (Not Required by Lender)$0.00
36
Survey$0.00
37
Inspection(s) $0.00
38
Other$0.00
39
TOTAL CLOSING (basis)$0.00
40
Expenses that are Currently Deductible
41
42
Property Taxes Paid$0.00
43
Interest Paid$0.00
44
Insurance Paid$0.00
45
TOTAL CURRENT EXP$0.00
46
Reserves and Deposits
47
48
Escrow Deposit With Lender$0.00
49
Security Deposits from Seller$0.00
50
Reductions to Amount Due
51
52
Earnest Money Deposit$0.00
53
Loan Funds$0.00
54
Tax Adjustment Unpaid by Seller$0.00
55
Pro-Rated Rental Income$0.00
56
Lender Credit to Buyer$0.00
57
Seller Credit to Buyer$0.00
58
Due From Borrower/(Due To Borrower)$0.00
59
Property Cost Basis$0.00
60
Loan Cost Basis$0.00
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100