Purchasing A Property For Rental Income Year 1 $15,725 $3,679 $3,679
Year 2 $15,725 $3,837 $7,516
Annual Mortgage Interest Property Taxes Maintenance Annual Costs
$12,046 $2,200 $2,400 $16,646
$11,888 $2,288 $2,496 $16,672
Annual Rental Income Yearly Income (Loss) Cumulative Income (Loss)
$15,600 ($1,046) ($1,046)
Annual Opportunity Cost Cumulative Opportunity Cost Annual Cash Flow Cash on Cash Return Capitalization (Cap) Rate
Annual Mortgage Payments Annual Mortgage Principal Cumulative Mortgage Principal
Year 3 $15,725 $4,002 $11,518
Year 4 $15,725 $4,174 $15,692
Year 5 $15,725 $4,353 $20,045
$11,723 $2,380 $2,596 $16,698
$11,551 $2,475 $2,700 $16,725
$11,372 $2,574 $2,808 $16,753
$16,224 ($448) ($1,493)
$16,873 $175 ($1,318)
$17,548 $823 ($495)
$18,250 $1,497 $1,001
$1,085 $1,085
$1,273 $2,359
$1,469 $3,827
$1,673 $5,500
$1,886 $7,386
($4,725) -4.4% 3.6%
($4,285) -1.6% 3.7%
($3,827) 0.6% 3.9%
($3,351) 2.3% 4.0%
($2,856) 3.7% 4.2%
Enter Parameters in Gray Boxes Purchase Price $295,000 Legal Fees to Purchase $1,000 Property Transfer Tax (PTT) $3,900 CMHC Insurance (if LTV > .80) $7,697 Adjusted Cost Base $307,597 Down payment (must be < .95 LTV) $20,000 @ Mortgage amortization – Years 35 Mortgage rate for 5 year term 4.25% Initial Mortgage Balance $287,597 Monthly Mortgage payment $1,310 Initial monthly rental income (annual increases) Annual Property Taxes Annual maintenance or condo fees Taxes, rent & maintenance increase per year Opportunity cost interest rate (annual) Opportunity cost includes down payment & principal
0.95
$1,300 $2,200 $2,400 4.00% 5.00%
LTV
Sale Price After 5 Years Legal Fees to Sell Realtor Fees (6% on 100K, 3%) Net Sale Price (after fees) Outstanding Mortgage Balance Proceeds to seller - Initial down payment - Equity (all principal payments) + Cumulative Income (Loss) Gain or (Loss) on Investment - Cumulative Opportunity Cost Gain or (Loss) compared to investing down payment and principal payments at opportunity cost rate
$319,996 $800 $12,600 $306,596 $267,553 $39,043 $20,000 $20,045 $1,001 $0 $7,386 ($7,386)
Prepared by Roger Need – July 2009