Cash Flow Calculator for Buy to Sell Discounted Deals  
         
      Please enter data in the WHITE boxes provided to obtain CASH FLOW FORECAST  
     
      Initial Purchase Cashflow Notes   Total Costs £  
      Property Price Open Market Value    
      Effective Discount % % Below Market Value (BMV)      
      Investor Purchase Price Net Price paid by investor    
      LTV Loan To Value %    
      Mortgage Mortgage Required    
      LTV Deposit Required Deposit Required    
      Total Equity Property Discount    
     
      Purchase Fees    
      Stamp Duty Scaled depending on purchase price -see scale below    
      Mortgage Advisor fee dependant on broker fee    
      Mortgage Lender Admin Fee Paid to mortgage lender as arrangment fee for loan setup. Typically added to loan.    
      Survey based on level of property survey    
      Legals based upon which solicitor used    
      Searches dependant on location    
      Refurbish Costs Total cost of refurbishment    
      Connect UK Commission Fee Fee for sourcing and completing transaction    
      Purchase Cost Including - Monthly Ownwership costs + Selling Disbursements      
      Total Funds Required Total Purchase Costs + Mortgage lender Deposit    
     
      Finance Costs        
      Rate Mortgage rate calculated %      
      Annual Mortgage payment Interest only Mortgage    
      Mortgage Payment Monthly mortgage payment (interest only)    
      Monthly Ownership Total mortgage payments whilst in ownership of property PLEASE ENTER MONTHS HERE  
      Total Purchase Price Investor Purchase Price + Total Funds Required    
      Selling Price Marketing @ OMV    
      Disbursements i.e Selling expenses- Agency Fees etc…    
      Total Cost Total Funds Required + Disbursements    
     
      Summary        
      Profit Profit Margin - BMV Deal    
      Return on Capital ROIC - Return On Investment Capital    
     
     
      Stamp Duty Upto £125,000 = 0% - £125,001-£250,000 = 1% - £250,001 -£500,00 =3% - £500,001-£1M = 4%  
        £1M+ = 5%  
      Note  
      Insurance is not included in the Net Profit because each individual Investor has different requirements.  
     
      The accuracy of this spreadsheet cannot be guaranteed and should be checked against your final records  
      This is an assessment of the final completion costs and invested capital used to purchase the above mentioned property