Property
Name:
Property Address:
City/State/Zip:
Purchase Date:
Purchase Details
Purchase Price
Property Tax
Transfer Tax
Appraisal
Closing/Escrow Fee
Title Fees
Title Insurance
Exam Fee
Survey Fee
Flood Determination
Homeowners Insurance
Escrow Deposit
Recording Fees
Processing Fee
Underwriting Fee
Total Costs/Fees
=SUM(D7:D21)
Financing
Financing New Bank Loan
Down Payment (%)
=C26*D7+(D22-D7)
New Note Amount
=D22-D26
Interest Rate
Term (yr)
Mortgage Payment
=IFERROR(PMT(D29/12,D30*12, D27, 0)*-1,0)
Current Value
Appraised/ Zillow Value
Date of Appraisal
Expected Appreciation/Depreciation
(Case Shiller)
Income Statement
Vacancy and Credit Loss Percentage
%
Revenue
Amount
Freq
Annual
Potential Gross Income
=G3*H3
Vacancy and Credit Loss @10%
=-G4*H4
Effective Gross Income
=G3-G4
12
=I3+I4
Expenses
Insurance
=-G7*H7
Property Tax
=-G8*H8
Utilities
=-G9*H9
Repairs and Maintenance
=-G10*H10
License and Inspection Fees
=-G11*H11
Lawn Care
=-G12*H12
Consulting Fee's
=-G13*H13
Property Management Fee's
=-G14*H14
Mortgage Payment
=D31
12
=-G15*12
Total Expenses
=I16/H16
12
=SUM(I7:I15)
Net Income (Before Taxes)
=I19/H19
12
=I5+I16
Taxes
Marginal Tax Rate
Tax Cost or Deduction
=-(I19*I22)
Net Income (After Taxes)
=I19+I23
% Income (Rate of Return)
=IFERROR(I24/D26,0)
Summary
Beginning Value
=D22
Appreciation/Depreciation
=D34-D22
Net Income
=I24*I36
Mortgage Payoff
=(D27+FV(D29/12,I36*12,-D31,D27))
Ending Value
=I29+I30+I31+I37
Gain/Loss
=SUM(I30,I31,I37)
Cumulative % Gain/Loss
=IFERROR(I33/D26,0)
Annual % Gain/Loss
=RATE(I36,0,-I29,Zillow-D27,0,2.00)
Number of Years
=(D35-C5)/365
– information is autopopulated by Zillow.
– information is autopopulated by Zillow. – information is autopopulated by Zillow.