The key to successfully operating a business is
having the right information to make your decisions.
This concept may appear elementary, but it can be
one of the greatest strategic and operational
obstacles a business faces. As any person who reads
or analyzes financial statements knows, there are
more financial indicators available than are needed.
The trick is to choose the indicators that have the
greatest relevance to a firm's financial goals.
Since a Blueprint is a plan of action, or something
already done that can be used as a guide to doing
something in the future,
JaxWorks Blueprint™ uses familiar
financial tools to analyze, plan, and grow a firm's
future.
JaxWorks Blueprint™
broadcasts thousands of data analysis information
from single data entry sheets. For example, the
primary module produces a 64 page analysis report
from data entered on one page.
Compatible with Microsoft Office 2000, 2003, and
2007, JaxWorks
Blueprint™ is totally open
architecture, has no macros, and contains 82
worksheets which print 109 pages.
Features:
JaxWorks Blueprint™
is "Printer Ready"
242 worksheets
Prints 313 pages
Full open architecture allows
you to customize to suit your needs.
Includes these bonus tools:
Cash Flow Analyzer (A
$50.00 value, if bought separately)
Business Plan for Startup Business
Business Plan Creator
Business Tools Library Volume I
Business Tools Library Volume II
Dynamic Strategic Planner
NeoPrice™ - Pricing Your Product or Service
Master Control 2003
Microsoft Office Excel 2003 system requirements
To use Microsoft Office Excel 2003, you need:
1) Computer and processor Personal computer with an
Intel
Pentium 233-MHz or faster
processor (Pentium III recommended)
2) Memory 128 megabytes (MB) of RAM or greater
3) Hard disk 150 MB of available hard-disk space;
optional installation files
cache (recommended) requires an
additional 200 MB of available
hard-disk space
4) Drive CD-ROM or DVD drive
5) Display Super VGA (800 × 600) or higher-resolution
monitor
6) Operating system Microsoft Windows 2000 with Service
Pack 3 (SP3),
Windows XP, or later
Apple Minimum System Requirements:
Microsoft (Apple) Office Excel 2008, Word 2008, and PowerPoint 2008 system requirements
To use Apple Microsoft Office 2008, you will need:
1) A Mac computer with an Intel 500 MHz or faster
processor
2) Operating system Mac OS X version 10.4.9 or later
3) 512 MB of RAM or more
4) 1.5 GB of available hard disk space
5) DVD drive
6) 1024 x 768 or higher resolution-monitor
NOTE: Since
Microsoft chose to drop VBA (Macros) in Apple Excel
2008, a good alternative is to use Boot Camp found
in Mac OS X or a 3rd party virtual desktop program.
This allows you to have Windows XP or Vista on your
Mac desk top.
|
|
|
|
Blueprint™ Index |
|
The
index is in workbook order. |
|
Master Data Entry
Introduction
Index
Days Process
Income Statement
Income Statement 8 Periods
Projected Income Statement
What-if Income Statement
Comparative P&L Statement
P&L Trend Analysis
Balance Sheet
Balance Sheet 8 Periods
Balance Sheet Projections
Comparative Balance Sheet
Balance Sheet Trend Analysis
Projected Balance Sheet
What-if Balance Sheet
Cash Flow Statement
Cash Flow Statement 8 Periods
Cash Flow Forecast Daily
Cash Flow Forecast Weekly
Twelve-month cash flow
Small Business Cash Flow
Small Biz Cash Flow Chart
Cash Flow Tracker
Cash Flow Tracker Chart
Cash Flow Sensitivity Analysis
Cash Flow Sensitivity AR
Cash Flow 12 Months
Cash Flow Forecast 12 Months
Cash Flow 4 Yrs
Quarterly
Cash Flow 4 Yrs Quarterly (2)
Financial Operations
Financial Operations Charts
Revenue Operations
Revenue Operations Charts
Operations Projections
Key Financial Indicators
Financial Ratios
Key Financial Ratios Indicators
Forecast Assessment Analysis
Optimal Performance
Stock Valuation
Bankrupcy Predictions
Market Value Analysis
Forecast Analysis
General Trend Assessment
Financial Summary |
Payroll Analysis
Break-Even Analysis
Breakeven Analysis (1)
Breakeven Analysis (2)
Breakeven Analysis (3)
Breakeven Analysis (4)
Breakeven Adjusted
Liquidity Ratios
Asset Ratios
Profitability Ratios
Debt Ratios
Market Ratios
Detailed Expense Estimates
Planned Expenses Input
Actual Expenses Input
Expense Variances
Expense Analysis
Total Expenses Chart
Detailed Sales Estimates
Sales Forecast Input
Sales Forecast Totals
Sales Forecast Chart
Sales Projection Charts
Linear Trendline Chart
Logarithmic Trendline Chart
Polynomial Trendline Chart
Power Trendline Chart
Exponential Trendline Chart
Moving Average Trendline Chart
Expenses vs. Sales Summary
Step Costs Graph
Budget System
Budget Summary
Profit & Loss Chart
Balance Sheet Chart
Marketing Budget Plan
Budget Plan Chart
Inputs & Assumptions
Business Unit Expense Analysis
Annual Operating Budget
Metrics Trend Chart
Budget vs. Actual
Budget Scenario Analysis
Headcount and Payroll Planning
Salary and Benefits Chart
Product Profitability Analysis
Summary Metrics Chart
License Agreement |
|
|
Bonus Tools Index
(All New and Updated) |
|
Accounts Payable Aging
Accounts Receivable Aging
Annual Direct Labor Analysis
Approval To Hire Request
Auto Expense Report
Average Selling Price Analysis
Advertising Expenditures-Media
Backorder Control
Balance Sheet
Balance Sheet (2)
Balance Sheet (3)
Basic Invoice
Bill of Ladding
Break-Even Analysis
Break-Even
Break-Even (2)
Break-Even Chart
Break-Even CIA
Break-Even Units
Budget-5 Profit Centers
Buried Costs
Business Acquisition Worksheet
Business Indebtedness
Business Loan Proceeds
Business Plan Sample
Business Valuation
Cash Budget
Cash Flow 4 Yrs Quarterly
Cash Flow Forecast
Cash Flow Forecast (2)
Cash Flow Sensitivity Analysis
Commercial Loan Checklist
Commission Report
Company Property Receipt
Comparative Business Income
Comparative Contribution Income
Comparative Earnings Analysis
Comparative Taxable Income
Corporate Earnings Analysis
Credit Application
Credit Control List
Credit History
Customer Ledger
Daily Profit Tracking
Weekly Profit Tracking
Daily Production Report
Daily Services Rendered
Debt Ratios
Direct Advertising Response
Direct Marketing Analysis
Employee Change Record
Employee Orientation
Employee Performance Review
Employee Self Evaluation
Employee Termination
Employee Time Sheet
Employee Turnover Analysis
Estimating Start-Up Capital
Expense Budget
Expense Report
Financial Calculator
Financial Comparison Analysis
Financial Analysis Data Entry
Financial Analysis
Financial Statement Ratios
Five Year Projections
Fixed Asset Record
Flexible Budget
G&A Expense Budget
Income Statement
Income Statement 2 Years
Income Statement 12 Months
Income Statement 5 Years |
Inspection Report
Insurance Coverage Report
Job Estimate
Liquidity Analysis & Ratios
Manufacturing Overhead Budget
Marketing Calculators
Marketing Personnel Expenses
Media Budget by Quarter
Media Forecast
Merchandise Plan
Merchandise Return
Monthly Sales Projections
Moving Average Sales Forecast
New Employee Record Chart
New Product Sales Forecast
One Year Project Process Report
Overdue Account File
Parts Inventory
Payroll Analysis
Perpetual Inventory Control
Personal Wealth Analysis
Personnel Activity Report
Present Value Mixed Stream
Price Estimate For Services
Price Line Sales Projections
Product Sales Goals
Production Reject Report
Profitability Ratios
Proforma Balance Sheet
Pro-Forma Balance Sheet
Proforma Income Statement
Pro-Forma Income Statement
Project Cost Summary
Projected Cash Flow
Puchases Log
Purchase Order
Quarterly Budget Analysis
Quarterly Cash Flow Projection
Quarterly Marketing Budget
Quarterly Sales Record
Quotation Evaluation
Quotation Record
Ratio Analysis
Receipt For Goods
Receiving Report
Request For Quotation
Sales Activity Report
Sales Budget
Sales Channel Analysis
Sales Promotion Expenses
Sales Quotation
Sales Revenue Report
Sales Seasonality by Month
Sales Trend Analysis
Service Invoice
Shipping Order
Small Business Valuation
Smoothing Forecast
Startup Budget
Startup Capitalization
Statement of Account
Statement of Cash Flows
Stock Balance Record
Stock Valuator
Store-To-Store Sales
Summary of Key Accounts
Vendor Cost Analysis
Vendor Evaluation Analysis
Vendor Master File
Wealth Accumulation Analysis
Weekly Cash Flow Projection
Weekly Work Schedule
Yearly Planner |
|
Blueprint™
Folder Contents |
|
 |
|
Screen Shots |
There is a Master Control Central worksheet.
These sheets has been set
up to make starting and reaping the
benefits of your analysis product as
simple as possible.
Just click on the system that you need
and it will start automatically. |
|
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
|
|
Some
Additional Blueprint™
Examples |
Financial Ratios
This worksheet will help both you and any
potential outside investor compare your business's
performance from one year to the next (for example,
has gross profit grown or declined between years one
and five?) and against other similar businesses (for
example, does your business give as good a return on
investment as others?).
The ratios can also be used as an aid in making
future financial projections. For example, if you
believe that it is prudent to hold the equivalent of
a month's sales in inventory, once you have made the
sales forecast for future years, the projections for
inventory in the balance sheet follow logically. |
 |
 |
|
 |
Optimal Performance
Analysis
Several numbers on this page may appear illogical
since maximum percentages were used in Sales and
minimum percentages were used in Expenses.
Its sole purpose is to show how, if everything comes
together, the results of maximum efficiency already
performed in other time periods. |
|
|
Market
Value Analysis
There is no single best method for determining a
business's worth since each business sale is unique.
The wisest approach is to compute a company’s value
using several techniques and then choose the one
that makes the most sense.
There are three techniques and several variations
for determining the value of a business:
1) The balance sheet technique.
2) The earnings approach.
3) The market (or price/earnings) approach . |
 |
|
|
|
 |
Break-Even Analysis
The Break-Even point can be easily computed by
dividing Fixed Expenses by Fixed Expenses plus
Profit: FE/(FE+P).
You will note that the date of Break-Even has also
been computed by multiplying 365 times the
Break-Even percentage. In the BE Chart, placing your
pointer on the bisection of Sales and Expenses will
also indicate the month and approximate date. |
|
|
|
General Trend
Assessment Analysis
Trend assessments are vital to discovering
the overall health of a business.
This sheet
yields 8 periods of trends in Net Sales, Cost of
Goods Sold, Gross Profit, Total expenses, Operating
income, EBIT, Net Income After, Current Assets,
Inventory. Total Assets, Current Liabilities,
Non-current Liabilities, Total Liabilities, Retained
earnings, Equity, and
Z-Score:
Publicly Held Firm
Privately Held Firm
Non-Manufacturing
And, much more . . . |
 |
|
|
|
 |
The Budget Scenario
Analysis
This analysis helps managers evaluate the impact of
different business scenarios on key budget drivers
that generate revenue. You can use them to enter
data about the best-case, average-case, and
worst-case scenarios on annual revenue. Find out
whether the revenue assumptions associated with your
annual budget are reasonable or whether mitigating
strategies should be implemented to limit risks
associated with the worst-case scenario.
Use this analysis as part of your annual budgeting
cycle after you've completed the initial draft of
your budget. |
|
|
Headcount Analysis
The Headcount and Payroll Planning worksheet set is
designed to help finance, human resources, and
compensation teams forecast and plan annual
headcount and total compensation. This set of
worksheets helps you forecast compensation expense
based on the predicted number of staff each quarter
within each department. It also accounts for key
expenses such as fringe benefits and variable pay. |
 |
|
|
|
 |
Product Profitability
Analysis
This analysis helps finance, product
management, and operations teams assess the overall
profitability of specific products quarterly and
annually. By conducting a product profitability
analysis, your company can understand the direct and
indirect costs associated with developing and
offering a specific product and assess a product's
contribution to the bottom line. |
|
|
Marketing Budget Plan
The Marketing Budget Plan worksheet lays out a list
of possible expenditures for you to consider when
creating your marketing budget. You can use all the
categories in the template, or only a few, or you
can add categories of your own.
This worksheet makes it easy for you to create a
budget plan, because formulas and other worksheet
features are already set up for you. When you enter
or change quantities and prices, the totals are
automatically adjusted. |
 |
|
|
|
 |
Dashboards
There are 4 dashboards:
1) Financial Operations Dashboard
2) Revenue Operations Dashboard
3) Key Financial Indicators Dashboard
4) Key Financial Ratios Dashboard
All serving to view key indicators at a glance.
All of these mini-charts can be drag copied or
linked to a PowerPoint presentation, or any suitable
MS Office or compatible application. |
|
|
|
 |
