This product is compatible with Excel 2010/2013.

JaxWorks Financial Magic™ Financial Analysis System is a very comprehensive analysis system created for financial professionals and consultants with advanced skills in finance and Excel 2010/2013.
Financial Magic™ :

     1) Produces a comprehensive analysis by processing 49,131 data and formula cells.
     2) Evaluates and assigns weighted trend values important to increasing profit and productivity.
     3) Produces a final number on the Summary Analysis worksheet that is hard evidence of the
         firm's real value to the owner(s), investors, or potential buyers.

You will need to gather financial data covering 5 years. The system will project performance metrics out another 7 years in the Forecast Analysis worksheet.

You will need several hours to complete the initial data entries, however, after completion, updating periodically is easy and less time consuming. 

NOTE: This product is especially important for business consultants and financial professionals.
On occasion, financial data is discovered by having to dig into all sorts of records and statements.
Financial Magic™ allows you to gather this information and enter it into a detail accounts environment. It then automatically accumulates the data for posting into the analysis engine through the Master Data Entry worksheet. A real time saver.


Product Features


Financial Magic™ is "Printer Ready". All sheets pre-formatted.
Full open architecture allows you to customize to suit your needs.
        Linked, 50 Slide, PowerPoint Presentation.  Click Here for Demo in PDF format.
        Budget Analysis System - Internal Linked System
        Budget Systems - Standalone External
        Business Tools Library Volume I - Standalone External
        Business Tools Library Volume II - Standalone External
        Detailed Expense Estimates - Internal Linked System
        Detailed Sales Analysis - Internal Linked System
        Diagnostics System - Internal Linked System
        Internal Master Control Panel


Minimum Requirements


Microsoft Office Excel 2010/2013 system requirements
To use Microsoft Office Excel 2003/2013, 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


Master Index


Control Panel


Selected Screenshots


Please Note

     This system yields so many important analysis metrics that we had to select a reduced number of screenshots for
     you to get a better overview. Otherwise, the load time would be over a minute and a half @ 384 Kbps. That's annoying!


System Setup



Master Data Entry Worksheet


This worksheet is much too large to adequately display as a screenshot.

Please click on demo button below to open and view the actual worksheet.

Works Best With Microsoft Internet Explorer + Excel 2010 or 2013 as defaults.


Summary Statements Worksheet



Forecasted Revenue, Gross Margin, & Income Chart



Executive Summary
Current vs. Projected Chart





Final Summary Analysis



Financial Snapshot - Summary Chart


Market Value Analysis Summary Chart



Increased Sales Versus Expense Reduction



Company Stock Valuation




Comparative Payroll Analysis


Breakeven Analysis Sample


Small Business Headcount and Payroll Analysis


Detailed Sales Forecast Chart


Revenue Forecast: Linear Trendline Chart


Revenue Forecast: Logarithmic Trendline Chart


Revenue Forecast: Polynomial Trendline Chart


Revenue Forecast: Power Trendline Chart


Revenue Forecast: Exponential Trendline Chart


Revenue Trendline: Moving Average Chart


Expenses/Sales Estimates vs Actuals


Detailed Expense Estimates Planned vs. Actual Charts


Benchmark Analysis Dashboard



Horizontal Analysis Dashboard



Vertical Analysis Dashboard



Financial Diagnostics





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