This product is designed for Excel 2003 thru 2016.


Background:
Occasionally, our consultants are asked to come into current clients who request a quick checkup of their business. In these instances they are seeking assurance that the business is performing properly and trending toward a successful year. To satisfy this need, they created a quick checkup system. Tweaked over the years, it evolved into a standard JaxWorks analysis tool we have named it QuickWorks™.

QuickWorks™ uses familiar financial data to analyze, plan, monitor, and grow a business.

It instantly broadcasts thousands of data analysis information from just 2 data entry worksheets. It automatically produces a 76 page analysis report.

Compatible with all versions of Microsoft Office, QuickWorks is totally open architecture, has no macros, and contains 96 worksheets. It will print up to a 121 page detail analysis report.


Features:
QuickWorks™ 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.
 


QuickWorks™ 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
QuickWorks Folder Contents

Screen Shots
 

 












 

Some Additional QuickWorks™ 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.



 

 
 

 

© Copyright, 2016, JaxWorks, All Rights Reserved.   |   Privacy Statement   |   Terms of Use