bizzdownloads

assets

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.
It has two components: a simple asset register and a lease asset register. It can work for a small business, but it will need to have rows inserted to accommodate additional asset items. This is easily done.

The fixed assets component aggregates the monthly depreciation and the balance sheet value of each fixed asset item, while the leased asset component aggregates the monthly lease values of each leased item.

bcg

This is a PDF graphic illustration, which explains the theory of the BCG Model.

bizzplan template

This PDF document shows what the bizzplan business plan template looks like and the type of information it presents. It is a checklist to guide you through the development of your own business plan, if you chose not to use the bizzplan app.

breakeven calculator

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It teaches how to calculate the breakeven point in a trading business. It provides opportunities to simulate ‘what if’ situations.

cash flow

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It can be used to forecast daily cash balances in a small trading business. Although simple, it is effective.

contribution mix

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It allows the creation of various product mix scenarios and demonstrates how changes to unit sales volumes, unit selling prices and unit cost prices will affect the aggregate gross profit contribution in a business.

cba

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It allows for the evaluation of savings efficiency when considering the purchase of assets used in the production of income.

customer analysis

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It is an example on how product contribution can be analysed for each customer. It can be adapted to accommodate many additional records, which ideally can be imported from an accounting system.

customer touch-points

This PDF document is a sample of an element in extracted from a customer care manual.

definitions

This is a PDF document, which contains a list of accounting definitions, designed to improve understanding of terms used in various financial reports.

doc

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It is a simple example of a daily operating control sheet (DOC). It compares monthly cumulative results against forecasts for: revenue, gross profit, expenses, net operating profit, inventory, receivables, payables, net assets and the bank balance.

dynamics

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It allows for the evaluation of changes to various business elements such as: contribution, expenses, interest and taxation, working capital and funding, on the profitability of a business. Real learning value is derived when used in conjunction with other downloadable spreadsheets such as the funding calculator, net asset management and working capital.

funding calculator

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It allows for the evaluation of changes to various balance sheet elements such as: total assets, non-interest-bearing debt and interest-bearing debt. It shows how interest paid is affected by the structure of debt and equity on a business’ balance sheet.

hi-level forecast

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It is an example of what a hi-level forecast model may look like and achieve, in terms of forecasting earnings of a business for the balance of a current financial period and five years beyond. This tool works best when data is entered systematically, in the cells from the top of the spreadsheet. As each element is completed, evaluate the effect of the assumptions in the income statement, balance sheet, cash flow and the key ratio reports.

Real learning value is derived when it is used in conjunction with the definitions document.

inventory analysis

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It analyses the effect of aging inventory in a business. It allows simulation of days inventory to calculate the effect on cash flow and interest costs.

management accounts

This PDF document illustrates a suggested presentation of monthly management accounts. Most modern accounting systems have very powerful report writing features, which allow for flexible reports designs.

This presentation demonstrates how monthly values can be compared, progressively, and how each month and the year-to-date results can be compared to a budget forecasts.

market share calculator

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It is designed as a check point to compare forecasted sales against the actual market demographic. The calculator consists of five elements: total market size, primary demographics, secondary demographics, target market and competitors’ share. It is designed as a reality check for sales forecasts.

net asset management

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It uses high-level trading data to demonstrate how a target return on net assets can be achieved. It teaches the formulae related to return on sales (ROS), asset turn (AT) and return on net assets (ROA) and their inter-relationship.

ors

This PDF document is a sample of a completed objective record sheet and explanations of each of its elements.

receivables analysis

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It analyses the effect of aging receivables in a business. It allows simulation of days receivables to calculate the effect on cash flow and interest costs.

valuator

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It teaches the basics of doing a high-level valuation of a business. It is not a comprehensive evaluation tool, but it does provide five basic measurement criteria for evaluation purposes.

working capital

This Microsoft Excel spreadsheet is designed as an interactive teaching tool.

It uses high-level trading data to teach the formulae related to days inventory, days receivables and days payables. It demonstrates how cash flow is affected by setting realistic targets for each working capital element.