This innovative template enables users to compile an informal valuation of a business based on the cash flow projections that are automatically compiled from the template assumptions. The net annual cash flows are discounted at the weighted average cost of capital (WACC) in order to calculate a net present value (NPV), internal rate of return (IRR) and an estimated business valuation. The flexible design of the template also enables users to perform sensitivities on the projected cash flow and financing of a business in order to evaluate how much the business is worth. All the valuation calculations are based on both a three year and a five year period. This template can also be used for service based businesses by simply specifying a 100% gross profit percentage.

This practical Excel template enables users to compile product costings for an unlimited number of manufactured products. The product costings are based on the purchase prices that are entered for all bought-in stock items and the bills of material (“recipes”) that are compiled for each manufactured product. A bill of material can be compiled by linking a manufactured product to the components that are used in the manufacturing of the product and entering an input quantity and a yield for each stock component. The template includes a detailed product cost review sheet, what-if cost calculations for cost analysis purposes and quantity forecast calculations that can be used for requirements planning and stock usage measurement.

This unique template enables users to create cash flow projections for a business plan which includes 12 monthly periods and 5 annual periods. The template includes a detailed income statement, cash flow statement and balance sheet. The cash flow projections are based on a number of default assumptions and the turnover amounts, gross profit percentages, expense amounts, capital expenditure amounts and loan amounts that are specified by the user. The monthly and annual reporting periods are all based on a single user defined start date. This template is ideal for trade based businesses but can also be used for service based businesses by simply entering a 100% value in the gross profit percentage input cells.

This template enables users to create annual cash flow projections for a five year period. The annual cash flow projections are calculated automatically based on the turnover, gross profit margins, expenses, working capital, capital expenditure and long term loan assumptions that are specified by the user. The turnover and expenses for subsequent years are determined by applying a user defined increase percentage to the appropriate amounts of the previous year. The template produces an annual income statement, cash flow report and balance sheet. The default list of expense accounts can be customized and additional accounts can be added by simply inserting the appropriate number of rows. A loan repayment amortization table is also included.

This template enables users to compile monthly cash flow projections for a 36 month period. The monthly cash flow projections are calculated automatically based on the monthly turnover, gross profit margins, expenses, working capital, capital expenditure and loan amounts that are specified by the user and the reporting periods that are included in the monthly cash flow projections are determined based on the start date that is entered in a single input cell. The template automatically produces an income statement, cash flow statement and balance sheet. The default list of expense accounts can be customized and additional accounts can be added by simply inserting the appropriate number of rows. A loan repayment amortization table is also included.

This template enables users to create a monthly cash flow forecast for any three year period and to compare the cash flow forecast to actual account balances. The cash flow forecast is created in exactly the same way as in the monthly cash flow projection template. Actual income statement and balance sheet account balances need to be entered and a unique, innovative management report can then be used to compare the forecasted and actual account balances on a monthly and year-to-date basis. The report includes an income statement, cash flow statement and balance sheet for both the cash flow forecast and the actual results and can be updated by simply selecting a month from the list box at the top of the sheet.

This template enables users to automatically compile a complete cash flow statement by simply entering basic income statement and balance sheet information. The template incorporates a current and comparative financial period and produces a cash flow statement in accordance with international accounting standards. The template is the ideal solution for accountants and financial managers and is guaranteed to save users a lot of time when compiling cash flow statements. The instructions cover each line item that is included on the cash flow statement and also assists users in developing an improved understanding of the calculations that need to be performed in order to compile a cash flow statement.

This template enables users to record deposit and withdrawal transactions for multiple bank accounts and automatically produces a monthly cashbook report and a bank reconciliation. The cashbook report can be compiled for any 12 month reporting period by simply entering the appropriate start date in a single input cell and the report can be viewed on an individual account or consolidated basis. The 30 default accounts that are included on the report can be customized and an unlimited number of additional accounts can be added if required. The template also accommodates petty cash transactions and sales tax calculations. Refer to our Excel Accounting templates if you require a more comprehensive monthly accounting solution.

This template enables users to control the expenses that are paid through any petty cash or cash float system. All petty cash expenses and reimbursements can be recorded by entering the appropriate transactions details and a monthly petty cash report is automatically produced. The monthly report includes a 12 month summary of expenses by account and also calculates the petty cash or cash float balance at the end of each monthly period. You can add as many accounts as required and the report can be rolled forward for subsequent periods by simply amending the start date of the report. The template also includes a general ledger journal summary which enables users to easily record petty cash or cash float expenses in any primary accounting system.

This template enables users to create an automated quotation and tax invoice based on the business details, banking details, customer information and invoice details that are recorded on the appropriate sheets. The template also facilitates creating automated customer account statements; reviewing monthly sales, receipts and debtor balances over any user defined 12 month period; viewing an age analysis for any individual customer account or an age analysis for all customer accounts and viewing a detailed customer account balance report based on any user defined statement date. The template is suitable for any service based business - refer to the Trade Based Invoice & Debtors template if you require stock codes to be included on your quotations and tax invoices.

This template enables users to create an automated quotation and tax invoice based on the business & banking details, customer & stock information and invoice details that are recorded on the appropriate sheets. The template also facilitates creating automated customer account statements; reviewing monthly sales, receipts and debtor balances over any user defined 12 month period; viewing an age analysis for any individual customer account or an age analysis for all customer accounts and viewing a detailed customer account balance report based on any user defined statement date. The template is suitable for any trade based business - refer to the Service Based Invoice & Debtors template if you don't require stock codes to be included on your quotations and tax invoices.

This template enables users to compile an age analysis for any invoice listing that is copied onto the Invoices sheet. The Invoices sheet contains 5 default columns but users can insert additional columns and move the default columns in order to change the layout of the sheet according to their requirements. The age analysis is compiled based on a user defined statement date and users can include all customer accounts or enter a specific customer account reference in order to produce an age analysis for a single customer. The age analysis can be based on calendar months or the user can specify a date other than a month end date in order to base the ageing calculations on a specific day of the month.

This unique inventory control template enables users to analyze the profitability of any trade based business by calculating the gross profit margins of all inventory items. The functionality that has been included in this template enables users to control inventory by creating stock codes for all individual inventory items; recording inventory purchases, sales and adjustments; performing physical stock counts and analyzing stock take variances; calculating stock valuations and measuring sales, cost of sales & gross profits based on any user defined date range. All inventory valuations are performed on an average cost basis and a comprehensive stock valuation, movement and gross profit margin report is automatically compiled for each stock code that is created.

This inventory template enables users to analyze the profitability of a business by comparing sales to inventory usage. In many business environments, it is impractical to perform accurate calculations of cost of sales and it is a lot more feasible to compare inventory usage to sales. The functionality that has been included in this template enables users to control inventory by creating stock codes for all individual inventory items; recording inventory purchases, usage and adjustments; performing physical stock counts and analyzing stock take variances; calculating stock valuations and measuring sales, cost of sales & gross profits based on any user defined date range. Cost of sales is defined as the sum of all usage and adjustment transactions for this purpose.

This template enables users to perform income tax calculations based on multiple tax brackets (also referred to as a sliding income tax scale). The template design incorporates six default tax brackets but additional tax brackets can be added if required. All the income tax calculations are automated and user input is limited to defining the appropriate tax bracket values and income tax percentages. The template also includes a monthly income tax calculation sheet which is especially useful when calculating the monthly income tax that should be deducted from an employee's salary based on variable monthly remuneration amounts.

This template enables users to control the annual leave entitlement of employees and to calculate a provision for the annual leave liability. The template can be used to calculate annual leave balances for any 12 month period that is specified by the user after which the template can easily be rolled forward for the next 12 month period. After recording the opening balances and annual leave entitlement of all employees, the leave that is taken by each employee can simply be recorded and the template automatically calculates the leave days due for each employee and the overall outstanding leave liability. A monthly analysis of the leave days that are taken by each employee is also included in the 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.

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.