Q:
# How do you calculate a commercial loan amortization schedule?

**To calculate a commercial loan amortization schedule, draw a four-column table, and label them payment amount, interest paid, principal paid and remaining loan balance, notes the Houston Chronicle.** Calculate and insert the appropriate amounts in the respective columns.

A business may take a loan and pay it off over a specified term in equal amounts or installments, according to the Houston Chronicle. The amortization schedule shows the payment breakdown, which includes the principal and interest to be paid. Decide the total number of installments, the term you are to pay back the loan and the interest rate, according to SF Gate. If you don't have the beginning amount to be paid, use the standard formula to calculate it.

To get the interest rate, multiply the original loan amount by the specified interest rate, notes the Houston Chronicle. If the beginning balance is $100 and the interest rate is 10 percent, then the interest to be paid is in the first year is $10. Subtract the interest from the payment value to get the principal. If the amount to be paid per year in the above example is $15, then the principal equals $15 minus $10 to get $5, which is the principal.

To get the first remaining balance, subtract the principal from the original loan amount, notes the Houston Chronicle. For example, $100 minus $5 equals $95, which is the remaining balance and also the opening balance for the succeeding period. Repeat the process until the remaining balance drops to zero.

Learn more about Financial Calculations-
Q:
## What information is on an amortization chart?

A: An amortization chart contains information on the monthly payment of a loan, including how much of the monthly payment goes towards interest and how much g... Full Answer >Filed Under: -
Q:
## How do you create an auto loan amortization spreadsheet in Excel?

A: Use Excel's PMT function to calculate individual payments, determine the interest and principal components of each payment, and then set an amortization sc... Full Answer >Filed Under: -
Q:
## Is a mortgage payment calculator the same as amortization?

A: A mortgage calculator is also known as an amortization schedule calculator that assists borrowers to estimate monthly home loan payments, according to Well... Full Answer >Filed Under: -
Q:
## Where can you find an amortization table for a loan?

A: Financial and banking websites often provide customizable loan amortization table apps, such as the one at Bankrate. Other sites that offer such apps inclu... Full Answer >Filed Under: