| Your Name: |
| Unit Mix Summary |
| | Units | Type | Approx. SF | Avg. Contact | Total Monthly | Market Rents | Total Monthly Market Rents |
| | 7 | 1 bd/1 ba | 600 | $1,462 | | $1,500 |
| | 3 | 2 bd/1 ba | 800 | $1,785 | | $1,850 |
| Totals | 10 |
| Acquisition | | Operations | | Financing | | Disposition |
| Gross Income Multiplier | 14.50 | Rental Increase | 3% | Interest Rate | 3.625% | Exit Cap Rate | 4.75% |
| Prop. Tax Rate | 1.15% | Vacancy | 2% | Term | 30 | Costs of Sale | 1% |
| Prop Tax Incr. | 2% | Property Mgmt | 5% | Debt Cov. Ratio | 1.25 | Broker Comm. | 5% |
| Acquisition Costs | $10,000 | Laundry Inc. | $15 | Points | 1.00 |
| Discount Rate | 14% | Op. Exp. Incr. | 2.50% |
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Rental Income |
| Laundry |
| GROSS SCHEDULED INCOME |
| Turnover Vacancy |
| GROSS OPERATING INCOME |
| Expenses |
| Property Management Fee |
| Building Insurance | $ 2,195.00 |
| Grounds Maintenance | $ 1,560.00 |
| Maintenance | $ 2,500.00 |
| Pest Control | $ 600.00 |
| Reserves | $ 1,700.00 |
| Taxes - Real Estate |
| Trash Removal | $ 1,000.00 |
| Utilities - Gas & Electric | $ 2,500.00 |
| Utilities - Water & Sewer | $ 5,000.00 |
| TOTAL OPERATING EXPENSES |
| NET OPERATING INCOME |
| Annual Debt Service |
| Cash Flows Before Taxes - Operations |
| Purchase Price | | | | | Sale Price |
| Loan Amount | | | | | Costs of Sale |
| Acquisition Costs | | | | | Broker Comm. |
| Loan Points | | | | | Loan Balance |
| Initial Equity | | | | | Net Sale Proceeds |
| Equity Cash Flows Before Taxes |
| IRR |
| PV of Cash Flows |
| Initial Investment |
| Net Present Value |
| Cash on Cash |
| Loan to Value Ratio |
llhhh666
hw_3_-_pro_forma1.xlsx
