Calculation formula of loan compound interest
Calculation formula of loan compound interest
F=P*( 1+i)N (power)
F: compound interest final value
headmaster
One: Interest rate
N: integer multiple of interest rate acquisition time
Assuming that the initial investment principal is 10000 yuan and the annual compound interest rate is 25%, how to calculate the final capital in EXCEL after five years?
Answer to the question = 10000 * (1+0.25) 5
For example, suppose the initial investment principal is 10000 yuan, the cycle is 5 years, and the final principal is 26000 yuan, that is, the profit is 16000 yuan. How to calculate the annual compound interest in EXCEL?
That is, the formula F=P*( 1+i)N (power) is used to reverse the value of I.
Then1+I =1/the power of n (f/p)
Then i=(F/P) to the power of 1/N-1, and the formula is = (f/p) (1/n)- 1. Add a condition to the compound interest calculation formula. For example, suppose the initial capital P = 10000, the interest rate I = 20%, the term N is 5 years, and the condition for joining is to subtract 1000 every year. How to find the final f value?
=RATE(5，0，- 10000，26000，0)
How to calculate the number of days of loan interest?
From the business occurrence date to the settlement date.
Personal consumption loan requirements: 1. Nationality requirements: China (excluding Hong Kong, Macao and Taiwan residents);
2. Age requirement: 2 1 one year old, under 55 years old;
3. Income requirement: minimum 3,000 yuan per month;
4. Credit requirements: credit cards or other loans have no bad credit records;
5. Residence requirements: the current residence address has lived for more than 6 months;
How to calculate the interest-bearing days of bank loans?
The interest rate is approved by the bank and substituted into the following formula.
Matching principal and interest repayment method:
Monthly loan amount = [loan principal × monthly interest rate ×( 1+ monthly interest rate )× repayment months ]=[( 1+ monthly interest rate )× repayment months]
Monthly interest payable = loan principal × monthly interest rate ×[( 1+ monthly interest rate) repayment months -( 1+ monthly interest rate) (repayment month serial number-1)] ÷ [(1+monthly interest rate) repayment months -650.
Monthly repayment principal = loan principal × monthly interest rate ×( 1+ monthly interest rate) ÷ (repayment month serial number-1)÷[( 1+ monthly interest rate) repayment months-1]
Total interest = repayment months × monthly repayment amount-loan principal
How to calculate loan compound interest
Use compound interest final value coefficient and annuity final value coefficient.
For example, the loan is 6,543,800 yuan, the loan term is 20 years, and the annual interest rate is 6%.
10 * (f/p，6%，20) = 32.05438+00，000。
Payment by installment
The annual payment is 32071(f/a, 6%, 20) = 32.071/36.786 = 0.9782 million yuan.
Pay 9782/ 12=8 15 yuan every month.
If monthly compound interest is considered, it will be converted into adulthood. More troublesome.
If it is an estimate. That's enough.
How to calculate loan compound interest
Use compound interest final value coefficient and annuity final value coefficient.
For example, the loan is 6,543,800 yuan, the loan term is 20 years, and the annual interest rate is 6%.
10 * (f/p，6%，20) = 32.05438+00，000。
Payment by installment
The annual payment is 32071(f/a, 6%, 20) = 32.071/36.786 = 0.9782 million yuan.
Pay 9782/ 12=8 15 yuan every month.
If monthly compound interest is considered, it will be converted into adulthood. More troublesome.
If it is an estimate. That's enough.
Is the loan compounded with daily interest and monthly interest?
The personal housing loan interest of China Construction Bank is compound interest.
In essence, loan interest is compound interest, not simple compound interest;
(2) that is, part of the monthly repayment is interest and part is principal. When calculating interest next month, first calculate the principal balance, directly multiply it by the monthly interest rate to get the interest payable this month, and then use the monthly payment-the interest payable this month is the principal amount repaid this month, and so on.
Transaction interest method:
(1) Calculate the interest one by one according to the predetermined interest formula: interest = principal × interest rate× loan term, with three details:
If the interest-bearing period is a whole year (month), the interest-bearing formula is: ① interest = principal × year (month )× year (month) interest rate; If the interest-bearing period has a whole year (month) and odd days, the interest-bearing formula is: ② Interest = principal × year (month )× year (month) interest rate+principal × odd days × daily interest rate for the same period.
How to calculate the loan profit? How much is compound interest?
The interest rate is 2.64% and the cost is 2.00%. 500 yuan is invested in a monthly cycle, with an initial principal of 6,000 yuan and a loan period of (month) 12.
Single business profit
No.65438+10 460.80 September 266.88+July 398.52
February 167.62, June 65438+1October 282.22, August 65438+August 4 16.49.
March 180.97,165438+1October 297.86, 65438+September 434.82.
April 194.59, February 3 13.82, October 453.52.
May 208.48, 65438+March 330. 10, 265438+1October 472.59
June 222.65 65438+April 346.70 22.04
July 237.10 June 65438+May 363.63 March 5 1 1.88
August 25th1.84, June 65438+ June 380.9438+0, April 24th, 2002. 36648.86868686667
What is the meaning of loan compound interest and how to calculate the interest/common sense of loan.
Solution: p- principal, also known as initial amount or present value;
I- interest rate refers to the ratio of interest to principal;
I- interest;
F- the sum of principal and interest, also known as the sum or final value of principal and interest;
N-the number of interest periods.
The interest of the first year under simple interest is not regarded as the principal of the second year, and the interest of the first year after compound interest is regarded as the principal of the second year. Compound interest is called rolling interest.
The final value refers to the sum of the principal and interest with compound interest after several periods.
The formula for calculating the final value of compound interest is:
FVN = PV * (1+I) n (that is, principal ×( 1+ interest rate) to the power of the number of periods)
For example, Wang Xiangyin Bank borrows 10000 yuan, the loan period is 2 years, and the annual interest rate is 6%. What is the final amount in the second year?
Fvn =10000 * (1+6%) 2 =10000 *1.1236 =1kloc-0/236 Yuan.
How to calculate the compound interest of loans?
The formula of compound interest is: F=P*( 1+i)N (power).
F: compound interest final value p: principal I: compound interest
N: an integer multiple of the time for obtaining compound interest.
I suggest you download a calculator. You don't need to remember the formula. You only need to know your rate of return, principal and cycle, and you can figure out how much you can earn.
The link is the download address of the calculator.