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 | 35000 | -4536.69 | -36135.69 | 0 | -36135.69 | -38001 | -400 | 35000 | -39536.69 | 0 |
| Yes | 1 | VAT=0, PriceRatio=0.5 (loss) | 2025 | 2025-26 | -4536.69 | -53698.6 | -49161.92 | 0 | -49161.92 | 0 | 0 | 0 | -49161.92 | 0 |
| Yes | 1 | VAT=0, PriceRatio=0.5 (loss) | 2026 | 2026-27 | -53698.6 | -53698.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 35000 | -3373.19 | -34972.19 | 0 | -34972.19 | -38001 | -400 | 35000 | -38373.19 | 0 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2025 | 2025-26 | -3373.19 | -51993.48 | -48620.29 | 0 | -48620.29 | -0.01 | 0 | 0 | -48620.3 | 0 |
| Yes | 2 | VAT=1, PriceRatio=0.5 (loss) | 2026 | 2026-27 | -51993.48 | -51993.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 35000 | 145992.69 | 141226.78 | 26833.09 | 114393.69 | -38001 | -400 | 35000 | 110992.69 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 145992.69 | 310101.26 | 202603.16 | 38494.6 | 164108.56 | 0 | 0 | 0 | 164108.56 | 0 |
| Yes | 3 | VAT=0, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 310101.26 | 310101.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 35000 | 146935.13 | 142390.28 | 27054.15 | 115336.13 | -38001 | -400 | 35000 | 111935.13 | 0 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 146935.13 | 311482.4 | 203144.79 | 38597.51 | 164547.28 | -0.01 | 0 | 0 | 164547.27 | 0 |
| Yes | 4 | VAT=1, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 311482.4 | 311482.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 30000 | 19891.51 | -11358.49 | 0 | -11358.49 | -33350 | -400 | 35000 | -10108.49 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2025 | 2025-26 | 19891.51 | 3073 | -16818.52 | 0 | -16818.52 | 0 | 0 | 0 | -16818.52 | 0 |
| No | 1 | VAT=0, PriceRatio=0.5 (loss) | 2026 | 2026-27 | 3073 | 3073 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2024 | 2024-25 | 30000 | 20221.68 | -11028.32 | 0 | -11028.32 | -33350 | -400 | 35000 | -9778.32 | 0 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2025 | 2025-26 | 20221.68 | 3944.79 | -16276.89 | 0 | -16276.89 | -0.01 | 0 | 0 | -16276.9 | 0 |
| No | 2 | VAT=1, PriceRatio=0.5 (loss) | 2026 | 2026-27 | 3944.79 | 3944.79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 30000 | 135198.37 | 166003.98 | 62055.61 | 103948.37 | -33350 | -400 | 35000 | 105198.37 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 135198.37 | 279133.69 | 234946.56 | 91011.25 | 143935.31 | 0 | 0 | 0 | 143935.31 | 0 |
| No | 3 | VAT=0, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 279133.69 | 279133.69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2024 | 2024-25 | 30000 | 135390.15 | 166334.15 | 62194 | 104140.15 | -33350 | -400 | 35000 | 105390.15 | 0 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2025 | 2025-26 | 135390.15 | 279640.79 | 235488.19 | 91237.55 | 144250.65 | -0.01 | 0 | 0 | 144250.64 | 0 |
| No | 4 | VAT=1, PriceRatio=3.0 (profit) | 2026 | 2026-27 | 279640.79 | 279640.79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
