I Hope You Enjoy This "Practice Tool" Before You BUY An "Investment" Property!
INCOME ANALYSIS FOR "INCOME-PRODUCING" PROPERTY
Fill in Prop Desc, Purch Price, Down Pmt, Int Rate, Mtg Years, Units of Each Type,
Income by Each Unit / Type of Unit, Then Enter Expenses for Entire Property.
Worksheet for :
Purchase Price:
Down Pmt:
Mtg:
Int Rate:
Mortgage Years:
Pmt:
# Units
Rent/Mnth
Tot Rent
Per Type
(each Unit)
Per Type
Describe Units
1
2
3
4
Totals
Total Mnthly
Annual
Rent
Rent
Potential Gross Income
(PGI)
Enter Any Misc Income (Annual Amount)
:
Vacancy Rate
of PGI
--------------------
Effective Gross Income
(EGI)
FIXED EXPENSES:
Insurance
(Enter as ANNUAL Expense) :
Real Estate Tax (Enter as ANNUAL Expense) :
VARIABLE EXPENSES:
Trash pickup (MONTHLY Expense):
Other Maintenance Expense (MONTHLY Expense):
Utilities Expense - If Paid By Owner - (MONTHLY Expense):
Misc Expenses Pd By Owner - (MONTHLY Expense):
Misc Expenses Pd By Owner - (MONTHLY Expense):
TOTAL EXPENSES:
--------------------
OPERATING CASH FLOW (Simple NOI)
Debt Svc (Mtg Pmts):
/MONTH
Annual Debt S
vc:
-----------
CASH THROW OFF (CTO) AFTER LOAN PAYMENTS
Approx Equity - Down Pmt + CTO + Principal Pmts - YEAR 1
Cash on Cash (Down Payment Only):
Debt Service Coverage Ratio (DSCR)
(Lenders will want at LEAST 120%)
Operating Expense Ratio (without Replacement Reserves)
Equity Dividend Rate (EDR) - On Down Pmt Plus Prin Portion of Debt Svc
Payback Period (Years)
(If NEGATIVE, You'll Want to Reconsider)
Cash Breakeven Ratio (Without Replacement Reserves)
***
FIGURES ARE APPROXIMATE, NONE ARE GUARANTEED OR WARRANTED ***
FIXED RATE ONLY - (No Entries Here - All Taken From Above Entries)
MORTGAGE AMORTIZATION SCHEDULE - First Two Years Only
LOAN AMOUNT
ANN INT RATE
YEARS (TERM)
BEGIN DATE:
01/01/08
PAYMENT:
PMT #
Pmt Amt
Int
Prin
Balance
Annual Int
Annual Prin
1
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.