ype html public "-//w3c//dtd html 4.0 transitional//en">

Rent_vs_Own_Analysis_Input-WEB-fixed.XLS
The page as a whole or parts of it is only allowed to be used for evaluating SpreadsheetConverter . All publishing on a webserver, for other purposes than evaluation, requires a license of SpreadsheetConverter .
Prepared By: David W. Bolick, CPM, GRI www.NetworkRealEstateAR.com                              
    RENT vs OWN Detail Analysis    
         
ENTER PROPOSED HOUSE PAYMENT:        
ENTER INTEREST RATE ONLY IF KNOWN DIFFERENT:    
             
         
Imputed Information:              
Purchase Amount:   Monthly P&I Payment:    
Loan Amount:   Insurance Factor: 0.0049      
Interest Rate:     Mortgage Ins Factor: 0.0049    
Down Payment $:     Taxes Factor: 0.01    
         
    Average                  
  Comparable Monthly TOTAL Comparable Home Ownership Payment Total Monthly TOTAL  
  Monthly Rent Increase ANNUAL (Annual Breakdown) Home Owner ANNUAL  
YEAR Rent Amt Each Year RENT Principal Interest Taxes Insurance Mtg Ins Payment PAYMENT  
1 0.00        
15.00    
15.00    
15.00    
15.00    
15.00    
15.00    
15.00    
15.00    
15.00    
      TOTAL      
       
          SAVINGS ANALYSIS          
        (1) (2) (3) (4)   Annual Cummulative  
  Annual Rent   Annual Annual Tax Annual Tax Annual Annual Annual After Tax After Tax  
  Payments   Home Pymts Savings Savings Equity Inflation Net Cost Savings of Savings of    
Year From Above   From Above from Interest from RE Tax Gain Increase to Own Ownership Ownership   Value
1          
       
       
       
       
       
       
       
       
       
(1) Based on average tax bracket of 18% for a total household income of $48,000 (3) Based on actual principal reduction    
(2) Based on average tax bracket of 18% for a total household income of $48,000 (4) Based on conservative estimate of 4% per year  
Note: Downpayment is assumed to be a minimum amount with seller paying closing costs   increase in value    
No Assumption is being made for annual maintenance or repair costs of ownership    

Powered By SpreadsheetConverter