How to get loan value for fixed time span and payment

Hi everyone,

I am wondering, how I can get the remaining value of a load or annuity after a fixed time span with a fixed rate.

Say e.g. I have a loan of $100.000, an annual interest rate of 11% and a monthly payment fo $1.500. What amount of money is left after this time?

All functions I have found (e.g. amortize, annurate, ...) either provide as output

• a timespan to completely pay the loan or
• a rate that need to be payed

Many functions even provide an additional input "FutureValue", but I would need that as an output of my function. Did I overlook something? Or does that function simply not exist?

Thanks!

[Peter]

Just to add: It is not about calculating it (I have done that), I just want to know, if there is a built-in function for this.

Answer 1

[Shivam Lahoti]

Hi Peter,

I understand that you want to calculate the remaining loan amount using a built-in function. You mentioned the 'amortize' function, but it seems you missed the complete output list of the aforementioned function.

Please run the following command in your MATLAB command line and take a look at the example provided:

matlab

openExample('finance/ComputeanAmortizationScheduleforaConventional30YearFixedExample')

In the example plot, you will observe that the solid blue line represents the declining principal over the 30-year period. This corresponds to the 'Balance' output from the 'amortize' function.

The 'Balance' output value is the remaining balance of the loan at each payment period. It indicates the amount of principal still owed, excluding the interest.

I hope this helps.

Regards,

Shivam