Enter a Bond Issue Where Debt ID's Are CUSIPs
To create a Bond Setup (BONDS) and several BONDM transactions in order to create a structure where the authorization is the bond issue and each Debt ID is a CUSIP:
-
Create an instance of a BONDS Transaction.
-
Navigate to the Authorization tab where a row will already be inserted and enter the following:
-
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 issue).
-
Authorization Status: Ready to Exercise
-
Debt Type: Coupon Bond
-
Navigate to the Authorization COA tab where a row will already be inserted and enter the following. (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 issue
-
Validate the transaction.
-
If errors exist, fix the errors and repeat Step 4. If no errors exist, continue with step 6.
-
Submit the transaction.
-
Create an instance of the BONDM transaction, navigate to the Authorization tab, enter the Authorization ID from the previous BONDS, and use the Auto Apply action.
-
Navigate to the Debt Instrument tab, insert a line and enter the following:
-
Debt ID, Debt Instrument Name, Debt Instrument Short Name Principal, Number of Bonds Issued, and Denomination: (enter information as needed to match the CUSIP)
-
Issue Date: (enter date of the bond issue)
-
Principal: (Amount of principal for the CUSIP)
-
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 you like):
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 Browser 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 CUSIP principal payment)
-
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 * (CUSIP Principal / Total Issue Principal)
-
Schedule Generation Action 1: Amortize – Constant Yield
-
Take the Calculate YTM action
-
Take the Generate Schedule action
-
Validate the transaction
-
If errors exist, fix the errors and repeat Step 13. If no errors exist, continue with Step 15.
-
Submit the transaction
-
Copy that BONDM to create a separate transaction instance for each CUSIP changing only the following fields to match that of each CUSIP.
-
Debt Instrument: Debt ID, Debt Instrument Name, Debt Instrument Short Name, Principal and Number of Bonds.
-
Schedule: Principal, Maturity Date, Other Amount 1
-
Take the Generate Schedule action.
-
Validate the transaction.
-
If errors exist, fix the errors and repeat Step 18. If no errors exist, continue with Step 20.
-
Submit the transaction.