Patent Application
20250131507
A portion of the disclosure of this patent document contains material that is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the Patent and Trademark Office patent files or records, but otherwise reserves all copyrights whatsoever.
The present disclosure relates generally to the processing of financial securities and instruments and, more particularly, in some embodiments, to a computer-based system and method, as well as to at least one computer-readable medium, for facilitating optimization of a portfolio of tax-lots by determining and recommending the best sequence and combination of tax-lots to sell.
Generally, the American financial services industry has not introduced any major improvements in the management of taxable equity portfolios for over two decades. It still relies largely on the goals and metrics of success offered by the traditional tax efficiency approach of minimizing taxes in a year. While the present inventor has previously developed and patented a computerized system and method that does not apply such a traditional tax efficiency approach and that optimizes after-tax proceeds for individual tax lots, accurately determining the after-tax value an individual could expect to have at the end of a holding period for each of a set of investment strategies associated with a particular lot of stock held (representing a major improvement in taxable equity management), there remains a need for further improvements in portfolio management.
Aspects, features, and advantages of some embodiments of the invention, both as to structure and operation, will be understood and will become more readily apparent in view of the following description of non limiting and non exclusive embodiments in conjunction with the accompanying drawings, in which like reference numerals designate the same or similar parts throughout the various figures, and wherein:
Throughout the description and claims, the following terms take at least the meanings explicitly associated herein, unless the context dictates otherwise. The meanings identified below do not necessarily limit the terms, but merely provide illustrative examples for the terms. The phrase “an embodiment” as used herein does not necessarily refer to the same embodiment, though it may. In addition, the meaning of “a,” “an,” and “the” include plural references; thus, for example, “an embodiment” is not limited to a single embodiment but refers to one or more embodiments. Similarly, the phrase “one embodiment” does not necessarily refer the same embodiment and is not limited to a single embodiment. As used herein, the term “or” is an inclusive “or” operator, and is equivalent to the term “and/or,” unless the context clearly dictates otherwise. The term “based on” is not exclusive and allows for being based on additional factors not described, unless the context clearly dictates otherwise. In addition, as used herein, unless the context clearly dictates otherwise, the term “coupled” refers to directly connected or to indirectly connected through one or more intermediate components
Some embodiments of the present invention relate to what is referred to herein as the Efficient Tax Portfolio Optimizer (ETPO), which may be embodied as a computerized system, computer-implemented method, and/or computer-readable medium. However embodied, ETPO represents and/or provides, among other things and in some respects, a complex set of structured computer-implemented mathematical calculations according to methods that empower investment decision makers to harmonize and synergize the selling of individual tax-lots, in a sequence, across an entire portfolio of taxable equity security tax-lots, doing so in a manner that achieves the maximization or optimization of after-tax wealth over a specified time horizon. And, as will be further understood from the ensuing disclosure, ETPO provides for such maximization or optimization by principally, but not limited to, identifying, recommending, and/or simulating a combination of (i) selling first those tax-lots, in descending sequence, that by doing so would generate the greatest excess after-tax returns, or alpha, (i.e., recommending (i) first selling the tax-lot whose sale would generate the greatest after-tax return, or alpha and (ii) next selling the tax-lot whose sale would generate the greatest after-tax return, assuming the first-recommended tax-lot with the greatest alpha were sold, etc., until none of the remaining or residual tax lots provide positive alpha, and (ii) then, if additional sales are desired, selling in a manner that gives up the least opportunity cost of doing so by selling first, in ascending order, those tax-lots with the least after-tax return potential remaining (i.e., recommending (i) first selling the tax-lot with the least after-tax return potential remaining, and (ii) next selling the tax-lot with the least after-tax return potential remaining, assuming the first-recommended tax-lot with the least after-tax return potential remaining were sold, etc., for all remaining tax-lots under consideration).
In accordance with some embodiments, tax-lot analysis providing resulting values representing, among other metrics, the after-tax return, or alpha, and the after-tax return potential upon which some embodiments of the present invention are based is disclosed in the present inventor's U.S. Pat. Nos. 6,115,697, 7,047,217, and 7,343,336 (“the prior patents”), each of which is hereby incorporated by reference herein in its entirety. As disclosed in detail in the prior patents, such output values are based upon expected after-tax returns resulting from comparing current tax-lot after-tax values against future expected after-tax values, considerate of expectations such as price target projections or forecasts over time. The aforementioned resulting values from the prior patents include the “After-Tax Annual Average Recommendation Advantage” (ATAAR) and the “Existing Tax-Lot After-Tax IRR” (ETLATIRR).
In accordance with some embodiments, the Existing Tax-Lot After-Tax IRR is the calculated compound after-tax Internal Rate of Return (IRR) amount generated by comparing the current after-tax value of an owned individual tax-lot (assuming any imbedded and deferred tax liability were to be paid) with the forecasted net after-tax value of the tax-lot given its future price projection at the end of a chosen investment horizon, along with all other material economic impacts accounted for, such as dividends, and investment costs. The ETLATIRR may be determined as an annual compounding rate, and may be represented as a percentage. By way of example, if the current after-tax value of an existing owned tax lot is $80, and the 3-year (36 month) forecasted net after-tax value of this tax lot is $100, then the ETLATIRR for this tax-lot would be 7.72% (i.e., 100[(100/80)1/3−1)]).
In accordance with some embodiments, After-Tax Annual Average Recommendation Advantage corresponds to so-called Alpha, and represents the advantage that would result from following a recommended investment strategy with respect to a tax-lot (e.g., sell now and reinvest; or sell and reinvest when longterm status is reached) rather than holding the tax lot until the end of the chosen investment horizon. In some embodiments, the After-Tax Annual Recommendation Advantage is set forth as a percentage. For clarity, the name of this metric references what it represents. For instance, it is presented on an After-Tax basis. And it is an “Annual Average” because it specifies the result (percentage advantage) that the investor would achieve on an annual basis, however, it is not an Internal Rate of Return calculation (i.e., it is not a calculation of an average annual compound rate). Rather, it is a simple average of the advantage through the end of the chosen investment horizon; namely, that advantage divided by the number of years until the end of the chosen investment horizon.
For example, if an investor is projected to have $100 after-tax should they hold a tax-lot for three more years, but would achieve a value at the end of three years of $110 if they waited until the tax-lot were to be held more than 365 days in total (i.e., to achieve long-term tax rate) to sell it and reinvest, the extra $10 of the latter strategy (Sell When Long-Term) versus the Hold $100 comparative value would yield the investor an extra 10% in after-tax wealth accumulation over three years. Dividing the 10% by three years provides a simple annual average of 3.33%, which is the After-Tax Annual Average Recommendation Advantage for this example. That is, according to this example, a $110 after-tax value forecasted to be attained by waiting until the long-term lower tax rate status is achieved before selling and reinvesting, as compared with a hold value of $100, would yield a 10% Alpha, excess return, or an After-Tax Annual Average Recommendation Advantage of 3.333% per year over a three year horizon. In accordance with such embodiments of the ATAARA, a more traditional IRR or compound value is not calculated because the extra value is often not achieved unless the Sell When Long-Term Maximum Strategy is followed, and that deferral makes a traditional IRR calculation problematic.
And finally, the term “Recommendation Advantage” in ATAARA refers to the fact that the Maximum Strategy Recommendation must be followed in order to capture any projected excess return. And, more simply, the term “Recommendation Advantage” refers to the ATAARA being the advantage associated with following the Maximum Strategy Recommendation (other than Holding). If there is no excess return by doing something other than Holding, the ATAARA value will be zero. Said differently, if Holding (to the end of the chosen investment horizon) is the Maximum Strategy Recommendation, then the ATAARA is zero, which is consistent with the Holding strategy after-tax value being the reference against which alpha is measured. In other words, the ATAARA is by definition set to zero if at the end of the chosen investment horizon, Holding would provide a greater after-tax value than any strategy other than holding. And ATAARA is by definition—and by calculation—equal to zero if at the end of the chosen investment horizon, Holding would provide an after-tax value equal to the greatest after-tax value that would be provided by the strategies other than holding.
And, more specifically, the Maximum Strategy Recommendation (also referred to as the “Max Strategy” or the like) is the strategy determined to provide the highest after-tax value from among the potential strategies evaluated. In accordance with some embodiments, an investor principally has three choices they can make that can make a material difference in the long-term after-tax wealth accumulation related to existing capital deployed in an existing tax-lot invested. These choices are the following: (1) Hold the subject tax-lot out to the end of a chosen investment horizon before selling and reinvesting; (2) Sell When Long-Term in the case of a tax-lot held less than the Long-Term tax status term (i.e., one year according to current tax law relating to Capital Gains), and then reinvest the after-tax proceeds, (i.e., wait until Long-Term tax status is achieved before selling and reinvesting); and (3) Sell Now and reinvest. For each tax-lot analyzed, the Max Strategy (Maximum Strategy Recommendation) is the identified highest after-tax strategy value from among these three potential strategies.
As indicated above, and as will be further understood in view of the ensuing disclosure, ETPO according to some embodiments is not driven by reducing, minimizing, deferring, or avoiding taxes, but by maximizing or optimizing the after-tax value of a portfolio by, among other things, determining with respect to each tax lot in a portfolio (or with respect to a subset of multiple tax lots selected by a user from among all the tax lots within the portfolio) what investment strategy to employ—and in what sequence respective tax lot strategies recommending a sale (e.g., Sell Now, Sell When LongTerm) should be executed, as well as in what sequence tax lots recommended to be held should be sold should the investor decide to sell them (e.g., to raise cash)—to provide the greatest after-tax value over a selected investment horizon, considering the effects of selling a given tax lot on all other remaining or residual tax lots.
More specifically, as will be further understood, ETPO applies its fundamental sell discipline over entire portfolios of tax lots, considering (among other things) the impact of each recommended potential tax lot sale on the potential strategy paths of the remaining or residual tax lots, such that ETPO indications or recommendations output by ETPO inform the user of the best sequence and combination of tax-lots to sell for trying to raise cash, and/or for improved portfolio repositioning. While ETPO's goal is not tax avoidance or minimization per se, ETPO can materially enhance after-tax performance over time. By generating a rigorous after-tax sell disciplined ranking of tax-lots to be sold in a sequence across an entire portfolio, ETPO can result in taxes being minimized—but not at the expense of future after-tax returns. In accordance with some embodiments, the recommendation provided by ETPO is (i) to first sell whole or partial tax-lots that when sold, are forecasted to generate the greatest After-Tax Alpha, and (ii) secondly, to sell any remaining tax-lots in the sequence recommended by the ETPO which results in keeping those tax-lots with the greatest after-tax return potential remaining.
For clarity of exposition of an ETPO according to the present disclosure, the ensuing disclosure includes the following sections: (i) a description of some features of the prior patents; (ii) a description of the dependency, or nexus between the present disclosure and prior patents; (iii) a further description of computer-based methods and systems according to some ETPO embodiments of the present disclosure, and (iv) detailed examples described with reference to illustrative screenshots from a reduction to practice of some embodiments of an ETPO according to the present disclosure.
To aid the process of describing some embodiments of the present invention, the following paragraph reproduces a portion of the description set forth in the original one of the prior patents. Then, set forth in concise terms are some aspects of some features that the prior patents disclose and provide, as well as some features that the present inventor recognized can be used and derived therefrom in accordance with the present disclosure, and how therefore certain aspects and features of the prior parents are linked to and embodied in some embodiments of the present invention.
Particularly, a portion of the prior patent reads as follows: “A computerized system and method process financial securities and instruments to accurately determine and optimize the after-tax proceeds an investor could expect to have at the end of a holding period for each of a set of investment strategies and determines an optimal strategy for maximizing such after-tax proceeds. The computerized system and method receive tax and investment data, user-customized investment expectations, and financial adviser-based investment expectations at a processor; perform tax loss harvesting analysis on the user-customized investment expectations and the financial adviser-based investment expectations over a dynamic taxation time range using a predetermined software program; perform comparative pro-forma tax sensitivity analysis of the tax and investment data and the analyzed investment expectations using the predetermined software program; and determine and output an optimal after-tax investment strategy path from a plurality of investment strategy paths over the dynamic taxation time range using the predetermined software program to optimize the after-tax proceeds from the plurality of investment strategies. The predetermined software program may include a spreadsheet program.”
What that means is that the prior patents disclose (among other things) comparing after-tax results (e.g., down to the penny in some implementations) of the material investment choices an investor has in deciding when to sell a taxable investment, pay any associated tax, and reinvest for higher projected after-tax returns. Performing such a comparison facilitates identifying the metric circumstances in which a holder of an individual, or group of tax-lots, would be better off on an after-tax basis, over time, by selling and reinvesting, and by how much better an alternative investment would have to be in order to more than pay for any costs associated with selling a taxable security, including the tax liability. Such comparisons and resulting information are a function or mathematical result of a set of investment facts and performance expectations supplied by the user.
Specifically, the choices, if a capital asset has been held less than 366 days, therefore not qualifying for long-term lower tax rates, are (i) holding a stock out to the end of a specified time horizon, selling and paying any tax due, (ii) selling the investment now, paying any taxes and associated costs, and reinvesting out to the end of the same time horizon, and (iii) waiting until the long-term tax status is achieved, before selling and reinvesting out to the end of the same investment horizon. Whichever strategy path yields the greatest after-tax value is identified in accordance with the methods and systems of the prior patents. For a capital asset (e.g., tax-lot of a security) for which the long-term status is already achieved, the same analysis is done, but without analyzing the third option of waiting until the long-term window is achieved before selling and reinvesting, as it already has been eclipsed.
Included as inputs are things known to the user (e.g., investor, portfolio manager, etc.), such as what was purchased, the price paid, and current realized gain and loss values, along with things that a user thinks (e.g., believes or expects, based on personal knowledge and/or opinions, as well as possible reference to the user's or third party's proprietary algorithms and/or research, etc.), like the future performance expectations for holding a position, including dividend and dividend growth, as well as reinvestment assumptions. The present inventor could have expressly added into the particular disclosed embodiments a strategy path for selling on any day until the long-term horizon would be achieved, but only included in those illustrative embodiments the strategy paths that generally represent material or meaningful change in the economics.
So by way of example, given various inputs, holding an individual tax-lot investment (an amount of shares purchased on a particular day at a particular price, or cost basis rather) having a current after-tax value of $80, might be forecasted to yield an investor $100 after-tax at the end of a three year investment horizon. Alternatively, according to methods and systems disclosed in the prior patents, this investment might be forecasted to provide (i) $105 after-tax if it were sold and reinvested now, and (ii) $110 after-tax if it were sold and after-tax proceeds reinvested once it achieved long-term status. In this example, the highest after-tax value result is, of course, to wait until the long-term tax status is achieved before the tax-lot is to be sold, and any after-tax proceeds reinvested.
From these values, along with other calculations based on the disclosure of the prior patents, the following mathematical results, plus others not listed here, are able to be determined, predominately because of the horizon after-tax strategy path values being calculated:
Based on these outputs, important further outputs for analysis purposes at the individual tax-lot level, which have always been primary outputs of the methods and systems of the prior patents, may be calculated and determined.
And, as has already been stated, such outputs are employed as primary calculation and decision driver inputs in the portfolio optimization methods and systems as implemented by some embodiments of ETPO according to some embodiments of the present disclosure. For instance, as indicated, outputs disclosed in the prior patents that are employed as primary metrics in some ETPO embodiments of the present disclosure include the After-Tax Annual Average Recommendation Advantage value and the Existing Tax-Lot After-Tax IRR. In other words, some embodiments of methods and systems according to the present invention are directly dependent upon the calculation results of the methods, algorithms, and outputs of the prior patents. The ensuing description further elaborates methods and systems according to some embodiments of the present invention, relating to what is referred to herein as the Efficient Tax Portfolio Optimizer (ETPO).
The following sets for the some illustrative goals of some embodiments of ETPO. As will be understood, one or more claims may be directed to methods and systems for providing each of these goals and/or methods and systems comprising combinations of features embodied in ETPO corresponding to these goals. Illustrative goals include, for example, the following:
Based upon these and other chosen inputs, some embodiments of ETPO will identify for an investor, which tax-lots, either individually, or in combination with others, for example ones with unrealized gains and ones with unrealized losses, and in which sequence, if an investor were to sell and reinvest the net after-tax proceeds, they could achieve greater after-tax wealth over time, and how much an investor could expect to achieve on an after-tax wealth accumulation basis, if the assumptions inputted are good predictors of future performance.
And doing so in a manner that generates the greatest Alpha or excess return at the tax-lot and portfolio level, by identifying when, for example in the case of a profitable tax-lot, the relative extra performance potential of an alternative investment versus that remaining from an existing tax-lot, will generate greater after-tax proceeds over a designated time period, because the new investment is forecasted to outperform an existing investment by more than the amount of the tax. And harmonizing and synergizing that process, by updating the realized gain and loss values with the simulated impacts of previously sold tax-lots within a sequence, (an important part of the ETPO methods as those updated realized gain and loss values are important inputs), resulting in the maximizing of the multi-year after-tax wealth accumulation of an investor, through the integration of the individual tax-lot sell discipline applied across an entire portfolio in a way that minimizes taxes, but not at the expense of future after-tax wealth accumulation. And doing so in a manner that keeps the higher forecasted after-tax return potential tax-lots in a portfolio, in order to maximize its future after-tax returns. This reiterative process, when applied to an entire portfolio, is referred to as an optimization “Serial Stream.”
A component of the simulation methods used in the optimization process is to continuously update the projected realized gain and loss values for the investor, impacted by a potential prospective sale or partial sale of tax-lots in a specified sequence, to be used in the determination of additional full or partial tax-lot sales, through the process of Tax Loss Harvesting. In accordance with the illustrative method according to some embodiments of the present invention, being able to run an analysis with one iteration of processing across a portfolio of tax-lots calculating values for the After-Tax Annual Average Recommendation Advantage and the Existing Tax-Lot After-Tax IRR, the key drivers of the sell decision sequencing process, is not sufficient for the Efficient Tax Portfolio Optimizer methods. When all tax-lots for example, are evaluated for which one, if it were sold, would generate the highest After-Tax Annual Average Recommendation Advantage, any subsequent analysis for which tax-lot should be sold next, is dependent upon the resulting values for Realized Gain & Losses from any tax-lot simulated to be sold precedent to it. Therefore in accordance with methods and systems according to some embodiments of the present invention, by way of example, a ten tax-lot portfolio, at a minimum, will have to have all ten tax-lots evaluated and compared in order to determine the most value-added tax-lot to sell first. Once that has been identified, the remaining tax-lots, with an updated realized gain and loss value, will have to be evaluated, in order to identify the best of that group of tax-lots to sell, or rather the second tax-lot in sequence to sell. Then the remaining eight tax-lots will have to be evaluated and compared (with the further updated realized gain and loss value), with the same process repeated until through a process of elimination, all tax-lots, or partial tax-lots have been evaluated and compared for a sale.
Referring now to
In some embodiments, such as that of depicted in
As schematically depicted, inputs to the ETPO processing resource 45 include Tax-Lot Holdings 20, Investor Inputs 22, Portfolio Inputs 24, Stock Performance Expectations 26, and Tax-Lot and Position Sell Designations 28, which are depicted as stored in CRM 25. Based on these inputs, one or more processors 30 executes one or more programs or program modules (e.g., stored in memory resource 35) that may be logically configured as a sequence of five processing module steps 40, 42, 44, 46, 48 to generate ETPO strategy recommendations identifying (among other things) the optimum sequence and combination of tax-lots to sell when tying to raise cash and/or for improved portfolio repositioning. As shown, in step 49, the ETPO tax-lot strategy recommendations are output to user interface resource 55, to thereby inform the user (e.g., investor, portfolio manager,) as to the ETPO strategy recommendations.
ETPO 100 may embody, for example, one or more application programs 30 and/or spreadsheet program 32 (e.g., spreadsheet calculation engine), and further embodies code (e.g., code modules) comprising a reiteration optimization analyzer 34, a tax-lot strategy path analyzer 36, and a tax-loss harvesting analyzer 38, to implement ETPO analysis according to the execution of process module steps 40, 42, 44, 46, 48, and 49. Examples of spreadsheets include commercially available programs such as “EXCEL” or others. A dedicated application program 118 may be implemented in a number of computer programming languages such as “JAVA”, C, C++, APL, COBOL, BASIC or others.
Tax-Lot Strategy Path Analyzer 36, when executed, analyzes individual tax-lots to identify (among other things) the maximal strategy path from among available paths over a time horizon, as described hereinabove. Tax-Loss Harvesting Analyzer 38, when invoked, performs Tax-Loss Harvesting analysis according to, for example, the first and/or second steps of tax harvesting as described hereinabove. And the Reiterative Optimization Analyzer 34, when executed, performs an optimization analysis on multiple tax-lots based on (among other things) the AATAARA and ETLATIRR metrics in accordance with the foregoing disclosure, and as further described hereinbelow. As will be understood, Reiterative Optimization Analyzer 34 may selectively invoke (or may embody) Tax-Lot Strategy Path Analyzer 36 as well as Tax-Loss Harvesting Analyzer 38. And further, in accordance with some embodiments, it will be understood that Reiterative Optimization Analyzer 34 includes code that updates Realized Loss and Gain values for each iteration within the reiteration processing, so that the impact of a proposed/potential sale can be properly accounted for in the subsequent iteration of the reiterative processing, so that an optimum recommended sequence based on descending ATAARA and then ascending ETLATIRR can be determined.
It will be understood that the depicted code modules stored in memory resource 35 is merely illustrative and is non-limiting on the software implementation (e.g., language, programs, code modules, code organization, etc.). For example, in various embodiments, depending on, for example, the software configuration and organization, application program(s) 30 and/or spreadsheet/calculation engine 32 may invoke and/or or embody one or more of reiterative optimization module 34, tax-lot strategy path analyzer 36, and tax-loss harvesting analyzer 38. Similarly, in various embodiments, depending on, for example, the software configuration and organization, reiterative optimization module 34, may invoke and/or or embody tax-lot strategy path analyzer 36, and tax-loss harvesting analyzer 38.
As will be understood by those skilled in the art, the representation of CRM 25 and memory resource 35 as separate blocks does not necessarily mean that these elements are physically distinct (though they may be), or that data and/or code modules depicted therein are necessarily separated into different computer-readable media (though they can be). Similarly, the depiction of CRM 25 as including inputs 20, 22, 24, 26, and 28 does not necessarily mean that all these inputs are stored in the same computer-readable medium, though in some implementations they may be. Memory resource 35 is similarly not limited to a single memory resource component that stores all the depicted code modules 30, 32, 34, 36, and 38. For example, more generally, CRM 25 and memory resource 35 may individually or together be implemented as one or more computer-readable media components, and each of the various data and/or code depicted or otherwise employed in ETPO 100 may be stored on one or more of such one or more computer-readable media. It will be understood, therefore, that the illustrative ETPO 100 shown in
It will further be understood that ETPO 100, as depicted, is not limited to a particular type of system; for example, ETPO 100, as schematically depicted, may be implemented as a standalone or networked personal computing device (e.g., personal computer or workstation, comprising at least the processing resource 45, memory resource 35, and user interface resource 55, etc.), or as a client-server system (e.g., where user interface resource 55 may comprise a computer system executing a client that is remote from processing resource 45, which is implemented on a server). For example, ETPO may be embodied as a networked or distributed system such as an Internet-based application and/or a World Wide Web (WWW)-based application on the Internet and connected components. And other embodiments are also possible such as intranet and extranet applications accessible by the browser 56.
As will be understood by those skilled in the art, each input 20, 22, 24, 26, and 28 represents information (e.g., data) stored in at least one computer-readable medium represented by CRM 25. Various data corresponding to this input may be based on user inputs, public and/or proprietary or third party data feeds, etc. In accordance with some illustrative and non-limiting embodiments, inputs 20, 22, 24, 26, and 28 may comprise the following (
Tax-Lot Holdings 20 comprises the data or information concerning individual tax-lots in a portfolio. A tax-lot is a number of shares purchased on a particular day at a particular price, for a total cost of the tax-lot, or cost basis, including any commission. Shares of the same company purchased on the same day at a different price, or even at the same price on the following day, represent a different tax-lot. A tax-lot generates a taxable event when it is sold. By way of example, via user-selectable functions provided by ETPO's user interface, tax-lots may be uploaded into a portfolio (e.g., stored in CRM 25) from an external file, and/or individual tax-lots may also be created manually.
Investor Inputs 22 comprise facts/information regarding each investor that is pertinent to the tax impacts of selling a security. Investor Inputs 22 include the following.
State of Residency (and State marginal tax rate): In accordance with some embodiments, ETPO accounts for the impact of state taxes impact the economics of each taxable tax-lot. For example, ETPO may store/maintain individual state tax rates available in the public domain, and provide a drop-down menu containing each State's tax rate, as a default option, in order to assist users. Users may edit and save each portfolio's Defaults, via the user interface.
A User may select a State of Residency in the drop-down menu, after-which a defaulted value will appear in the State Marginal Tax Rate field. A User or an Investor may over-write or input their own marginal tax rate value that they may be subject to, over and above Federal tax rates. According to some embodiments, ETPO analysis calculates the aggregate total tax impact on a tax-lot, or series of tax-lots, with the following formula: Total Marginal Short-term Tax Rate=(Federal Short-term Tax Rate)+(1−Federal Short-term Tax Rate)×(State Marginal Tax Rate). As State taxes are deductable for Federal purposes, the formula is repeated, taking proper consideration for long-term marginal tax rates.
Federal Marginal Short-Term Tax Rate and Federal Marginal Long-Term Tax Rate: By way of example, these values may be defaulted as 39.6% and 20.0%, respectively, and user's may modify these defaults via the user interface (e.g., comprising screenshots depicted in
Realized Short-Term Gains/Losses: Accurate entry of these values is important for a proper Efficient Tax Portfolio Optimizer Analysis, such that it provides an optimization that is as accurate as possible, based on accurate values for Short-Term Gains/Losses being required to properly assess and take full advantage of any Tax-Loss Harvesting opportunities. This value should include the value of net Short-Term Gains and Losses year-to-date, plus any net Short-Term Tax-Loss Carry-Forward of previously realized short-term loss values, that have not yet been utilized to offset any gains.
Realized Long-Term Gains/Losses: This value should include the value of net Long-Term Gains and Losses tax-year to-date, plus any net Long-Term Tax-Loss Carry-Forward of previously realized long-term loss values, that have not yet been utilized to offset any gains.
Other Income Offset: Normally, capital losses generated from the sale of a capital asset, a stock for example, cannot offset ordinary income, and reduce ordinary income taxes. But there is an exception. Single tax-payers may offset up to $3,000 of capital losses each year against ordinary income. There are special considerations for married couples, depending upon how they file; for example, a married couple, in aggregate, possibly may be eligible to deduct capital losses against ordinary income, greater than $3,000 between the two of them. ETPO, in an effort to maximize the value of this tax benefit, will preserve the value of a long-term capital loss eligible to reduce ordinary income, by not utilizing its tax savings impact to reduce a lower tax-rated long-term gain; instead saving it for offsetting and reducing ordinary income, and its higher associated tax cost. For many investors, this is not a big item, but in order to be thorough, ETPO, according to some embodiments, includes it.
Portfolio Inputs 24 are those inputs related more particularly to each portfolio. Investor Inputs 22 affect all portfolios that may be owned by a single tax-payer; however, each portfolio may have its own unique characteristics, which are reflected by Portfolio Inputs 24, which may include the following.
Before Tax Reinvestment Rate: A tax cost related to the selling of a taxable security may be recovered by reinvesting any after-tax proceeds in an investment with a better return potential than an existing holding is expected to achieve. The Before Tax Reinvestment Rate is the rate an investor expects to achieve through reinvesting after-tax proceeds from the sale of a taxable security. It is important for this number to be realistic. A too optimistic number may have an investor selling too soon, and being more aggressive with turnover than can be economically justified. Too low a number may result in opportunities to sell and reinvest for higher after-tax returns, being missed. In some embodiments, ETPO provides a default value of 9% as a Before Tax Reinvestment Rate, representing approximately the long-term return history of the U.S. stock market, under normal market conditions. What rate may best apply to a given portfolio under consideration may be affected by things such as asset allocation, investor risk tolerances, and current market valuations.
Annual Portfolio Turnover: If an investor has ten equally valued stock investments, and sells and replaces five of them in a year, then they are generating 50% in Annual Portfolio Turnover; thus, it takes two years to sell and replace an entire portfolio value, with the investor holding onto each position an average of a year. In other words, a 50% or less Annual Portfolio Turnover input will result in Efficient Tax Portfolio Optimizer assuming all reinvested monies will be in positions that are held more than a year. If an investor sells and replaces all ten stocks, they have a 100% Annual Portfolio Turnover. Which assumes all stocks are held less than one year. Therefore the higher an Annual Portfolio Turnover, the higher effective tax rate an investor is likely to be subject to. Efficient Tax Portfolio Optimizer calculates an Effective Tax Rate influenced by portfolio turnover. A 50% Annual Portfolio Turnover is assumed to generate a capital gains tax rate on reinvested assets at the Long-Term Marginal Tax Rate, while a 100% or greater Annual Portfolio Turnover input value will generate an effective tax rate at the Short-Term Marginal Tax Rate. In some embodiments, ETPO calculates a linear relationship between those two values, such as, for example, a 75% Annual Portfolio Turnover will impact an Investor's Effective Tax Rate by being half way between the Marginal Short-Term Tax Rate and the Marginal Long-Term Tax Rate. The higher the Annual Portfolio Turnover inputted within the 50-100% range, the harder it will be to justify a sale.
Investment Horizon Year: In accordance with some implementations, the Investment Horizon Year is an important input for three key reasons. The first is that, the longer time horizon an investor allows themselves to recoup a tax cost and profit from a sale by the prospect of generating after-tax excess return over time through a more promising investment opportunity set, the more likely they are able to justify a sale. A shorter investment horizon will require a higher reinvestment rate of return, in order to recover a tax cost over the time horizon designated. The second reason Investment Horizon Year is important is that stock price forecasting gets more difficult, the longer the horizon, which means a longer investment horizon will generate more Alpha generating opportunities given a reinvestment rate of return, but is more difficult and risky to forecast. And thirdly, when an ETPO analysis is processed, even though in some embodiments each tax-lot evaluated has a three, four, and five year analysis associated with it (which may be depicted to the user in a Graph), only one ranking or sequencing of sale candidates is generated with each Job processed, in accordance with some embodiments. And that ranking or sequencing of sale candidates is governed by the Investment Horizon Year.
Minimum Compound Selling Advantage: Absent the use of this special tool, Efficient Tax Portfolio Optimizer will recommend the selling of a tax-lot whenever there is an advantage to do so in terms of generating an After-tax Annual Average Recommendation Advantage, or Alpha, even just one extra penny. Accordingly, ETPO provides for the opportunity/option to input, in effect, a minimum after-tax annual Alpha value as a minimum criteria for a sale. For example, if an investor inputs a 1% value in this field, Efficient Tax Portfolio Optimizer will artificially raise the end-of-horizon after-tax value for Holding a tax-lot, by 1% per year on a compound basis, making it more difficult for a reinvestment to catch up and beat a Hold decision. Therefore the After-Tax horizon value for a Hold will no longer be an Absolute number an investor could expect to have at the end of a chosen investment horizon, but rather an absolute number adjusted by a relative factor. The remaining values such as the Alpha number (e.g., After-Tax Annual Recommendation Advantage) generated on the Job Results Page, and the Existing Tax-Lot After-Tax IRR values will remain correct, on an absolute basis. But the After-Tax Annual Average Recommendation Advantage percentage value will be adjusted by this input.
Brokerage Cost/Share: If brokerage costs are high, this value will materially impact an Efficient Tax analysis. If they are not, not so much. As many institutional brokerage costs are assessed on a cents per share basis, ETPO provides for inputting the brokerage cost input in that format. An individual investor, or manager who has brokerage impact costs as a flat rate for each trade, such as $8.95 per trade, and on average invests $5,000 per tax lot, (considering that stocks on average, as a result of stock splits, have prices in a distribution around $30 per share), might then input in this value, 5.4 cents. ($5,000/$30)=166.7 average shares per tax-lot. ($8.95/166.7)=5.4. Insofar as brokerage costs are usually not significant, this value generally will not change ETPO results materially, and thus may be optionally omitted, or ETPO may employ a default amount. But to the extent they are inputted, the results will be more precise.
Brokerage Annual Wrap Fee: Many brokers charge a fee as a percentage of the assets under management, as an aggregated cost of both management services and brokerage transaction costs. The Brokerage Annual Wrap Fee, when inputted, will reduce the accumulating after-tax horizon values by this percentage amount, on an annual basis.
Annual Advisor Fee Percentage: Registered Investment Advisors generally charge for their services, a percentage of the assets under management. 1% for example. As with the Brokerage Annual Wrap Fee, this value will be deducted from accumulated end-of-horizon values.
Price Targeting Option: ETPO, according to some embodiments, provides for two methods of price targeting: Price-based, and Earnings-based. Because of the importance of price targeting in After-Tax Portfolio Optimization, the Price-based method maintains an inputted price target as a static value across the three, four and five year horizons, in accordance with some embodiments. Alternatively, the Earnings based method, requires a current year earnings estimate, an annual compound growth rate, and a Price Earnings Multiple to apply against an end-of-horizon projected earnings forecast, in order to arrive at a price target, which will result in a different price at the end of each investment time horizon. By way of the user interface, if a user toggles the Price based option, then the price targeting input fields below, by Position, (a collection of tax-lots of the same company), will just have one input field for price target provided. User selection of the Earnings based option, will convert the input fields to the ones described.
Expectations To Use: Users may toggle and select to utilize, as stock price forecasts over their chosen investment horizon, either their own User saved expectations, for either Price or Earnings based options. In some implementations, third party forecasts may be used. For example, in some implementations, Value Line expectations may be used when selecting the Price based option, and Dynamic Capital Management's forecasts may be used when using the Earnings based option.
Stock/Position Inputs and Performance Expectations 26 comprises inputs related to each company (ticker) for the tax-lots (regardless of how many tax-lots may be owned within a multi-lot position), within the portfolio to be analyzed by ETPO, and may include the following, with respect to each company represented by the tax lots in the portfolio to undergo ETPO analysis according to some embodiments of the present disclosure.
Price: ETPO may be configured to automatically retrieve Delayed Market Pricing from BarCharts, during the Job Creation process. If prices are not available for a particular company, and/or the User wishes to supply more real-time pricing information, and/or the user wishes to simulate a price, the user may over-write the value in the Price field.
In addition, ETPO identifies, based on the inputs 26, the Price Date, and the total number of shares in a position in a company, which may include more than one tax-lot. And then the Price-based Price Target (if selected) is also an input that may be displayed. Both price and price targets remain the same across all tax-lots within a Position. Current price or a price target is not affected by a date of purchase or the cost of a tax-lot. In addition, a User may “Save As User Expectations” via the user interface, whatever values are resident in any of the Expectation Set input fields. For example, Value Line price targets may be saved as User Price based targets, and DCM Expectations Sets may be saved as User Earnings based Expectations, or any other value may be inputted and saved as a User Expectation.
If Earnings based price targeting were selected as an input, then instead of a single Price target (which would remain the same for the end of a three, four or five year investment horizon), a price target is calculated and derived by starting with an Earnings Base, whereby an Earnings Growth Rate is applied on a compound basis through the end of an investment horizon, and then that number is multiplied by a PE Target. In accordance with some embodiments, that information may be displayed to a user in a company ticker row in a job positions screen (rather than a single Price target). As noted, a user may either save and use their own Earnings based targeting inputs, or may choose to use Dynamic Capital Management's.
Highest Justifiable Price: Another value included in a company's input set 26 (e.g., as may be displayed in a given row of a user interface screen; e.g., selected position in job screenshot portion in
Because this feature has a material impact on the tax economics of an individual tax-lot, in accordance with some embodiments, we require the User to be pro-active in the use of this value, in order for it to be included in an analysis where it could impact the results. One way is to use DCM expectations. DCM calculates and distributes a Highest Justifiable Price on most of the members of the S&P 500 and Nasdaq 100, plus some additional companies. If a User toggles the Earnings based option, and chooses the DCM Expectations (which may be set as the default ones, since the present inventor knows there was fundamental rigor attached to the development of that value), those values will automatically populate the Highest Justifiable Price input field. In addition, if a User deliberately saves a value for Highest Justifiable Price either within the Input Page, or within the Expectations tab, then those values will be defaulted within the Input Page. However, if neither of those conditions apply, then, in accordance with some embodiments, the system will take the Current Delayed Market Price, and multiply it by 125% as a default. Since the HJP only impacts an analysis when the market price is above the HJP in the short-term window, defaulting the price below the HJP takes any impact out of the equation. The HJP values that are calculated and inputted as 125% of market prices may be shown in an identifying color (e.g., Orange), so that the User knows they have to make a deliberate input decision if they wish to invoke the impact of any Highest Justifiable Price.
Dividend Amount: This is another input that, in some embodiments, requires a deliberate decision by the User. Dividend amounts, and their related Dividend Growth Rates, may be defaulted as either a Saved User Expectation, or as a result of selecting DCM as an Earnings based Expectation Set source. This is because dividend amounts are often not stable, and are often reduced dramatically. As DCM reviews, for the stocks it follows, over ten years of dividend history, pay-out ratios and growth rates, and assesses whether a dividend might be vulnerable to a drop due to dividends being distributed in an amount that further threatens an already weak balance sheet, DCM reduces a dividend amount to a Sustainable Dividend Amount, so as not to make dividend distribution Expectations very speculative. A DCM Expectation Set selection will have its dividend and dividend growth rate values defaulted as Position Defaults, as will saved User Dividend Amount and Dividend Growth rates. However, again, if neither of those conditions are present, those values are defaulted to be zero.
Risk Premium Adjustment: Risk Premium Adjustment is another Position related input. If a held position is more or less risky than an alternative investment, than that of a reinvestment option, it can be value added to take that into consideration. If an investor's choice is whether to hold onto U.S. Steel with a high Beta of almost 2, versus a reinvestment alternative with the risk profile of the market at large with a Beta of 1, ETPO can fundamentally account and adjust for that rationally as well. If an investor were to conclude that in order to accept the risk of owning a steel company, and U.S. Steel in particular, could only be justified with an extra 3% per year in return, then the investor could, for example, put a plus 3.0 value in the Risk Premium Adjustment field (which may be saved as a User Expectation, as mentioned before). The impact that value has on an ETPO analysis is that the Hold End-of-Horizon After-tax value would be reduced by 3% per year of an investment horizon, thus making it easier and more justified to replace a riskier stock with a tax liability with a less risky alternative, than one with less risk. And otherwise, when a stock is less risky than the market as a whole, such as with a Johnson & Johnson with a Beta of 0.5, a lower return requirement by, for example, 2%, than would be needed to be rewarded for full market risk might be inputted. This would increase the Hold After-Tax End-of Horizon value by 2% per year, thus making an alternative investment, all else being equal, less justified, unless it could more than outperform by the value of the Risk Premium Adjustment. Accordingly, some embodiments of ETPO may include this value-added input option.
Shares To Sell: In accordance with some embodiments, Shares To Sell can have different meanings depending, for example, on the context of the illustrative ETPO user interface, such as with respect to illustrative screenshots depicted in the accompanying figures. For example, Shares to Sell can mean any one of the following: (1) the number of shares Designated by a User within either the Portfolio, Input, or Results pages/screens, to be sold out of a particular tax-lot, and therefore (in some implementations) alphabetically ranked by ticker, at the top of a Results Set optimization ranking; (2) the number of shares Designated by a User within the Input page, to be sold among one or more tax-lots included in a multi tax-lot stock position; and (3) the number of shares recommended to be sold out of each individual tax-lot, within the Results Set portfolio optimization sell candidate ranking, and included in all the related ETPO tax-lot calculations (which may also be converted to an individual Shares To Sell Tax-Lot Sell Designation within the Results page, then Re-Processing an EPTO Analysis directly from the Results page.
In the case of Shares To Sell on an Input Page that may be displayed to a user for entering input information such as that described hereinabove (see, e.g.,
ETPO analysis inputs referred to as Tax-Lot and Position Sell Designations 28 may include two types of Shares To Sell Designations that may be input by the user. By way of example as to the utility of these inputs, it may be appreciated that there are many reasons to sell a stock, other than for reasons of valuation; for example, having too much of a given stock.
Since a Position may be made up of just one tax-lot, and an investor may want part if it to be sold, ETPO according to some embodiments provides three different opportunities for a User to Designate at the Tax-lot level, the number of Shares To Sell: first at the point in which they select the individual tax-lots to be included in a Job Creation (i.e., where the user effectively can select a portfolio of tax-lots to undergo ETPO analysis from among all tax-lots held by the user; in some embodiments the user may select all such held tax-lots); Second, within the Input Page, where they may review and change an already made individual tax-lot Sale Designation; and third, again within the Job Results Page, whereby a User may change their mind again, after seeing the Results Set, change an individual tax-lot Shares to Sell Designation, and Re-run a Job without returning to the Job Input page.
It will be understood that an individual tax-lot Designation does not go through an optimization process. The User is deciding to sell some or all of a tax-lot, independent of an optimization process. A reason ETPO provides a user this flexibility to Designate Shares To Sell at the individual Tax-lot level is that it is important that ETPO update the Realized Gains/Losses values with the impact of those decisions, before the optimization process begins.
The second kind of Shares To Sell Designation 28 is at the Position level. An investor may wish to sell a number of shares among more than one tax-lot making up an entire position, but doesn't know which tax-lots to sell. Some may have been purchased at different costs, and on different dates, with some being in a profit, and some with a loss. While some are still short-term and others are long-term already. A Position Designation will cause Efficient Tax Portfolio Optimizer to recommend selling those tax-lots first within a position, that when sold, would generate the greatest excess return through a sale and reinvestment. And if additional shares are to be sold within a position than would generate an excess return by doing so, then Efficient Tax Portfolio Optimizer identifies and recommends selling those additional tax-lots first, in part or in whole, that have the least after-tax return potential remaining, based on calculating and comparing their existing after-tax value with their projected end-of-horizon after-tax value, while keeping in a portfolio (e.g., by ranking lower for potential sale), those tax-lots within a Position that retain the greatest after-tax return potential.
In other words, a user may specify a Position Shares To Sell Designation if, for example, the user wishes to reduce the number of shares they may own across a Position with multiple tax-lots, because, for example, they wish to reduce their exposure or take some profits. Based on that Position Shares to Sell Designation, ETPO will perform an optimization Analysis to recommend selling owned tax-lots in a sequence that identifies tax-lots to be sold first that would generate the greatest excess return, or Alpha, through a sale and reinvestment. And then, if not all the number of shares that are wished to be sold generate an Alpha, the ETPO optimization Analysis will recommend that the investor sell those tax-lots first that have the least after-tax return potential remaining.
As depicted by
As may be understood in view of the foregoing, reiterative processing analysis according to ETPO optimization analysis (e.g., in accordance with invoking, for example, Reiterative Optimization Analyzer 34) involves a highly calculation intensive and rigorous portfolio data analysis mining optimization process, wherein the ETPO Analysis first identifies which tax-lot, among all of those within a portfolio, if sold, given inputs like cost basis, market price, up-to-date realized gain and loss values and tax rates, would generate the greatest excess after-tax return or Alpha through a sale and reinvestment versus holding onto an existing investment.
Then by updating the Realized Gain and Loss values with the forecasted gain/loss realization impacts from that sale candidate, ETPO optimization analysis (e.g., in accordance with invoking, for example, Reiterative Optimization Analyzer 34) identifies, from the remaining tax-lots, which tax-lot sale candidate would generate the greatest Alpha or excess, risk adjusted, return, if desired, that tax-lot thereby becoming the second tax-lot in sequence to sell in an optimization process. And this reiterative process is repeated until all tax-lots are ranked in descending order of potential Alpha forecasted, if any.
And then, after all tax-lot candidates that would generate an extra return if sold are identified and ranked, an ETPO optimization analysis (e.g., in accordance with invoking, for example, Reiterative Optimization Analyzer 34) converts the ranking sequence such that tax-lots with the least Existing Tax-Lot After-Tax IRR are suggested to be sold first, in the end, resulting in a ranking that recommends the selling of tax-lots that are likely to generate the greatest excess return first, and ultimately recommending keeping those tax-lots with the greatest after-tax return potential remaining. And that is the basic operation underlying how ETPO effectively minimizes taxes, but not at the expense of sacrificing future after-tax wealth accumulation by doing so.
In some embodiments, such as depicted in
More specifically, in accordance with the illustrative processing executed by processing resource 45, an ETPO Analysis includes five steps to provide its overall Optimization process. As one skilled in the art can understand, inputting up-to-date realized gain and loss values is important in the portfolio optimization process.
As discussed, keeping in mind that there are many reasons to sell other than valuation, such as having too much of any one stock, ETPO Portfolio Optimizer provides the user, at three different points of time, with the flexibility of Designating any number of shares to sell from any specific existing tax-lot, as an independent decision.
Accordingly, in step 40, ETPO accounts for all such individual tax-lot sale Designations, prior to any reiterative optimization process, by accruing (e.g., and displaying) gross and after-tax proceeds, in addition to updating the realized gain and loss values, as a precursor to the full optimization process. As such, an accurate accounting of any resulting impacts on realized gain and loss values will be calculated for any such Tax-Lot Sale Designations. In accordance with some embodiments, ETPO ranks all Tax-Lot Sale Designations alphabetically by ticker, for consistency, recognizing that regardless of which sequence Designated shares are sold, the end-resulting Realized Gain and Loss values will be the same.
In Steps 42 and 44, ETPO performs ETPO optimization analysis with respect to Multiple Tax-Lot Position sale Designations, in the event that any such Sale Designations have been input by a user. ETPO thus recognizes and accounts for an investor who may want to sell or designate for sale, a specified number of shares from a position, but in many cases, suh a position will be made up of more than one tax-lot. For example, 500 shares of IBM may be owned across four different tax-lots purchased on different days. And because of the position's increased portion of a portfolio due to its rise in price, an owner may want to sell 175 shares, but does not know which shares should be sold from the possible four tax-lots in the 500 share position.
In step 42, ETPO Analysis determines which shares from which tax-lot or sequence of tax lots, if sold, would be forecasted to generate the highest after-tax extra return by doing so. More specifically, step 42 comprises reiterative processing of a multiple tax-lots corresponding to a position for which a Position Sell Designation has been input/specified, to provide a recommended tax-lot sale sequence with descending ranking according to After-Tax Annual Average Recommendation Advantage, wherein the realized gain and loss values are updated on each iteration, including the last.
And then, in step 44, if more shares were Designated to be sold from the Position than would generate a forecasted Alpha if sold, reiterative processing according to ETPO analysis would be performed to identify potential additional share sales that would come first from any residual tax-lot, that if shares were sold thererom, contain the least after-tax return potential remaining, and further potential additional share sales would come from tax-lots ranked in ascending order with respect to Existing Tax-Lot After-Tax IRR, thereby recommending keeping tax-lots with the greatest after-tax return potential. Again, the realized gain and loss values are updated on each iteration.
All else being equal, short-term losses would be sold first, then long-term losses, then long-term gains, and then finally short-term gains.
Any Residual Shares not sold based on a Sell Designation are then included in the main optimization process of steps 46 and 48. Again, in accordance with ETPO optimization analysis, in step 46, with respect to such residual shares, tax-lots are ranked to be sold in a sequence such that those that would generate the greatest After-Tax Alpha are sold first. And then in step 48, any remaining tax-lots still suitable for ownership, are ranked as a sale candidate from the least after-tax return potential remaining to the highest, such that future after-tax returns are forecasted to come from existing tax-lots with greater after-tax return potential remaining.
In step 49, the output of the ETPO analysis, comprising recommended tax-lot strategies and potential sale sequences for portfolio optimization over the investment period/horizon, may be provided or output (e.g., to the user via the user interface resource 55.
The following illustrative examples are set forth with respect to screenshots representing a user interface present by ETPO 100, and are not limiting of the present invention. More specifically, in view of the foregoing disclosure, and given the original patented methods of the prior patents, and the values derived thereof that are primary inputs into ETPO, the description of ETPO itself, and its goals, the ETPO optimization process, in some implementations, includes and embodies the following illustrative non-limiting methods and sequence of analysis, in accordance with some embodiments of the present invention. These Figures, provided by way of non-limiting example, depict inputs and outputs of the front-end user interface, referencing the above mentioned descriptions. As will be understood, each of the enumerated Figures (i.e.,
An investor may Designate how many shares, if any, of any individual tax-lot they wish, should be sold, separate from the optimization process. The results of these Designation decisions will affect and will be included in the updating of the realized gain and loss values, along with other accumulating values, such as gross and net after-tax proceeds. This method's results are depicted in
Specifically,
Also referenced in
The remaining two tax-lot Shares To Sell values in the ETPO ranking process are governed by their rising Existing Tax-Lot After-Tax IRR value, and the the fact that one of them, IBM, has 40 Residual Shares of an original 50 share purchase on Sep. 30, 2012, impacted by the prior 10 share tax-lot Shares To Sell Designation.
An investor may further Designate, how many shares, among a number of tax-lots, associated with a particular company, or rather a total position in a company, they wish to sell. For example just to reduce their overall exposure or investment in a particular company.
ETPO will generate a sequence of selling among multiple tax-lots in an assembled position, in a manner consistent with the general optimization “Serial Stream” process but in its own “Mini Serial Stream” instead.
If any shares from a particular tax-lot that have been Designated to sell at the tax-lot level, any resulting residual shares, along with any other tax-lots within a position, will first be evaluated for which tax-lot, if it were to be sold, would generate the greatest, if any, After-Tax Annual Average Recommendation Advantage. This would be done either within a Position Designation Mini Serial Stream, or for a full remaining portfolio optimization regular Serial Stream. Resulting in the need to update the realized gain and loss values for the next comparative analysis within a Serial Stream, or in this case, a Mini Serial Stream, on the remaining tax-lots within a position. To identify among the remaining full and residual tax-lots within a position, which, if sold, would generate the highest After-Tax Annual Average Recommendation Advantage. Or rather then the second tax-lot to sell shares from, within a position, in an optimization Mini Serial Stream process method.
This Serial Stream, or Mini Serial Stream process is done a minimum of (n−1) times, with “n” being the number of tax-lots to be evaluated in an Efficient Tax Portfolio Optimizer Job, or within an individual position, respectively. Once all tax-lots within a position, that would generate an After-Tax Annual Average Recommendation Advantage, have been identified and exhausted, if there are any, then a reiterative sequential process will continue, updating realized gain and loss values along the way, using the least Existing Tax-Lot After-Tax IRR value tax-lot as the next tax-lot identified to be sold, in the optimization method. In effect, allowing the investor to raise cash in a manner that generates the greatest Alpha first, and then causes the least reduction in potential future returns by keeping tax-lots with the greatest after-tax return potential remaining by selling those first with the least after-tax return potential remaining. In an investor's desire to raise cash. Enabling an investor to prioritize the sequencing of tax-lots to be sold in a process of raising cash, in a manner consistent with the goal of maximizing after-tax wealth accumulation.
The reason that a Serial Stream process, whereby if there are 100 tax-lots to be sequenced in a Job, has to identify the top ranking value of the After-Tax Annual Average Recommendation Advantage value, in combination with the lowest Existing Lot After-Tax IRR value, at least 99 times, is because, in the most simple example, without any Designations having been made, and without the realization and harvesting of losses in a Serial Stream process, (in a manner that could generate the selling of partial tax-lots, resulting in residual shares that require addition tax-lot analysis), after the 99th iteration has assessed which of the last two tax-lots should be sold first, no further iterations are necessary to complete the optimization sequence ranking.
This process and method's inputs and results set are reflected in
As part of the Serial Stream processes, losses, both short and long-term, may be realized, and harvested against whole or partial shares of profitable tax-lots, in a manner that either adds the greatest after-tax wealth over time, or gives up the least by doing so. An example of this process is reflected in
These losses are harvested in an ETPO process, with the sequencing results displayed in FIG. 4B1 (Outputs), whereby only short-term losses are only offset against short-term gains, and long-term losses are only offset against long-term gains, with the following Data Elements identified and described:
In this example, 200 shares of Cisco (CSCO) were purchased on Jan. 1, 2013, for a total cost of $2, 188.00, or $10.94 per share, making it still a short-term holding. With a current market price of $26.38, not shown, it is yielding an Unrealized Short-Term Gain of $3,088.00, or $15.44 in unrealized profit per share. The $750 in Short-Term Loss, if divided by the $15.44 profit per share, could be harvested against 48.575 shares, matching gains and losses, and resulting in no taxes due due to the sale. As ETPO doesn't recommend fractional Shares to Sell, we always round down to whole numbers. In this example, Data Element “B−2” indicates that 48 shares could be sold, given the $750 in Realized Short-Term Losses, avoiding any tax, as a result of Tax Loss Harvesting where Short-Term Losses can only be harvested against Short-Term Gains, and Long-Term Losses can only be offset and harvested against Long-Term Gains. If there exists no value other than Zero (0) for a value for Tax Loss Harvesting, “B−2”, then a positive Shares To Sell value “B−1” represents shares recommended to be sold, given a User's inputs, that could be sold, with the referenced outcomes, absent any Tax Loss Harvesting.
Normally Short-Term Capital Losses must be harvested and applied against Short-Term Capital Gains, and Long-Term Capital Losses must be harvested or applied against Long-Term Gains. However the tax law allows that if at the end of a tax year, a taxpayer has net residual long-term losses, after offsetting all of the year's long-term losses against gains, and by adding any long-term capital loss carry-forward, then those losses can be used to offset likewise net residual short-term gains. And vice versa. Residual short-term losses can be used to avoid taxes on net realized residual long-term gains. Doing so would under-utilize the potential value of the short-term loss by only reducing profit that would be taxed at the lower long-term tax rate when it could otherwise be used to reduce a profit that would be taxed at the higher short-term rate. While offsetting a long-term loss against a short-term gain adds value otherwise to a loss. FIG. 4B2 (Outputs) is another version of outputs given the inputs displayed in
Once all individual Tax-Lot Designations, and Position Designations have been made, and processed, updating the realized gain and loss values along the way, all remaining tax-lots, and or residual shares remaining, will be processed in the general optimization Serial Stream. First, of course, using the highest After-Tax Annual Average Recommendation Advantage value as the ranking driver. Then switching to the lowest Existing Tax-Lot After-Tax IRR, once those tax-lots with an After-Tax Annual Recommendation Advantage value have been identified and exhausted.
It is possible that once all the After-Tax Annual Average Recommendation Advantage tax-lots have initially been recommended for sale, and the lowest Existing Tax-Lot After-Tax IRR value is being used as the sequencing driver, that a loss realized in the latter process, now available for harvesting, could re-generate one or more tax-lots that if sold, would generate an After-Tax Annual Recommendation Advantage on a particular yet to be optimized tax-lot, that the optimization process didn't before identify as the highest value user of the losses. But lower in the ranking, it then becomes the optimal user of losses as a Sell Now & Reinvest recommendation. With the optimization process then reverting again back to using the Existing Tax-Lot After-Tax IRR, when appropriate.
FIG. 5B1 (Outputs) is the non-Alternate Results Set from inputs from
2 (Outputs) simply adds the illustration of the impacts of including any Alternate realized losses either of offsetting short-term losses against long-term gains, or long-term losses against short-term gains, on the Shares To Sell values, and optimization ranking. As referenced in Data Set “A”.
It will be understood that the foregoing illustrative embodiments are implemented as computerized systems and methods, which may comprise, for example, one or more processors, at least one non-transitory computer-readable medium, software, and a user interface. The user interface (e.g., which may comprise a graphical user interface (GUI) and/or a browser) may be used for entering the user-specified information (e.g., designations, financial data, etc.) to be processed, for displaying results of the processing, and for other purposes. In some embodiments, the system and method may be implemented as a web-based system. In some implementations, the underlying engine for carrying out the ETPO processing (e.g., reiterative processing) may be implemented using a commercial spreadsheet application and/or dedicated application program. The one or more processors includes hardware operable for executing code (e.g., which may include executing a spreadsheet executable) for performing the analysis, and the one or more processors may be implemented in one or more personal computers and/or workstations, and may be implemented as server(s) and/or client(s), and may be configured for communication over an intranet and/or the Internet. The at least one computer-readable storage medium may include a variety of information about investment alternatives, performance expectations for these investment alternatives, client data, and other information.
It will be understood from the foregoing, that myriad variations and additional or alternative embodiments may be implemented without departing from the scope of the present disclosure. The present invention has been illustrated and described with respect to specific embodiments thereof, which embodiments are merely illustrative of the principles of some embodiments of the invention and are not intended to be exclusive or otherwise limiting embodiments. Accordingly, although the above description of illustrative embodiments of the present invention, as well as various illustrative modifications and features thereof, provides many specificities, these enabling details should not be construed as limiting the scope of the invention, and it will be readily understood by those persons skilled in the art that the present invention is susceptible to many modifications, adaptations, variations, omissions, additions, and equivalent implementations without departing from this scope and without diminishing its attendant advantages. For instance, except to the extent necessary or inherent in the processes themselves, no particular order to steps or stages of methods or processes described in this disclosure, including the figures, is implied. In many cases the order of process steps may be varied, and various illustrative steps may be combined, altered, or omitted, without changing the purpose, effect or import of the methods described. Similarly, the structure and/or function of a component may be combined into a single component or divided among two or more components. It is further noted that the terms and expressions have been used as terms of description and not terms of limitation. There is no intention to use the terms or expressions to exclude any equivalents of features shown and described or portions thereof. Additionally, the present invention may be practiced without necessarily providing one or more of the advantages described herein or otherwise understood in view of the disclosure and/or that may be realized in some embodiments thereof. It is therefore intended that the present invention is not limited to the disclosed embodiments but should be defined in accordance with claims that are based on the present disclosure, as such claims may be presented herein and/or in any patent applications claiming priority to, based on, and/or corresponding to the present disclosure.
This application claims the benefit of U.S. Provisional Application No. 61/890,097, filed Oct. 11, 2013, which is hereby incorporated herein by reference in its entirety.
| Number | Date | Country | |
|---|---|---|---|
| 61890097 | Oct 2013 | US |
| Number | Date | Country | |
|---|---|---|---|
| Parent | 14514368 | Oct 2014 | US |
| Child | 19005243 | US |
