verismall
File Download Portal

Whats NewMost popularterms and conditionsAbout UsContact Us

 
Home Page > Budgeting > Financial Budget for Retailers
Financial Budget for Retailers
What will happen in the next 5 years?

screenshot

File Size: 135 KB
Date Added: May 2003
Requirements: Microsoft Excel 97 and higher

screenshot

user manual right arrow download

Description
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 spreadsheet was 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 sheet budget.

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.

Features:
  • An input page that is well structured
  • A sales forecast page for up to 25 different products
  • Sales budget
  • Cash Flow budget
  • Profit and Loss budget
  • Balance Sheet budget
  • Menu system on each sheet for easy navigation
  • Worksheets are preformatted to be printed
Customer Reviews
none

Copyright 2014 Francois Andlau  -  all rights reserved