Employee Stock Purchase Plan (ESPP) - Immediate Selling Strategy

An almost fool proof strategy for ESPP shares is to opt for selling them immediately after the plan purchases the allotted shares. This “almost” guarantees a return of 17.65% on the money invested which when annualized brings the return figure to 98%. It is not a 100% guarantee only because there is minutely small chance that the company stock could slide significantly on the day it was purchased and before one is able to sell them. Almost guaranteed annualized-return of 98% is still an outstanding investment option. Below are the details of the return calculation.

17.65% return calculation:

The company stock is purchased at a 15% discount – the discount rate that is largely standard for ESPP plans. For e.g., $100 worth of stock purchased for $85 earns a profit of $15 on the $85 that went in. So, the percentage return is:

15*100/85=17.65%

98% annualized return calculation:

The $85 is deducted from the paycheck over a period of 6 months using semi-monthly payroll deductions. An amount of $7.08 ($85/12) is deducted from the paycheck every pay period and at the end of 6 months, stocks worth $100 are purchased which on immediate sale realizes $100 cash. The XIRR function in Excel (might need to install the Analysis options package to get it to work) allows to calculate the internal rate of return for such a schedule of cash flows. Below is an example that uses the function over the first 6 months of 2007:

=XIRR(
{-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,-7.08,7.08,100},
{"1/15/2007","1/30/2007","2/15/2007","2/28/2007","3/15/2007","3/30/2007",
"4/15/2007","4/30/2007","5/15/2007","5/30/2007","6/15/2007","6/30/2007",
"7/1/2007"}
)

The formula above yields a whopping 98% annualized internal return – the first array represents the cash flows – the first 12 values represents the semi-monthly payroll deductions of $7.08 and the last value in the array represents the $100 realized after selling the purchased stock. The 2nd array represents the actual dates when each cash-flow event in the first array happened.

Taxes and commissions will take its due out of this return. The commission however should be minimal on a percentage basis, especially when participating at the maximum allowed limits ($25000/year). Ordinary income taxes will be due on the gain, but the almost guaranteed return should be well above any other option with a similar risk profile that is available

Related Posts:
  1. Flexible Spending Accounts (FSA) – Great Benefit with a few caveats!.
  2. Writing Covered Calls against Employer Stock Plan Shares (ESPP, Restricted Stock, and Stock Options) – A Primer.
  3. Employee Stock Purchase Plan (ESPP) and 401K Retirement Plan Annual Enrollment and Contribution Review.
  4. Employee Stock Purchase Plan (ESPP) - Immediate Selling Strategy.
  5. Realizing Long-Term Capital Gains With Stock Based Compensation.
  6. Stock Based Compensation Tax Optimization Strategies.

Last Updated: 01/2015. 

No comments :

Labels

401k ( 15 ) Abad Turtle Beach ( 1 ) Abrams Capital Management ( 5 ) Acoustic Electric Guitars ( 1 ) Acoustic Guitars ( 1 ) ACT ( 1 ) Activist ( 4 ) Address Change ( 2 ) Advanced Placement ( 4 ) air asia ( 2 ) airlines ( 2 ) Akre Capital Management ( 18 ) Alex Roepers ( 5 ) AP ( 4 ) apartments ( 2 ) Appaloosa ( 15 ) ARIUS ( 1 ) Arlington Value Capital ( 3 ) Atlantic Investment Management ( 5 ) Ayemenem ( 1 ) Bangalore ( 3 ) Bangkok ( 2 ) Bannerghatta National Park ( 1 ) barbuda ( 2 ) Battery Park ( 1 ) Baupost ( 2 ) Baupost Group ( 17 ) bay area ( 2 ) BDCs ( 3 ) Benjamin Graham ( 2 ) Benjamin Graham Model ( 2 ) Berijam Lake ( 2 ) Berkshire Hathaway ( 35 ) best sites ( 9 ) Bill & Melinda Gates Foundation ( 41 ) Bill Ackman ( 19 ) Bill Gates ( 40 ) Blue Ridge Capital ( 16 ) Blum Capital Partners ( 12 ) books ( 4 ) Boone Pickens ( 2 ) BP Capital Management ( 2 ) Brave Warrior ( 3 ) Brave Warrior Advisors ( 16 ) british honduras ( 2 ) Bruce Berkowitz ( 19 ) Bruce Fund ( 38 ) Camcorders ( 3 ) canada ( 4 ) cancun ( 3 ) CANROYs ( 7 ) Cantillon ( 12 ) carl icahn ( 9 ) Carl Ichan ( 8 ) casino ( 3 ) Casio ( 2 ) CBRE ( 2 ) CEF ( 2 ) Charles Akre ( 15 ) Charlie Munger ( 40 ) Chase Coleman ( 16 ) Chou Associates ( 29 ) Christmas gifts ( 7 ) Christopher H. Browne ( 7 ) Chuck Akre ( 13 ) Cisco ( 2 ) Class Action Settlements ( 2 ) CLEP ( 1 ) Coatue Management ( 28 ) Cochin ( 2 ) coin collecting ( 266 ) collectibles ( 266 ) Consumer Product Reviews ( 29 ) cook islands ( 2 ) coonoor ( 2 ) Covered Calls ( 2 ) credai ( 4 ) Daily Journal ( 37 ) Dalal Street ( 8 ) Dan Loeb ( 10 ) DAT ( 1 ) David Abrams ( 5 ) David Einhorn ( 22 ) David Swensen ( 17 ) David Tepper ( 15 ) David Winters ( 15 ) DCF ( 2 ) Digital Piano ( 3 ) Dinakar Singh ( 20 ) Donald Yacktman ( 10 ) dry bulk shipping ( 2 ) Duquesne ( 34 ) Education ( 37 ) Edward Lampert ( 21 ) Egerton Capital ( 39 ) Egypt ( 3 ) Elementary Education ( 10 ) Elementary School Textbooks ( 5 ) eReaders ( 2 ) Eric Mindich ( 13 ) ESL Investments ( 14 ) ESPP ( 6 ) ETF ( 2 ) ETN ( 2 ) Eton Park ( 13 ) Everyday Musings ( 58 ) Exam Prep ( 7 ) Exiting the rat race - how to? ( 19 ) EXPLORE ( 1 ) Fair Value Estimates ( 4 ) Fairfax Financial ( 4 ) Fairfax Financial Holdings ( 14 ) Fairholme ( 19 ) Fairpointe ( 28 ) Family Office ( 18 ) FD Laddering ( 1 ) Financial Independence ( 93 ) Fisher Asset Management ( 10 ) Flash Camcorders ( 3 ) flat ( 4 ) flats ( 2 ) Flip ( 3 ) Francis Chou ( 29 ) free ( 17 ) frugal ( 3 ) Frugal Living ( 34 ) Fund Holdings ( 961 ) futures ( 2 ) FVE ( 2 ) gambling ( 3 ) garmin ( 2 ) Genting ( 2 ) george soros ( 27 ) giveaway ( 15 ) Glenn Greenberg ( 20 ) Glenview Capital ( 14 ) GMAT ( 1 ) Google ( 2 ) Gotham Asset Management ( 7 ) gps ( 5 ) GRE ( 1 ) Greenlight Capital ( 22 ) Guitars ( 3 ) Half Marathon ( 2 ) Hawaii ( 2 ) Hedge Funds ( 1154 ) HELOC ( 1 ) High School Education ( 7 ) High School Textbooks ( 6 ) HOA ( 3 ) hobby ( 17 ) holiday shopping ( 7 ) Holidays ( 3 ) Holyland ( 11 ) Home Improvement ( 2 ) home ownership ( 5 ) Homes ( 18 ) Homeschool ( 18 ) Houses ( 2 ) Housing ( 3 ) Hykon ( 2 ) Ian Cumming ( 15 ) Icahn Enterprises ( 6 ) india real estate ( 5 ) Infinuvo ( 6 ) Insurance ( 3 ) invesco ( 17 ) investing strategies ( 3 ) Investment Portfolio ( 96 ) Investment Research ( 10 ) Investments ( 7 ) iRobot ( 5 ) Irving Kahn ( 13 ) israel ( 5 ) Jason Maynard ( 10 ) Jefferies ( 2 ) Jeffrey Bruce ( 39 ) Jeffrey Ubben ( 23 ) Jerusalem ( 2 ) Jim Chanos ( 20 ) Joel Greenblatt ( 7 ) John Armitage ( 40 ) John Griffin ( 16 ) John Paulson ( 17 ) Joho Capital ( 19 ) Jordan ( 3 ) Joseph Steinberg ( 9 ) Julian Robertson ( 4 ) Kahn Brothers ( 14 ) Kakkanad ( 4 ) Kanyakumari ( 2 ) Kawai ( 2 ) Ken Fisher ( 10 ) kerala real estate ( 5 ) Kids ( 49 ) Kids Yamaha ( 3 ) Kindle ( 2 ) kochi ( 8 ) Kodaikanal ( 2 ) Korg ( 2 ) Kraft ( 2 ) Kuala Lumpur ( 2 ) KWA ( 2 ) Kynikos ( 20 ) laptop ( 5 ) Larry Robbins ( 14 ) Las Vegas ( 2 ) Leon Cooperman ( 30 ) Leucadia ( 2 ) Leucadia National ( 13 ) Lone Pine Capital ( 9 ) long ( 6 ) long call ( 2 ) long puts ( 3 ) Lou Simpson ( 15 ) LSAT ( 1 ) Mahabalipuram ( 2 ) Malaysia ( 3 ) Marathon ( 2 ) Mark McGoldrick ( 10 ) Markel ( 23 ) Mason Hawkins ( 4 ) MCAT ( 1 ) Melinda Gates ( 31 ) memorabilia ( 266 ) MFP Investors ( 37 ) Michael Dell ( 22 ) Michael Price ( 40 ) Middle School Education ( 4 ) Middle School Textbooks ( 3 ) Mini Notebook ( 3 ) MODUS ( 1 ) Mohnish Pabrai ( 22 ) mortgage ( 2 ) Mount Kellett ( 10 ) MSD Capital ( 22 ) Music ( 6 ) Mutual Funds ( 8 ) mysore ( 2 ) Nelson Peltz ( 13 ) Netbook ( 4 ) Notebook ( 3 ) numismatics ( 266 ) O-Duster ( 1 ) Oahu ( 2 ) offers ( 2 ) Ole Andreas Halvorsen ( 10 ) Omega Advisors ( 29 ) online tax ( 4 ) ooty ( 2 ) Options ( 4 ) Pabrai Fund ( 17 ) passive income ( 7 ) pattaya ( 2 ) Paulson & Company ( 7 ) Paulson and Company ( 9 ) PEG ( 2 ) Pershing Square ( 19 ) Phil Fisher ( 5 ) philately ( 283 ) Philippe Laffont ( 28 ) Piano ( 9 ) PLAN Test ( 1 ) portfolio ( 4 ) Prem Watsa ( 17 ) product reviews ( 13 ) Property Taxes ( 2 ) PSAT ( 1 ) R2I ( 24 ) R2I Finances ( 3 ) R2I Housing ( 5 ) Raising Kids ( 41 ) Rat Race ( 15 ) RBS Partners ( 19 ) reading ( 5 ) real estate ( 6 ) Reducing Expenses ( 2 ) REIT ( 3 ) Retirement Portfolio ( 9 ) Reviews ( 81 ) Richard C. Blum ( 12 ) Robert Bruce ( 39 ) Robert Karr ( 19 ) Robotic Vacuum ( 4 ) Roland ( 2 ) Roomba ( 10 ) schooling ( 2 ) Sears ( 12 ) seeking alpha ( 2 ) Services - Reviews ( 33 ) Seth Klarman ( 19 ) Shipping ( 5 ) Shopping ( 3 ) short ( 5 ) short calls ( 2 ) short put ( 2 ) short puts ( 2 ) short selling ( 13 ) Ski ( 5 ) Sled ( 4 ) Solar Stocks ( 13 ) Soros Fund Management ( 14 ) Southeastern Asset Management ( 4 ) Southwest ( 2 ) spin-offs ( 2 ) SQ Advisors ( 15 ) stamp collecting ( 283 ) Stanley Druckenmiller ( 33 ) Statue of Liberty ( 2 ) Stephen Mandel ( 9 ) Stock Analysis ( 84 ) Stock Investments ( 4 ) Stock Portfolio Updates ( 6 ) stocks ( 3 ) summer ( 2 ) tax ( 7 ) TaxAct ( 3 ) TaxCut ( 1 ) Teacher's Editions ( 5 ) Technology ( 5 ) Test Prep ( 11 ) Thailand ( 3 ) Thekkady ( 2 ) theme park ( 2 ) Third Point ( 10 ) Thomas Gayner ( 40 ) Thyra Zerhusen ( 29 ) Tiger Cub ( 34 ) Tiger Global ( 17 ) Tiger Management ( 13 ) Time Square ( 2 ) TOEFL ( 1 ) TPG-Axon ( 20 ) Travel ( 278 ) Travel Reviews ( 82 ) Trian Fund Holdings ( 9 ) trip report ( 21 ) TurboTax ( 3 ) Tweedy Browne ( 10 ) Vacations ( 28 ) value investing ( 25 ) ValueAct ( 9 ) ValueAct Holdings ( 6 ) Vancouver ( 2 ) Video ( 3 ) Viking Global ( 10 ) Wallace Weitz ( 14 ) Warren Buffett ( 32 ) Wayanad ( 4 ) Weitz Investment Management ( 13 ) wilbur ross ( 17 ) William Von Mueffling ( 12 ) Wintergreen Advisors ( 15 ) Yacktman Asset Management ( 10 ) Yale Endowment ( 17 ) Yale University ( 7 ) Yamaha ( 7 ) YDP ( 1 ) YPG ( 1 )