USE THIS SPREADSHEET TO FIGURE OUT HOW GOOD OF A DEAL YOU HAVE AND FIND OUT HOW MUCH CASH YOU CAN GET OUT OF IT.      
  UP-FRONT FEES  
List Price/Asking Price   RBL'S Consulting Fees Look for in RBL Fee Agreement  
Current or Projected NOI (Net Operating Income after expenses)   Lender's Due Dilligence Fee    
  Appraisal Cost  
EXISTING MORTGAGE THAT MUST BE PAID OFF   Total Fees Up-Front    
NET CASH SELLER WANTS AFTER ALL CLOSING EXPENSES AND MTG PAYOFF   CLOSING FEES BELOW TO BE PAID AT CLOSING      
  Down Payment Assistance    
      Loan Origination    
LENDER MIN. DSCR (Debt Service Coverage Ratio)   Discount Points    
Possible Lender Interest Rates   Credit Report    
This is the most you can finance based on NOI, Interest Rates and DSCR   Processing Fee    
Sales Comparison Approach   Tax Service Fee    
Estimated Value   Flood Certification Fee    
      Document Preparation    
YOUR OFFER or Purchase Price on Real Estate Contract (IMPORTANT)   Underwritting Fee    
Using the lower of the Estimated Value or Contract Price For Calculations   Advance Interest    
Equity   Mortgage Insurance    
Purchase Price To Be Used For Loan   Hazard Insurance    
LOAN ENTER LOAN TO VALUE (LTV) EXPECTED BELOW   Flood Insurance    
  Settlement Fee    
Cash Available After Bank Loan   Abstract or Title Search    
Possible Seller Financing   Title Examination    
Seller Can Finance up To This % Amount   Title Insurance Binder    
  Document Preparation    
Seller Financing (PMM)   Title Insurance    
Total Seller Net   Endorse    
Down Payment Required   Recertification Fee    
$ -   Document Storage    
Total Down Payment Assistance Required   Recording Fees    
Down Payment Assistance Cost   City/County tax Stamps    
Down Payment Assitance Cost   State Tax Stamps    
      Intangible Tax    
FIGURING OUT CASH TO YOU - THIS SEC TION SHOWS WHAT CLOSING AGENT GETS IN ESCROW     Survey    
Loan Wired From Lender   Lien Letters    
Down Payment Wired By DPA INVESTOR   Wire Transfer Fee    
Closing Costs WIRE BY DPA INVESTOR   Courier Fee    
Deposit from you   Escrow For Payoff    
Total in The Deal At Closing Sent To Escrow   Collectin Payoff    
Outgoing Total     Signing Agent    
Down Payment Goes Back to Investor from Seller   Real Business Loans LLC  
CLOSING COSTS PAID BY SELLER   Broker Fee  
Net Seller Wants to Walk Away With   Real Estate Commissions  
Total Out of Escrow          
      TOTAL Closing Costs (Hopefullly to Be Paid By Seller)    
Seller Financed this so you add that to your total          
  This should be Buyer's Closing Costs (NO Real Estate Commissions)    
      10% Additional DPA Costs to Be Paid By Seller/Buyer    
Mortgage From Lender   THIS DPA COST HAS BEEN ADDED TO THE ABOVE ALREADY      
Interest Rate from A8          
Annual Mortgage   TOTAL DPA TO REQUEST    
Seller Financing          
Seller PMM Rate   Figuring Out What Seller is Receiving After Closing The Deal.  
PMM Annual Mortgage   CASH FROM LENDER    
Total Annual Mortgage Payments (INTEREST ONLY)   CASH FROM BUYER    
ANNUAL PROPERTY TAXES @1.25%        
LEFT OVER CASH AFTER PUTTING AWAY RESERVES FOR 12 Months        
         
    OUT OF SELLER'S POCKET      
         
FOR THE BANK This is what needs to be shown on the contract      
Contract Purchase Price      
     
Down Payment Required by Bank      
Down Payment Required by Bank   TOTAL OUT OF SELLERS POCKET    
Seller Financing PMM   NET CASH TO SELLER AFTER CLOSING  
             
Mortgage From Lender          
Interest Rate from A8          
Annual Mortgage Payments to Lender (Interest Only)          
Seller PMM Rate          
PMM Annual Mortgage (INTEREST ONLY)          
Total Annual Mortgage Payments          
         
           
 

Create online calculators using Excel