Auburn Home Builders, Inc.

“Builder of Distinct Custom Homes”.

Mortgage qualification use.xls
                                 
                                 
                                 
            Conventional Mortgage Qualification Worksheet      
                                 
          Income Annual Income Monthly Income                
        Salary or wages                
        Other salary or wages   First Qualifying Number      
        Rental income              
        Investment income     =      
        Additional income     /12 =      
        Total Income                
                    Second Qualifying Number      
          Long-Term Debts Monthly Debt Annual Debt              
        Car loan payments     =      
        Credit card payments     /12 =      
        Other loan payment              
        Other loan payment                
        Total Debts                
        Qualifying                    
        The first qualifying number (above right) calculates your maximum monthly payment, assuming you    
        have no long-term debt. It is computed by multiplying your total income by your housing cost ratio
        and dividing the result by 12. The second qualifying number takes into account your monthly debt    
        payments, applying your total debt service ratio. Mortgage companies usually qualify you for monthly
        payments that are no higher than the lesser of the two results. By default, this worksheet assumes  
        a housing cost ratio of 0.28 and a total debt service ratio of 0.36, which are standards often used for
        conventional mortgages. If different ratios apply in your case, change the values in the cells below.
                                 
                                 
              Housing cost ratio      
              Total debt service ratio      
              You may qualify for monthly payments of      
                                 
        Loan Amount                    
        The table below calculates the amount of a loan you might qualify for with the monthly payment shown
        above. Depending on the circumstances, some or all of the following will be true:      
        • In all cases, your monthly payment will include principal and interest payments.      
        • In most cases, it will include a monthly escrow deposit to cover taxes and mortgage insurance, if any.
          In some cases, homeowner's insurance is also included in this calculation.        
        • If you are buying a condominium or co-op unit, the monthly payment figure may also include your  
          homeowner's dues and/or maintenance fees. You will need to estimate these monthly costs and type  
          them into the appropriate cells below.                  
                                 
                                 
        Important: Total monthly payment allowed      
        This worksheet provides Estimated monthly escrow payment      
        a rough estimate for Homeowner's insurance, if applicable      
        conventional, fixed-term Homeowner's dues and other fees, if any      
        mortgages. Loan terms Annual interest rate (e.g., 7.125)      
        vary depending on type Duration of loan (in years)      
        of mortgage and lender Monthly principal + interest payment      
        policies.                    
        Consult a professional Maximum loan amount      
        lender for exact data.