Multi Family Calculator

Opportunity Quick Analysis

Pro-Forma

Actual

What If… (1)

What If… (2)

Purchase Price:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Gross Potential Rental Income:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Vacancy & Credit Loss:

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

OR $:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Vacancy & Credit Loss Used:

Pro-Forma

Actual

What If… (1)

What If… (2)

Other Income (not affected by vacancy):

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Effective Gross Income (EGI):

Pro-Forma

Actual

What If… (1)

What If… (2)

Total Operating Expenses:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Operating Ratio (Expenses As % of EGI):

Pro-Forma

Actual

What If… (1)

What If… (2)

OR %:

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

Expenses Being Used From Above:

Pro-Forma

Actual

What If… (1)

What If… (2)

Net Operating Income (NOI):

Pro-Forma

Actual

What If… (1)

What If… (2)

Cap Rate:

Pro-Forma

Actual

What If… (1)

What If… (2)

Value (based on cap rate):
%

Pro-Forma

Actual

What If… (1)

What If… (2)

Primary Financing:

Pro-Forma

Actual

What If… (1)

What If… (2)

Loan LTV:

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

Loan Amount:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Loan Amount Used:

Pro-Forma

Actual

What If… (1)

What If… (2)

Amortized or Interest-Only:

Pro-Forma

Actual

What If… (1)

What If… (2)

Interest Rate:

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

Term (years):

Pro-Forma

Yr

Actual

Yr

What If… (1)

Yr

What If… (2)

Yr

Periods Per Year:

Pro-Forma

#

Actual

#

What If… (1)

#

What If… (2)

#

Monthly Payments:

Pro-Forma

Actual

What If… (1)

What If… (2)

Loan Constant:

Pro-Forma

Actual

What If… (1)

What If… (2)

Secondary Financing:

Pro-Forma

Actual

What If… (1)

What If… (2)

Loan LTV:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Loan Amount:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Loan Amount Used:

Pro-Forma

Actual

What If… (1)

What If… (2)

Amortized or Interest-Only:

Pro-Forma

Actual

What If… (1)

What If… (2)

Interest Rate:

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

Term (years):

Pro-Forma

Yr

Actual

Yr

What If… (1)

Yr

What If… (2)

Yr

Periods Per Year:

Pro-Forma

#

Actual

#

What If… (1)

#

What If… (2)

#

Monthly Payments:

Pro-Forma

Actual

What If… (1)

What If… (2)

Loan Constant:

Pro-Forma

Actual

What If… (1)

What If… (2)


Pro-Forma

Actual

What If… (1)

What If… (2)

CLTV:

Pro-Forma

Actual

What If… (1)

What If… (2)

Annual Debt Service:

Pro-Forma

Actual

What If… (1)

What If… (2)

Before-Tax Cashflow (After Debt Service):

Pro-Forma

Actual

What If… (1)

What If… (2)

Debt Service Coverage Ratio (DSCR):

Pro-Forma

Actual

What If… (1)

What If… (2)

Down Payment:

Pro-Forma

Actual

What If… (1)

What If… (2)

Closing Costs & Other Costs (%):

Pro-Forma

%

Actual

%

What If… (1)

%

What If… (2)

%

Closing Costs & Other Costs ($):

Pro-Forma

Actual

What If… (1)

What If… (2)

Cash Back (Deferred Maintenance:

Pro-Forma

$

Actual

$

What If… (1)

$

What If… (2)

$

Net Cash Out Of Pocket:

Pro-Forma

Actual

What If… (1)

What If… (2)

Annual Cash-on-Cash (before taxes):

Pro-Forma

Actual

What If… (1)

What If… (2)