This product is designed for Excel 2003/2007/2010. 
 


 
If you are one of the thousands who downloaded our Free Microshots, this new and expanded version might be of interest. We have greatly expanded the selection of microshots (see below), included our Cash Flow Analyzer product, and added several bonus features.

For those of you new to the micro charting concept, downloading the Free Microshots workbook will give you a good idea and feel for its advantages.

Comment: In our beta testing, one volunteer printed all of the button selections and produced a 72 page 5" x 9" leave-behind booklet for their client. Their client's presentation combined the MicroShots with the normal 8" x 11"  worksheets to create a 150 page analysis manual.

 

Control Panel


Product Description


MicroShots Pro™ Business Analysis System
is designed to quickly analyze the overall health of any business. Its main feature is the "MicroShots Control Panel". MicroShots are condensed chart snapshots of key financial analysis data. The MicroShots worksheets are fully automated and yield instant results.

Easy to setup:
1) Click the number of financial periods that you desire for posting: 4 through 12 periods.
2) Click a Z-Score class: Public, Private, Non-manufacturing.
3) Click a business category: Manufacturing, Service, Retail, Wholesale, or Job Shop.
4) Set up as "C" corp or "S" corp.
5) Choose Year, Month, or Quarter configurations.
6) Enter data in cells in the "Master Data Entry" worksheet.
7) Enter data in cells in the "Cash Flow Data Entry" worksheet.
8) Go to the "Quick Analysis 4 Periods" worksheet. Here you will find the Primary Financial
    Predictors that determine the overall health of the business.
9) Next, go to the "Summary Analysis" worksheet. All of the key analysis worksheets feed
    information back to this summary sheet for additional fast assessment.
10) Then, go to the "Financial Health Analysis" worksheet. This worksheet condenses everything
      into one printed page. Button clicks yield blowups for printing.
11) Lastly, go to the automated "MicroShots Control Panel" worksheet for some amazing fast analysis results.

This product is "open architecture" which allows you to sculpture it to suit any business analysis situation.
 

Product Features

 
MicroShots™ is "Printer Ready". All sheets pre-formatted.
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
 

Minimum Requirements

 
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.
 

MicroShots Pro™ Index

This index is in alphabetical order.

Audit Assessment Key
Automatic Audit
Average Collection Period
BE Adjusted
Breakdown of Costs
Breakeven Analysis (1)
Breakeven Analysis (10)
Breakeven Analysis (11)
Breakeven Analysis (12)
Breakeven Analysis (2)
Breakeven Analysis (3)
Breakeven Analysis (4)
Breakeven Analysis (5)
Breakeven Analysis (6)
Breakeven Analysis (7)
Breakeven Analysis (8)
Breakeven Analysis (9)
Break-Even Applied
Breakeven Summary
Business Audit Introduction
Cash Flow
Cash Flow 4 Periods
Cash Flow 8 Periods
Cash Flow Data Entry
Cash Flow Sensitivity Analysis
Cash Flow Sensitivity AR
Comp. Balance Sheet
Comp. Income Statement
Copyright
Corporate Headcount Analysis
Cover Sheet
Current Ratio
Current Summary Chart

Dashboard
Debt Ratio
Earnings Per Share
Equity Ratio
Executive Summary
Expanded Ratios
Expense Analysis
Expense Budget
Financial Analysis Dash (1)
Financial Analysis Dash (2)
Financial Analysis Dash (3)
Financial Analysis Dash (4)
Financial Health Analysis
Financial Ratios Dashboard
Financial Summary
Forecast Analysis
Forecast Analysis Dashboard (1)
Forecast Analysis Dashboard (2)
G&A Expenses Chart
Gross Profit Margin
H-Factor
Industry Analysis
Introduction
Inventory Turnover Ratio
Labor Expenses Chart
License Agreement
Logit Analysis
Manual Audit
Market Value Analysis
Market Value Explained
Master Data Entry
Master Index
Materials Cost Chart
MicroShots Control Panel
Net Profit Margin
Optimal Performance
Ownership Chart
Payroll Analysis
Profit Chart
Proforma Balance
Proforma Income
Quarterly Report
Quick 4 Periods
Quick Ratio
Ratios Introduction
Return on Assets
Return on Equity
Return-on-investment analysis
Sales Performance Chart
Sales Projection Chart
Sales vs. Expense
SB Headcount Analysis
Snapshot
Snapshot (10)

Snapshot (11)
Snapshot (12)
Snapshot (2)
Snapshot (3)
Snapshot (4)
Snapshot (5)
Snapshot (6)
Snapshot (7)
Snapshot (8)
Snapshot (9)
Snapshot Summary Chart
Springate
Stock Valuation
Summary Analysis
The Business Audit Background
Times Interest Earned Ratio
Total Expenses Chart
Z-Score Analysis (1)
Z-Score Analysis (2)
Z-Score Analysis (3)
Z-Score Explained

MicroShots Pro Folder Contents




 

 
 

 

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