Formula help on payment schedule

[Tinhare]

Here is the payment schedule in a condensed form for posting from my worksheet.

Book2
	A	B	C	D	E
1		TotalDifference	RemainingMonths	Diffpermonth
2		111,929	5	22,385.72
3
4
5
6		MonthlySplit	OriginalSchedule	ActualPaid	UpdatedSchedule
7	Deposit	10.0%	72000.00	79312.50	79312.50
8	Month1	10.0%	72000.00	14922.50	14922.50
9	Month2	15.0%	108000.00	74356.70	74356.70
10	Month3	15.0%	108000.00	79479.70	79479.70
11	Month4	15.0%	108000.00	0.00	130385.72
12	Month5	15.0%	108000.00	0.00	130385.72
13	Month6	10.0%	72000.00	0.00	94385.72
14	Month7	7.5%	54000.00	0.00	76385.72
15	Month8	2.5%	18000.00	0.00	40385.72
16	Total		720000.00	248071.40	720000.00
Sheet1

I have taken out the formulas as the data actually resides in another workbook.
My problem is with the updated schedule column. As you can see I have added the difference per month that needs to be paid in a flat line for the last five months. This works, however a better solution would be to increase the months with a larger original payment by a larger percentage increase than the months with a smaller payment.

For example Months 4 and 5 would instead of increasing from 108000 to 130385.72 they would increase from 108k to say 140k.
Correspondingly the remaining months increase would be less than currently stated.

I hope someone understands what I mean.

What I can't for the life of me figure out is the formula for cells E11 to E15 to make the increase relative to the original schedule.

I'be working for 18hours and need a break but it needs to be done for the morning, 6hours time.

Any help appreciated.

 

[Tinhare]

Solved it so don't waste your time