r/shares – Spreadsheet to calculate GME Exit Technique, ROI Calculations & Breakeven Evaluation

0
16

PLEASE DROP AN UPVOTE AND/OR COMMENT IF YOU USE. IT TOOK ME A FEW HOURS TO MAKE THIS SPREADSHEET AND I WOULD LIKE TO HELP AS MANY PEOPLE AS POSSIBLE. I SEE A LOT OF PEOPLE OPENING AND DUPLICATING THE SHEET, PLEASE HELP PAY IT FORWARD.

Disclaimer: I initially created this device for WSB, but it surely seems like I’m muted there for some motive, so I figured I’d share on another subs the place individuals are additionally speaking about GME.

This complete expertise has been (and will probably be) a loopy journey, however you do not need to be the one caught holding the bag when it will definitely comes crashing all the way down to earth. HAVE AN EXIT STRATEGY. Everybody has completely different ranges of expendable capital and danger tolerance. A few of us can afford to YOLO away six-figure investments, whereas others could be very happy to easily flip a number of hundred {dollars} right into a grand.

Your exit technique ought to rely on how a lot cash you might be snug dropping, and the way a lot earnings you’ll be blissful taking. I am not right here to let you know what your technique needs to be, however I did make a device so you may determine it out for your self: Exit Strategy Calculator (Google Sheet)

HOW TO USE THE EXIT STRATEGY PLANNER

– Notice 1: That is for shares solely. I am not sensible sufficient to make this work for choices.

– Notice 2: The hyperlink I offered is READ ONLY, so step one is to make a replica on your personal use (File –> make a replica)

Now, enter your present place. Present the variety of shares you will have in A3, and your common value foundation in B3 (these cells are highlighted in yellow). Your complete funding will routinely calculate in C3.

Columns E-F are the ROI calculator. Column F tells you what the share worth might want to attain so as to hit the ROI listed in Column E. Column G tells you what your complete worth could be at that share worth.

Columns I-Okay are your break-even evaluation, which principally tells you what the share worth would have to be so that you can break even by promoting X variety of your shares, and what your revenue could be in case you offered all of them at stated worth. You’ll in all probability need to alter the #s in Column I based mostly on what number of shares you at present have in your place. Columns J & Okay will routinely replace whenever you do.

Columns M-N calculate your earnings at completely different share costs. How a lot cash will you make in case you promote when GME hits $80? What about $100, or $250, and even $1,000? These columns will let you know. Be at liberty to regulate the share costs in column M if you would like, however I’ve many of the massive milestones coated.

Columns P-R are your exit technique planner. You’ll need to supply the next data: # of shares (if any) you need to maintain long run, post-squeeze [cell P4]. Most greenback quantity out of your preliminary funding that you would be able to abdomen dropping [Q4]. Revenue quantity you’ll be 100% blissful cashing out with no FOMO of future positive factors [R3]. Cell Q6 will calculate your “worst case state of affairs” promote worth. Set a cease loss order at this worth to maximise your losses to the quantity you entered in This fall, whereas nonetheless holding your required # of long-term shares. Cell Q7 will calculate your “finest case state of affairs” promote worth. Set a restrict order at this worth to money out along with your “100% glad revenue” you entered in R4, whereas nonetheless holding your required # of long-term shares.

Columns T-V is an incremental gross sales planner. A few of you might need to promote a portion of your shares when sure benchmarks are hit (ie promote 10 shares when it hits $100, one other 10 at $150, and many others.). Merely enter in what number of shares you need to promote at every worth level [column U], and the sheet will calculate your cumulative revenues, internet revenue, and remaining shares.

TLDR: Use this spreadsheet to keep away from getting caught holding the bag on GME when all the shorts are formally squeezed. Make a replica for your self and alter the cells highlighted in yellow to account on your private place and danger/reward preferences.

In fact you should use this spreadsheet on your different investments, however let’s be trustworthy… half of us appear to be all in on GME proper now. Huge week forward, might all of our earnings be plentiful!

LEAVE A REPLY

Please enter your comment!
Please enter your name here