This finance video tutorial explains how to create an amortization table in excel. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.Step 1: Set up your amortization table. Open a new Excel sheet and create input cells for the known components of your loan. • A complete copy of the federal return. The FTB will accept the federal Schedule M-3. For more information, visit SBCountyElections. Diego, San Bernardino, Ventura, and Kern Counties. The. The SCAG region encompasses six counties (Imperial,. Los Angeles, Orange, Riverside, San Bernardino, and Ventura) and 191 cities.