With a Table like this, you then simply put in the amounts you calculated for each of the 4 scenarios.
Where the reduced tax rate applied, use it, and where it is not applicable, just use the current rate.
It will look simple enough to understand. The detail calculations for each case, you can note them on different sheets.
Please urgently help me with this. Many thanks as usual.