4. Current Period vs. Prior 4 Calendar Years -Analysis by Activity-Based Categories

[M/S -4] contains [yellow highlighted cells] formatted for entering [data]. All other cells are protected, and cannot be changed or altered in any way.  Therefore; entering incorrect data is the only possible mistake or error a user can make when using FastBooks Solutions Service-Based Business Software.

The best first step to quickly gain a basic understanding and appreciation for the business purpose of [M/S -4] is to review the [2] images below.  The first image populated with the [simulated-business-data] contained in the Practice Software. 

The second is an image of how [M/S -4] appears before populating any [data] in the software.  Take note of the protected cell coordinates designed to display calculations or information appear as blank cells.  Displaying cell coordinates not requiring a calculation as a blank cell is a principle design structure throughout the software to by design limit the [number of numbers] displayed in each respective software segment.  For example; cell coordinates designed to display actual vs. forecast better or worse calculations will appear as blank cells when the software does not contain a future forecast.Model Segment 4 of 18 -FastBooks Solutions Microsoft Excel Service Business Accounting ModelLeft click on the image above to open an enlarged image in a new tab.

 

Click the link to open [M/S -4] in an Adobe PDF file:

Click the link to open [M/S -4] in an Excel file:Model Segment 14 of 18 -FastBooks Solutions Microsoft Excel Service Business Accounting ModelLeft click on the image above to open an enlarged image in a new tab.

Click the link to open [M/S -4] in an Adobe PDF file:

Click the link to open [M/S -4] in an Excel file:

The Excel file will open in a Protective View. The [Enable Editing Button] on the top row must be clicked first to save an Excel file on a device. The carefully structured screen and scrolling design of the software segments in FastBooks Solutions were all formatted for viewing in the Excel Auto Hide Ribbon screen viewing mode.   Click on the first icon on the right top corner of Excel to change the screen display view to this designed screen display option. 

[M/S -4] The Financial Historical Comparison Analysis

The primary purpose for the Financial Historical Comparison Analysis software segment is to help you put your current year financial results in perspective by comparing them to your three prior years of business financial results.  The “primary key” for comparisons is the percentage of revenue for each Activity Based Expense Classification.  It helps you better understand how current-year expense and percentages compare to your most recent financial periods.  (Please note; these numbers rounded in thousands for easier comparison.)

Use the [yellow cells] in this software segment to enter the businesses last three years of financial tax statement data in columns [D-E-F] for comparing your current year Income Statement expense and percentage to the prior periods.  There are only five numbers you must enter for each prior annual period.  The prior periods should also be rounded to thousands when copied from your 1120-S Corporation Income Tax statements.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Microsoft Excel small business niche software; FastBooks Service Business Software is a 21st Century [paradigm-shift] in niche business software; that was exclusively designed for Service Based Businesses.  It is easy to learn and use; and generates amazing vitally informative relevant service business insight, generated by unique Microsoft Excel functionality features; that are not offered in Quick-Books; or similar business solutions. FastBooks-2016 is the 4th enhanced annual release of the time and money saving FastBooks Service Business Software: