We’re still in first place! But we had to correct a major error. Beware of large spreadsheets. We’re down $21K from last month’s reported value. But that’s because last month (going back to when?) we had an error in the calculation.
Read more great spreadsheet humor and useful information at “Excel Spreadsheets Help”.
We’ve fixed it now. The true accounting shows we are up $17K from last month. But we’ll take the loss for now for the League standing. We are still comfortably in first place:
Oil stayed in 2nd place thanks to the ongoing international crisis in Ukraine. Oil has the distinction of going the lowest ($47,900 in April 2020) during the initial stages of the COVID panic and coming back the highest. And the stock market is hanging in there. We can’t say that for the bond fund. It lost money compared to $100,000 cash in your sock drawer!
Note that we have also added the historical record for all TheMonopolyProject investment options on our “Historical” page. Here’s what it looks like today going all the way back to the inception of TMP in March of 2019.
TOTAL ASSETS = TMPbank_Account + TMP_Valencia
+ TMP2bank_Account/2 + TMP2_29th/2 + TMP2_Crismon/2
Valencia increased by $18K, by the huge runup in monthly prices:
29th Avenue increased by $5K.
Our latest TMP2 property, a condo on Crismon Rd in Mesa, AZ was purchased on 14 January 2022. Overall, we show a modest $5K gain over last month.
One lesson from the spreadsheet error is that you should have someone check your numbers or, even better, have an independent way of checking the number. I should have looked at the value of each house, subtracted the outstanding mortgage and added the bank account value. If I do that (and divide the TMP2 house by 2) our estimate would be (using the numbers above):
Valencia (value-mortgage) plus one half of 29th Ave (value-mortgage) plus one half of Crismon ((value-mortgage) plus bank accounts =
Valencia (362-169) plus one half of 29th Ave (350-180) plus one half of Crismon (355-259) plus 5 =
Valencia (193) plus one half of 29th Ave (170) plus one half of Crismon (96) plus 5 =
193 plus 85 plus 48 plus 5 = 331K versus our spreadsheet value of $331,371.
And we got an offer (and MANY others) to buy Valencia that reinforces our number above:
