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 Svc:    
              -----------    
  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