Excel uses NPER function to calculate how many years it will take to pay off the loan.

Excel uses NPER function to calculate how many years it will take to pay off the loan. What is the specific data? If the repayment is monthly, it is calculated by the number of months, which needs to be divided by 12 to get the number of years.

=NPER (interest rate, payment, PV, FV, type)

= number of periods (interest rate, amount paid in each period, present value, final value, whether to pay at the beginning)

The final value is 0. Is the payment 0 at the beginning?

How many years is it cost-effective to pay off the loan and buy a house? The longer the time, the more interest. The repayment method of the bank's equal principal and interest paid more interest in previous years. Apply to the bank for repayment of average capital, with the same principal and interest, and pay less interest. Take 100 as an example, the difference in 20 years is more than 20,000.

How many years can Rong Tai loan last? Pay off your personal qualifications. The better your qualifications, the easier it is to apply. You can apply now. Generally, there is no mortgage for 1-5 working days.

Unsecured loan information:

Provide personal identification information, including ID card, residence permit, household registration book, marriage certificate and other information;

Provide stable address, housing lease contract, utilities, property management and other related information;

Provide stable income sources, bank statements, labor contracts, etc.

How many years has the loan been paid off, not counting buying a house. From a practical point of view, the basic conditions for loans are:

First, Chinese mainland residents, under the age of 60;

Second, it has a stable address and work or business premises;

Third, there is a stable source of income;

Fourth, there is no bad credit record, and loans cannot be used for stock trading and gambling;

Fifth, have full capacity for civil conduct.

How many years will it take me to pay off the 200,000 loan? Can I get a loan elsewhere? The longer the service life, the more interest you need to pay. Choose your acceptable service life according to your own situation. Loans can be obtained from other places, but due to different local policies, the auditing standards are different. Please ask the bank or relevant departments for details.

How to use the functions in excel to calculate the length of service Assuming that the entry date is A 1, the length of service formula is:

1, anniversary:

=DATEDIF(A 1，TODAY()，" y ")

2. Year and month:

=DATEDIF(A 1，TODAY()，" y ")& amp； "Year"&; DATEDIF(A 1，TODAY()，" ym ")& amp； "Last month"

How to calculate the form of a * b+c * d+ with Excel function ... Enter the formula = a1* 6+b1* 2+c1* 3 in the cell D/kloc-0, and then copy it.

I borrowed 0.2 million/200 thousand. If I pay it off within two years, how many years is the most cost-effective loan, and two years is the most cost-effective. If it's a mortgage, I'll borrow it for five years! The interest rate is the lowest, but the short-term repayment pressure is also the greatest! Since you want to pay off in two years, it is estimated that the repayment pressure is not a problem for you! I hope it helps you!

How many years can a shop pay off the loan at most? Current maximum 10 year.