|Financial Budget for Retailers|
|What will happen in the next 5 years?|
|File Size:||135 KB|
|Date Added:||May 2003|
|Requirements:||Microsoft Excel 97 and higher|
This financial budget for
retail companies will
help you plan your financial budget for up to 5 years into the
future. The financial budget spreadsheet is designed for businesses
that trade goods and carry inventory. The budget
designed for a customer who wanted a simple but structured way to plan his
business' finances as part of his business plan. The spreadsheet
contains a sales budget, cash flow budget, a profit and loss budget as well as a balance
All input is done on a input page and sales forecast page which is well structured to make accurate predictions of future income and expenses. Sample figures are shown in blue and can be changed. The budgets are automatically calculated as the figures are entered. A distinction is made between cash and credit sales. Debtor days outstanding and creditor days outstanding as well as a provision for bad debt can be entered. Details of fixed assets purchased can be entered. Tax is also taken into account.
The sales budget calculates gross sales, stock purchases, closing stock, cost of sales and gross profit for up to 25 different products.
The cash flow budget calculates the opening and closing bank balance for each year. Detail of cash received and cash payments is shown as well as total cash receipts and total cash payments for each year.
The profit and loss budget shows sales, cost of sales and gross profit Detail of expenses are shown. Tax for each year is calculated as well as the retained income for the year.
The balance sheet budget shows details of capital, long term liabilities, fixed assets, current assets and current liabilities. A detail breakdown of transactions with fixed assets is shown. Detail of transactions regarding long term liabilities is also shown.
The financial statement is designed according to generally accepted accounting practice.
There is also a free online user manual.
Copyright 2014 Francois Andlau - all rights reserved