Business planning calculators  (just click to download for free)

Use these handy tools to evaluate key aspects of your business planning and strategy.

• 5-year financial plan - manufacturing
  • Find a complete interlinked manufacturing tabel linked into the Profit & Loss, Balance Sheet, Cash Flow, Loan Calculator. This will assist in quick calculations whatever the product.
• 12 month sales forecast
  • Forecasting sales of your product or service is the starting point for the financial projections. The sales forecast is the key to the whole financial plan, so it is important to use realistic estimates.
• Activity Ratios
  • Activity ratios gives a quick overview of the most critical part of any running concern. This is a helpful tool to plan or to make business decisions on.
• Balance sheet with ratios and working capital
  • The Balance Sheet table shows the cash position for the business - its Assets and Liabilities (Debts; money that must be paid) at a specified time.
  • The ironclad rule of Western double-entry bookkeeping and accounting is that assets are equal to capital and liabilities (Debts; money that must be paid) . This is what balance means.
• Balanced scorecard
• Break-even analysis
  • Using figures from your Profit and Loss Projection, enter expected annual fixed and variable costs.
  • Fixed costs are those that remain the same regardless of your sales volume. They are expressed in dollars. Rent, insurance and real estate taxes, for example, are usually fixed.
  • Variable costs are those which change as your volume of business changes. They are expressed as a percent of sales. Inventory, raw materials and direct production labor, for example, are usually variable costs.
• Loan Amortization1
• Personal financial statement
  • Many financial institutions will require information about your personal financial data. This spreadsheet will help you prepare a personal financial statement.