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.
Includes:
        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