Tuesday, May 17, 2022

Learning What You Pay For?

The chart below shows the top 30 colleges according to US News rankings and their respective tuition and fees. Schools below the linear regression are theoretically a better than average deal relative to the group, while those above the line might be supposed to be a worse than average deal. (This assumes a uniform distribution in quality, e.g. the difference between the first and second rank is the same as the difference between the second and third, etc.) Five of the top ranked schools are public: University of Michigan - Anne Arbor, University of Virginia, and the Los Angeles, Berkeley, and Santa Barbara campuses of the University of California. For these schools the out-of-state tuition rates were used. In some cases two or more colleges tied for a rank. It would appear that Princeton is the best deal at $56,010, while Tufts is the most overpriced of the group at $63,000. 





 

Wednesday, March 9, 2022

Crime in Minneapolis and Crime in the Nation

Has crime in Minneapolis gotten out of control? One side of this debate cites crime statistics that are far greater than (recent) historical averages, while the other side argues that crime has increased throughout the country and that attention to local policy is therefore unfounded. The chart below shows the change in homicide rates from 2010 to 2020 using 2010 as the baseline. Overall, the national rate increased by 35% over this period, while the Minneapolis rate increased by 102%. The Minneapolis chart shows more volatility, but the change from 2019 to 2020 still appears to be a divergence. Comparing Minneapolis to other cities may also be useful.


Figures for United States Data:

0.00%
-2.08%
-2.08%
-6.25%
-8.33%
2.08%
12.50%
10.42%
4.17%
6.25%
35.42%
Figures for Minneapolis Data:
0.00%
-6.70%
10.78%
5.74%
-17.03%
27.83%
-8.90%
12.18%
-20.37%
13.86%
102.01%

Tuesday, November 9, 2021

Multiples and Returns of Nine Communication Services Stocks

I have previously compared multiples and returns for stocks without isolating for a specific sector. The results were not particularly useful. PEG ratio was the only multiple that predicted stock performance in the "proper" direction, and it didn't do so with much consistency. I thought that if I analyzed a single sector, the results would be more meaningful. I compared the same multiples and tracked returns from the opening price on June 28, 2021 to the closing price on November 5, 2021 for nine large/mega cap stocks in the communication services sector (dividends were added to the returns). The results were not much better. The linear regression for PEG ratio and price/forward earnings for 2021 were the only multiples that produced the expected negative slopes. PEG ratio predicted positive returns more consistently than price/forward earnings. It might be worth noting that six of the nine stocks had negative returns, but those data points should still be valid; a useful multiple should predict the stocks that will lose the least value during a downturn as well as predicting those that will gain the most in a bull market. 








Friday, October 15, 2021

Addicted to Low Interest Rates?

 The charts below show the product of the effective federal funds rate and the unemployment rate on a monthly basis. The Federal Reserve is tasked with promoting "maximum employment and stable prices". Generally, it will try to move the federal funds rate lower when unemployment is high, and higher when unemployment is low, but these charts appear to support my feeling that near-zero rates have become the default. I made three charts: one beginning with 1990, one beginning with 2008, and one beginning with 2009. The most recent observation had the effective federal funds rate at .08 while the unemployment rate was 4.8 for a product of .384. While the federal funds rate has gone lower than this a few times, never has it done so with such a low unemployment rate. 










Sunday, September 19, 2021

Will Choi Reduce Racial Disparity?

 On September 8 Ramsey County Attorney John Choi “announced that his office would no longer prosecute most felony cases arising from low-level traffic stops, an effort aimed at reducing racial disparities in the criminal justice system,” the Star Tribune reported. The article states that “his office will decline to prosecute felony cases — such as those involving illegal possession of drugs or firearms — if evidence is discovered during a traffic stop for a nonpublic safety violation like expired tabs, objects dangling from mirrors or a burned-out taillight. The policy makes exceptions for cases that endanger public safety.” I'm struggling a little with Choi's apparent belief that illegal possession of firearms generally does not endanger public safety. Second amendment advocates should have a field day with this; how can anyone justify increasing gun regulation for the law abiding when it is now enshrined in policy that gun laws (at least in some cases) will not be enforced for criminals. What I wondered, however, is whether evidence supports the claim that moving police focus away from routine traffic stops will in fact reduce racial disparities in the criminal justice system. I looked at the 2019 arrests by offense and race from the Uniform Crime Reporting Program. The chart below shows the offenses sorted from highest to lowest by the percent of those arrested who are white. 


Note that 'property crime' and 'violent crime' are aggregates of other crimes listed; the data presented here is not focused on number of arrests, rather it is focused on the tendency of arrests for specific crimes to predominately affect white or non-white people. There may be some disparity between the way that law enforcement and the census bureau collect data about race, but according to the census 76.3% of the country was 'white alone' in 2019, implying that white people are overrepresented in arrests for just three types of offenses: driving under the influence, liquor laws, and suspicion. You may be wondering what 'suspicion' is. The FBI defines it as “Arrested for no specific offense and released without formal charges being placed.” Out of arrests for all crimes in 2019, 69.4% of those arrested were white. Nine types of offenses exceeded 69.4% for white arrests. 




So how is John Choi's plan likely to impact the racial breakdown of who gets prosecuted? Weapons offenses rank fourth from the bottom (55.6% white), so dropping these charges may reduce racial disparity in prosecution. But drug arrests rank sixth from the top (71.2% white), so a shift away from drug enforcement is unlikely to have much impact on the disparity. It strikes me that the crime most heavily weighted toward white arrests, driving under the influence, would probably be a common arrest during routine traffic stops. Isn't an open alcoholic beverage container or slurred speech one of the most likely pieces of incriminating evidence police might notice while looking through the window of a pulled over car? At the other end of the list, robbery and murder are the crimes least likely to involve the arrest of a white person, and by a large margin: 44.7% and 45.8% respectively. I suppose police might sometimes notice items that had been reported as stolen in a pulled over car, but I think this would be somewhat rare. If police find a dead body during a routine traffic stop, I would think that Choi would still carry out the prosecution. I guess I could be wrong.


One might question whether Choi is stepping outside his responsibilities. People sometimes accuse judges of 'legislating from the bench'; is Choi legislating from the attorney's office? Granted, there are probably many examples of elected leaders trying to influence policy in other areas of government, and discretion in prosecution is nothing new. In this case, however, Choi's concern apparently is not that those accused don't deserve to be prosecuted, but rather that he wants to persuade police departments to modify their policies on routine traffic stops. Aside from the question as to whether elected city leaders should be making decisions about how to run their police departments rather than Choi, I think there is a question about who suffers as a result of Choi's lesson to police departments. Assuming that prosecution really does reduce crime, Isn't it the general public that suffers for the sake of Choi's use of the attorney's office to manage police departments?

Thursday, July 29, 2021

Housing: more bubbles?

 I decided to update the data from the post I made in February about Minneapolis home prices. In that post I charted the yearly change in the Case-Shiller Minneapolis Home Price Index using December-December numbers. Obviously, December data for 2021 isn't available, so I made a new chart using April-April data. For example, the bar for 2020 represents the change in home prices from April 2020 to April 2021. Changing the observed month has resulted in some notable changes to the chart. For example, 2009 moved from -2.0% to 10% by observing April rather than December. The trend of escalating recent price increases, however, remains. With the updated data, there are now only three years, rather than four, of increases greater than the most recent year. Moreover, the mean yearly increase was 4.2%, meaning that the last two years have been above average, with the most recent year more than double the average. 


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. 

Sunday, February 28, 2021

Housing Bubble?

 The chart below shows the yearly percent change in the Case-Shiller Minneapolis Home Price Index from 1990 to 2020 (using December to December numbers). The 10.2% increase in 2020 was big, but four of the 31 years analyzed had even bigger increases. The 2020 increase can still be viewed as unique, given that it happened during a recession. The other big increases happened in 2012, during the recovery from the Great Recession, and 1999 to 2001, around the time of the Dot-com bubble. The mean yearly change is 3.92%.



Tuesday, February 16, 2021

Meaning of The Killing of a Sacred Deer

This post contains spoilers for The Killing of a Sacred Deer.


Some have identified the meaning of Yorgos Lanthimos' movie The Killing of a Sacred Deer as detailing a tragedy of karmic fate. Steven caused the death of Martin's father; the movie has us watch the painful march toward an inevitable rebalancing of this transgression, despite all attempts to deny it or avoid it. In reality, the meaning is more complicated than this. The Killing of a Sacred Deer is about the hollowness of vengeance, and the search for meaning in familial relationships. The eating habits of the characters are key to demonstrating this. When we see Steven and Martin eating together at the diner, Steven asks Martin if he is going to eat his fries. Martin explains that he really likes fries and is saving them for last. Steven says that he does the same thing. Later in the movie, Martin is eating spaghetti, and recalls to Anna that he was once told that he eats spaghetti just like his father does. Martin explains that he later found out that everyone eats spaghetti the same way, and that he was even more disappointed by this realization than he was when learning that his father had died. Finally, at the end of the movie, we see the Murphy family eating at the diner while Martin sits at the counter. We see Kim eating her fries without a bite taken from her hamburger. It's easy to view Martin's role in the movie as a messenger from the karmic forces of the universe, but things might make more sense if we view him as more of a protagonist. Martin wanted Steven to replace his father. He took their commonality in the way they eat fries as a sign that such a relationship was warranted. Martin believed that with Bob dead, he would be able to take Bob's place in the Murphy family. The final scene illustrates the hollowness of Martin's vengeance. The family remains together, and Martin remains separate, sitting alone at the counter, and furthermore, vexed that Kim retains her place in the family despite the fact that she doesn't eat fries the way her father does. 

Sunday, January 31, 2021

What is a WallStreetBets?

 The GameStop (GME) saga is certainly unprecedented, at least in some ways, but some have ascribed an anti capitalist narrative to it that really isn't accurate. I have actually followed the WallStreetBets Reddit sub since late 2019, back when it had fewer than a million members. While it may have some complaining of 'hedge fund manipulation', it is anything but anti capitalist. Political discussion is officially not allowed on the sub, but I would describe the users as generally pro Trump. Moreover, discussions on the sub are laced with pejorative use of the words 'gay' and 'retard', and the humor that dominates the sub would be found to be offensive by many on the political left. In fact, what permeates the sub more than anything else is an idolization of wealth. In fact, Martin Shkreli ("Pharma Bro") was supposedly active on the sub before going to prison. I can't confirm whether Shkreli really posted on the sub, but I can say that he is still well regarded by WallStreetBets members. I don't really state these things to say that I have any ill will toward WallStreetBets members, I think a lot of them are just young people who might be a little misguided, but my point is that the narrative that some people have ascribed to them is not accurate. 

The second point that must be made, and perhaps the more important one, is that people should seriously consider whether demanding that Robinhood allow unrestricted trading on GME is irresponsible. The most revered style of trade in the WallStreetBets community is the 'YOLO'. This generally means a high risk/high reward options play that someone places a large amount of money into. Often, the implication is that they are using all the money available to them. In some cases, this includes maximum margin, student loan money, and maxing out credit cards. Granted, this may just be talk, but in the case of GME, the fervor is so intense that I think many actually did this. I don't see any reason that Robinhood would want to protect hedge funds. The reasons they stated for restricting trading appear to be true. Ironically, the first time Robinhood and WallStreetBets were in the news together, it was because a WallStreetBets user had opened a box spread position that he didn't understand the risks of. It put him about $58,000 in debt, and Robinhood was harshly criticized for allowing such high risk trades on its platform. 

This brings me to the third point, the question of how this will all end. There are plenty of financial journalists doing much more in depth analysis than I have, but I will make a few comments about the future of GME. Firstly, many people have referred to a hedge fund going bankrupt, and this needs to be corrected. Melvin Capital and Citron both remain solvent after closing their short positions on GME. According to S3 Partners, the value of GME stock held short is about the same as it was before the short squeeze. Many on WallStreetBets are convinced that Melvin Capital didn't really close their position. This doesn't make sense, because then there would not have been a short squeeze. More likely, is that other hedge funds have taken new short positions. It is likely that the new short positions were taken by larger funds that have calculated the risk of another short squeeze, and feel confident. Given that the stock has gained about 600%, one could calculate that generating another short squeeze would require six times the money. Moreover, some of those GME holders might be paying 18% interest on the credit cards they used to finance their purchases. And of course, I can't end the discussion without looking at GameStop's fundamentals. I compared GME to four companies with very similar market capitalizations. (Total Equity is most recent quarter, net income is last reported annual net income)

Company                          Market Cap   Total Equity  Net Income

Old Dominion Freight Line (ODFL)    22.8B        3.17B         616M

SVB Financial Group (SIVB)          22.7B        8.22B        1.21B

PG&E (PCG)                          22.7B        20.8B       -7.64B

Gamestop (GME)                      22.7B         332M        -471M

Coupa Software (COUP)               22.4B         413M       -90.8M

Surprisingly, GME doesn't look too bad in this group, but at the rate it is loosing money, total equity will be negative before the end of the year. 

There is another discussion that could be had about whether short selling is actually bad. The upward pressure when short sellers buy to cover counters the downward pressure from the short sale, so I don't think long term investors should be concerned about shorting. In the end, companies don't go bankrupt because of short selling or a decline in stock price generally. Companies go bankrupt because people stop buying their products.

Tuesday, November 17, 2020

The Bachelorette - Season 16

I've posted a lot about politics and economics on here, and I thought I should switch to something more serious: predictions for the current season of The Bachelorette. Tayshia has just replaced Clare, and as of yet has not eliminated anyone. 

 Episode 6 updates:

I guess I was expecting Ed, Noah, and Demar to be gone earlier, but the bracket still looks good.

Episode 7 updates:
I still have no upsets in the bracket, but I'll really need Ed, Noah, and Demar to go home this week to maintain that status.



Tuesday, September 15, 2020

2016 Electoral Analysis

I again made a chart designed to help estimate the likelihood of the incumbent president's reelection. The percent vote margin in the 2016 presidential election is shown for each state (note that a few states separate Congressional Districts in the electoral process). The states are shown in order with the strongest margin for Clinton on the left, and the strongest margin for Trump on the right. The number after each state name is the number of electoral votes for that state. Trump's margin of victory was 74 electoral votes, meaning that half that number (37) electoral votes will need to move from Trump to the Democrat for Trump to lose in 2020. Based on this data, this would most easily happen with three states (Michigan, Pennsylvania, and Wisconsin) moving from Trump to the Democrats. Without looking at any polls, I would estimate that this is a possibility. Trump won these states largely because of promises of manufacturing and mining jobs. While Trump did achieve a lot of economic growth and low unemployment before the pandemic started, the largest job growth was actually in healthcare and education. Mining and manufacturing actually continued to lose jobs. On the other hand, the Democrats have continued to blunder their way through the election, showing no signs of a winning strategy, and failing to identify galvanizing candidates. 


Friday, August 7, 2020

Gold, Copper, Natural Gas, Oil

Many people watching federal debt levels and Federal Reserve policy are bracing for inflation as far as the eye can see, but is the ‘buy gold’ mantra really the best way to go given the current situation? I compared one year of futures prices for gold, copper, oil, and natural gas. With gold near all-time-highs, and oil still far below last year’s prices, oil may have more upside potential. Moreover, I think there is strong political will for massive infrastructure spending, so a commodity that benefits from industrial activity is likely to perform well. I think there is a strong case for oil producers being the winners for the second half of 2020.
 

Wednesday, August 5, 2020

Multiples and Total Return for 33 Mega Cap Stocks

Multiples are a key part of fundamental analysis used in stock picking. There is some debate over which multiples are best, or whether any of them are really useful. I put data for seven multiples into a spreadsheet for 33 of the highest market cap stocks traded on US exchanges. (I attempted to analyze the highest market cap stocks, but a a few were excluded because incomplete data was available for them.) I obtained the multiple data on Sunday, November 10 (primarily from TD Ameritrade). I calculated the total return (including dividends) supposing someone bought at the opening price on November 11, 2019, and sold at the closing price on August 4, 2020. I then charted the results for each multiple. The results were not promising for people who use multiples to invest. The linear regressions should be expected to have negative slopes, but this was only the case for PEG ratio. In other words, companies with low earnings and low book values had better returns for investors. I think I'll check the returns after a full year before I start buying stock with the lowest earnings I can find. 





Friday, July 17, 2020

Percentage of Deaths Caused by Covid-19

I calculated the percentage of all deaths reported by the CDC that involved Covid-19. The data was last updated July 16. The total number of deaths is much lower for recent weeks because of a lag in processing of death certificates, but unless the lag for Covid-19 involved deaths is greater than deaths from other causes, the percentages still indicated that the pandemic (as measured by number of deaths) peaked in mid April and is now in decline. Reporting of surging infection rates is probably mostly a result of increased testing, but the discrepancy between number of infections and number of deaths is likely also due to improved treatments and the fact that new infections may be affecting healthier populations as compared to those infected in April.

Week    All Deaths  Deaths From  Percentage of Deaths Caused by
Ending  Involving   All Causes   Covid-19
        Covid-19
04/18/20   16928    76133        22.2%
04/25/20   15261    73060        20.9%
05/02/20   12997    68319        19.0%
05/09/20   10983    65572        16.7%
05/16/20    8972    62896        14.3%
05/23/20    6984    59608        11.7%
05/30/20    5921    56843        10.4%
06/06/20    4738    55281         8.6%
06/13/20    3863    53233         7.3%
06/20/20    3258    51142         6.4%
06/27/20    2501    46892         5.3%
07/04/20    1440    36602         3.9%
07/11/20     413    19408         2.1%

Tuesday, June 23, 2020

Minnesota and Racial Disparity

Criticism of Minnesota's racial disparities is not new, but the murder of George Floyd and ensuing protests and riots have amplified the attention these disparities are getting from news media. According to US News, Minnesota ranks 43rd in terms of equality as measured by racial income gap. That's pretty bad, but it should be noted that California (the most populous state) ranks 48th. A popular inference seems to be that Minnesota's high racial disparity indicates a greater level of racism in Minnesota (despite Minnesota's 'liberal facade'). I live in Ward 9 of Minneapolis, which is where George Floyd was killed. With the exception of Donald Trump and Mike Pence, every elected politician representing Ward 9 is a Democrat. That includes the city council, mayor, county commissioner, members of Congress, governor, lieutenant governor, secretary of state, state auditor, and state attorney general. I will also note that of these 13 elected politicians, two are Latina, one is Native American, and four are black. I decided to compare Minnesota to the five states with lowest racial income gap. In order starting with the lowest gap, these are: New Hampshire, Kentucky, Virginia, Missouri, and Washington. I'll preface this by saying that I don't claim to have a definitive measurement of racism, but I do think the judgement that Minnesota is particularly racist may be ignoring the context of the situation. Firstly, we'll consider the percentage of the vote Donald Trump received in these states in 2016:
New Hampshire 46.61%
Kentucky      62.52%
Virginia      44.41%
Missouri      56.77%
Washington    36.83%
Minnesota     44.92%
Of course, Donald Trump and Hillary Clinton are both white. I also analyzed the propensity for non-white people to be elected to Congress by these states. The first numeric column is the percentage of the congressional delegation that is non-white. The second is the percentage of the state's population that is non-white (2019 estimate). The last column is the ratio of non-white people in the congressional delegation to non-white people in the state.
               CD          Population          Ratio (CD/Population)
New Hampshire   0           6.11%               0
Kentucky        0          12.21%               0
Virginia       15.38%      31.42%               .49
Missouri       20.00%      17.21%              1.16
Washington     16.67%      22.73%               .73
Minnesota      10.00%      14.70%               .68
The data from this measure is limited because of the small size of some of the congressional delegations. New Hampshire and Kentucky have all white congressional delegations, but these delegations only consist of four and eight people, respectively. The ratio in the last column indicates the degree to which non-white people are underrepresented in the delegation (or, curiously in the case of Missouri, overrepresented). The data suggests that non-white politicians in Minnesota have a greater propensity for being elected than three out of the five 'most equal states' (after adjusting for the demographics of the state). 
The final statistic I will consider is the change in the proportion of black residents in these states. These are the percentages of 'black or African American alone' for 2000 and 2010, and the percent change of these proportions:
                 2000    2010    Percent Change
New Hampshire    .73%     1.14%  56.16%
Kentucky        7.32%     7.78%   6.28%
Virginia       19.64%    19.39%  -1.27%
Missouri       11.25%    11.58%   2.93%
Washington      3.23%     3.57%  10.53%
Minnesota       3.49%     5.17%  48.14%
While New Hampshire experienced the most rapid increase in its black population, at 1.14% in 2010, the number remains very low. The rate at which Minnesota's black population is increasing is far faster than any of the other four states. While many have decried Minnesota as a bad place for black people to live, the fact remains that black people continue to move there. Other factors, such as birth rate or even emigration of other races, may have had an impact, but with Minnesota's black population increasing 60% over the course of 10 years, it would be reasonable to estimate that most of the black people in Minnesota spent much of their lives in other places. Before states like Kentucky are used as models for Minnesota to remake itself after, other factors impacting racial disparities ought to be considered.