APL |
APL Gain Loss Trade Modeling (GLTM) |
APL > APL Documentation > Reference Materials > APL Gain Loss Trade Modeling (GLTM)
APL Gain Loss Trade Modeling (GLTM)
Tip: An Adobe AcrobatTM formatted version of this document (PDF) materials are available for sharing with your customer.
Getting Started
| Report Function Keys | |
|---|---|
| B | Move to the bottom of a report. |
| T | Move to the top of a report. |
| S | Search for a pattern in a report. |
| N | Search for the next occurrence of a pattern. |
| P | Print a full report. |
| E | E-mail a report. |
| F | Fax a report (requires special set up). |
| D | Download a report. |
| (ESC) | Return to previous screen. |
Certain function keys are not accessible in some screens. Refer to the menu bar at the bottom of the screen or in the upper right hand corner for the valid function keys.
| F1 | Screen Specific Help. |
| F3 or ESC | Go back one screen. |
| F7 |
Depending on the screen, this will display a list of accounts at the Account Selection prompt. or Change the template on the Trade Results screen. |
| F8 | Edit, delete or create templates. |
| F9 |
Depending on the screen, this will cycle through the available fields. or Access failed mail from the Trade Results screen. |
| F10 | Save file or execute command. |
| F12 | Toggle Header. |
| Sell Codes | |
|---|---|
| FIFO | First in, first out. Sorts tax lots by purchase date. |
| LIFO | Last in, first out. Sorts tax lots in reverse purchase date order. |
| Min Tax | Sorts tax lots in ascending order of tax liability / unit, regardless of tax term. |
| Max Tax | Sorts tax lots in descending order of tax liability / unit, regardless of tax term. |
| High Cost | Sorts tax lots in descending order of unit price (price per share), regardless of tax term. |
| Average Cost | Liquidates equal pieces of all tax lots. |
Trade Transaction Reports
| ACTIVITY | All trades sorted by account. |
| BWTX | Tax-lot level holding report. |
| COMMSUMM | Total commissions for all brokers for specified accounts, as of a specific date. |
| TRANPEN | Displays purchases, sells, contributions, and withdrawals. |
| TRANALL | Displays purchases, sells and maturations, reorgs, receipts, and disbursements. |
| TRANLET | Purchase and sells, including trade and settlement information. |
| QKGNL | Quick gain / loss report. |
| REALGAIN | Capital gain according to tax consequences. |
| Gain/Loss Reports | |
|---|---|
| SKED | Realized gains and losses with net and gross proceeds. |
| SKEDOLD | Short and long-term realized gains and losses. |
| REVIEWTOT | Gains and losses by security, including income. |
GLTM
| GLTM Terms | |
|---|---|
| Gain | Current market value greater than purchase price. |
| Loss | Current market value less than purchase price. |
| Unrealized Gain / Loss | The difference between the purchase price and current market value of a capital asset. |
| Realized Gain / Loss | The difference between the purchase price and selling price, less transaction costs of a sold capital asset. |
| Holding Period | The time an investor holds an asset before disposing of it. |
| Long Term | Holding period of longer than 1 year. |
| Short Term | Holding period of 1 year or less. |
| Effective Tax Rate | The tax rate applied to a gain if the asset were liquidated. This is the sum of Federal and State tax rates by tax term. |
| Tax Liability | The dollar amount of taxed owed on a realized gain. |
| After Tax Market Value | Market value of a tax lot discounted for prospective taxes owed on a realized gain. |
| Short Term Rollover | Number of days before a short term tax lot changes to long-term. This uses an actual day count method and applies the IRS definition of a “month.” |
| Wash Sale |
Prevents an investor from declaring a loss under two circumstances. The rules are:
|
| GLTM Abbreviations | |
|---|---|
| EQ | Equal to. |
| GT | Greater Than. |
| GTE | Greater Than or Equal To. |
| LT | Less Than. |
| LTE | Less Than or Equal To. |
| MV | Market Value. |
| PCOST | Purchase Cost. |
| PDATE | Purchase Date. |
| ST or S | Short Term. Abbreviation “S XYZ” in the Tax Term column shows short term and XYZ = the number of days until the short-term lot rolls over to a long-term holding. |
| MT or M | Medium Term. Not currently applicable. (Points Directly to Long Term). |
| LT or L | Long Term. |
| GLTM Calculations | |
|---|---|
| % of Portfolio | Tax lot MV/WTOTAL. |
| Realized Gain / Loss | Sale Price Less - (transaction costs) - Purchase Price. |
| % Gain or Loss | MV tax lot / PCOST tax lot. |
| Tax Liability | (MV tax lot—PCOST tax lot) X Effective Tax Rate. |
| Tax Liability Per Unit | Tax Liability / # of units. |
| After Tax Price | Closing Price — Tax liability per share. |
| After Tax Market Value | After Tax Price X Number of shares. |
| Trade Creation | |
|---|---|
| SAMS | Trade multiple securities in a single account. |
| MASS | Trade a single security across multiple accounts. |
| Failure Reasons | |
|---|---|
| Not Owned | Account does not own a security. |
| None exists |
There are not enough tax lots to satisfy Gains or Losses only; or There are not enough tax lots to meet the tax term criteria. |
| Purchase Date failure | No tax lots owned in the purchase date range. |
| Term Rollover | Tax lots rolling over from short to long term in specified number of days. |
| Wash Sale | A purchase or sale that triggers a tax lot violation. |
| Cost failure | No tax lots in specified cost range. |
| Percent Gain / Loss failure | No tax lots in specified gain or loss range. |
| Tax Liability failure | No tax lots in specified tax liability range. |
| Outside Objective | Will not violate specified criteria. |
| General Restrictions | This product allows the user to restrict by gain, loss or gain / loss profiles or by tax term or gross. |
Trade Order Management (using Block Status)
| Show Detail | Display allocation within each block and summarize by security or broker. |
| Edit |
Modify a block of trades. Options include:
|
| Delete | Delete an entire block of trades. |
| Combine Blocks | Combine blocks of trades. |
| Append Rebal Trades | Run the Cash Rebalancer and append the resulting trades to an existing block. |
| Create Empty Block | Create an empty block for manual trade entry. |
| Separate Block | Break one block into several blocks by designated broker code. |
| Extract Trades | Extract trades from a block and include in a separate block. |
| Change Block Status | Make a market order good-till-cancelled and vice versa. |
Trade Execution Management (using Block Status)
| Commit | Commit a block of trades. |
| Multiple Commit | Commit multiple blocks of trades. |
| Uncommit | Uncommit a block of trades. |
| Execute Trades | After a block has been committed, price the trade for posting. |
| Full Execution | Execute several trades in a block at one time. |
| Quasi Execution | Execute trades in a block on an account by account basis. |
| Unexecute | Reverse one or all executions in a block. |
| Execution Detail | Display allocation detail for a block. |
| Execution Report | Display trade allocation ticket sorted by broker or trade type. |
| Effects of Block | Show before and after view of accounts. |
| BLTSUM | Print hard copy report showing trades separated by security, price, broker, or trade date. |