dmunsil
Disney Uber-Nerd
- Joined
- Jan 11, 2008
- Messages
- 1,456
In the home stretch!
These are the resales and ROFRs recorded for May 2013 at Old Key West.
The title companies are Magic Vacation Title (***), First American Title (FAT), and Timeshare Title & More (TTM).
Standard caveats apply:
- The date listed is the date on the deed, which is typically shortly after the ROFR waiver comes. The actual price was negotiated 3-4 weeks prior, so these prices are lagging about 2 months.
- The price is calculated from the Florida deed document tax, which gives the price to the next highest multiple of $100. As a way of trying to compensate for that, I've rounded all of the prices down to the nearest dollar, which I think is right more often than not.
Median sale price was $61. Median ROFR price was $60.
Looking at the mean rather than the median they separate more, to $62.68 and $57.57, respectively. The median has always made more sense to me when analyzing these numbers, but I can't articulate why, other than it's thrown off less by outliers. Can anyone think of a good reason to report the mean rather than the median?
Another thing that makes the comparing the sales and ROFR averages (whether mean or median) problematic is that they cover a different time period. Disney is very slow about filing their ROFR deeds, either because it's not a high priority or because they don't want people to know what they're ROFRing. So the ROFR numbers lag the sales numbers by 3-4 weeks. If I had a longer data set, it would probably make more sense to report by months using the dates on the deeds. But then more deeds from earlier months would come rolling in, requiring going back and adjusting the previous numbers. So grouping them by recording dates is easier.
These are the resales and ROFRs recorded for May 2013 at Old Key West.
The title companies are Magic Vacation Title (***), First American Title (FAT), and Timeshare Title & More (TTM).
Standard caveats apply:
- The date listed is the date on the deed, which is typically shortly after the ROFR waiver comes. The actual price was negotiated 3-4 weeks prior, so these prices are lagging about 2 months.
- The price is calculated from the Florida deed document tax, which gives the price to the next highest multiple of $100. As a way of trying to compensate for that, I've rounded all of the prices down to the nearest dollar, which I think is right more often than not.
Code:
Sales:
Date Points UY Sale PPP TitleCo
16-Apr 300 Feb $55.00 ***
19-Apr 50 Sep $68.00 ***
19-Apr 50 Feb $66.00 ***
20-Apr 100 Jun $62.00 ***
20-Apr 200 Jun $60.00 ***
23-Apr 100 Feb $66.00 ***
23-Apr 440 Feb $63.00 ***
23-Apr 100 Feb $65.00 ***
25-Apr 230 Apr $60.00 TTM
25-Apr 310 Apr $66.00 TTM
25-Apr 900 Oct $55.00 ***
25-Apr 210 Dec $57.00 ***
26-Apr 100 Oct $60.00 FAT
26-Apr 300 Apr $59.00 TTM
28-Apr 460 Sep $54.00 TTM
30-Apr 50 Feb $68.00 ***
30-Apr 232 Dec $58.00 ***
2-May 344 Sep $59.00 ***
6-May 80 Feb $67.00 ***
6-May 200 Dec $60.00 ***
7-May 150 Dec $60.00 ***
13-May 250 Mar $60.00 TTM
14-May 210 Dec $57.00 ***
16-May 40 Feb $70.00 ***
21-May 210 Aug $78.00 TTM
24-May 50 Apr $68.00 ***
24-May 180 Apr $62.00 ***
24-May 50 Aug $72.00 ***
ROFR:
Date Points UY Sale PPP
6-Apr 232 Jun $47.00
18-Apr 120 Sep $60.00
18-Apr 55 Sep $65.00
22-Apr 60 Mar $58.00
23-Apr 210 Mar $51.00
25-Apr 230 Jun $60.00
29-Apr 230 Jun $62.00
Median sale price was $61. Median ROFR price was $60.
Looking at the mean rather than the median they separate more, to $62.68 and $57.57, respectively. The median has always made more sense to me when analyzing these numbers, but I can't articulate why, other than it's thrown off less by outliers. Can anyone think of a good reason to report the mean rather than the median?
Another thing that makes the comparing the sales and ROFR averages (whether mean or median) problematic is that they cover a different time period. Disney is very slow about filing their ROFR deeds, either because it's not a high priority or because they don't want people to know what they're ROFRing. So the ROFR numbers lag the sales numbers by 3-4 weeks. If I had a longer data set, it would probably make more sense to report by months using the dates on the deeds. But then more deeds from earlier months would come rolling in, requiring going back and adjusting the previous numbers. So grouping them by recording dates is easier.