You can make the loan amortization schedule table, calculate the annuity loan, calculate the amount of interest, calculate the annual percentage rate.
Loan amortization schedule table is the plan of repayment of the loan and is usually annexed to the treaty on taking a loan. It contains the following information:
- loan amount
- interest rate
- transfer date
- number of annuities
- monthly annuity amount
- amount of any potential costs
- method of interest calculation
- annuity amount
- amount of the effective interest rate
- serial number
- Amount of loan repayment
In amortization plan are all financial information related to the loan. In addition to basic information such as the amount of the loan, interest amount and the interest rate, there is a very important balance on a given day, which tells us how much do we owe at certain date.
To make an amortization schedule we need the following information: loan amount interest rate date of transfer number of annuities how many months of annuity the amount of potential costs method of interest calculationAll other data, which are an integral part of the amortization schedule, are found by the program.
An annuity is an amount that the borrower in equal installments (monthly, quarterly, semi-annual, annual) returns to the lender. Each installment consists of interest and repayment, this is the amount by which the payment of each installment reduces the debt.
Since there are differences in meaning of what is the effective interest rate, I will use the term “Rate For Money”. Some consider that the effective interest rate is the rate which was calculated with compound method. The second one is the rate at which the costs of the loan are also taken into account and the compound was applied method of calculation. In our case, we mean the effective interest rate, which includes the costs. This information is very important because it represents the real price of the loan and is the best indicator for the comparison of large loans. The calculation is very difficult because there is no formula, but we have to find it . We are looking to recalculate all transfers and returns of the same day. That discount rate at which the sum of the calculated transfers and repayments equals, is a measure of money.