|
|
MULTI - FAMILY STAT / PROFORMA SHEET | ||||||||||
| Property Address: | Grantwood Village | ||||||||||
| City: | Columbia | State: | MO | Zip | BRICE BRADSHAW | ||||||
| Date: | Listing Price: | $4,200,000 | Phone: | (913) 901-6305 | |||||||
| MLS No. | |||||||||||
| Directions: | |||||||||||
| www.kccommercial.net | |||||||||||
| Unit Description | 2010 Actual | 2011 Proforma | |||||||||
| # of Units | # Bed | # Bath | Unit Rent | Mo. Rent | Yearly Rent | Unit Rent | Mo. Rent | Yearly Rent | |||
| 29 | 4 | 2 1/2 | $1,240 | $35,960 | $431,520 | $1,240 | $35,960 | $431,520 | |||
| 2 | 4 | 2 1/2 | $1,000 | $2,000 | $24,000 | $1,240 | $2,480 | $29,760 | |||
| 2 | 4 | 2 1/2 | $945 | $1,890 | $22,680 | $1,240 | $2,480 | $29,760 | |||
| 3 | 4 | 2 1/2 | $700 | $2,100 | $25,200 | $1,240 | $3,720 | $44,640 | |||
| $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| TOTALS | $41,950 | $503,400 | TOTALS | $44,640 | $535,680 | ||||||
| PROFORMA | § | § | |||||||||
| 6 | GROSS SCHEDULED INCOME: | $503,400 | % GSI | % GSI | $535,680 | ||||||
| 7 | Vacancy, Loss to Lease and Credit Losses: | $71,684 | Â | 14.2%[1] | 7.0%[2] | ¨ | $37,498 | ||||
| 8 | Misc. Income: | $0 | Â | 0.0% | 0.2% | ¨ | $900 | ||||
| 9 | ADJUSTED GROSS INCOME (L6-(L7+L8)): | $431,716 | % AGI | % AGI | $499,082 | ||||||
| 10 | Advertising: | $15,375 | Â | 3.6% | 1.0% | ¨ | $5,000 | ||||
| 11 | Administrative and Office: | $5,660 | Â | 1.3% | 0.2% | ¨ | $1,200 | ||||
| 12 | Repair and Maintenance: | $24,950 | Â | 5.8% | 5.8% | ¨ | $28,800 | ||||
| 13 | Insurance: | $17,100 | Â | 4.0% | 3.4% | ¨ | $17,100 | ||||
| 14 | Management: | $6,650 | Â | 1.5%[3] | 6.0%[4] | ¨ | $29,891 | ||||
| 15 | Pool: | $1,240 | Â | 0.3% | 0.2% | ¨ | $1,240 | ||||
| 16 | Taxes: | $39,725 | Â | 9.2% | 8.0% | ¨ | $39,725 | ||||
| 17 | Contracted Services including Shuttle: | $10,930 | Â | 2.5% | 4.2% | ¨ | $21,000 | ||||
| 18 | Utilities including Cable and Internet to Units: | $30,010 | Â | 7.0% | 6.0% | ¨ | $30,010 | ||||
| 19 | Cleaning, Snow Removal and Lawn Care: | $0 | Â | 0.0% | 1.4% | ¨ | $7,200 | ||||
| 20 | Other: | Replacement Reserves: | $0 | Â | 0.0% | 2.2% | ¨ | $10,800 | |||
| 21 | Total Expenses(sum L10 - L20): | $151,640 | Â | 35.1% | 38.5% | ¨ | $191,966 | ||||
| 22 | Net Operating Income(L9 minus L21): | $280,076 | $307,116 | ||||||||
| 23 | Less Annual Debt Service: | 197,183 | Â | 45.7% | 39.5% | ¨ | 197,183 | ||||
| 24 | Net Income (Cash Flow) L22-L23): | 82,893 | 109,934 | ||||||||
| 25 | CAP RATE (NOI ü PURCHASE PRICE): | 6.67% | 7.31% | ||||||||
| 26 | RETURN ON INVESTMENT (NI ü DOWN): | 7.89% | 10.47% | ||||||||
| Existing Financing | |||||||||||
| Purchase Price: | $4,200,000 | 4.75% | :Interest | ||||||||
| 25% | Down: | $1,050,000 | 30 | :Years Amortized | |||||||
| Amount Financed: | $3,150,000 | $16,431.89 | :P&I Monthly Payment | ||||||||
| Description: | |||||||||||
| This property summary includes assumptions, which represent a projection of future events and assumptions which may or may not occur. Absolutely no tax or legal advice is being implied or given. These projections may not and should not be relied upon to indicate results, which might be obtained. Income collected and expenses incurred will vary depending upon the type of management employed. Therefore, all information provided is solely for the purpose of permitting parties to determine whether or not the property is of such type and general character as might interest them in this purchase, and Reece Commerical/KCCommercial.net makes no warranty as to the accuracy of such information. Interested persons are expected to acquaint themselves with the property and arrive at their own conclusions as to physical condition, number and occupancy of revenue producing units, estimates of operating costs, tax matters and any factors having to do with the valuation of property. | |||||||||||