2017~ 3 Ways to Calculate Interest Payments
1 Write down the principal, term ,and interest from your loan in one column. Fill separate boxes with the amount of the loan, the length you have to pay, and the interest, and Excel can calculate your monthly payments for you. For the remainder of the section, you can use the following example loan: You take out a $100,000 home loan. You have 30 years to pay it off at 4.5% annual interest rate.
2 Write the principal in as a negative number. You need to tell Excel that you're paying a debt. To to so, write the principal with a negative number, without the $ sign. 100,000 = Principal
3 Determine the number of payments you're making. You can leave it in years, if you want, but your answer would spit out yearly interest payments, not monthly. Since most loans are paid monthly, simply multiple the number of years by 12 to get your total number of payments. Write this down in another box. 100,000 = Principal 360 = Number of Payments
4 Convert your interest rate to fit the number of payments. In this example, your interest rate is annual, meaning it is calculated at the end of the year. However, you're paying monthly, meaning you need to know what your monthly interest rate is. Since 4.5% is for 12months of interest, simply divide by 12 to get one month's worth of interest. Be sure to convert the percentage to a decimal when you're done.
5 Use the =PMT function to determine interest payments. Excel already knows the equation for calculating monthly payments, with interest. You just have to give it the information it needs to make the calculation. Click on an empty box, then ;locate the function bar. It is located right above the spreadsheet and labeled "fx." Click inside of it and write "=PMT(" Do not include the quotation marks. If you're Excel savvy, you can set up Excel to accept the
6 Enter the inputs in the correct order. Place the values needed to calculate the payment in the parenthesis, separated by commas. In this case, you'll enter (Interest rate,number of periods,principal ,0). Using the example above, the full entry should read: "=PMT(0.00375,360,100000,0)" The last number is a zero. The zero indicates you will have a balance of $0 at the end of your 360 payments. Make sure you remember to close the parenthesis off.
7 Press enter to get your monthly payment. If you've entered the function correctly, you should see your total monthly payment in =PMT cell of the spreadsheet. In this case, you'll see the number $506.69. That will be your monthly payment. If you see "#NUM!" or some other output that doesn't make sense to you in cell, you've entered something incorrectly. Double check the text in the function bar and try again.
8 Figure out the total payment amount by multiplying by your number of payments. To figure out the total amount you will pay over the life of your loan, all you have to do is multiply the payment amount by the total number of payments. In the example, you'd multiply $506.69 by 360 to get $182,408. This is the total amount you'll pay over the loan's term.
（EDIT：admin） 

New~ IndusInd Bank Raises a $225 Mill
WASHINGTON – The Overseas Private Investment Corp...[More] 
New~ A relief from paying multiple De
Debt consolidation loan process is that it will not...[More] 
A short term loan is a form of financing that is at...[More]

2017~ Gramor Development, Inc. Secure
Gramor Development, Inc. announced today that it ha...[More] 
News~ Commercial loan risk rises on H
The agency reviewed the impact of a persistent oil ...[More] 
The loan payment formula is used to calculate the p...[More]

How to Find a Good Home Loan Broker i
For a lot of people, investing in a New home is one...[More]
 2017~ Federal student loans are a
 2017~ 3 Ways to Calculate Interes
 News~ RLPC: Formula One prices lo
 Lithuanian households spend less
 News~ SBI’s QIP issue opens as
 News~ Unsecured Loan Alternative
 Calculate Mortgage Payments with
 New~ Using Collateral to Obtain a
 Lowinterest emergency physical l
 New~ Crew Cuts: Martinez familiar