CALCULATE INTEREST RATE IN LOAN

If we will borrow the money in bank, discussion moment how much do instalment to be paid per month its of the loan we do, usually we is given or simply showed by the containing paper sheet of lines line of level of loan, a period of loan and level of instalment to be paid per month its. big Wrong if not the loan as described there the amount of hims in five millions fold or ten million.

By using function on the application MS Excel, we can make calculation of level of instalment to be paid its month;moon to each;every loans amount to be taken, including the loans amount don't written in the paper given by bank. Possible there are some ways calculation of instalment, and the I write here – according to my knowledge– at most used, for example BCA, Bank Mandiri, and BII.his Case example of, we will borrow the money equal to Rp 45.000.000,00 to a period of/to loan of 5 year. The flower applying at that moment for example 16% per year. For example we write down each this value in cell [at] worksheet MS Excel.

A1 = 45000000 A2 = 5 A3 = 16%

Calculation result of level of instalment we will put down [at] cell A5, hence to cell A5 we enter formula following:

= PMT(A3/12;A2)

The calculation will yield the negative value, because seen from the aspect of approach we [release] the money.From got level of instalment, possibly we wish to know the level of loan fundamental in the instalment we pay [for]. For example we will put down his calculation result [at] cell A6, formula which is to be enterred:

= PPMT(A3/12;INSTALMENT_TO;A2)

Instalment to we change with number 1, 2, 3 and so on refer instalment first, second, third and so on.
paid level of Flower, we can calculate direct from level of instalment lessened by the loan fundamental paid. If counted by using function at]MS Excel, formula enterred as follows:

= IPMT(A3/12;INSTALMENT_TO;A2)

If we pay attention with situation of exact interest, amount of instalment will [is] same to [be] its monthly, big [of] loan fundamental will progressively go up and paid flower will progressively go down to each;every his monthly instalment. Following I enclose the file MS Excel for the calculation.

Bank Mandiri
Loan 40.000.000
Rate 12.25%
Duration 10 Years
Final Years 69.561.353,99

PR: wait... I: wait... L: wait... LD: wait... I: wait... wait... C: wait... SD: wait...

Credit Record

If You want to apply loan in your bank you must have good credit record, what must a credit record...?

Credit history or credit report is, in many countries, a record of an individual's or company's past borrowing and repaying, including information about late payments and bankruptcy. The term "credit reputation" can either be used synonymous to credit history or to credit score.

In the U.S., when a customer fills out an application for credit from a bank, store or credit card company, their information is forwarded to a credit bureau. The credit bureau matches the name, address and other identifying information on the credit applicant with information retained by the bureau in its files.

This information is used by lenders such as credit card companies to determine an individual's credit worthiness; that is, determining an individual's willingness to repay a debt. The willingness to repay a debt is indicated by how timely past payments have been made to other lenders. Lenders like to see consumer debt obligations paid on a monthly basis.

The other factor in determining whether a lender will provide a consumer credit or a loan is dependent on income. The higher the income, all other things being equal, the more credit the consumer can access. However, lenders make credit granting decisions based on both ability to repay a debt (income) and willingness (the credit report) as indicated in the past payment history.

These factors help lenders determine whether to extend credit, and on what terms. With the adoption of risk-based pricing on almost all lending in the financial services industry, this report has become even more important since it is usually the sole element used to choose the annual percentage rate (APR), grace period and other contractual obligations of the credit card or loan

Loan Definition

What Means A Loan....?

A loan is a type of debt. This article focuses exclusively on monetary loans, although, in practice, any material object might be lent. Like all debt instruments, a loan entails the redistribution of financial assets over time, between the lender and the borrower.

The borrower initially does receive an amount of money from the lender, which they pay back, usually but not always in regular installments, to the lender. This service is generally provided at a cost, referred to as interest on the debt. A loan is of the annuity type if the amount paid periodically (for paying off and interest together) is fixed.


Legally, a loan is a contractual promise between two parties where one party, the creditor, agrees to provide a sum of money to a debtor, who promises to return the money to the creditor either in one lump sum or in parts over a fixed period in time. This agreement may include providing additional payments of rental charges on the funds advanced to the debtor for the time the funds are in the hands of the debtor (interest).

PR: wait... I: wait... L: wait... LD: wait... I: wait... wait... C: wait... SD: wait...