Budgets

[Lionking]

Hi guys, i'm trying to make a budget spreadsheet for the game (Zardugal). I made several (hope correct) calculations on how taxes are payed on luxuary goods and basic goods same as for taxes on business with this formula:

Total income amount divided by tax rate and then multiply by 100 = amount of total productivity

Now i'm stuck with personal tax!!!!! As i can never calculate the total amount on each category that this game bases upon, as the amount always various with the earnings and percentage. Someone has a formula? Also if you want to change the brackets in future.

Income Taxes
Bracket[?] Tax Revenue[?]
> 10,000 ZAR 5% 14,333,504,360 ZAR
> 15,000 ZAR 10% 28,667,008,740 ZAR
> 20,000 ZAR 14% 38,287,343,547 ZAR
> 25,000 ZAR 16% 36,426,956,115 ZAR
> 30,000 ZAR 20% 39,221,045,043 ZAR
> 35,000 ZAR 24% 39,769,881,614 ZAR
> 40,000 ZAR 30% 40,816,379,577 ZAR
> 45,000 ZAR 34% 38,184,049,343 ZAR
> 50,000 ZAR 37% 62,285,032,838 ZAR
> 60,000 ZAR 42% 70,581,519,210 ZAR
> 75,000 ZAR 47% 17,792,754,182 ZAR
> 80,000 ZAR 49% 62,249,346,862 ZAR
> 100,000 ZAR 51% 94,198,866,617 ZAR
Total 582,813,688,048 ZAR

[Siggon Kristov]

Try 1 ZAR at 1% (with no other brackets) and multiply the figure by 100 to get the total income of all the people in Zardugal.
I hope I'm answering what you're asking. I'm not sure exactly what you're asking.