FEASIBILITY STUDY & EQUIPMENT  BREAK-EVEN  ANALYSIS  
     
  The following spreadsheet has been provided as a guide only and should not be construed as either authoritative nor complete. It is strongly recommended that you consult your accountant or finance professional to verify all numbers and procedures.  DAP Imports Pty Ltd has provided this service in good faith and will not be held liable for any actions, events or damages that may arise from the usage of this spreadsheet. At all times, this is not an invitation to purchase or entice. Equipment prices serve as approximates and may vary from those displayed on the product detail pages. All calculations ignore taxation, depreciation. premise decorations and staff contributions  
     
  Please feel free to ammend all values in blue.  Clicking anywhere outside of the input cells will automatically update all others cells  
     
     
    INPUT 1             INPUT 2           INPUT 3    
                             
    Fees       Equipment       Operating Expenses  
    Please enter your fee structure       Please estimate the equipment that you  will need. Be mindful of the type of courses and the size of your groups.       Please enter your approx monthly expenses  
      Mat Small Large               Fixed    
      Classes Equip Equip       Reformers         Rent   
    1 on 1       Premier Reformer       Subscriptions  
    Small Class       PPS Reformer       Memberships  
    Group Class       TWS        Insurance  
              Mve       Utilities  
                          Training  
    People in a Small Class       Barrels                
    People in a Group Class       Instep Barrel       Variable    
    Studio Floor Space (sqm)       Classic Barrel       Advertising  
              Ladder Barrel       Stationary  
                        Travel  
                  Cadillacs                
        Trad Cadillac    
    INPUT 4             Class Cadillac       INPUT 5    
    Timetable       Ped-o-Pul          
    Please enter the number of sessions you wish to offer on a weekly basis at full capacity       Tower       Equipment Finance  
                        Equipment Cost  
      Mat  Classes Small Equip Large Equip       Chairs           Deposit  
                  Mve       Amount Borrowed  
    1 on 1       High Low       Borrowing Rate  
    Small       Low Chair       Borrowing Term  
    Group                 Residual  
              Misc           Residual Amount  
    Days per week          Mats          
    Months per year         Rollers       Personal Drawings  
    Session length          Circles       $ per week  
    Session breakl         Bands            
    Total Sessions                   Staff Commissions  
    Staff sessions           Total :       $ per session  
                                       
   
                                       
        Activity Forecasts  
         
    The timetable in "Input 4" represents the number of weekly classes you aim to offer at full capacity. Enter your monthly   
    forecast of how your business will grow as a percentage of full capacity, and the table will calculate the number of monthly sessions provided  
         
      Jan Feb March Ap May Jun Jul Aug Sept Oct Nov Dec    
      Capacity      
      No of Sessions    
       
                                       
     
                                       
         
                                       
        Cashflow Analysis  
             
          Jan Feb March Apr May Jun Jul Aug Sept Oct Nov Dec Full Year  
               
        Income  
        Fixed Expenses  
        Var Expenses  
        Equip Expense  
        Commisions   
        Personal Drawings  
        Total Expenses  
        Profit/Loss  
                                       
         
         
             
                                   
        Equipment Metrics         Income Analysis        
        Initial Equipment Cost       Personal Drawings      
        Amount Borrowed       Studio Profit      
        Residual       Total Income      
        Principal                
        Interest on Principal        
        Total Cost        
        Monthly Repayments        
      * ROI        
                                 
        Studio Metrics         Loan Service & Breakeven Analysis      
        Rent per sqm       Days per year needed to service loan     
        Operating cost psm       Repayments as % of Income    
        Revenue psm     * Breakeven     
        Profit per sqm                      
        Net Profit Margin        
        Cashflow Cover        
        Average Capacity        
                       
             
             
      All calculations ignore taxation, depreciation, staff contributions, and non-equipment start-up costs  
      * Days to Breakeven refers to the number of days required to fully repay equipment using studio net profits   
      ROI refers to the reurn on investment