Thursday, June 17, 2021

Change in Minneapolis Homicide Rate

There has been some discussion about increasing crime in Minneapolis and whether there is a causal relationship between policy and crime rates. Changes in Minneapolis police policy have mostly amounted to rhetoric. The funding cut made to the Police Department last year was less than 1% of the department's budget. Despite this, the rhetoric appears to have had an impact; many officers have left the job apparently due to low morale. The chart below shows the year-over-year difference in the Minneapolis homicide rate for months from January 2020 to May 2021. Crime rates are usually much higher in summer months, but these numbers are year-over-year (for example, the January 2020 data point is the increase from January 2019), so they can be thought of as "seasonally adjusted". The rates are per 100,000 population.

 I should also clarify that these are increases in the rate, not percentage increases. The total homicide rate peaked in August 2020 at 4.18. The national murder/nonnegligent manslaughter rate according to the FBI was 5.0 for both 2018 and 2019 (the 2020 numbers are not yet available), but that's an annual rate. The annual rate for Minneapolis was 10.7 in 2019. Based on the numbers I obtained from the City of Minneapolis website, the 2020 rate should be 21.7. This is alarming seeing as it is much higher than any other year in recent history, but to keep things in perspective, the Jackson, Mississippi rate was 46.5 in 2019. Minnesota has the sixth lowest homicide rate in the country, but the geography of Minneapolis makes its crime statistics appear worse than they actually are. A large percentage of the metropolitan population resides in suburbs, thereby skewing the official population of Minneapolis. On the topic of population, the data here is based on the official 2019 and 2020 population estimates, 435,885 and 382,618 respectively. Yes, this suggests that the city's population decreased 12%. This may partly be due to differences in the way the estimates are made. The 2019 estimate is a projection from the 2010 census, while the 2020 number is based on the 2020 census. Still, I think it is reasonable to assume that the pandemic did result in some population decrease in Minneapolis, particularly because of fewer college students residing in the city. For 2021 I used the 2020 population number. 

Tuesday, May 18, 2021

Multiples and Return for 32 Mega Cap Stocks

 In August last year I published Multiples and Total Return for 33 Mega Cap Stocks. The results of my analysis then, which tracked the returns of stocks from November 2019 to August 2020, showed that only PEG ratio correlated with returns in the expected direction. For the charts below, I used the same multiple and entry point data, but extended to a much longer exit point. I assumed the stocks would be sold at the April 23, 2021 closing price. The results were not fundamentally different. Again, PEG ratio was the only multiple with a negative slope for its linear regression. I'm still hesitant to jump to the conclusion that multiples are not useful. Three of the four best performing stocks were in the information technology sector. All four of the financials sector and all four of the consumer staples sector stocks were in the bottom 18 performing stocks. This may suggest that, for the time frame analyzed, sector rotation drove performance more so than multiples. In a future analysis, I may compare performance and multiple correlation within a sector. 

Some notes on the data:

The new analysis compares only 32 stocks rather than the original 33 because China Mobile Ltd was delisted.

I should clarify that where I've used the term 'total return' I meant the simple stock appreciation plus dividends; I did not make any calculations for reinvestment of dividends. For the time period and stocks selected I don't think dividend reinvestment would make a meaningful difference to the outcome. 

The data here for Apple (AAPL) is split adjusted.









Tuesday, April 27, 2021

Timing the Market

 "Don't try to time the market" is some of the most frequently given advice to beginner investors. I decided to do some testing of the theory against a frequently discussed strategy: "buy the dip". I backtested investing in Apple from February 24, 2020 to February 8, 2021. I assumed that one investor (the anti timer) bought one share at the opening price every Monday, while a second investor (the dip buyer) bought one share at the opening price on the first day following a down day (a day with a closing price lower than the previous close). The logic here is that an investor might identify a stock they are bullish on over the weekend. The anti timer would simply buy as soon as possible, while the dip buyer would wait for the price to decline. If the Friday before that weekend was a down day, then I assume both the anti timer and dip buyer would buy at the Monday opening price. I ignored weeks with a market holiday, and weeks with an ex-dividend date. 

The anti timer outperformed the dip buyer in this analysis. The dip buyer paid a lower price in only six of the 39 weeks. The anti timer paid a total of $3,896.64, while the dip buyer paid $3,908.43 for the 39 shares. The close on February 12, 2021 (the final week of this analysis) was 135.37, making the 39 shares worth $5,279.43. Ignoring dividends, that is a 35.5% gain for the anti timer, and a 35.1% gain for the dip buyer. Not a huge difference. The logic against buying the dip is that equities generally increase over time, and the dips are unpredictable, so it is best to simply buy as early as possible. While this analysis confirms that, I wouldn't rule out the possibility that a more sophisticated dip buying strategy may be effective. This might be a topic for a future post. 

The six instances of the dip buying strategy paying a lower price are in bold.

DateMonday OpenFirst Dip Open
Feb 24, 2074.3271.63
Mar 2, 2070.5770.57
Mar 9, 2065.9465.94
Mar 16, 2060.4961.85
Mar 23, 2057.0257.02
Mar 30, 2062.6962.69
Apr 13, 2067.0871.85
Apr 20, 2069.4969.49
Apr 27, 2070.4571.18
May 11, 2077.0378.04
May 18, 2078.2579.17
Jun 1, 2079.4479.44
Jun 8, 2082.5686.18
Jun 15, 2083.3187.85
Jun 22, 2087.8487.84
Jul 6, 2092.594.18
Jul 13, 2097.2794.84
Jul 20, 2096.4296.42
Jul 27, 2093.7193.71
Aug 10, 20112.6112.6
Aug 17, 20116.06116.06
Aug 24, 20128.7126.18
Aug 31, 20127.58127.58
Sep 14, 20114.72114.72
Sep 21, 20104.54104.54
Sep 28, 20115.01113.79
Oct 5, 20113.91113.91
Oct 12, 20120.06121
Oct 19, 20119.96119.96
Oct 26, 20114.01114.01
Nov 9, 20120.5120.5
Nov 16, 20118.92118.61
Nov 30, 20116.97122.6
Dec 7, 20122.31122.31
Dec 14, 20122.6122.6
Jan 4, 21133.52133.52
Jan 11, 21129.19128.5
Jan 25, 21143.07139.52
Feb 8, 21136.03136.03
Total3896.643908.43

Wednesday, March 17, 2021

Monopoly Strategy

 Most people think it is all about Boardwalk and Park Place, but designing an algorithm for winning Monopoly is fairly complicated. Listed below is every property along with its location on the board, price, rent, price/rent ratio, and intrinsic value, which is the price the property would cost to make the price/rent ratio equal 12.14 (the average for all properties). For the utilities, I assume the dice roll is seven (which should be the average when rolling two dice). The big caveat here is that I didn't consider the various ways of increasing the value of a property (getting both utilities rather than one, multiple railroads, monopolies, houses, and hotels). Some might argue that additional value should be assigned to Mediterranean, Baltic, Park, and Boardwalk because they only require two purchases to get a monopoly. 

PropertyLocationPriceRentPrice/RentIntrinsic Value
Mediterranean Avenue16023024
Baltic Avenue36041549
Reading Railroad5200258303
Oriental Avenue610061773
Vermont Avenue810061773
Connecticut Avenue912081597
St. Charles Place111401014121
Electric Company12150285340
States Avenue131401014121
Virginia Avenue141601213146
Pennsylvania Railroad15200258303
St. James Place161801413170
Tennessee Avenue181801413170
New York Avenue192001613194
Kentucky Avenue212201812218
Indiana Avenue232201812218
Illinois Avenue242402012243
B. & O. Railroad25200258303
Atlantic Avenue262602212267
Ventnor Avenue272602212267
Water Works28150285340
Marvin Gardens292802412291
Pacific Avenue313002612316
North Carolina Avenue323002612316
Pennsylvania Avenue343202811340
Short Line 35200258303
Park Place373503510425
Boardwalk39400508607
Average


12.14

People might be surprised that Boardwalk did not come in as the best deal, but is tied with Park Place and the railroads behind the best buys on the board: the utilities. I charted the properties by location and price/rent below.

The instinct that the deals improve as one moves toward the end of the board is generally true, but one ironic thing to point out: Mediterranean Avenue (by far the worst deal) is on square 1, so when playing with two dice it will actually on average take longer to land on than any other property on the board.

Tuesday, March 9, 2021

Buying Teslas with Bitcoin

 A brief comment must be made about recent predictions for bitcoin to become some kind of international currency standard. Personally, I've never managed to get excited about a nonproductive asset with no usefulness outside of its perceived value, but a lot of people have gotten excited about it, and made a lot of money with it. Tesla announced last month that it purchased $1.5 billion worth of bitcoin, and plans to start accepting it as payment. Below is a chart comparing bitcoin futures to the Euro/Dollar over the last year. 


What I'm trying to understand is the fact that predictions for bitcoin adoption seem to be tied to its increasing value. For normal currencies, deflation is usually seen as a cause for major concern. One could imagine that if everyone is buying their Teslas with bitcoin, Tesla will have to continually decrease their prices (as the value of bitcoin rises). This will cause buyers to hold off on purchases. Why pay 1 bitcoin for a Tesla this week if it will probably only cost me .9 bitcoin next week? Meanwhile, Tesla is further stressed from the other side of the equation as the price it is now trying to sell cars for is less than what it paid workers and suppliers to build them. By the way, I originally planned to chart a few other major currencies for comparison, but they appeared to have lines pretty much identical to the Euro.