This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. We'll be showing you how to build a full loan amortization schedule from scratch in google sheets you can easily use microsoft excel too.Use our amortization calculator, type in a dollar figure under "Loan amount. Amortization is an accounting technique used to periodically lower the book value of a loan or intangible asset over a set period of time. This amortization calculator returns monthly payment amounts as well as displays a schedule, graph, and pie chart breakdown of an amortized loan. The Innovative CPA Group has built a library of FREE Excel tools and calculators for you to use, including a Loan Amortization schedule! In this lesson we'll learn how to calculate the number of periods for a loan. Make payments anytime, anywhere. The mortgage payoff calculator helps you find out. This is an example of a payoff letter used in a syndicated loan transaction.