This page captures a reference resultset for the synthetic scenario matrix.
The table rows are produced by executing:
Schema/tcNodeDb4/Scripts/EXEC_DatasetSyntheticMIS.sqland copying the final SELECT resultset.
| IsCompany | Scenario Id | Scenario Name | Year | Description | Opening Capital | Closing Capital | Profit | Business Tax | Profit After Tax | Capital Movement | Opening Position | Opening Account Position | Capital Delta | Variance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Yes | 1 | VAT=0, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 0 | -4536.69 | -36135.69 | 0 | -36135.69 | -3001 | -400 | 35000 | -4536.69 | 0 |
| Yes | 1 | VAT=0, PriceRatio=0.5 (loss) | 2025 | 2025-26 | -4536.69 | -46348.6 | -41811.92 | 0 | -41811.92 | 0 | 0 | 0 | -41811.92 | 0 |
| Yes | 1 | VAT=0, PriceRatio=0.5 (loss) | 2026 | 2026-27 | -46348.6 | -46348.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 0 | -3373.19 | -34972.19 | 0 | -34972.19 | -3001 | -400 | 35000 | -3373.19 | 0 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2025 | 2025-26 | -3373.19 | -44643.48 | -41270.29 | 0 | -41270.29 | 0 | 0 | 0 | -41270.3 | -0.01 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2026 | 2026-27 | -44643.48 | -44643.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 0 | 145992.69 | 141226.78 | 26833.09 | 114393.69 | -3001 | -400 | 35000 | 145992.69 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 145992.69 | 316054.76 | 209953.16 | 39891.1 | 170062.06 | 0 | 0 | 0 | 170062.06 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 316054.76 | 316054.76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 0 | 146935.13 | 142390.28 | 27054.15 | 115336.13 | -3001 | -400 | 35000 | 146935.13 | 0 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 146935.13 | 317435.9 | 210494.79 | 39994.01 | 170500.78 | 0 | 0 | 0 | 170500.77 | -0.01 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 317435.9 | 317435.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 0 | 19891.51 | -11358.49 | 0 | -11358.49 | -3350 | -400 | 35000 | 19891.51 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2025 | 2025-26 | 19891.51 | 10423 | -9468.52 | 0 | -9468.52 | 0 | 0 | 0 | -9468.52 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2026 | 2026-27 | 10423 | 10423 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 0 | 20221.68 | -11028.32 | 0 | -11028.32 | -3350 | -400 | 35000 | 20221.68 | 0 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2025 | 2025-26 | 20221.68 | 11294.79 | -8926.89 | 0 | -8926.89 | 0 | 0 | 0 | -8926.9 | -0.01 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2026 | 2026-27 | 11294.79 | 11294.79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 0 | 135198.37 | 166003.98 | 62055.61 | 103948.37 | -3350 | -400 | 35000 | 135198.37 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 135198.37 | 283396.64 | 242296.56 | 94098.29 | 148198.27 | 0 | 0 | 0 | 148198.27 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 283396.64 | 283396.64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 0 | 135390.15 | 166334.15 | 62194 | 104140.15 | -3350 | -400 | 35000 | 135390.15 | 0 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 135390.15 | 283902.69 | 242838.19 | 94325.64 | 148512.55 | 0 | 0 | 0 | 148512.54 | -0.01 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 283902.69 | 283902.69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
