OptionsOptions strategies

Covered Call Income Generation (With Excel Template)

Written by admin
Sat Jun 24 2017
Covered Call Income Generation
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Covered Call Income Generation
 

Investors who generally follow a buy and hold strategy can make an extra income by adding options to their portfolio. In this article, we will learn about the covered call income generation strategy and how investors who are long underlying stocks can generate additional income with minimal risk. At the end of the article, you will also find an Options Strategies Excel Template. The excel template allows you to create any options strategy, view its profit and loss, and it also creates the payoff diagram of the strategy.

What is an Options Strategy?

An options strategy refers to buying and selling a combination of options along with the underlying assets to create a certain payoff. Any option strategy will involve the investor going long/short the stock and buying or writing call or put option contracts. The option strategies are generally classified as covered strategies, spread strategies and combined strategies. Covered strategies involve taking the position in the underlying stock and the option. Spread strategies involve taking positions in two or more call options of the same type to take advantage of the spread. In this article we will look at the covered call strategy.

Covered Call Income Generation Strategy

A covered call strategy involves being long on a stock and short on a call option of the same stock. In a call option, the writer (short) of the call option grants the buyer of the option the write to buy the underlying stock at the exercise price (which is fixed at the time of selling the option. There are two key components of a call option: 1) The exercise price (also called the strike price) which is the price on which the call option buyer has the right to buy the underlying stock. 2) The expiration date (the date on which an option expires and becomes worthless).

While building a covered call strategy, the holder of the stock is writing a call option on the same stock, i.e., he is granting the buyer the right to purchase the underlying stock at the pre-decided strike price. Selling the option earns the writer a small income called the premium. This is a conservative strategy because the seller of the option is taking only a limited risk as he already holds the underlying stock. The long position in the stock acts as a cover for the short position in the call option. Thereby, it protects the option seller from the market price of the stock. If the option buyer decides to exercise the option, the option seller that the option seller holds can be delivered.

Salient Features

Let’s review the salient features of a covered call income generation strategy:

Strategy: Long 100 stocks + Short call option

When to use: Investor should consider this strategy if he is neutral to slightly bullish about the market.

Reward: Reward is limited in the form of the premium received. There is also a notional gain equivalent to the price rise upto the strike price.

Risk: Risk is limited from the short call but can significantly affect you if the stock prices fall.

Covered Call Example

Let’s say an investor creates a covered call with the following details:

The payoff diagram for this covered call will look as follows:

Option Strategies Excel Template

You can download the attached Covered Call Strategy excel template that you can use to form a “covered call” strategy for any stock. The template allows you specify a stock and an options contract for that stock. Once you specify these details, the template will perform all calculations and plot the payoff diagram. Furthermore, the template uses MarketXLS functions to fetch real-time data for both stocks and options.

Download Option Strategies Excel Template

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

CRA InternationalInc. logo

CRA InternationalInc.

89.32
 
USD
 
1.50
 
(1.71%)
81
Rank
Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
78.05   
   115.47
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.36
 
USD
 
1.83
 
(2.07%)
81
Rank
Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
69.32   
   90.99
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

45.86
 
USD
 
-0.26
 
(-0.56%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

75.45
 
USD
 
0.73
 
(0.98%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   75.00
Sanderson Farms Inc. logo

Sanderson Farms Inc.

215.53
 
USD
 
-3.08
 
(-1.41%)
78
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

24.49
 
USD
 
0.01
 
(0.04%)
77
Rank
Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
19.61   
   29.50
Republic Services Inc. logo

Republic Services Inc.

130.87
 
USD
 
1.12
 
(0.86%)
76
Rank
Optionable: Yes
Market Cap: 40,406 M
Industry: Waste Management
52 week range    
109.24   
   145.00
ConAgra Brands Inc. logo

ConAgra Brands Inc.

34.24
 
USD
 
-0.09
 
(-0.26%)
76
Rank
Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
29.80   
   36.67
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

104.69
 
USD
 
-5.36
 
(-4.87%)
75
Rank
Optionable: Yes
Market Cap: 8,406 M
Industry: Auto & Truck Dealerships
52 week range    
71.77   
   123.60
Franklin Covey Company logo

Franklin Covey Company

46.18
 
USD
 
8.15
 
(21.43%)
75
Rank
Optionable: Yes
Market Cap: 557 M
Industry: Education & Training Services
52 week range    
33.41   
   52.52

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!