Quick Analysis Worksheet V5.1 - Rental Property - Chara.xlsx

Opportunity Quick Analysis Pro-Forma 1 Purchase Price

$

2 Gross Potential Rental Income

$

3 Vacancy & Credit Loss Factor Vacancy & Credit Loss Amount Vacancy & Credit Loss Used

% OR $ $

4 Other Income (not affected by vacancy) 5 Effective Gross Income (EGI) 6 Total Operating Expenses Operating Ratio (Expenses As % of EGI) Expenses Being Used From Above 7 Net Operating Income (NOI) 8 Cap Rate 9 Value (based on cap rate) 10 Primary Financing Loan LTV Loan Amount Loan Amount Used Amortized or Interest-Only Interest Rate Term (years) Periods Per Year Monthly Payments Loan Constant 11 Secondary Financing Loan LTV

10.00%

$ = $ $ % OR % $ = $ Actual % = $ % OR $

Actual

-

$

What If… (1)

-

$

-

0 -

0 $

-

$ $ -

75%

$

-

$

75%

-

$ $

50.00% -

$

70%

$ $ $ Fully Amortizing Fully Amortizing Fully Amortizing % 5.50% 5.95% 7.00% 25 ### 30 ### 25 ### 12 12 12 $0.00 $0.00 $0.00

%

0%

Loan Amount Loan Amount Used Amortized or Interest-Only Interest Rate Term (years) Periods Per Year Monthly Payments Loan Constant CLTV Annual Debt Service Before-Tax Cashflow (After Debt Service) Debt Service Coverage Ratio (DSCR) Down Payment 16 Closing Costs & Other Costs (%) Closing Costs & Other Costs ($) 17 Cash Back (Deferred Maintenance) Net Cash Out Of Pocket 18 Annual Cash-on-Cash (before taxes):

OR $ $ $ %

12 13 14 15

-

$ $ Fully Amortizing Interest-Only 6.25% 5.00% ### 5 30 ### 30 ### 12 12 12 $0.00 $0.00 $0.00

#DIV/0! $ $

#DIV/0! 0.00 0.00

#DIV/0! $ % $ Minus $ $

0.00 0.00 #DIV/0!

0 3.00% 0.00 0 0 #DIV/0!

#DIV/0!

Down Payment Source $ $ $ $ $ $

0 0 0 0 0 0

0.00 0.00 #DIV/0!

0 3.00% 0.00 0 0

Copyright 2004 - 2007 © George Antone - All rights reserved (rev 1.5 - 09.21.07)

Source 1 Rent Credits Source 2 Defered Maintenance Source 3 Buyer's Agent Source 4 Uncle George Source 5 Uncle David Total Down Payment

#DIV/0!

0 3.00% 0.00 0 ### 0 #DIV/0!

Licensed to ADG Holdings LLC - www. Licensed to Wealth Classes Inc - www

What If… (2)

What If… (3)

What If… (4)

$

-

$

-

$

-

$

-

$

-

$

-

$ $

-

$ $

-

$ $

-

$

60%

$

75%

$

75%

$ $ $ Fully Amortizing Fully Amortizing Fully Amortizing 5.00% 5.50% 4.50% 25 ### 25 ### ### 30 12 12 12 $0.00 $0.00 $0.00

0%

0%

0%

$

-

$

30 ### 12 $0.00 #DIV/0!

#DIV/0!

#DIV/0!

$

### 5 12 $0.00

0.00 0.00

#DIV/0!

#DIV/0!

0.00 0.00 #DIV/0!

0 5.00% 0.00 0 0 #DIV/0!

-

### 5 12 $0.00

0.00 0.00

0 3.00% 0.00 0 0 #DIV/0!

-

0 3.00% 0.00 0 0 #DIV/0!

to ADG Holdings LLC - www.adgholdingsllc.com to Wealth Classes Inc - www.wealthclasses.com

Loan Constant Calculator Amortized or Interest-Only

Fully Amortizing

Loan Amount

Fully Amortizing

$1,000,000

$1,000,000

Num Payments per year

12

12

Years

20

30

6.50%

8.20%

$7,455.73 $89,468.78 8.95%

$7,477.54 $89,730.53 8.97%

Interest Monthly Payment (P&I) Annual Payments (P&I) Loan Constant Copyright 2004 © George Antone - All rights reserved

lator Fully Amortizing

Fully Amortizing

$1,000,000

$1,000,000

12

12

5

25

4.00%

7.00%

$18,416.52 $220,998.26 22.10%

$7,067.79 $84,813.50 8.48%