Click Here To View a 12 Period Example
(MS Word 2003 Document)

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

Legend™ is designed to save you even more time with business analysis.  

Legend™ is composed of 3 major components:
1) A MS Excel 2003 Comprehensive Business Analysis System that is linked to . . .
2) A set of preconfigured and linked MS Word 2003 analysis reports.
3) MicroShots Pro™ Business Analysis System. MicroShots are condensed chart
     snapshots of key financial analysis data. The MicroShots worksheets are fully
     automated and yield instant results.

The logic is simple:
1) Enter on one worksheet (The Master Data Entry Worksheet) your financial data,
2) Have that data instantly populate all analysis worksheets,
3) Produce analysis results that point to problem areas for improving the business,
4) Finally, these results are then instantly posted to linked MS Word analysis documents.

There are 5 preconfigured and linked MS Word 2003 templates:
1) Comprehensive (103 Printed Pages)
2) Expanded (95 Printed Pages)
3) Standard (73 Printed Pages)
4) Concise (64 Printed Pages)
5) Short (45 Printed Pages)

All of these reports can, and should be, customized to suit your needs.

Click Here To View an Example
(MS Word 2003 Document)

Legend™ is "Printer Ready". All sheets pre-formatted.
90 worksheets
Prints 126 pages
5 preconfigured and linked MS Word 2003 templates.
Full open architecture allows you to customize to suit your needs.
Created for Microsoft Excel 2003.
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

Legend™ Index

This index is in alphabetical order.

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
Cash Flow
Cash Flow Sensitivity Analysis
Cash Flow Sensitivity AR
Comp. Balance Sheet
Comp. Income Statement
Corporate Headcount Analysis
Cover Sheet
Current Ratio
Current Summary Chart
Debt Ratio
Earnings Per Share
Equity Ratio
Executive Summary
Expanded Ratios
Expense Analysis
Expense Budget
Financial Summary
Forecast Analysis
G&A Expenses Chart
Gross Profit Margin
Health Analysis Chart
Industry Analysis
Inventory Turnover Ratio
Labor Expenses Chart
Logit Analysis
Market Value Analysis
Market Value Explained
Master Data Entry
Master Index
Materials Cost Chart
Net Profit Margin
Optimal Performance
Ownership Chart
Payroll Analysis
Profit Chart
Proforma Balance
Proforma Income
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 (10)
Snapshot (11)
Snapshot (12)
Snapshot (2)
Snapshot (3)
Snapshot (4)
Snapshot (5)
Snapshot (6)
Snapshot (7)
Snapshot (8)
Snapshot (9)
Snapshot Summary Chart
Stock Valuation
Summary Analysis
Times Interest Earned Ratio
Total Expenses Chart
Z-Score Analysis (1)
Z-Score Analysis (2)
Z-Score Analysis (3)
Z-Score Explained
License Agreement

Master Control

Legend Folder Contents

Screen Shots

Master Data Entry Worksheet


Instructions Example


Pro Forma Income Statement - 12 Months


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


Master Data Entry - Automated Side Bar Selections


















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