I am doing something seemingly quite easy: Prinipal calcuation of a loan.
I need to calculate daily principal payments and accumulate it on a yearly basis.
So my current implementation look like that:
However, implementing it in excel is not that easy.
Below you can find the logic:
At the moment I am calculating the first year, if the date is not the beginning or the end of the year, daily and the other years with a yearly formula, which gives me differences an accumulated difference in my solution.
Any recommendations, how to implement "daily principal payments and accumulate it on a yearly basis" in excel?
I appreciate your replies!