[M/S’s 1 & 9] are the [2] Primary [What-if] Model Segments in the easy-to-learn-and-use FastBooks.Solution Service-Based Business Accounting Model.
[M/S -1] contains [yellow highlighted cells] formatted for entering [data]. A principle design structure throughout the software is only [yellow highlighted cells] are 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 Accounting Model.
The best first step to quickly gain a basic understanding and appreciation of the business purpose of [M/S -1] 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 -1] 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. Left click on the image above to open an enlarged image in a new tab.
(Please note below is a link to download both images in an Adobe PDF reader-file providing a clearer adjustable image of [M/S-1]. The website homepage provides a link to download all [18] primary model segments in one Adobe PDF reader-file.)
Left click on the image above to open an enlarged image in a new tab.
Open [M/S -1] in an Adobe PDF file:
Click the link to open [M/S -1] in an Excel file:
Left click on the image above to open an enlarged image in a new tab.
Click the link to open [M/S -1] in an Adobe PDF file:
Click the link to open [M/S -1] 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 -1] -The Actual vs. Forecast “What-if” Dashboard.
1 -Displays the business [Current Month] and [Year-to-Date] Income Statement in a summarized format appropriate for a service-based enterprise to allow for a quick understanding of the financial results immediately after the close of each month of business.
2 -Reconstructs “any” [selected historical business period] to serve as a comparable benchmark prior business time-period to assist in creating a Future Business Forecast.
3 -Creates a Service-Business [Revenue-Based] Future Forecast from 1 to 12 months in any one calendar year. The Future Revenue Based Forecast constructed in Model Segments [1 and 9].
4 -Generates a [Break-Even] or [Risk-Reward] analysis. By utilizing a trial and error process of adjusting the [Revenue] in column [5] cell [L9] until the Ordinary Business Income calculation in the cell [L16] either [Calculates-to-Zero] or achieves the respective strategic financial [Risk-Reward-Ratio] desired.
Below is a description of the business information provided in the [7] data column design structure of Model Segment-1:
Column [1] -Reflects the [Current Month] Income Statement for the last month of data entered in the Accounting Model.
Column [2] -Reflects the [Year-to-Date] Income Statement for the last month of data entered in the Accounting Model.
Column [3] -Reflects the [Total-Sum] of every month of Income Statement [data] entered in the Accounting Model.
Column [4] provides software functionality to restates a selected prior historical period for purposes of creating a comparative based period which would best represent a valid period to use to compare against or analyze various “What-if” assumptions and Future Forecast generated in columns [5 to 8].
Column [5] provides software functionality designed to calculate either a [Revenue Break Even Point] analysis or to construct a [Risk Reward Ratio Analysis]. Cells [L39 to 43] and [L47 to L69] in column [5] provide [Activity-Base 3 and 4] restated Historical Period Expense Account balances for the prior period of months entered in the cell[J18]. The Historical Expense accounts information is used to create a comparative based period for analyzing various “What-if” assumptions and Future Forecast generated in columns [6 to 8].
Column [6] provides the [Year-to-Date] Future Forecast for the number of months selected in the cell [N18].
Column [7] provides Actual vs. Forecast Better or (Worse) statistics calculated from the [Year-to-Date] financial positions reflected in Columns [2 and 6].
Column [8] provides the Total Future Forecast for the number of months selected in Cell [N18].