Financial Performance Summary |
||
Cash on Cash Return (Year 1) |
||
Cap Rate (Year 1) | ||
Total Equity at Year 5 | $ | |
Projected Monthly Cash Flow | $ |
Assumptions for Calculations (Annual) |
||
Gross Scheduled Income (Monthly) | $ | |
Mortgage Interest Rate | (%) | |
Mortgage Down Payment | (%) | |
Mortgage Loan Term (Fixed) | ||
Property Taxes | $ | |
Insurance | $ | |
Homeowners Association (Yearly) | $ | |
Property Management Fee | (%) | |
Maintenance Reserve | (%) | |
Appreciation Rate | (%) | |
Vacancy Allowance | (%) | |
Rental Income Increase | (%) | |
Property Tax Increase | (%) | |
Closing Costs (Purchase) | (%) | |
Closing Costs (Sale) | (%) |
Cash Flow and Equity Accumulation |
CASH-FLOW | MONTHLY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 10 | YEAR 20 | YEAR 30 |
Gross Scheduled Income | $1,150 | $13,800 | $14,076 | $14,358 | $14,645 | $14,938 | $16,492 | $20,104 | $24,507 |
Vacancy Allowance | $0 | $0 | $845 | $861 | $879 | $896 | $990 | $1,206 | $1,470 |
Total Operating Income | $1,150 | $13,800 | $13,231 | $13,496 | $13,766 | $14,041 | $15,503 | $18,898 | $23,036 |
Property Taxes | $202 | $2,419 | $2,467 | $2,517 | $2,567 | $2,618 | $2,891 | $3,524 | $4,296 |
Insurance | $50 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 |
Homeowners Association | $13 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
Maintenance Reserve | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Property Management | $92 | $1,104 | $1,126 | $1,149 | $1,172 | $1,195 | $1,319 | $1,608 | $1,961 |
minus Total Operating Expenses | $356 | $4,273 | $4,343 | $4,415 | $4,489 | $4,563 | $4,960 | $5,882 | $7,006 |
Net Operating Income | $794 | $9,527 | $8,888 | $9,081 | $9,277 | $9,478 | $10,542 | $13,015 | $16,030 |
minus Mortgage Expense | $408 | $4,891 | $4,891 | $4,891 | $4,891 | $4,891 | $4,891 | $4,891 | $4,891 |
GROSS CASH FLOW | $386 | $4,636 | $3,997 | $4,190 | $4,387 | $4,587 | $5,652 | $8,125 | $11,139 |
Plus Principle Paydown | $93 | $1,120 | $1,177 | $1,238 | $1,301 | $1,368 | $1,755 | $2,891 | $4,761 |
Plus Yearly Appreciation | $237 | $2,847 | $2,932 | $3,020 | $3,111 | $3,204 | $3,715 | $4,992 | $6,709 |
EFFECTIVE NET CASH FLOW | $717 | $8,603 | $8,107 | $8,448 | $8,799 | $9,159 | $11,122 | $16,008 | $22,609 |
EQUITY ACCUMULATION | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 10 | YEAR 20 | YEAR 30 | |
Property Value | $94,900 | $97,747 | $100,679 | $103,700 | $106,811 | $123,823 | $166,408 | $223,638 | |
(Mortgage Balance) | $74,800 | $73,622 | $72,385 | $71,084 | $69,716 | $61,755 | $38,425 | $0 | |
EQUITY (WEALTH) | $20,100 | $24,125 | $28,295 | $32,616 | $37,094 | $62,068 | $127,983 | $223,638 | |
TAX BENEFIT | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 10 | YEAR 20 | YEAR 30 | |
Depreciation | $3,451 | $3,451 | $3,451 | $3,451 | $3,451 | $3,451 | $3,451 | $3,451 | |
Mortgage Interest | $3,771 | $3,713 | $3,653 | $3,590 | $3,523 | $3,136 | $2,000 | $130 |