| IRR: | 5.25% | Year | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||||
| Land | $ 75,000 | Down Payment | (70,000) | |||||||||||
| Improvements | $ 275,000 | Interest Payment | (18,620) | (18,410) | (18,186) | (17,948) | (17,693) | (17,421) | (17,132) | (16,823) | (16,494) | (16,142) | ||
| Purchase Price | $ 350,000 | Amortization | (3,156) | (3,366) | (3,590) | (3,829) | (4,083) | (4,355) | (4,644) | (4,953) | (5,283) | (5,634) | ||
| Property Taxes | (7,000) | (7,280) | (7,571) | (7,874) | (8,189) | (8,517) | (8,857) | (9,212) | (9,580) | (9,963) | ||||
| Down Payment | 20% | Insurance | (2,500) | (2,575) | (2,652) | (2,732) | (2,814) | (2,898) | (2,985) | (3,075) | (3,167) | (3,262) | ||
| Interest Rate | 6.65% | Maintenance | (1,000) | (1,030) | (1,061) | (1,093) | (1,126) | (1,159) | (1,194) | (1,230) | (1,267) | (1,305) | ||
| Property Tax Rate | 2.00% | Commissions | (29,890) | |||||||||||
| Insurance (per year) | $2,500 | Capital Gains Tax | (22,224) | |||||||||||
| Maintenance (per year) | $1,000 | Tax on Recaptured Depreciation | (25,000) | |||||||||||
| Tax Bracket | 28% | Mortgage Payoff | (237,108) | |||||||||||
| (102,276) | (32,661) | (33,060) | (33,475) | (33,904) | (34,350) | (34,813) | (35,292) | (35,790) | (350,527) | |||||
| Rent (per month) | $ 1,750 | |||||||||||||
| Occupancy | 97% | |||||||||||||
| Property Tax Rate | 2% | Rent | 21,000 | 21,630 | 22,279 | 22,947 | 23,636 | 24,345 | 25,075 | 25,827 | 26,602 | 27,400 | ||
| Inflation Factor | 3% | Passive Loss Tax Benefit | 2,274 | 2,146 | 2,014 | 1,876 | 1,732 | 1,582 | 1,426 | 1,263 | 1,093 | 916 | ||
| Appreciation Factor | 4% | Depreciation Tax Benefit | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | 2,800 | ||
| Sale | 498,159 | |||||||||||||
| Investor's AGI | $ 100,000 | 26,074 | 26,576 | 27,093 | 27,623 | 28,168 | 28,727 | 29,301 | 29,891 | 30,496 | 529,276 | |||
| Passive Loss Percentage | 100% | |||||||||||||
| Cash Flows | (76,203) | (6,085) | (5,968) | (5,852) | (5,737) | (5,623) | (5,511) | (5,402) | (5,294) | 178,748 | ||||
| Property Value | 350,000 | 364,000 | 378,560 | 393,702 | 409,450 | 425,829 | 442,862 | 460,576 | 478,999 | 498,159 | ||||
| Accumulated Depreciation | 10,000 | 20,000 | 30,000 | 40,000 | 50,000 | 60,000 | 70,000 | 80,000 | 90,000 | 100,000 | ||||
| Mortgage Balance | 276,843.87 | 273,477.86 | 269,888.00 | 266,059.43 | 261,976.25 | 257,621.54 | 252,977.24 | 248,024.10 | 242,741.57 | 237,107.75 | ||||
| Passive Loss | (8,120.00) | (7,665.12) | (7,191.73) | (6,698.88) | (6,185.56) | (5,650.69) | (5,093.15) | (4,511.72) | (3,905.11) | (3,271.97) | ||||