Multi-Family Proforma

Property Details

Purchase Price ($)

Total Number of Units (#)

Rent per Unit per month ($)

Repairs per unit ($)

All in costs

500,000

Price per door

125,000

Down Payment (%)

Interest Rate (%)

Duration of loan (years)

Tax rate (%)

1. Income

%
Month
Annual

Rental Income ($)

100%
6,000
72,000

Laundry Income($)

0%
0

Storage Income($)

0%
0

Parking Income($)

0%
0

Other Income($)

0%
0

-

-

-

-

-

-

-

-

-

-

Total Income

6,000
72,000

2. Expenses

%
Month
Annual

Property Tax (%)

688
8,250

Insurance (%)

174
2,088

Utilities: Water/Sewer (%)

264
3,168

Utilities: Garbage (%)

240
2,880

Utilities: Electric (%)

318
3,816

Utilities: Gas (%)

60
720

HOA Fees (%)

0
0

Lawn and Snow (%)

69
828

Vacancy (%)

300
3,600

Repairs (%)

180
2,160

Capital Expenditures (%)

264
3,168

Property Management

480
5,760

Operating Expenses

51%
3,036
36,438

Net Operating Income

49%
2,964
35,562

Morgage Payment

47%
2,832
33,990

Total Monthly Expenses

5,869
70,428

3. Cash Flow

Month
Annual

Total Monthly Income

6,000
72,000

Operating Expenses

3,036
36,438

Morgage

2,832
33,990

Total Monthly Cashflow Before Taxes

131
1,572

Taxes owed

46
550

Total Monthly Cashflow

85
1,022

4. Metrics and Analytics

Annual Net Operating Income (NOI)

35,562

Cap Rate

7.1%

Cash On Cash Return (COC)

0.8%

Debt Service Coverage Ratio (DSCR)

1.0X

Gross Rent Multiplier (GRM)

6.9X

Total Equity

125,000

Loan Amount

375,000

Loan Constant

9.1%

Loan to value (LTV)

75.0%

Loan to cost (LTC)

75.0%

Breakeven Loan Value

392,346

Return on Equity (ROE)

0.8%

Annual Debt Service

33,990