Property
Purchase Details
=SUM(D7:D21)
Financing
Financing New Bank Loan
=C26*D7+(D22-D7)
=D22-D26
 
=IFERROR(PMT(D29/12,D30*12, D27, 0)*-1,0)
Current Value
Income Statement
Vacancy and Credit Loss Percentage %

Revenue Amount Freq Annual
=G3*H3
=-G4*H4
=G3-G4 12 =I3+I4
 
Expenses
=-G7*H7
=-G8*H8
=-G9*H9
=-G10*H10
=-G11*H11
=-G12*H12
=-G13*H13
=-G14*H14
=D31 12 =-G15*12
=I16/H16 12 =SUM(I7:I15)
 
=I19/H19 12 =I5+I16
Taxes
=-(I19*I22)
=I19+I23
=IFERROR(I24/D26,0)
Summary
=D22
=D34-D22
=I24*I36
=(D27+FV(D29/12,I36*12,-D31,D27))
=I29+I30+I31+I37
=SUM(I30,I31,I37)
=IFERROR(I33/D26,0)
=RATE(I36,0,-I29,Zillow-D27,0,2.00)
=(D35-C5)/365

– information is autopopulated by Zillow.