To create a Bond Setup (BONDS) transaction in order to create a new bond authorization where each Debt ID within the authorization is a bond issue, perform these steps:
Create an instance of the BONDS transaction.
Complete the Authorization tab where a row will already be inserted for you and complete it with information for your bond authorization.
Authorization Debt ID, Authorization Name, Authorization Short Name, Authorization Date, Authorization Start, Authorized Amount, and Minimum Denomination: (enter information as needed to match the bond authorization)
Authorization Status: Ready to Exercise.
Debt Type: Coupon Bond
Navigate to the Authorization COA tab where a blank row will already be inserted for you. (This task assumes a Bond Authorization Event Type is entered for your Coupon Bond code selected from the Debt Type page.)
Percentage: 100%
COA: Fund and possibly Sub Fund code setup to track the authorization.
Navigate to the Debt Instrument tab, use the Insert Line action and enter the following:
Debt ID, Debt Instrument Name, Debt Instrument Short Name, Issue Date, Principal, Number of Bonds Issued, and Denomination: (enter information as needed to match the bond issue).
Debt Instrument Status: Active Bond
Use the Save action to save the Debt Instrument data, which will infer the Debt Type from the Authorization and create a record on all the remaining transaction tabs that are required for a bond.
Navigate to the Paying Agent/Lender Information tab.
Vendor Code: (enter or choose that of the paying agent).
Navigate to the Bond Proceeds/Lender COA tab and create the following 3 records (copy and paste, if preferred):
Record 1
Type of Payment: Principal
Percentage: 100%
COA: Enter the Fund responsible for the debt
Record 2
Type of Payment: Interest
Percentage: 100%
COA: Enter the Fund responsible for the debt
Record 3
Type of Payment: Other Amount 1 (discount)
Percentage: 100%
COA: Enter the Fund responsible for the debt
Skip the Borrower Information tab, navigate to the Bond Payment/borrower COA tab and enter the following:
Type of Payment: Principal
Percentage: 100%
COA: Enter the Debt Service Fund and other COA necessary for payments of interest and principal.
Navigate to the Schedule tab and enter the following:
Schedule Type: Principal in Last Payment w/Rate Interest
Selected Schedule: true.
Interest Rate: (the annual rate for the issue)
Frequency: Semi Annual
Maturity Date: (date of last CUSIP to mature)
Payment Month and Date of Month: (values stated in the issue)
Amortization Frequency: Yearly
Number of Amortizations: (number of years from issue to maturity)
Amortization Month: June
Amortization Date of Month: 30th
Other Amount 1: total discount on the issue.
Schedule Generation Action 1: Amortize -Constant Yield
Take the Calculate YTM action.
Take the Get Template action.
Complete the template with each payment for all CUSIPs in the issue along with an amortization of discount at the end of each year using the calculated YTM.
Attach the template to the schedule record.
Import File: (use the pick to select your attachment)
Take the Generate Schedule action.
Validate the transaction.
If errors exist, fix the errors and repeat Step 9. If no errors exist, continue with Step 11.
Submit the transaction.