Bonds Payable Rollforward

This template tests bond activity and related interest accounts by rolling the balances forward from the previous year.
The user must select the source of data for the current year activity. The current year payment information can be entered every year, or it can be pulled in from the applicable debt amortization schedules that were previously loaded into the worksheet. Upon selecting the Use Amortization Table option, an amortization schedule worksheet is created that stores the amortization schedules for ten bond issuances. The user can test and load the required amortization information into the schedule for the life of the bond during the year of issuance so that the workbook can automatically pull in the proper information in future years.
The Disclosure worksheet summarizes debt service requirements in accordance with GASB Statement No. 38.