|
|
MULTI - FAMILY STAT / PROFORMA SHEET | ||||||||||
| Property Address: | Franklin Apartments | ||||||||||
| City: | Liberty | State: | MO | Zip | BRICE BRADSHAW | ||||||
| Date: | Listing Price: | $550,000 | Phone: | 913-901-6305 | |||||||
| MLS No. | |||||||||||
| Directions: | |||||||||||
| KCCommercial.net | |||||||||||
| Unit Description | Current Data | Market Rental Data | |||||||||
| # of Units | # Bed | # Bath | Unit Rent | Mo. Rent | Yearly Rent | Unit Rent | Mo. Rent | Yearly Rent | |||
| 1 | Studio | 1 | $395 | $395 | $4,740 | $395 | $395 | $4,740 | |||
| 6 | Studio | 1 | $475 | $2,850 | $34,200 | $500 | $3,000 | $36,000 | |||
| 13 | 1 | 1 | $503 | $6,539 | $78,468 | $525 | $6,825 | $81,900 | |||
| $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| TOTALS | $9,784 | $117,408 | TOTALS | $10,220 | $122,640 | ||||||
| PROFORMA | § | § | |||||||||
| 6 | GROSS SCHEDULED INCOME: | $117,408 | % GSI | % GSI | $122,640 | ||||||
| 7 | Vacancy and Credit Losses: | $8,219 | Â | 7.0%[1] | 7.0%[2] | ¨ | $8,585 | ||||
| 8 | Other Income: | $1,800 | Â | 1.5% | 1.5% | ¨ | $1,800 | ||||
| 9 | ADJUSTED GROSS INCOME (L6-(L7+L8)): | $110,989 | % AGI | % AGI | $115,855 | ||||||
| 10 | Â | 0.0% | 0.0% | ¨ | |||||||
| 11 | Accounting and Legal: | $937 | Â | 0.8% | 0.8% | ¨ | $937 | ||||
| 12 | Repairs and Maintenance: | $14,000 | Â | 12.6% | 12.1% | ¨ | $14,000 | ||||
| 13 | Replacement Reserves: | $4,000 | Â | 3.6% | 3.5% | ¨ | $4,000 | ||||
| 14 | Management: | $8,879 | Â | 8.0%[3] | 8.0%[4] | ¨ | $9,268 | ||||
| 15 | Insurance: | $5,300 | Â | 4.8% | 4.6% | ¨ | $5,300 | ||||
| 16 | Taxes: | $4,932 | Â | 4.4% | 4.3% | ¨ | $4,932 | ||||
| 17 | Trash: | $3,059 | Â | 2.8% | 4.1% | ¨ | $4,740 | ||||
| 18 | Electric: | $10,100 | Â | 9.1% | 8.7% | ¨ | $10,100 | ||||
| 19 | Gas: | $5,671 | Â | 5.1% | 4.9% | ¨ | $5,671 | ||||
| 20 | Other: | Water: | $6,000 | Â | 5.4% | 5.2% | ¨ | $6,000 | |||
| 21 | Total Expenses(sum L10 - L20): | $62,878 | Â | 56.7% | 56.1% | ¨ | $64,948 | ||||
| 22 | Net Operating Income(L9 minus L21): | $48,111 | $50,907 | ||||||||
| 23 | Less Annual Debt Service: | 26,816 | Â | 24.2% | 23.1% | ¨ | 26,816 | ||||
| 24 | Net Income (Cash Flow) L22-L23): | 21,295 | 24,091 | ||||||||
| 25 | CAP RATE (NOI ü PURCHASE PRICE): | 8.75% | 9.26% | ||||||||
| 26 | RETURN ON INVESTMENT (NI ü DOWN): | 15.49% | 17.52% | ||||||||
| Estimated Financing | |||||||||||
| Purchase Price: | $550,000 | 4.25% | :Interest | ||||||||
| 25% | Down: | $137,500 | 25 | :Years Amortized | |||||||
| Amount Financed: | $412,500 | $2,234.67 | :P&I Monthly Payment | ||||||||