[EM] EM Loan Amortization / Notes Payable

Created by Spencer Ross, Modified on Wed, 29 Jan at 2:17 PM by Anya Erkstam

Open the Amortization Workbook in the company's "Equipment" folder
Open the "Notes Payable" sheet in the GL Recon workbook
Enter the "Ending Balance" value in the row matching the previous month
Repeat for all GLs in the Note Payable sheet
In the grid at the bottom, there are three columns to edit
1. Total Principal Payments
  - Sum the Principal column from first month to previous month
2. Payments Remaining
  - Decrease the values in this column by 1
3. Current Portion of LTD
  - Sum the Principal column from current month through the next six months