| A | B | C | D | E | |
| 1 | Budget Worksheet | ||||
| 2 | Budget | 100000 | |||
| 3 | Fixed Costs | Additional Percent | Added Amount | Final Budget | |
| 4 | Rent | 26500 | 0 | =exremainder*exaddpercent | =exfixed+exadded |
| 5 | Wages | 36800 | 0.3 | =exremainder*exaddpercent | =exfixed+exadded |
| 6 | Cost of Goods Sold | 12000 | 0 | =exremainder*exaddpercent | =exfixed+exadded |
| 7 | Travel | 5000 | 0.5 | =exremainder*exaddpercent | =exfixed+exadded |
| 8 | Training | 2000 | 0.4 | =exremainder*exaddpercent | =exfixed+exadded |
| 9 | Total | =SUM(exfixed) | =SUM(exaddpercent) | =SUM(exadded) | =SUM(exfinalbudget) |
| 10 | Remainder | =T3-T10 | |||
This table was created by a free Excel macro written by Charles Balch.
Here's the code. It is care ware - it's yours for free if do something nice for anyone (anyone includes you).