DC4MS

DestinationClubForums.com is proud to announce the release of their new Exclusive Resorts Comprehensive Membership Analysis Tool (version 1.0).

Rather than create a single Excel spreadsheet template that encompasses every Destination Club, we decided to focus our efforts on creating the ultimate membership analysis tool for individuals considering membership in Exclusive Resorts as there are many unique variables that are unique to this club.

The Excel spreadsheet templates have all the new Exclusive Resorts membership fees and options already entered and users can manipulate several variables and observe the immediate changes in the variety of reporting categories. We used Microsoft Excel 2007 to create the first version and then saved the file as an Excel 97-2003 version for individuals that decided not to upgrade their Microsoft Office software.

There are two different worksheet tabs to allow different forecasts for a variety of purposes depending on the individual opinion on the value of the opportunity costs of membership. There are several situations where this may or may not be beneficial. In addition, the annual dues are FIXED to the May 2008 rates, are not increased, even though they may increase yearly due to inflation.

The First worksheet tab (ER Membership Analysis) is the simplest and cleanest layout as it presents data to an individual that is not interested in factoring any opportunity costs for the membership fees. This analysis only requires user input for the "Duration of Membership" and the "Optional Holiday or Family" membership prices. The Total membership fees required (including first year dues) summarizes the initial cost to join Exclusive Resorts.

The Second worksheet tab (Opportunity Costs) is more complex as it presents data to an individual that is interested in factoring opportunity costs for the membership fees and this rate is Compounded Annually. This analysis requires user input for the "Opportunity Costs" along with the "Duration of Membership" and the "Optional Holiday or Family" membership prices. There is also a Total percentage of membership fees refunded analysis that accounts for the non-refundable nature of the membership options.

Please download this file, experiment with the variables, and post your opinion, observations, problems, bugs, or suggestions here.

DC4MS

Great News!

I have just finished the "Exclusive Resorts Comprehensive Membership Analysis Tool" - version 2.0.

Yes, I know that version 1.0 was just released last week, but I have added a ton of cool improvements and have decided to release it only in the Microsoft Excel 97-2003 compatibility mode as many people have not upgraded to the Microsoft Office 2007 version yet and it is too time consuming to try to make two separate versions....Thanks Microsoft for making everything so difficult.

Thanks to everyone that downloaded version 1.0 and sent me feedback for improvements. I think I added every requested feature....that is until version 3.0.

Enjoy!

.

Attached Files

Exclusive Resorts Membership Analysis (Version 2).xls (58.0 KB, 36 views)

3DH

You might need to update the holiday surcharges, as I think they have changed... see new pricing here:

Select Holiday: Priority access for one reservation each year for the weeks that include Spring Break, the 4th of July holiday, or Thanksgiving is available for a one-time fee of $49,000.

Peak Holiday: Priority access for one reservation each year for the weeks that include Christmas, New Year's, President's Day, or any Select Holiday week is available for a one-time fee of $79,000.

__________________
"Boutique" is better! Another extremely satisfied LUSSO member!

DC4MS

Thanks...this must have been a quiet change as I did not receive any advanced notice.

Here is the newly edited version of our Exclusive Resorts Comprehensive Membership Analysis Tool (version 3.0)


.

Attached Files

Exclusive Resorts Membership Analysis (Version 3).xls (58.0 KB, 30 views)