Enter the number of payments which will be used to calculate the periodic payment due - in this case, 30-years or 360 monthly payments. However, the portion of the payment that is principal or interest will change. Let's say that a company has developed a software solution to be used internally to better manage its inventory. The principal is the current loan amount. Explore the best credit cards in every category as of December 2020. Then apply step 2. Calculate the principal amount for month two: (\$100,000 principal - \$99.55 principal payment = \$99,900.45). Amortization Calculator; Amortization Formula in Excel (With Excel Template) Amortization Formula. You will mostly be paying off the interest when you start making payments, and then your payments will start to go to the balance. Or, simply learn more about loan amortization. This loan calculator - also known as an amortization schedule calculator - lets you estimate your monthly loan repayments. We can calculate loan amortization in Excel using formulas. Jill Newman is a Certified Public Accountant (CPA) in Ohio with over 20 years of accounting experience. Research source. However, a mortgage is like an amortized loan in which you can pay your debt over a period of time in installment. Compute the interest for month two: (\$99,900.45 principal X 0.005 = \$499.50). This image may not be used by other entities without the express written consent of wikiHow, Inc.
\n<\/p>

\n<\/p><\/div>"}, Computing Amortization for the Entire Loan’s Term, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Calculate-Amortization-Step-7-Version-5.jpg\/v4-460px-Calculate-Amortization-Step-7-Version-5.jpg","bigUrl":"\/images\/thumb\/f\/fb\/Calculate-Amortization-Step-7-Version-5.jpg\/aid1169310-v4-728px-Calculate-Amortization-Step-7-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

\n<\/p>

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Calculate-Amortization-Step-5-Version-5.jpg\/v4-460px-Calculate-Amortization-Step-5-Version-5.jpg","bigUrl":"\/images\/thumb\/9\/9d\/Calculate-Amortization-Step-5-Version-5.jpg\/aid1169310-v4-728px-Calculate-Amortization-Step-5-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

\u00a9 2020 wikiHow, Inc. All rights reserved. Sometimes, when you're looking at taking out a loan, all you know is how much you want to borrow and what the rate will be. wikiHow is where trusted research and expert knowledge come together. But the information on an amortization schedule is crucial to understanding the ins and outs of your loan. Experiment with other loan calculators, or explore hundreds of other calculators addressing topics such as math, fitness, health, and many more. Calculating First Month’s Interest and Principal, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Calculate-Amortization-Step-1-Version-5.jpg\/v4-460px-Calculate-Amortization-Step-1-Version-5.jpg","bigUrl":"\/images\/thumb\/6\/69\/Calculate-Amortization-Step-1-Version-5.jpg\/aid1169310-v4-728px-Calculate-Amortization-Step-1-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"