OK, so we are back with the same scenario, the same loan amount, interest rate and years, but with
a different objective, and this time our objective is to calculate the interest rate, a combined value
for a multiple periods, for example, a range of period from year one to five or any other different
range of periods.
This will be called cumulative payment or further cumulative interest payments for any particular duration.
So what we are going to do here is that, first of all, let me tell you this definition here.
This is not correct.
Correct.
And that is Sourcefire.
So now let us calculate the cumulative payment.
See, you might be empty and then press Dabb.
So here is our formula, which is asking me for the rate, first of all.
So I will take the rate of 12 percent.
The second argument is number of periods.
So I will take it as done.
The third argument is present value, which is this one.
And now Exelis asking me for the starting period that from which period do you want to start?
I want to start from period one and two, which period I want to to say I want to period five.
And then I would say zero for the end of the period and I breath control enter.
So XSL has given me an answer of twenty six thousand one forty five.
What is that.
That is the cumulative interest payment for first five years.
Well is that correct?
Let's check some other manually calculate the sum of all of these five years.
So I'm summing up all the five year interest payment I will press control enter and here we have twenty
six thousand one forty five point forty six, the same value.
That is just I don't need to ignore that so you can go to the cumulative interest payment for any duration
directly rather than calculating the complete schedule and then something that up.
So I hope that function is, again, a very helpful function.