Update future date after entering money value in different Cell

[ylliricon]

Hi all.

hope someone can help me with the issue i'm having in excel

Example: I have a mortgage of 85,000 Euros, my Payment plan started on 01/09/2016 and will end on 30/06/2025, I have a monthly payment of 550 Euros per month.

From 01/09/2016 up until end of April 2019 that's 32 months, which mean i have paid 17,600 euros per agreed payment plan ( 32*550=17,600 ).

I have made over payments by 6,050 Euros which brings the total amount to 23,650 Euros if we calculate that in months that would be a total of 43 months of 550 Euros payments,
(43*550=23,650), 43 months from 01/09/2016 comes up to 01/04/2020. which brings me to my question and issue I am having.

What method could i use to automatically update the months (01/04/2020) if I make A SINGLE payment of the minimum required of 550 Euros that date to update to (01/05/2020) or MULTIPLE payments of 550 Euros

I would really appreciate if anyone could formulate the method for this to work as i can not figure this out!!!

Many thanks in advance

 

[oldbrewer]

OWING	DATE	PAID	EXTRA PAID	MONTH INT RATE	OUTSTANDING
85000	01/09/2016	550	0	0.005	84875
84875	01/10/2016	550	0	0.005	84749.375
84749.38	01/11/2016	550	0	0.005	84623.12188
84623.12	01/12/2016	550	550	0.005	83946.23748
83946.24	01/01/2017	550	0	0.005	83815.96867
83815.97	01/02/2017	550	0	0.005	83685.04852
83685.05	01/03/2017	550	550	0.005	83003.47376
83003.47	01/04/2017	550	0	0.005	82868.49113
82868.49	01/05/2017	550	0	0.005	82732.83358
82732.83	01/06/2017	550	0	0.005	82596.49775
82596.5	01/07/2017	550	0	0.005	82459.48024
	YOU CAN DRAG DOWN TO MORTGAGE END DATE

<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[ylliricon]

OWING	DATE	PAID	EXTRA PAID	MONTH INT RATE	OUTSTANDING
85000	01/09/2016	550	0	0.005	84875
84875	01/10/2016	550	0	0.005	84749.375
84749.38	01/11/2016	550	0	0.005	84623.12188
84623.12	01/12/2016	550	550	0.005	83946.23748
83946.24	01/01/2017	550	0	0.005	83815.96867
83815.97	01/02/2017	550	0	0.005	83685.04852
83685.05	01/03/2017	550	550	0.005	83003.47376
83003.47	01/04/2017	550	0	0.005	82868.49113
82868.49	01/05/2017	550	0	0.005	82732.83358
82732.83	01/06/2017	550	0	0.005	82596.49775
82596.5	01/07/2017	550	0	0.005	82459.48024
	YOU CAN DRAG DOWN TO MORTGAGE END DATE

<tbody>
</tbody>

Thank you for your replay, that's not quite what i'm looking for

Please see the link ( google spreadsheets ) https://docs.google.com/spreadsheets/d/16kNhnTBwGpYFc6v7crsy7Os6T-JZpxdHMxUYOjlUWl0/edit?usp=sharing

so what I want to figure out is if cell C10 (marked Yellow ) currently showing 43 (months) updates to 44 (months) then that to trigger cell D12 (marked Red)to automatically to update from 03/2020 to 04/2020

Thank you