How to get loan value for fixed time span and payment

3 次查看（过去 30 天）
Peter
Peter 2023-2-2
回答： Shivam Lahoti 2024-6-24
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!
  1 个评论
Peter
Peter 2023-2-2
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.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Shivam Lahoti
Shivam Lahoti 2024-6-24
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

类别

在 Help Center 和 File Exchange 中查找有关 Financial Toolbox 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by