|
|
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
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.
If this freebie interests you, take a look at
Microshots Pro™ or
Click Magic™.
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.
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. |
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 For Download Page.
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 For Download Page.
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 For Download Page.
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 For Download Page.
40 Month Projection Analysis.
Click
Here For Download Page.
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 For Download Page.
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 For Download Page.
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 For Download Page.
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 For Download Page.
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.
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 For Download Page.
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 For Download Page.
Advertising Expenditures by Media 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 For Download Page.
Altman
Z-Score - Background - The Altman Z-Score is the world standard for measuring the
overall health of any business. It is THE bankruptcy predictor.
Check it out with your
numbers.
The Altman
Z-Score Analysis - Routinely used by Stockbrokers trying to determine if a company is
a good investment, Bankers to determine loan risk, and internally, by anyone who wants to
take close look at his or her own company's financial health.
Check it out with your
numbers.
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 For Download Page.
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 For Download Page.
Average Selling Price Analysis 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 For Download Page.
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.
Download Click Here.
The Balanced Scorecard (BSC).
It has been around since 1992 and is sweeping businesses Worldwide at
all size levels.
"The Balanced Scorecard (BSC) concept was created by Drs. Robert S. Kaplan
and David P. Norton in 1992, and has been implemented in corporations, organizations, and government agencies worldwide.
The Balanced
Scorecard allows organizations to implement strategy rapidly and effectively
by integrating the measurement system with the management system. Based on
the simple premise that “measurement motivates”, the Balanced Scorecard has
been integral to the success of organizations throughout the world."
Read More .
. . . and Download Templates.
Balance Sheet (4
Years) $ Dollars $ - This sheet compares 4 years of your assets and liabilities
expressed in dollars. Print it and use it as a guide.
Balance Sheet (4
Years) % Percentage % - This sheet compares 4 years of your assets and liabilities
expressed as percentages. Print it and use it as a guide.
Breakdown of
Operating Costs
- Down to the minute, what it costs to operate your business.
Breakdown of
Operating Profits - Down to the minute, your profits.
Breakdown of
Ownership - Down to the minute, what you are taking out of the business.
Breakeven
Chart Analysis Calculate your breakeven with this
simple worksheet.
Click
Here For Download Page.
Breakeven Simple Chart Analysis Calculate your breakeven with this
simple worksheet.
Click
Here For Download Page.
Breakeven
Analysis Corrected 4th Year - This sheet illustrates how improvements in efficiency impact on the day of
the year when you start making a profit.
Breakeven
Analysis - This is a one page picture of your firm's current breakeven performance.
Breakeven
Analysis (4 Years) - This is a one page picture of your firm's break-even performance
over 4 years and its overall performance.
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 For Download Page.
Breakeven Analysis Workbook
- Calculate your breakeven with this stand-alone Excel® 95 worksheet.
Download FREE Breakeven Analysis. Click Here.
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 For Download Page.
Business Plan
Creation. This is a Must!
Click Here to Read and
Print.
Click
Here To Download MS Word Document. (82 KB)
Business Plan Outline
- Go here for a Business Plan Outline. Use this model as a guide when developing the business plan for your business.
Business Plan Sample - A good example for you to follow. Print it and use it as a guide AND
Download the Workbook Template.
Cash Flow Analysis - An analysis of the flow of cash through the year by quarter. Another indicator of your company's financial soundness.
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 For Download Page.
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 For Download Page.
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 For Download Page.
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 For Download Page.
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 For Download Page.
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 a good example of the importance of expense control.
Click Here For Download Page.
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 For Download Page.
Current Assets Value - This is a view of your firm's raw asset value (Market Value) for the current fiscal year.
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 For Download Page.
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 For Download Page.
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 For Download Page.
Excel Functions Glossary - Here is the complete function listing for Excel 2000.
Free Training Courses - Here are Excel 2002
Training Courses.
Executive Summary - Zeroing in on all of the areas that might be detracting from your bottom line.
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 For Download Page.
Financial Dashboard - You'll have to see this
workbook to appreciate its concept.
Click Here To Open
Financial Health Calculations - Quick calculations of your company's Financial Health.
Financial Health Checkup This is the meat without fat. When banks look over your business for a loan these ratios are the litmus test for risk limits.
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 For Download Page.
Forecast Analysis - A comprehensive trend analysis that contains forecasted values by regression analysis.
Forty (40) Month Financial Projection - This sheet incorporates Regression Analysis, Moving Averages, Trend Analysis, Smoothing, and Box-Jenkins to Project out 40 Months.
Click Here For Download Page..
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 For Download Page.
Headcount Analysis Ever wondered how companies determine how many employees to terminate when they "downsize" or "rightsize"? It Is Called "Headcount Analysis".
Click Here For Download Page.
Impact of Expense Reduction - How Expenses Impact On Profits. This is an eye opener.
Test it!
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.
Download FREE Investment Payback Analysis. Click Here
.
Loan Tree - To Download Click Here
Evaluate your business with this cool tool.
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 For Download Page.
Market Value Analysis - This is the most objective and accurate method of buying or selling a business. It has several steps and involves some sophisticated business mathematics. Banks and good
business brokers use this or a combination of these methods.
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 For Download Page.
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 For Download Page.
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 For Download Page.
NeoPrice™ Excel® Pricing Analysis System.
This file has been compiled into
a convenient PDF (Portable Document File) file. PDF Files are best viewed using
Acrobat
Reader. Before viewing the files, please download and install Acrobat
Reader:
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 For Download Page.
Operating Statement (4 Yrs) $
- This is a one page picture of your
firm's performance over 4 years and its overall performance expressed in dollars.
Operating
Statement (4 Yrs) % - This is a one page picture of your firm's performance over 4
years and its overall performance expressed as percentages.
Optimal
Operating Statement - This analysis applies the best performance percentages over 4
years to sales. It shows what the business could do if it performed at its maximum
potential.
Payroll
Analysis - This analysis determines the number of employees required to perform next
year's work at the current year's productivity.
Click Here to calculate your
payroll status.
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 For Download Page.
|
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.
| 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 For Download Page.
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 For Download Page.
Pro Forma
Worksheet - Creating pro forma financial statements is a standard way to forecast a
company's financial future. It is a requirement for business plans. Print it and use it as
a guide.
Productivity
Analysis - The impact of 30 minutes wasted each day in your business.
Projected 4
Year Asset Value - Using Forecast Analysis (Regression Analysis) this is a view of
your business Market Value out 4 years based on previous 4 years values.
Projected
Operating Statement - Using Forecast Analysis (Regression Analysis) this is a view of
your business out 4 years based on previous 4 years performance.
Projection of
Asset Value - Using Forecast Analysis (Regression Analysis) this is a view of your
firm's raw asset value (Market Value) for the next fiscal year.
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 For Download Page.
Sales Channel Analysis - Use this worksheet to analyze your distribution channel sales volume.
Click
Here For Download Page.
Sales Seasonality by Month For Excel®
2000 - 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 For Download Page.
Small Business Budget -
Every business needs a budget. This tool is not unlike a navigation chart for planning
your annual performance trip.
Click
Here For Download Page.
Small Business Tools - How to use Excel's Small Business Tools. The Business Planner, Mail Manager, Customer Manager, Financial Manager explained with graphics. MS Word 2000.
Download FREE Compressed ZIP File
Download FREE self-extracting file
Small Business Valuation - For Excel® 2000 - 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 For Download Page.
Small Builder/Contractor
Workbooks
Download Here> (Excel®
2000 - builder.exe. - 305KB)
Contains the following Workbooks:
1. Concrete Log Sheet (2 Tabs)
2. Daily Report (1 Tab)
3. Field Logs (3 Tabs)
4. Punch-list (1 Tab)
5. Time-Progress Report (5 Tabs)
Smoothing Forecast Analysis
- Predict your sales by units using an advanced method of forecast
analysis called Smoothing.
Download FREE Smoothing Forecast Analysis - Click
Here
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 For Download Page.
Strategic Planning For The Small Business
- The Strategic Plan is
the process by which we can envision the future and develop the necessary procedures and
operations to influence and achieve that future. It is the life-support system that, if
followed, assures your business a successful future. There are the 10 absolutes of a
Strategic Plan - Click Here to read or
Click Here to print them.
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
Ten (10) Key Ratios - Ratio analysis, a method of expressing the
relationships between any two accounting elements, provides a convenient technique for
performing financial analysis.
Vendor Evaluation Analysis - You can
objectively evaluate the various advantages and disadvantages of each
of your vendors.
Download Vendor
Evaluation - Click Here
Wealth
Analysis For Excel® 2000 - 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 For Download Page.
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 For Download Page.
|
DISCLAIMER
There is No Support For Free Downloads
It is important that you have at least an
intermediate proficiency in using Microsoft Excel® 2000/2002/2003/2007/2010/2011.
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. |
(Sorry,
There
is No Support For Free Downloads)
|
Microsoft Excel®
2000 or later,