Feb 21 2022 07:19 PM - edited Feb 21 2022 07:50 PM
I am trying to find a way to add up different financing and paybacks. The "3" in the input cell is the number of years each payment will be paid back. The different payments are below the "3".
I need to the bank payback cells to be able to add them and then stop once they've reached the allotted number of payments.
So if it was 3 years per payment The Bank Payback cell would look like:
Year 1: Payment 1
Year 2: Payment 1+ 2
Year 3: Payment 1+ 2 + 3
Year 4: Payment 2+ 3 +4 (The first payment has been paid off)
Year 5: Payment 3+ 4 (The second payment has been paid off)
And so on. However, they need to be able to adapt to if the number of years per payment is changed and if new payments are added as well.
This can be done via functions or VBA.
Feb 21 2022 09:41 PM
Solution@crimsonb Not the most elegant and dynamic solution but with some (hidden) helper columns I could achieve what you asked for, I think. But it requires some manual adjustments if you want to expand the schedule. See if the attached example is something that could work for you.
Feb 21 2022 09:47 PM
@Riny_van_Eekelen This works! Thank you so much! I really appreciate it.
Feb 21 2022 09:41 PM
Solution@crimsonb Not the most elegant and dynamic solution but with some (hidden) helper columns I could achieve what you asked for, I think. But it requires some manual adjustments if you want to expand the schedule. See if the attached example is something that could work for you.