MillerKnoll, Inc.
US ˙ NasdaqGS ˙ US6005441000

Introduction

This page provides a comprehensive analysis of the known insider trading history of John J McPhee. Insiders are officers, directors, or significant investors in a company. It is illegal for insiders to make trades in their companies based on specific, non-public information. This does not mean it is illegal for them to make any trades in their own companies. However, they must report all trades to the SEC via a Form 4. Despite these restrictions, academic research suggests that insiders - in general - tend to outperform the market in their own companies.

Average Trade Profitability

The average trade profitability is the average return of all the open market purchases made by the insider in the last three years. To calculate this, we examine every open-market, unplanned purchase made by the insider, excluding all trades that were marked as part of a 10b5-1 trading plan. We then calculate the average performance of those trades over 3, 6, and 12 months, averaging each of those durations to generate a final performance metric for each trade. Finally, we average all of the performance metrics to calculate a performance metric for the insider. This list only includes insiders that have made at least three trades in the last two years.

If this insiders trade profitability is "N/A", then the insider either has not made any open-market purchases in the last three years, or the trades they’ve made are too recent to calculate a reliable performance metric.

Update Frequency: Daily

See the list of most profitable insider traders.

Companies with Reported Insider Positions

The SEC filings indicate John J McPhee has reported holdings or trades in the following companies:

Security Title Latest Reported Holdings
US:MLHR / Herman Miller Inc. President - HM Consumer 4,451
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by John J McPhee. Non-planned trade are trades that were not made as part of a 10b5-1 trading plan. The stock performance is charted as cumulative percent change in share price. For example, if an insider trade was made on January 1, 2019, the chart will show the daily percent change of the security to the present day. If the share price were to go from $10 to $15 during this time, the cumulative percent change in share price would be 50%. A change in price from $10 to $20 would be 100%, and a change in price of $10 to $5 would be -50%.

Ultimately, we are trying to determine how closely the insider’s trades correlate to excess returns (positive or negative) in the share price in order to see if the insider is timing their trades to profit from insider information. Consider the situation where an insider was doing this. In this situation, we would expect either (a) positive returns after purchases, or (b) negative returns after sales. In the case of (a), the PURCHASE chart would show a series of upwardly sloping curves, indicating positive returns after each purchase transaction. In the case of (b), the SALE chart would show a series of downward sloping curves, indicating negative returns after each sale transaction.

However, this alone is not enough to draw conclusions. If, for example, the share price of the company was in a non-cyclical climb over many years, then we would expect all the post-purchase plots to be upwardly sloping. Likewise, non-cyclical declines over many years would result in downward sloping post-trade plots. Neither of these charts would suggest insider trading activity.

The strongest indicator would be a situation where the share price was extremely cyclical, and there were both positive signals in the PURCHASE chart and negative plots on the SALE chart. This situation would be highly suggestive of an insider that was timing trades to their financial advantage.

Insider Purchases MLKN / MillerKnoll, Inc. - Short Term Profit Analysis

In this section, we analyze the profitability of every unplanned, open-market insider purchase made in MLKN / MillerKnoll, Inc.. This analysis helps to understand if the insider consistently generates abnormal returns, and is worth following. This analysis is for one-year following each trade, and the results are theoretical.

The following table shows the most recent open market purchases that were not part of an automatic trading plan.

Trade Date Ticker Insider Reported
Shares
Reported
Price
Adjusted
Shares
Adjusted
Price
Cost Basis Days to
Max
Price at
Max
Max
Profit ($)
Max Return (%)
2015-12-21 MLHR McPhee John J 3,000 28.3626 3,000 28.3626 85,088 261 36.1400 23,333 27.42

Adjusted Price is the split-adjusted price. Adjusted Shares is the split-adjusted shares.

MLKN / MillerKnoll, Inc. Insider Trades
Insider Sales MLKN / MillerKnoll, Inc. - Short Term Loss Analysis

In this section, we analyze the short-term loss avoidance of every unplanned, open-market insider sale made in MLKN / MillerKnoll, Inc.. A consistent pattern of loss avoidance may suggest that future sale transactions may predict declines in price. This analysis is for one-year following each trade, and the results are theoretical.

The following table shows the most recent open market sales that were not part of an automatic trading plan.

Trade Date Ticker Insider Reported
Shares
Reported
Price
Adjusted
Shares
Adjusted
Price
Cost Basis Days to
Min
Price at
Min
Max Loss
Avoided ($)
Max Loss
Avoided (%)
2020-01-28 MLHR McPhee John J 1,716 40.7800 1,716 40.7800 69,979 50 15.1500 -43,981 -62.85
2020-01-28 MLHR McPhee John J 1,716 40.7800 1,716 40.7800 69,979
2020-01-23 MLHR McPhee John J 10,758 41.0698 10,758 41.0698 441,829
2020-01-23 MLHR McPhee John J 4,088 41.0698 4,088 41.0698 167,893
2020-01-23 MLHR McPhee John J 3,130 41.0698 3,130 41.0698 128,548
2020-01-23 MLHR McPhee John J 1,220 41.0698 1,220 41.0698 50,105
2020-01-23 MLHR McPhee John J 3,000 40.9800 3,000 40.9800 122,940
2020-01-22 MLHR McPhee John J 16,494 41.0266 16,494 41.0266 676,693

Adjusted Price is the split-adjusted price. Adjusted Shares is the split-adjusted shares.

MLKN / MillerKnoll, Inc. Insider Trades
Insider Trading History

This table shows the complete list of insider trades made by John J McPhee as disclosed to the Securities Exchange Commission (SEC).

File Date Tran Date Form Ticker Security Code 10b5-1 Shares Remaining Shares Percent
Change
Share
Price
Tran
Value
Remaining
Value
2020-02-11 2020-02-09 4 MLHR HERMAN MILLER INC
Restricted Stock Units
M - Exercise -12,894 4,451 -74.34
2020-02-11 2020-02-09 4 MLHR HERMAN MILLER INC
Common Stock
F - Taxes -4,212 9,850 -29.95 40.63 -171,134 400,221
2020-02-11 2020-02-09 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 12,894 14,062 1,103.58
2020-01-30 2020-01-28 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -1,716 624 -73.32 40.78 -69,979 25,462
2020-01-30 2020-01-28 4/A MLHR HERMAN MILLER INC
Common Stock
S - Sale -1,716 624 -73.32 40.78 -69,979 25,462
2020-01-28 2020-01-24 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -491 2,340 -17.35 40.95 -20,112 95,839
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Non-Qualified Stock Option (right to buy)
M - Exercise -1,220 2,438 -33.35 41.07 -50,105 100,128
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Non-Qualified Stock Option (right to buy)
M - Exercise -3,130 1,565 -66.67 41.07 -128,548 64,274
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Non-Qualified Stock Option (right to buy)
M - Exercise -4,088 0 -100.00 41.07 -167,893
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Non-Qualified Stock Option (right to buy)
M - Exercise -10,758 4,088 -72.46 41.07 -441,829 167,893
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -3,000 2,832 -51.44 40.98 -122,940 116,036
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -1,220 5,832 -17.30 41.07 -50,105 239,499
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 1,220 7,052 20.92 38.30 46,726 270,073
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -3,130 5,832 -34.93 41.07 -128,548 239,499
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 3,130 8,962 53.67 33.75 105,638 302,451
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -4,088 5,832 -41.21 41.07 -167,893 239,499
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 4,088 9,920 70.10 31.86 130,244 316,036
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -10,758 5,832 -64.85 41.07 -441,829 239,499
2020-01-24 2020-01-23 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 10,758 16,590 184.48 31.86 342,750 528,542
2020-01-24 2020-01-22 4 MLHR HERMAN MILLER INC
Non-Qualified Stock Option (right to buy)
M - Exercise -16,494 14,846 -52.63 41.03 -676,693 609,081
2020-01-24 2020-01-22 4 MLHR HERMAN MILLER INC
Common Stock
S - Sale -16,494 5,832 -73.88 41.03 -676,693 239,247
2020-01-24 2020-01-22 4 MLHR HERMAN MILLER INC
Common Stock
M - Exercise 16,494 22,326 282.84 31.86 525,499 711,291
2019-07-18 2019-07-16 4 MLHR MILLER HERMAN INC
Restricted Stock Units
A - Award 2,089 17,345 13.69
2018-07-18 2018-07-16 4 MLHR MILLER HERMAN INC
Restricted Stock Units
A - Award 767 15,256 5.29
2018-07-18 2018-07-16 4 MLHR MILLER HERMAN INC
Non-Qualified Stock Option (right to buy)
A - Award 3,658 3,658
2018-02-13 2018-02-09 4 MLHR MILLER HERMAN INC
Restricted Stock Units
A - Award 12,894 14,489 808.40
2017-07-20 2017-07-18 4 MLHR MILLER HERMAN INC
Restricted Stock Units
A - Award 889 1,595 125.92
2017-07-20 2017-07-18 4 MLHR MILLER HERMAN INC
Non-Qualified Stock Option (right to buy)
A - Award 4,695 4,695
2016-07-21 2016-07-19 4 MLHR MILLER HERMAN INC
Restricted Stock Units
A - Award 706 706
2016-07-21 2016-07-19 4 MLHR MILLER HERMAN INC
Non-Qualified Stock Option (right to buy)
A - Award 4,088 31,340 15.00
2016-07-21 2016-07-19 4 MLHR MILLER HERMAN INC
Non-Qualified Stock Option (right to buy)
A - Award 27,252 27,252
2015-12-23 2015-12-21 4 MLHR MILLER HERMAN INC
Common Stock
P - Purchase 3,000 3,000 28.36 85,088 85,088
P
Open market or private purchase of non-derivative or derivative security
S
Open market or private sale of non-derivative or derivative security
A
Grant, award, or other acquisition of securities from the company (such as an option)
C
Conversion of derivative
D
Sale or transfer of securities back to the company
F
Payment of exercise price or tax liability using portion of securities received from the company
G
Gift of securities by or to the insider
K
Equity swaps and similar hedging transactions
M
Exercise or conversion of derivative security received from the company (such as an option)
V
A transaction voluntarily reported on Form 4
J
Other (accompanied by a footnote describing the transaction)