JaxWorks
Small Business Spreadsheet Factory
Since 1996

 

     
 

Free Downloads




JaxWorks is a Microsoft Partner

 

(Sorry, There is No Support For Free Downloads)
Also visit our Spreadsheet Library

 

Please Note

Our free downloads are now compatible with Microsoft Office 365® and Microsoft Office for the iPad®.

The only exceptions are those downloads with macros. In these instances, they must be opened in the Excel Desktop version.
 


 

INSTRUCTIONS

1) For 100% effective use, you must have installed on your system:
          Microsoft Excel® 2000 or later,
          Microsoft Internet Explorer® 6 or later
              or compatible browser,
          Microsoft Word® 2000 or later

2) Click on each item's hyperlink.   

3) Either open or save to your hard drive for future use.
We suggest saving.
 

 


DISCLAIMER

The analysis systems below are very basic. They should not be confused with our products which are more accurate, advanced, powerful, and comprehensive.

They are not intended to be a substitute for professional advice. Accordingly, you may wish to consult your accountant, financial, or legal advisors regarding their use.

JaxWorks and its authors are not responsible for any action you take based on the use of these free downloads.


Think of these systems as learning exercises in business analysis concepts and using Excel to do it.
 



 

FREE Excel Chart Factory


We suggest Saving rather than Opening.
NOTE: There is no support for free downloads.

 

FREE Entrepreneurial Test


We suggest Saving rather than Opening.
NOTE: There is no support for free downloads.

FREE
     Quick Analysis™
     Key Financial Predictors    

Excel 97-2003

Ever wondered how loan institutions evaluate your business as a risk for a loan. This template might solve some of the mystery.




We suggest Saving rather than Opening.
Sorry, There is no support for free downloads.

FREE
     MicroShots™
     Business Analysis System    

Excel 97-2003

MicroShots™ Business Analysis System is designed to quickly analyze the overall health of any business. MicroShots are miniature chart snapshots of key financial analysis data. The MicroShots worksheet is fully automated and yields instant results.




We suggest Saving rather than Opening.
Sorry, There is no support for free downloads.

FREE
     The CEO Financial Assistant™    


Now in Excel 2003 and 2007
AND
PowerPoint 2003 and 2007 Linked Presentations


Resurrected from our archives of 2002 and updated, here is
a goodie that might help perform a quick business analysis.



This is a small zip file.
We suggest Saving rather than Opening.
Sorry, There is no support for free downloads.

FREE
NeoCalc™ Comprehensive Break-Even Analysis

This workbook was produced at the request of hundreds of our loyal visitors to our web site. It appears there is a great demand for an in-depth understanding of the financial "tool-of-tools" known as the Break-Even Analysis.

Actually the Break-Even is only a portion of a larger concept known as "Contribution and Margin Analysis" that has at its heart the analysis of cost/volume/and profit relationships.

This free tool makes an attempt at demystifying all of these concepts with examples and popup explanations. This workbook can be used with your business by entering your own data.


For Excel 97 Through Excel 2003


For Excel 2010 and Excel 2013

We suggest Saving rather than Opening.
Sorry, There is no support for free downloads.
 

FREE Excel Dashboard Workbook


We suggest Saving rather than Opening.
Sorry, There is no support for free downloads.
 


 

FREE Excel Budget Analysis


We suggest Saving rather than Opening.
NOTE: There is no support for free downloads.

 

Turn Excel Into a Financial Sleuth
An easy-to-use digital analysis tool can red-flag irregularities such as fraud.
FREE

Click Here To Investigate Your Financial  Irregularities
 

 


5 Year Projections - This worksheet estimates the key financial figures for a company over five years. The projections include abbreviated income and cash flow statements, and a balance sheet. 
Click Here To Open

7 Year Balloon Loan Amortization - This worksheet calculates monthly loan payments and prepares an amortization schedule for a 7 year balloon loan. A balloon loan requires a large final payment at some future date.
Click Here To Open. 

24 Month Sales Forecast - Use this worksheet to forecast 2 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month. Click Here To Open

36 Month Sales Forecast - This worksheet forecasts 3 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.
Click Here To Open

40 Month Projection Analysis.
Click Here To Open

48 Month Sales Forecast - This spreadsheet forecasts 4 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.
Click Here To Open

52 Week Sales Record - Use this worksheet to keep track of weekly sales by product or product line. Begin by entering the first date of the first week of the 52 week period that you want to track. Next enter the product name and sales numbers for each product by date.
Click Here To Open

401K Planner - This worksheet forecasts the growth in value of your 401K plan and to project the monthly income you will receive from the plan upon retirement. It also compares the wealth accumulation in the 401K plan in contrast to the growth of a taxable savings plan. The forecasted monthly income during retirement is pre-tax. After tax retirement income will depend on the marginal tax rates upon retirement.
Click Here To Open

401K Reallocation Planner - This spreadsheet helps you to reallocate your investments in your 401(k). Enter your current 401(k) investments by category. Then input the new percentages (new allocation %). The "Change Needed" column calculates the amounts by which you will need to increase accounts (negative numbers represent the amounts by which you need to decrease accounts).
Click Here To Open

Accessories - These are small and safe programs. We have tried, for 5 years, to retire them, but we still get requests for them. Refer all of your questions to the respective developers.
 

Accessories

Free Accounting Program

Free Spreadsheet Programs

    1) Critec Accounting (critacct.exe) 1) Spreadsheet Program 1 - (spread32.exe)
    2) Spreadsheet Program 2 - (sssheet.exe)
   

Free Office Suite

SSuite Office - The Fifth Element
   

Accounts Payable Aging - Use this spreadsheet to organize a company's current and past due payable accounts according to how long they have been outstanding. Such an analysis can help your company maintain a good credit rating and give cash flow priority to older payables.
Click Here To Open


Activity Ratios - Use this spreadsheet to calculate a firm's activity ratios; such as
1) inventory turnover,
2) average collection period, and
3) fixed asset turnover.

Activity ratios help to measure a company's efficiency managing certain assets such as:
1)inventory,
2)accounts receivable, and also
3)long-term and total assets. 
Click Here To Open

Advertising Expenditures by Media For Excel® 2000 - This worksheet can be used to summarize actual advertising expenditures or to plan expenditures for an upcoming month period. It is made up of three common advertising media: print, broadcast, and direct mail.
Click Here To Open.

Annual Budget Forecast - 5 Profit Centers  - Annual budget for your business, outline format, showing breakdowns by quarter, site and expense category, for the Fiscal Year. Enter your categories and numbers.
Click Here To Open.

Annual Direct Labor Analysis - This spreadsheet helps you analyze the annual cost of labor by comparing labor costs to standard labor. Standard labor is an expected labor cost based on estimated capacities of output costed at an estimated hourly rate plus benefits. This type of analysis is critical to keeping costs under control.
Click Here To Open

Average Selling Price Analysis For Excel® 2000 - This worksheet helps you calculate the average selling price for multiple products sold across multiple distribution channels. It also calculates the simple average selling price of the products sold in each channel.
Click Here To Open.

Bad Debt Analysis - This is a 3 step workbook. You enter the data and it does the rest. Track how others are using your money at no interest.
Click Here To Open.

Breakeven Analysis Workbook - Calculate your breakeven with this stand-alone Excel® 95 worksheet.
Click Here To Download.

Breakeven Chart Analysis - For Excel® 2000 -  Calculate your breakeven with this simple worksheet.
Click Here To Open.

Breakeven Interactive Analysis - Here is a new toy you might like. Both Charts change as you alter key parameters with spinners. Put in your numbers and watch the action.
Click Here To Open.

Breakeven Simple Chart Analysis - Calculate your breakeven with this simple worksheet.
Click Here To Open.

Business Acquisition Worksheet - This spreadsheet helps you organize key information needed to value a business that you are interested in buying or selling. With this information, an appraiser should be able to give you an opinion of value.
Click Here To Open

Business Plan Creation
. This is a Must!
Click Here to Read and Print.
Click Here To Open MS Word Document.

Business Plan Sample - A good example for you to follow. Print it and use it as a guide. 
Click Here To Open.

Cash Flow Sensitivity Analysis - Use this spreadsheet to prepare a cash flow sensitivity analysis. Prepare your expected cash flow projections and by entering a percentage change assumption, the spreadsheet will automatically prepare a pessimistic and optimistic set of cash flow scenarios. Under the pessimistic scenario, cash receipts will be lowered by the percentage and disbursements will be increased by the same percentage. Under the optimistic scenario, receipts will be increased while disbursements will be decreased by the percentage assumption.

Click Here To Open

Comparative Balance Sheet - This comparative balance sheet serves as a financial comparison from year to year. Prepare this analysis at least once a year to see what kinds of trends are developing. Your future financial security could very well depend on how well you grow and maximize your net worth. Percentage totals may not always equal 100% because of rounding.
Click Here To Open

Comparative Business Income - This spreadsheet allows you to compare your business revenues, expenses, and net income (loss) over the course of three tax years. Enter the starting year, which is the first year in the three year period you want to analyze. The format follows that of schedule C of the U.S. Income Tax Return (1040).
Click Here To Open

Comparative Contribution Analysis - Use this spreadsheet to prepare a 5 year comparative contribution margin income statement. The contribution margin is found by subtracting all variable costs from revenue (sales). Enter the first year and the remaining year (column titles) will automatically calculate.

Click Here To Open

Comparative Taxable Income Analysis - This spreadsheet allows you to enter four years of tax return data and compare the various elements of taxable income over the years. This type of format allows you to do some comparative analysis, possibly spotting trends and opportunities. The starting year is the earliest of the four years of actual data. After you enter the starting year, begin entering data from your past tax returns. The report follows the format of the U.S. Individual Tax Return (1040).
Click Here To Open

Contribution Income Analysis 
Use this spreadsheet to prepare a contribution margin income analysis. The contribution margin is found by subtracting all variable costs from revenue (sales). After you enter your numbers you can check the Break-Even Chart on the same sheet. This is a good example of the importance of expense control.
Click Here To Open.

Corporate Earnings Analysis - This spreadsheet helps you perform some basic fundamental equity (stock) analysis. Enter the year for the most recent annual results, that way you can enter historical data for the last 5 years.
Click Here To Open

Daily Time Sheet This worksheet computes hourly/daily rate charges for consultants/accountants/attorneys or any service business that charges by the hour. 31 days/Subtotals/Total.
Click Here To Open.



Direct Marketing Analysis
- Use this spreadsheet to run the numbers on a direct marketing campaign. It includes a breakdown of gross margin of the product being sold, the cost of the direct mail piece, and an analysis of the profit. For some mailings, you may know the total cost of each mail unit but not know the breakdown costs for the individual components. In this case, simply enter the total unit cost into the "other" calculation cell, and enter the label "Total cost" in the cell to its left.
Click Here To Open.

Estimating Startup Capital
Before going to the bank you must know how much capital is needed to start your new business. This worksheet helps you do it.
Click Here To Open.


Excel Functions Glossary - Here is the complete function listing for Excel®.
Click Here To Open.

Financial Comparison Analysis - Use this spreadsheet to compare your company with an average firm in your industry. The financial comparison analysis is a diagnostic tool that will help you pinpoint previously unnoticed strengths and weaknesses. The first year column heading is unlocked; the following year dates are calculated. Totals, shareholders' equity, and financial ratios are calculated automatically after all financial data is entered.

Click Here To Open

Financial Dashboard - You'll have to see this workbook to appreciate its concept. 
Click Here To Open

Flexible Budget - This spreadsheet is a flexible budget for a manufacturer. Enter possible unit levels of activity and the variable cost per unit for the various variable cost items. Then enter each fixed cost.
Click Here To Open

General and Administrative Expense Budget - This spreadsheet compares actual General and Administrative (G&A) expenses with budget amounts for the current month and the year to date. Fixed expenses generally don't change over the course of the year, while variable expenses change with the level of activity. Variances and totals are calculated automatically after data is entered in the unlocked cells on the template.

Click Here To Open

Headcount Analysis  Ever wondered how companies determine how many employees to terminate when they "down-size" or "right-size"? It Is Called "Headcount Analysis".
Click Here To Open.

Investment Payback Analysis - Investment Payback is the length of time between an initial investment and the recovery of the investment from its annual cash flow. This worksheet helps you with the financial feasibility of expanding your business, or buying a new business.
Click Here To Open.

Loan Tree Evaluate your business with this cool tool.
Click Here To Open.

Manufacturing Overhead Budget - Use this spreadsheet to forecast annual overhead costs for a manufacturer. The overhead costs are those that cannot be directly traced to the production of a product in an economically feasible manner and therefore must be allocated based on a budgeted amount.
Click Here To Open.



Marketing Calculators - This spreadsheet contains eight calculators you can use to make marketing decisions. It contains the following:
  1) Sales Revenue - represents net revenue after sales returns and 
      allowances and discounts.
  2) Cost of Goods Sold - the cost of the sales.
  3) Gross Margin - Net revenue less cost of goods sold.
  4) Selling Expense Ratio - Total selling expenses divided by sales.
  5) Inventory Turnover - On average, the number of times per year you
      "turnover" the inventory.
  6) Mark-up based on Cost - Mark-up divided by cost.
  7) Markup Based on Selling Price - Mark-up divided by selling price.
  8) Markdown - Markdown in dollars divided by the original price.
Click Here To Open.

Media Forecast This worksheet helps you plan the monthly advertising amount your firm will use over the next year. It also compares each month's actual expenditures to the forecast established at the beginning of the year.
Click Here To Open.

Microsoft Office Training Courseware

NeoToys - An assortment of really cool Excel® 2000 spreadsheets.
1) 2 Balance Sheets
2) 5 Income Statement Worksheets
3) 2 Cash Flow Worksheets
4) 1 Comprehensive Ratio Analysis Worksheet
5) 1 Trial Balance Worksheet
6) 2 Charts that can be easily adjusted to almost any data.
All configured for printing and professional in appearance.
Click Here To Open.

NeoPrice™ Excel® Pricing Analysis System.
Ready to start your business? Whether an e-commerce merchant, manufacturer, retailer, wholesaler, or service firm, all businesses have one thing in common:  What price do I charge to make a profit and be competitive? 
NeoPrice will compute product or service prices. You enter the numbers and NeoPrice tells you the price to charge from several perspectives. 
Click Here To Open.

Personal Wealth Analysis - This spreadsheet allows you to analyze your net worth to help you determine if you are doing a good job accumulating wealth. There are three basic steps to follow in performing this analysis.

1) First you must estimate your annual realized income. This is income you receive. Don't include "paper gains" like unrealized capital gains on stocks or gifts you haven't yet received.
2) The second step involves estimating your present net worth. You do that by entering your best estimates for assets and liabilities.
3) Be sure to also enter your age. The spreadsheet calculates what your net worth should be based on an accepted financial rule of thumb formula: (Age multiplied by realized pretax annual household income) Divided by 10

If your actual net worth is less than the projected amount, that is a signal that you need to employ strategies to save and invest more of your annual income. This spreadsheet also calculates your annualized realized income as a percentage of your net income. Over time you want to see that percentage get smaller.
Click Here To Open


Pivot Tables
for
Microsoft Excel 2007

One of the most under-utilized tools in Excel is Pivot Tables. This section is intended to help you better understand their use.

Imagine an Excel worksheet of sales figures with hundreds or thousands of rows of data. The worksheet lays out all the data about salespeople in two countries and how much they sold on individual days. But it's a lot of data to deal with — listed in row after row and divided into multiple columns. How can you get information out of the worksheet? How can you make sense out of all of this data?

Who sold the most overall? Who sold the most per quarter or per year? Which country has the most sales? You can get answers to all these questions with PivotTable reports — it's like turning a mob into a marching band. A PivotTable report turns all that data into small, concise reports that tell you exactly what you need to know.

Save and unzip the files below to a folder of your choice. Then, open the Word document for reference as you perform tasks in each workbook.

 

Office 2007 Files

Office 97-2003 Files

Instructions Word 2007

Instructions Word 97-2003

Salespeople PivotTable 2007.zip Salespeople PivotTable 97-2003.zip
Products PivotTable 2007.zip Products PivotTable 97-2003.zip
Human resources PivotTable 2007.zip Human resources PivotTable 97-2003.zip
Sales PivotTable 2007.zip Sales PivotTable 97-2003.zip
Invoices 2007.zip Invoices 97-2003.zip
Customers PivotTable 2007.zip Customers PivotTable 97-2003.zip
NOTE: Check out our Free Training page, Level 5 of Excel 2000 and XP.  

Pro-Forma Balance Sheet - This spreadsheet is a financial planning tool for businesses. It is important for estimating long-term financing needs. It is equally important as a component for a Business Plan.
Click Here To Open

Pro-Forma Income Statement - This spreadsheet is a financial planning tool for businesses. It is important for estimating long-term financing needs. It is equally important as a component for a Business Plan.

Click Here To Open

Ratio Analysis
This workbook produces 12 important financial ratios. These ratios belong to four basic categories: profitability ratios, liquidity ratios, activity ratios, and leverage ratios. Detail explanations of each ratio included on each worksheet.
Click Here To Open.


Sales Channel Analysis - Use this worksheet to analyze your distribution channel sales volume.
Click Here To Open.

Sales Seasonality by Month This worksheet shows how sales by month can vary because of seasonal factors. There are two columns of data to enter: actual sales per month and the industry percentage of total sales.
Click Here To Open.

Small Business Budget - Every business needs a budget. This tool is not unlike a navigation chart for planning your annual
performance trip.

Click Here To Open.

Small Business Valuation This spreadsheet helps you to value your business. Use it only as an estimate. This spreadsheet offers 4 methods for valuation of your business.
Click Here To Open.

Small Builder/Contractor Workbooks  
1. Concrete Log Sheet
2. Daily Report
3. Field Logs
4. Punch List
5. Time-Progress Report

Smoothing Forecast Analysis - Predict your sales by units using an advanced method of forecast analysis called Smoothing.
Click Here To Open.

Spreadsheet Library - We updated over 150 spreadsheets for free download. You will find some of these sheets are also linked from this and other pages.
Click Here.

Standard Industrial Codes 
Compare your Income Statement, Balance Sheet, and 4 Key ratios with your industry. 
Click Here To Open.

SWOT Assessment Using the Malcolm Baldrige Model
SWOT = Strengths, Weaknesses, Opportunities, and Threats. Strengths and weaknesses are internal to a company (i.e. they can be directly influenced by company action or inaction). Opportunities and threats are external to the company (i.e. circumstances which may or may not arise in the outside environment and over which the company has no control). So the purpose of a SWOT is to actively promote the identified strengths, minimize weaknesses by planning them out of existence, exploit the opportunities before the window closes and have contingency plans in place to minimize threats before they materialize.

     1)
Download Free SWOT Kit
     2) Go to
http://www.quality.nist.gov/
     3) Then search Google for Malcolm Baldrige

Training Courses - Here are Free MS Office Training Courses.

Vendor Evaluation Analysis - You can objectively evaluate the various advantages and disadvantages of each of your vendors.
Click Here To Open.

Wealth Analysis This spreadsheet allows you to analyze your net worth to help you determine if you are doing a good job accumulating wealth. Cool Sheet!!
Click Here To Open.

Yearly Planner - Use this calendar to outline your plans and goals for a full year. Enter the year and then press the "Enter" key. Enter your company name. Use the notes area at the bottom of the sheet to record your ideas and/or goals.
Click Here To Open

DISCLAIMER

Sorry, There is No Support For Free Downloads or Web Based Calculators

It is important that you have at least an basic proficiency in using Microsoft Excel®.

Our free downloads have been prepared to give you ideas and examples of how you might use them for business analysis. It may not, however, be appropriate for analysis of your particular business due to differences in accounting principles, tax laws and other regulations and standards applicable in your area. They are not intended to be a substitute for professional advice. Accordingly, you may wish to consult your accountant, financial, or legal advisors regarding their use.

JaxWorks and its authors are not responsible for any action you take based on the use of these free downloads and registered products.

     1) We do not offer support for free downloads.

     2) We do not offer support for free software. You must contact the respective
         author or vendor for problems in setup and use.

Finally, a good understanding of Financial Statements and General Accounting terms is helpful.