 |
|
|
 |
|


This product is designed
exclusively for
Excel 2010.
This Product is NOT compatible with Excel
97/2000/2003/2007 Versions.
Please
See Requirements Below
|
|
|
Product
Description |
Click Magic™ Business Analysis System is
designed to quickly analyze the overall health of
any business. Its main feature is the "Click
Magic
Control Panel". Click Magic are condensed chart
snapshots of key financial analysis data. The
Click Magic 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 "Click Magic
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. |
| |
|
Internal
Control Panels |
|
 |
| |
|
Print Preview of Example 1 |
| |
 |
| |
|
|
Control Panel
2 |
|
 |
| |
|
|
Control Panel 3 |
| |
|
 |
|
|
|
Control Panel 4 |
|
|
|
 |
|
|
|
Sparkline Charts Now Available with Excel 2010 |
|
|
 |
|
|
Product Features |
| |
Click Magic™
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 2010 |
| |
|
Requirements |
| |
Microsoft's Minimum Requirements For Office
Excel 2010
CPU
500-megahertz (MHz) processor or higher; 1
gigahertz (GHz) required for Outlook with
Business Contact Manager
Memory
256 megabytes (MB) of RAM or higher; 512 MB
recommended for graphics features, Outlook
Instant Search, Outlook with Business Contact
Manager, Communicator, and certain advanced
functionality
Hard disk
3.5 gigabyte (GB) available disk space
Display
1024 × 768 or higher-resolution monitor
Operating system
Windows XP with Service Pack (SP) 3 (32-bit),
Windows Vista with SP1 (32-bit or 64-bit),
Windows Server 2003 R2 (32-bit or 64-bit) with
MSXML 6.0 installed, Windows Server 2008 or
later (32-bit or 64-bit), Windows 7 (32-bit or
64-bit). Terminal Server and Windows on Windows
(WOW) (which allows installing 32-bit versions
of Office 2010 on 64-bit operating systems) are
supported
Additional - Please Note
Requirements and product functionality can
vary based on the system configuration and
operating system.
This product is CPU and Memory intensive.
Click Magic™ was created on a system with the
following configuration and OS.
|
OS
Name |
Microsoft Windows 7 Ultimate |
|
Processor |
Intel(R) Core(TM)2 Quad CPU
Q6600 @ 2.40GHz, 2400 Mhz, 4 Core(s),
4 Logical Processor(s) |
|
Installed Physical Memory (RAM) |
4.00
GB |
|
Total
Physical Memory |
3.00
GB |
|
Available Physical Memory |
2.00
GB |
|
Total
Virtual Memory |
6.00
GB |
|
Available Virtual Memory |
4.95
GB |
|
Page
File Space |
3.00
GB |
Other
1) Certain Linking Features require running
Windows XP Table PC edition or later. Speech
recognition functionality requires a close-talk
microphone and audio output device. Information
Rights Management features require access to a
Windows Server 2003 with SP1 or later running
Windows Rights Management Services.
2) Connectivity to Microsoft Exchange 2000
Server or later is required for certain advanced
functionality in Office Outlook 2007. Instant
Search requires Windows Desktop Search 3.0.
Dynamic Calendars require server connectivity.
3) Connectivity to Windows Server 2003 with SP1
or later running Windows SharePoint Services is
required for certain advanced collaboration
functionality. Microsoft Office SharePoint
Server 2007 is required for certain advanced
functionality. PowerPoint Slide Library requires
Office SharePoint Server 2007. To share data
among multiple computers, the host computer must
be running Windows Server 2003 with SP1, Windows
XP Professional with SP2 or later.
4) Graphics hardware acceleration requires a
DirectX 9.0c graphics card with 64-MB or higher
video memory.
5) Internet Explorer 6 or later, 32-bit browser
only. Internet functionality requires Internet
access (fees might apply)
6) 512 MB of RAM or higher recommended for
Outlook Instant Search. Grammar and contextual
spelling in Word 2010 is not turned on unless
the computer has 1 GB memory.
7) Silverlight plug-in. See Get started with
Microsoft Silverlight (http://go.microsoft.com/fwlink/?LinkID=169372).
|
This product is designed exclusively for Excel
2010. This Product is NOT compatible with Previous Excel Versions.

|
|
|
Click
Magic™ 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
Master 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 |
|
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 |
|
|
Master Control Central
This sheet 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. |

A Few Dashboards
(Each printed on a single
sheet of 8˝ x 11 Paper)











Master Data Entry Worksheet

Instructions

Master Data Entry -
Automated Side Bar Selections

Pro Forma Income Statement
- 12 Months

Click a button and the 12
month Pro Forma sheet
transforms into showing 4 Quarters.





|
|
 |
|
|
|
|
|