Enter a Bond Issue Where Debt ID Is the Issue
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.