How to Create a Loan Amoritization Schedule in Excel. Microsoft Excel allows you to either create a spreadsheet from scratch with your own formulas or use a premade template provided by Microsoft.

Start Microsoft Excel. Click in the first cell on the worksheet, A1, and type the business name and "Sales Budget," such as "Janofsky Wood Company, 2012 Sales Budget." ...