Designed For Excel 2010/2013
and
MS Word 2010/2013


 
Every week or so, we get email suggestions for creating new analysis systems. One that appears with regularity is "a complete analysis system on one worksheet with easy navigation to each analysis module". So, we created OneSheet™.
 
What is OneSheet™ ?
It is built on the unique JaxWorks process of entering financial data in One Master Data Entry Module and have that data populate multiple analysis systems to produce a comprehensive multipage health analysis report.
 
How does OneSheet™ work?
  Step 1) Gather your financial data from your accountant or internal accounting system.
  Step 2) Click the Clear Buttons to clear the Master Data Entry and Cash Flow Data Entry modules.
  Step 3) Enter your data into both Data Entry modules.
  Step 4) Open and Edit the linked MS Word file entitled "onesheet.docx".
  Step 5) Print your report.
 
What do you need?
          1) Intermediate skills on Microsoft Excel.
          2) Intermediate skills on Microsoft Word.
          3) Microsoft Excel 2010 or 2013.
          4) Microsoft Word 2010 or 2013.
 
Advantages?
          1) The entire analysis system is on one worksheet.
          2) Very small file size footprint - runs very fast in laptops, tablets, and smart phones - all brands.
          3) Extremely portable for onsite analysis jobs.
          4) Low learning curve.
          5) Totally open and unprotected architecture for altering to suit a client situation or yourself.

 

 

Product Features

 

OneSheet™ is "Printer Ready". All sheets pre-formatted.
Full open architecture allows you to customize to suit your needs.
Includes these bonus systems:
        Budget Analysis System
        Budget System
        Business Audit
        Business Tools Library Volume I
        Business Tools Library Volume II
        Detailed Expense Estimates
        Detailed Sales Analysis
        Diagnostics System
        Master Control

 

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 Control Panel

Eagle's Eye View - Partial SnapShot at 10% Zoom

System Setup



 
Simple Steps:              
Step 1) Gather your financial data from your accountant or internal accounting system.
Step 2) Click the Clear Buttons to clear the Master Data Entry  and   
            Cash Flow Data Entry modules.        
Step 3) Enter your data in both modules.        
Step 4) When data entry is completed, open the linked MS Word file onesheet.docx
            by clicking on the "Open the Linked Printing Document" button.  
Step 5) Print your Business Analysis Report report.      
                 
Navigation:              
Step 1)  Click on any worksheet title in the index panel.      
Step 2) Click on the return button on any worksheet to return to the index.  
            You may also use "CTRL+ Home" on the keyboard to return to the index.
                 
NOTE:                
Totally open and unprotected architecture for altering to suit a client situation or yourself.
 
 

Master Data Entry Module (Full View)







 
 

Cash Flow Data Entry Module (Full View)

 













 

 

 

Summary Analysis (Full View)



 

Forecast Analysis - Regression Analysis Applied (Snap Shot)



 

Breakdown of Operating Costs - Down To The Minute

 

Expanded Financial Ratios


Alphabetized by ratio description, this worksheet will help both you and any potential outside investor compare your business's performance from one year to the next (for example, has gross profit grown or declined between years one and four?) and against other similar businesses (for example, does your business give as good a return on investment as others?).
 



 
 

Market Value Analysis


   There is no single best method for determining a business's worth since each business sale is unique.

   The wisest approach is to compute a company’s value using several techniques and then choose the one that makes the most sense.

   There are three techniques and several variations for determining the value of a business:
     1) The balance sheet technique.
     2) The earnings approach.
     3) The market (or price/earnings) approach.
 



 

 

 

 
 

 

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