Calculating Interest and splitting over Financial years

[Rickardo]

Hello

First post

I know how to calculate the overall daily interest rate on a loan but what i would like to do if possible is to split this out into financial years

So for example if a loan was taken out on 1 November 2018 and matured on 31 October 2021 (three years) I can calculate the interest for the three years as a lump sum but how can i split the interest out shows is shows what is due in 18/19, 19/20 and 20/21.

Just to be clear this is a financial year which starts in April and ends in March

 

[AhoyNC]

Take a look at the CUMIPMT function.
https://support.office.com/en-us/article/cumipmt-function-61067bb0-9016-427d-b95b-1a752af0e606