Enterprise business plan feasibility calculation and verification system and its operating method
Patent Information
- Application Number
- TW114147340
- Authority / Receiving Office
- TW · TW
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2025-12-03
- Publication Date
- 2026-11-11
- Estimated Expiration
- 2045-12-02
Smart Images

Figure TWG2TB001920959_001 
Figure TWG2TB001920959_002 
Figure TWG2TB001920959_003
Abstract
Claims
1. A feasibility calculation and verification system for a business plan, comprising: At least one calculation and verification software, configured as an electronic spreadsheet, includes at least one data input module, at least one automatic calculation and logic check module, at least one profit and loss statement generation module, and at least one result presentation and alert module. The data input module includes data entry fields for operating expenses and data value fields for corresponding input of operating expense items and values. These data entry fields and data value fields are linked together to perform calculations using interconnected formulas. The automatic calculation and logic check module has built-in formulas and logic functions forming a calculation area. This calculation area performs automatic calculations, logic checks, and real-time feedback on the values input in the data value fields. The profit and loss statement generation module is linked to the data input module to output data values. Upon input, at least one profit and loss statement is automatically generated. The result presentation and warning module includes a warning area and a business feasibility judgment result area. The warning area is linked to the data input module and the automatic calculation and logic check module, and the calculation and logic check results are fed back to the warning area and the business feasibility judgment result area in real time. The result presentation and warning module takes the numerical data entered in the operating expense value field of the data input module, performs automatic calculation and logic check by the automatic calculation and logic check module, and then links it to the business feasibility judgment result area to provide a feasible or infeasible judgment result prompt. There is also at least one storage interface device, which can be a computer, server, USB flash drive, memory card, mobile phone, tablet, removable hard drive or cloud database. The storage interface device stores the calculation and verification software to provide data input and calculation and generate business feasibility judgment results.
2. The business plan feasibility calculation and verification system as described in claim 1, wherein, The data input module's "Number of Operating Expenses" field stores operating expense data, revenue and cost estimates, legal benchmark data, and industry reference ratios. The estimated operating expenses include: opening expenses, rent, sales and administration expenses, personnel costs, employee benefits and year-end bonuses, accounts receivable ratio and cash conversion days, loan amount, and loan interest rate. The revenue estimates include: estimated per capita consumption, estimated sales volume, estimated operating revenue, and cost ratio. The legal benchmark data includes: minimum wage and labor and health insurance rates. Actual values for the above items are entered through the "Number of Operating Expenses" field.
3. A business plan feasibility calculation and verification system as described in request item 1 or 2, wherein, The data input module's data entry module's data entry field for operating expenses and data entry field for operating expenses are arranged and adjusted according to the category of operating expenses to form at least one A integrated data area and at least one B integrated data area.
4. A business plan feasibility calculation and verification system as described in claim 1 or 2, wherein, The data input module further includes at least one depreciation period value field, which is used to input the depreciation period to be accrued for fixed assets and intangible assets.
5. The business plan feasibility calculation and verification system as described in claim 1, wherein, The automatic calculation and logic checking module forms a numerical calculation area with built-in calculation formulas and logic functions such as IF, VLOOKUP, SUMPRODUCT, AND, OR, CELL, TYPE, and ISERROR. However, it is not limited to these logic functions. Different spreadsheets will have different logic function contents for automatic calculation and logic checking. The automatic calculation conditions include gross profit, depreciation, interest, expense classification and subtotal, operating profit, pre-tax profit, and after-tax net profit. The logic checking conditions include automatic linkage calculation and logic checking if the data is deemed unreasonable.
6. The business plan feasibility calculation and verification system as described in claim 1, wherein, The profit and loss statement generation module includes operating revenue, operating costs and gross profit, operating expenses (distinguished by including rent, personnel costs, depreciation and amortization, and sales and management expenses excluding the above three items), operating profit, pre-tax net profit, after-tax net profit, operating profit income tax, and extended indicators (break-even sales, break-even sales volume, return on investment, working capital requirement and funding gap, payback period, and estimated total funds to be prepared for the project). After automated calculation and logic checking by the automatic calculation and logic checking module, these are presented in the profit and loss statement.
7. The business plan feasibility calculation and verification system as described in claim 1, wherein, The results presentation is linked with the warning module, which distinguishes the numerical storage cells, calculation area and warning area of operating expenses with different colors. The linked numerical storage cells, calculation area and warning area of operating expenses are presented with different visual prompts, and the warning area will provide a prompt if the wages are below the statutory wage or if there is insufficient cash flow.
8. A method for operating a feasibility calculation and verification system for a business plan, which uses the system described in any one of claims 1 to 7, and the method of operating the system includes: S100 Operational Data Input: The user opens the calculation and verification software, enters the operating expense value in the corresponding operating expense item field of the data input module, and saves it; S101 Operational Data Logic Check: The operating expense value entered in the operating expense value field is automatically calculated and logically checked through the calculation area of the automatic calculation and logic check module; S102 Alert Status Prompt: After the operating value has been automatically calculated and logically checked, the result is displayed in the alert area of the alert module. The data input module and the automatic calculation and logic check module feed back the calculation and logic check results to the alert area. The result is displayed in the alert module and the operating expense value field, the calculation area, and the alert area are distinguished by different colors; S103 Business Plan Feasibility Assessment: If the S101 operational data calculation and logic check are normal, the result of the business feasibility assessment in the display and warning module will link the data input module and the automatic calculation and logic check module to perform a feasibility analysis of the "predicted profit target". If the analysis shows that the business plan can achieve the "predicted profit target", it will be marked as "feasible"; otherwise, it will be marked as "infeasible". At the same time, you will be prompted to select whether to print the result form or archive the result. After making the selection, the process will end.
9. The operating method of the business plan feasibility calculation and verification system as described in claim 8, wherein, After the S1000 operating data input process, the input of values will enter the S100A profit and loss statement generation process, which will automatically generate at least one profit and loss statement through the profit and loss statement generation module.
Citation Information
Patent Citations
Financial report accounting method and system and related equipment
CN121052944A
Automated financial statement preparation system
TWM674303U
