Work with Investments (Add, Edit, View)

Description

Displays the Corp ID.

Use the lookup to access a list of Investment IDs from which to select.

Enter the two-character code to indicate the type of investment. Click the lookup button to see a list of your credit union’s configured codes.

SEE ALSO: Configuring Investment Type Codes

Enter up to 30 characters to describe this investment.

Use this field to enter the FDIC insurance code of a specific investment.

Use this field to enter the CUSIP account number of a specific investment.

This field shows the original principal of the investment.

This field shows the Original Par less any principal paydowns.

Use the lookup to access configured FASB code to further identify the type of investment. Investments can be listed separately by FASB code on various reports.

SEE ALSO: Configuring FASB Codes

Check this box if the investment is pledged.

Use this field to enter the information of the entity to which the investment is pledged.

Enter the total number of units purchased. This figure might represent number of dollars, “blocks” of value (e.g., 1 block = $100,000), shares of stock, etc. The field will store quantities up to 99,999,999. This figure is multiplied by the Curr Unit Price to calculate the market value for this investment.

• For example, if this investment was a single $100,000 certificate, this field would be set to 1 and the Curr Unit Price would be entered as 100,000.00000. If this investment represented 100,000 shares of stock at $10.25 each, this field would be set to 100,000 and the Curr Unit Price would be 10.25000.

Enter the price paid per unit for this investment. This field has 5 decimal positions and will store amounts up to $9,999,999.99999. This figure is multiplied by the # of Units to calculate the market value for this investment.

• For example, if this investment was a single $100,000 certificate, the No of Units field would be entered as 1 and this field would set to 100,000.00000. If this investment represented 100,000 shares of stock at $10.25 each, the No. of Units would be entered as 100,000 and this field would be set to 10.25000.

Enter the price that was actually paid when this investment was purchased. This field has 5 decimal positions and will store amounts up to $9,999,999.99999. This field is informational only and is not used by any other process.

• This may be the same as the Current Unit Price when the investment is first created, but while Current Unit Price can be changed to reflect market conditions, this figure represents a permanent record of the price initially paid.

Use the pencil icon to access the Coupon Reset Date screens to either add, or edit the information. A checkmark will appear if a coupon reset rate record already exists. Coupon dates and rates are for informational purposes only.

Enter the Vendor ID for the company that will serve as the primary contact for this investment. Click the lookup button 3 to see a list of your credit union’s configured vendor codes.

• NOTE: This could be the same ID as the broker, institution, or safekeeper, or be any other organization that will be your main contact for questions and information about this investment.

• This selection will automatically fill the contact information that has been configured for this vendor ID.

• Note:  Vendor ID’s are configured here.  The Contact, Institution, Safekeep and Broker fields all pull from the same Investment Vendor Configuration.

• Note:  Vendor ID’s are configured here.  The Contact, Institution, Safekeep and Broker fields all pull from the same Investment Vendor Configuration.

• Note:  Vendor ID’s are configured here.  The Contact, Institution, Safekeep and Broker fields all pull from the same Investment Vendor Configuration.

• Note:  Vendor ID’s are configured here.  The Contact, Institution, Safekeep and Broker fields all pull from the same Investment Vendor Configuration.

This field shows the last date on which income was accrued for this investment. This can be the current date, or a date in the past or future depending on the status of the investment when it is set up. (The date cannot be more than 30 days before the Purchase Date.)

• A past date can also be entered, and the first time accruals are run the system will “catch up” the outstanding accrual amount starting at that date.  For example, say you purchase an investment on April 20 and enter the item into CU*BASE on the 23rd. If you enter April 20 here, when you run accruals for April the system will accrue from the 20th through the 30th to catch up that partial month for this particular item.  From that point forward this item will accrue full months like other items.

Enter one of the following codes to indicate how income accruals should be calculated for this investment:

Based on 365 days (365): Income will be calculated using the following formula:

Coupon Rate / 365 x Principal Value x No. of days since Last Accrued Date

Based on 360 days, daily accrual (36D): Income will be calculated using the following formula:
Coupon Rate / 360 x Principal Value x No. of days since Last Accrued Date

Based on 360 days, monthly accrual (36M): Income will be calculated using the following formula:
Coupon Rate / 360 x Principal Value x 30 days

• IMPORTANT: Investments with this calculation type will always accrue a full 30 days of income, even if the accrual is run more than once during the same month. Extra care should be taken when running accruals for investments with this calc. type.

Based on 366 days (366): Income will be calculated using the following formula:

Coupon Rate / 366 x Principal Value x No. of days since Last Accrued Date

Based on a fixed rate (FIX) - The accrual amount will be the same each time it is processed, using the amount shown in the Amount field described below.

No accrual (NO) - No income will be calculated for this investment.

Choose Discount if this investment was purchased at a discount, or Premium if it was purchased at a premium. Be sure to enter the discount or premium amount in the monthly amount field.

SEE ALSO: Understanding CU*BASE Discount and Premium Accounting

If this investment was purchased at a discount or premium, enter the monthly accretion amount here. This amount will be used during the accrual calculation and posting process to post the monthly accretion to either the discount or premium subsidiary account.

• NOTE: Your credit union’s investment manager is responsible for calculating the monthly amount recorded here. If the amount changes at some point down the road, adjustments can be made by changing the monthly amount recorded here, or by making adjusting entries to the specific subsidiary ledger.

This field can be used to “tag” this investment with a configured Variable Rate Code so that its rate can be changed in a batch with other similar investments. The initial rate for this investment should still be entered into the Coupon Rate field in the Investment/Maturity section of this screen.

SEE ALSO: Configuring Investment Variable Rate Codes

This field is used to enter the date on which the rate was last changed via the Variable Rate update system. For a new investment, this is usually entered as the current date.

SEE ALSO: Updating Investments with Variable Rate Codes

This field appears only when adding an investment. Use the lookup to select a GL code and automatically default G/L selections on the investment record.

These fields show the G/L associated with each of the subsidiary items for this investment.  

Subsidiary Detail (shown when editing or viewing an investment)

These fields show the current balance for each of the subsidiary items for this investment. To see detailed transaction history for any of these items, or to edit transactions for each item, select the View button to access the Investment Transactions screen.  

This field shows the Market Value for each investment, calculated as follows:

Current Unit Price x Number of Units

This could represent 1 unit with a single sum cash value (1 unit @ $100,000), or multiple units (123,050 units @ 1.01250, for a market value of $124,588.13).

This field shows the current Book Value for each investment, calculated as follows:

Principal Value + Premiums (or - Discounts)

For example:

Principal Value of $100,000 with a $15,000 premium = $115,000 Book Value

Principal Value of $100,000 with a $15,000 discount = $85,000 Book Value

This field shows the reserves required if the investment was to be sold as of the Quote Date, calculated as follows:

Market Value - Book Value

This field shows the net amount of income earned year-to-date on this investment. This is calculated by adding the net results of all debits and credits to the income subsidiary ledger.

• IMPORTANT: Remember that this figure will be accurate for the current year only if YTD income was reset for the previous year.

 When editing an investment, use the button Unlock YTD Income to adjust the income as needed.

A field calculating the remaining days until the investment reaches maturity.

Description

Select this button to view any investment comments.

After completing your edits to the investment in the CHANGE screen, use this button to save your work.

This button will allow you to view broker information, as well as edit and update existing broker records. To update the current investment record with any new broker information, re-select the Contact for the broker and use Add/Update.

Viewed when adding an investment, this button will bring you to the Investment GL Codes tool to update, add, or delete any GL Code information.

When editing an investment, use this button to unlock the YTD Income Earned field to make any necessary adjustments on the investment record.