We can use an amortization table, or schedule, prepared using Microsoft Excel or other financial software, to show the loan balance for the duration of the loan. An amortization table calculates the allocation of interest and principal for each payment and is used by accountants to make journal entries. The effective interest rate method is...Read More