DC4MS

DestinationClubForums.com is proud to announce the release of their new Quintess, LRW - 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 Quintess, LRW as there are many unique variables that are unique to this club.

The Excel spreadsheet templates has all the new Quintess, LRW membership fees (including the just announced non-holiday plans) and options already entered and users can manipulate several variables and observe the immediate changes in the variety of reporting categories. This single file will work with all versions of Microsoft Excel.

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 cost of capital for 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 (Quintess Membership Analysis) is the simplest and cleanest layout as it presents data to an individual that is not interested in factoring any capital costs for the membership fees. This analysis only requires user input for the "Duration of Membership," "Holiday Plan Membership," "Additional space available nights, " and the number of "Non-extended family designee" prices. The Total membership fees required (including first year dues) summarizes the initial cost to join Quintess, LRW.

The Second worksheet tab (Capital Costs) is more complex as it presents data to an individual that is interested in factoring capital costs for the membership fees and this rate is Compounded Annually. This analysis requires user input for the "Capital Costs" along with the "Duration of Membership," "Holiday Plan Membership," "Additional space available nights" and "Non-extended family designee" prices. There is also a Total percentage of membership fees refunded analysis that accounts for the non-refundable nature of the membership options for membership years 2-4.

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

Attached Files

Quintess Membership Analysis.xls (70.0 KB, 40 views)

3DH

Nice work, as usual! I am quite impressed with your Excel abilities, to say the least!

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

pvk750

Nice tool. Wow I bumped the cost of capital up to 8% and the prices really jumped, nearly doubled.