Quarterly tax reserve from uneven profits · Calculation guide

Find the next cash transfer needed for a user-estimated cumulative tax reserve.

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.

needed = max(0,max(0,ytd+profit)*rate/100-paid-held); estimated = max(0,ytd+profit)*rate/100

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

InputValue
Profit before this quarter40,000
Current quarter profit or loss20,000
Assumed tax rate25%
Tax already paid7,000
Cash already reserved3,000
ResultValue
Additional reserve needed5,000
Estimated cumulative tax15,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Profit before this quarter40,00044,000Additional reserve needed5,0006,000
Current quarter profit or loss20,00022,000Additional reserve needed5,0005,500
Assumed tax rate25%28%Additional reserve needed5,0006,800
Tax already paid7,0007,700Additional reserve needed5,0004,300
Cash already reserved3,0003,300Additional reserve needed5,0004,700
Quarterly tax reserve from uneven profits →

Sources