Calculation guide
Same-year profits and losses net at one assumed rate. Deduct tax already paid and cash already reserved. This is a cash budget, not a statutory installment calculation.
Inputs
Profit before this quarter
Example entry 40000 (in the selected currency).
Current quarter profit or loss
Example entry 20000 (in the selected currency).
Assumed tax rate
Example entry 25 %. Allowed range 0 to 100.
Tax already paid
Example entry 7000 (in the selected currency).
Cash already reserved
Example entry 3000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Profit before this quarter | 40,000 |
| Current quarter profit or loss | 20,000 |
| Assumed tax rate | 25% |
| Tax already paid | 7,000 |
| Cash already reserved | 3,000 |
| Result | Value |
|---|---|
| Additional reserve needed | 5,000 |
| Estimated cumulative tax | 15,000 |
Calculation steps
Additional reserve needed = max(0, ((((max(0, (Profit before this quarter + Current quarter profit or loss)) × Assumed tax rate) ÷ 100) − Tax already paid) − Cash already reserved))
max(0, ((((max(0, (40,000 + 20,000)) × 25) ÷ 100) − 7,000) − 3,000)) = 5,000
Estimated cumulative tax = ((max(0, (Profit before this quarter + Current quarter profit or loss)) × Assumed tax rate) ÷ 100)
((max(0, (40,000 + 20,000)) × 25) ÷ 100) = 15,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Profit before this quarter | 40,000 | 44,000 | Additional reserve needed | 5,000 | 6,000 |
| Current quarter profit or loss | 20,000 | 22,000 | Additional reserve needed | 5,000 | 5,500 |
| Assumed tax rate | 25% | 28% | Additional reserve needed | 5,000 | 6,800 |
| Tax already paid | 7,000 | 7,700 | Additional reserve needed | 5,000 | 4,300 |
| Cash already reserved | 3,000 | 3,300 | Additional reserve needed | 5,000 | 4,700 |
