Increasing by a percentage based on a dynamic spread

I am trying to figure out the best way to calculate an increase in revenue over the course of a year. I want the total percent increase to remain the same throughout the whole year (ie. 4%), but I have two problems.

1. I want to be able to adjust the monthly increase amount based on different factors (ex: increased revenue in some months, lower in other months), while keeping the overall increase the same. So if In July, there is a bigger increase, the remaining months will adjust to smaller increases to keep the overall increase the same.

2. Right now, in the attached sample sheet, I have it increasing by a flat 0.33% every month, but the way I have it set up, it is compounding this increase so it comes out to the total increase being a bit more than 4%. How can I avoid this?

Sample Budget Worksheet.xlsx

Two propositions: "remaining" means:

a) from the month with extra change (like July being 1% written later - when there is already formula - directly in I5) till the end of the year.
if it's like that - see Sheet1. And formula in C5 copied right:

Formula:

Please Login or Register  to view this content.

b) all months (also earlier in year) are affected by the change in July.
Write percents for non-tipical months in row 4. See Sheet2. In C5 and copy right formula:

Formula:

Please Login or Register  to view this content.