Lyn Alden

Investment Strategy

  • Start Here
  • Free Newsletter
  • StockDelver
  • OptionWeaver
  • Top Resources
  • Premium
  • Members Area
  • Log In

Option Selling Starter’s Kit: OptionWeaver

OptionWeaver is a digital download that helps investors get started with selling options, including covered calls and cash-secured puts.

It includes:

  • A PDF booklet that lists over 50 stocks and ETFs that make great targets for selling options on when the price is right, including the stocks and ETFs I most-often sell options on.
  • A streamlined Excel spreadsheet that helps you value stocks and figure out which options to sell.
  • A PDF set of instructions for how to use the spreadsheet.

This tool lets you calculate the fair value of stocks in three different ways, as well as calculate the potential rates of return from option premiums.

It’s a streamlined spreadsheet model that keeps things fast and simple, and can be used on a variety of platforms. It has all of the calculators from StockDelver, plus two more for options.

I make several thousand dollars per year in option premium income and this is the tool I use to evaluate which options to sell.

Option Premium Calculator OptionWeaver Cover

It’s fast to use, and has five different calculators:

#1) Detailed One-Stage Model

This is elegant in its simplicity, yet powerful and flexible in its approach.

The hardest part about applying discounted cash flow analysis, or using any stock valuation method, is figuring out what growth rates to use. An output is only as good as your inputs are accurate, so if your forecast is off and you put bad numbers in, you’ll get bad numbers out.

This framework makes it easy to segment the growth estimate into individual parts, so that you can approach them individually and come up with an accurate estimate.

Here’s an example of what it looks like:

Discounted Cash Flow Calculator Example

You start with top line growth, and work your way down from there, variable by variable, using recent company history, investor presentations regarding management plans and goals, or any other data you have available, to determine how the performance might play out over the coming years.

The output area automatically calculates a result for you, based on your inputs.

I like to use this tool for sensitivity analysis as well. Once you have a valuation estimate, you can see how negative impacts to pricing or growth or anything else can affect how your investment will turn out.

This helps you identify risks ahead of time.

It works on just about any type of publicly-traded company, whether they pay a dividend or not.

#2) Simple Two-Stage Model

The simple two-stage model cuts right to the chase and lets you calculate the fair value of a stock based on changing growth rates:

Fair Value Calculator Example

This is great for fast-growing companies that will necessarily be slowing down in a few years.

#3) Dividend Discount Model

Next, the spreadsheet has a dividend discount model sheet for high-yield companies:

Dividend Discount Model Example

I cut the output picture short because it’s a long image.

This model is great for REITs, MLPs, or any high-yielding dividend stock.  You don’t need to use a 10-year sale multiple like the others; it calculates the sum of perpetual discounted dividends for you.

#4) Graham and Lynch Formulas

Lastly, the calculator includes a page for modified Graham and Lynch formulas:

StockDelver Graham Lynch Formula

It calculates the original Benjamin Graham formula as well as his modified version for various interest rate environments. In addition, it calculates a dividend-adjusted P/E/G ratio, which is a modified version of Peter Lynch’s popular valuation approach.

The instructions walk you through each of these methods step by step and explains how they work.

#5) Put-Selling Calculator

This calculator lets you enter the stock price, strike price, bid premium, and expiration, and then it calculates the rate of return of the option under different scenarios:

Put Option Premium Calculator

It shows what will happen whether the option is exercised or expires, shows the potential rate of return over the lifetime of the option and on an annualized basis, and provides a chart comparing selling the put (Put RoR) to simply buying the stock outright at market prices (Base RoR) over a range of stock prices during the lifetime of the option.

#6) Call-Selling Calculator

The final spreadsheet does that for covered calls:

Call Option Premium Calculator

Platform-Independent and 100% Unlocked

Although this is an Excel (.xlsx) file, it can be opened and used on most spreadsheet programs, including free ones like Open Office.

You can even upload it to Google Drive and use it on the cloud like a web application.

I chose not to lock or hide any of the cells. You can see all the formulas if you want, and you can customize the spreadsheet file to suit your needs.

Stock and ETF Booklet

Some stocks and ETFs are great for selling options on, while others are not.

In addition to the calculator and instructions, OptionWeaver comes with a PDF booklet that explains the three most important attributes of a security that makes it a good target for selling options on, and then lists over 50 example stocks and ETFs that have all of those attributes.

It’s the list of stocks and ETFs I most often refer to when deciding which securities to sell options on, and serves as a good list for getting started.

Download OptionWeaver

OptionWeaver is available as a digital download for $14.95.

It includes the Excel calculator (.xlsx), and comes with a 27-page detailed PDF tutorial on how to use it to value stocks and calculate option premium returns, as well as a 30-page booklet that shows readers which types of stocks and options are good for selling options on, along with over 50 examples of stocks and ETFs that are great securities for option-sellers, and that I tend to sell most options on myself.

I use one of the most trusted digital delivery platforms for secure payment, and this entire site is SSL-encrypted for additional safety.

Download OptionWeaver below:

Loading…
Tweet
Share
Share

This site provides equity research and investment strategies to give you the insight and data you need for managing your money through all market conditions.

Click here to join the free investing newsletter.

Featured On:

Investment Strategy Press

Let’s Connect:


Stock Ideas & Market Info:

  • The Shiller PE (CAPE) Ratio: Current Market Valuations
  • Contrarian Investing: Smart Moves for 2023 and Beyond
  • 4 Economic Bubbles Growing In the United States
  • Safe High Dividend Stocks: 20+ Strong Picks For 2023
  • 5 Rock-Solid Blue Chip Dividend Stocks That I’m Bullish On Now
  • 7 Top Stocks to Buy and Hold for the Next Decade and Beyond

Build Wealth:

  • How to Build Wealth Fast- This Chart Shows What it Takes
  • How to Increase Your Credit Score to 800 and Above
  • The 5 Most Impactful Tactics to Save Money I’ve Ever Found
  • 12 In-Depth Tactics to Seriously Boost your Energy

Investing Basics:

  • How to Invest Money Intelligently: The Starter’s Guide
  • How to Invest in Stocks and the Stock Market
  • Roth IRAs: How to Optimize Yours
  • Federal Thrift Savings Plan (TSP): The Ultimate Guide for 2019
  • How to Survive a Stock Market Crash or Bear Market

Experienced Investors:

  • Covered Calls: A Step-by-Step Guide with Examples
  • Selling Put Options: How to Get Paid for Being Patient
  • Equal Weighted Index Funds: The Pros and Cons and Which to Pick
  • Discounted Cash Flow Analysis: Complete Tutorial With Examples

Disclaimer

This site is for informational and entertainment purposes, and should not be construed as personal investment advice.

Please seek out a certified financial planner if you need advice tailored to your unique situation.

Instead of running ads on this site, I receive affiliate commissions for recommending certain products or services. See my disclosure for more info.

Get The Book

This digital book describes my process for finding great stocks, and comes with streamlined calculators to determine fair value.

StockDelver Investing Book

Check it out here.

Premium Membership

Premium Research Service

Join the new premium research service for timely deep-dive analysis of high-conviction investment opportunities.

Learn more here.

  • Privacy Policy
  • Legal Information
  • Article Archives
  • Newsletter Archives
  • Support
  • Contact

Copyright © 2023 · Generate Pro On Genesis Framework · WordPress · Log in