LOADING
   
   
  View Special Offer View membership fees  
  This page lists all our Sales & Free Excel templates. Our 40+ unique templates are listed on the following template pages:  
 
  • 37 Sales Commission Template
This template enables users to calculate sales commission for up to 5 levels of sales agents. Simply create a unique agent code for each sales agent, specify the appropriate commission percentages, copy & paste the appropriate sales data into the template, link each sales transaction to an agent code and all the commission amounts are automatically calculated. The template also includes a unique commission report which enables users to display an automated sales commission calculation for any user defined date range.
  • Includes the following features:
  • Suitable for any business
  • Create unique sales agent codes for all sales agents
  • Specify the appropriate sales commission percentages for each agent
  • Copy & paste or enter sales transactions and link to sales agent codes
  • Automated calculation of all sales commissions
  • Unique commission report accommodates any user defined date range
  • Accommodates up to 5 levels of sales commission
 
    commission template excel sales commission sales commission calculation sales commission model  
  Return to Top File Size: 155KB File Size: 61KB File Size: 234KB File Size: 83KB ZAR300 ($28 £17 €21)  
 
  • 38 Sales Analysis Charts
This template enables users to produce a daily and monthly sales analysis chart by simply entering or copying basic sales data. The daily sales chart includes a 60 day period and the monthly sales chart includes a 12 month period. The date range that is included in each chart can be adjusted by simply changing the start date in a single input cell. The default date cell ranges of 60 days and 12 months respectively can be changed by following the step by step instructions that are included in the template. This template can therefore be used to produce a complete daily and monthly sales analysis for any user defined period.
  • Includes the following features:
  • Includes daily and monthly sales analysis charts
  • Change chart date range by editing only one input cell
  • Includes 60 days on daily chart and 12 months on monthly chart
  • Default date ranges can be customized
 
    sales analysis template excel sales chart sales chart template sales chart template  
  Return to Top File Size: 129KB File Size: 61KB File Size: 162KB File Size: 74KB ZAR200 ($19 £11 €14)  
 
  • 39 Gross Profit & Sales Mark-up Calculations
This template enables users to calculate the gross profit percentage of any single product based on a specified sales mark-up percentage and to calculate the sales mark-up percentage of any single product based on a specified gross profit percentage. The template also includes two additional sheets which can be used to calculate the gross profit & sales mark-up percentages of multiple products.
  • Includes the following features:
  • Calculate gross profit & sales mark-up percentages
  • Includes two calculators for individual product calculations
  • Includes sheet for multiple product gross profit percentage calculations
  • Includes sheet for multiple product sales mark-up percentage calculations
 
    gross profit template sales markup template gp calculation sales markup calculation  
  Return to Top File Size: 110KB File Size: 39KB File Size: 151KB File Size: 53KB ZAR250 ($23 £14 €18)  
 
  • 40 Net Disposable Income
This free Excel template enables users to calculate their individual or combined monthly net disposable income. User input cells have been grouped into four categories for remuneration, other income, operational and financing expenses. Detailed guidance is provided for each input cell. The net disposable income calculation is very useful for personal finance purposes, especially to determine the monthly income that is available for savings or to determine the affordability of a home loan.
  • 41 Sales Forecast - 3 Years
This free Excel template enables users to create a monthly sales forecast for a three year period. The sales forecast includes 5 default product categories but you can add additional categories if required by simply inserting the required number of additional rows and copying the existing formulas into the new rows. User input is limited to specifying the monthly sales volumes, selling prices and gross profit percentages for each product category and entering the appropriate date into the first month. All the other values on the sales forecast are automatically updated.
 
 
  • FREE EXCEL TEMPLATE
net disposable income disposable income calculation
  • FREE EXCEL TEMPLATE
sales forecast template excel sales forecast  
  Return to Top File Size: 58KB File Size: 22KB   File Size: 125KB File Size: 50KB  
 
  • 42 Loan Amortization
This free Excel template enables users to create a monthly loan amortization table for any loan period up to 30 years. User input is limited to entering the loan principle amount, loan period, starting date of the loan, the loan repayment type and the appropriate monthly interest rates (in order to accommodate variable interest rates). Any loan review date can then be specified in order to display the total loan repayments, interest paid and capital repaid on a cumulative, year-to-date, next 12 months and entire loan period basis.
  • 43 Home Loan Calculator
This free Excel based home loan calculation template includes a comprehensive set of home loan calculations such as monthly loan repayments, increased instalment savings, home loan affordability, interest rate sensitivity and also includes a monthly and an annual amortization table. The main calculation sheet also includes an increased instalment savings chart and a capital repayment chart. The latter is especially useful in providing a visual analysis of the repayment of capital over the entire loan period.
 
 
  • FREE EXCEL TEMPLATE
loan amortization template excel loan amortization
  • FREE EXCEL TEMPLATE
bond calculator template excel bond calculator  
  Return to Top File Size: 179KB File Size: 68KB   File Size: 381KB File Size: 143KB  
  This page lists all our Sales & Free Excel templates. Our 40+ unique templates are listed on the following template pages: