What are the limitations of the Loan Amortization Worksheet?

Andrew Skujins -

This worksheet is primarily driven by the total number of payments, and will provide uniform results in virtually all situations.

Due to the extreme diversity of finance options available, calculated results may not agree to lender schedules in exceptional cases, such as when irregular year lengths are used, special amortization policies apply, or other considerations arise beyond the scope of ordinary use.

Use of irregular dates (e.g. February 29) may also cause unexpected results.

Have more questions? Submit a request


Please sign in to leave a comment.