Hello, dear, I'm glad to answer your question! The loan interest rate calculation formula is: daily interest rate = annual interest rate ÷ 360; Daily interest rate = monthly interest rate ÷ 30; Monthly interest rate = annual interest rate12; Monthly interest rate = daily interest rate × 30; Annual interest rate = monthly interest rate ×12; Annual interest rate = daily interest rate ×360. abstract

How to calculate the loan interest?

Hello, dear, I'm glad to answer your question! The loan interest rate calculation formula is: daily interest rate = annual interest rate ÷ 360; Daily interest rate = monthly interest rate ÷ 30; Monthly interest rate = annual interest rate12; Monthly interest rate = daily interest rate × 30; Annual interest rate = monthly interest rate ×12; Annual interest rate = daily interest rate ×360. answer

Dear, for general loans, interest can be calculated by this formula "interest = principal × interest rate× loan term". answer

If someone borrows 200,000 yuan, the loan term is 1 year, and the annual interest rate of the loan is 8.52 1%, then it can be calculated that the total interest payable by the user is 2000008.52 1% 1 year = 17042 yuan.

The calculation of loan interest is directly proportional to the loan amount, loan interest rate and loan term. answer

Second, how to calculate the loan interest rate?

The simplest way to calculate the interest rate is to calculate the total repayment amount first, and the monthly repayment period is 12 months, and then subtract the total repayment amount from the total loan amount to get the interest. Interest = principal interest rate. So the interest rate equals the total interest/loan.

Interest rates of different loan channels

1, credit card cash installment or cash-out: credit card holders often think of borrowing money or cash-out with their own credit cards. First of all, cashing is brushed out by some methods, probably from 60 yuan to 80 yuan, and then by stages.

2. Mortgage loan: At present, the interest rate of bank mortgage loan is between 6% and 8% according to local policies and banks, but it still needs collateral that meets the requirements and needs to go through various procedures, which is more troublesome.

3. Bank credit loans: At present, many banks also provide various mobile phone credit loans with annual interest rates ranging from 8% to 14%. According to the product category and some repayment methods, the interest is about 15%.

4. Our company: The current loan company only needs to provide loans ranging from several hundred thousand. If the threshold is low, the interest will be high, and the interest will be around 24%.

5. Small loan platforms: JD.COM Gold Bar, Bai Jie, Microfinance, Wanda Loan and other formal and reliable platforms all bear interest on a daily basis. The daily interest rate is about 0.05%, and the calculated annual interest rate is about 18%. There are also some mobile phone loan platforms with even higher interest rates, mostly around 36%, and the annual interest rate of some illegal online loans can even be as high as 200%.

Simple interest and compound interest

Single interest rate means that the principal is generally fixed, which will be settled at maturity and then included in the next principal. The calculation formula of single interest rate is: principal (1 interest rate term). Simple interest is different from compound interest. Compound interest is actually taking the principal and interest of the previous period as the principal of the next period, and then calculating the interest circularly. The formula of compound interest is: principal (1 interest rate) _, and n is the deposit term. For example, if the principal is 1 0,000 yuan and the monthly deposit interest rate is 1%, the calculation formula of one-year simple interest and compound interest is:10,000× (1%×12). The formula of compound interest is10000× (11%)12 =11268 yuan.

Third, how to calculate the total loan interest?

In fact, the monthly repayment amount of the loan can be solved by the PMT function in excel, and the corresponding usage of the PMT function formula in excel is as follows: =-PMT (annual loan interest rate/one or two years, fixed number of years, repayment amount). If you know the total loan amount and monthly repayment amount, you can use the PMT function of excel to substitute the loan amount into this function. By adjusting the parameters of the annual interest rate of the loan, the value calculated by EXCEL is equal to the monthly repayment amount.