DC4MS

Adam Capes, President of Equity Estates, sent me two spreadsheets that allows the ability to project various scenarios on future membership values.

I originally wanted to create our own DestinationClubForums.com spreadsheet like the others, but these are pretty good.

The spreadsheets shows what Equity Estates membership values could look like based on varying growth assumptions. Please keep in mind that these are forward-looking statements and actual results may vary materially from what is presented. A full disclaimer is on the back page of the Executive Summary and also applies to these spreadsheets.

Enjoy!

DC4MS

Here is a summary of the membership interest value (pro forma) that starts at 2008 and goes to 2021.

The Total number of Full Membership Interests tops out at 300 (estimated in 2012).

The capital contribution for the end of 2008 is estimated at $375,000 and increases to $550,000 in 2012. This indicates a rising price for new members.

The Value of Membership Interest is calculated for 4 different Annual Appreciation of Portfolio rates: 5%, 7.5%, 10%, and 12.5%

There is even a total value with appreciation and dividends included that reflect the potential savings vs renting an equivalent home (at $2,000 per night).

The Estimated Annual dues shows a steady increase from $16,500 per year in 2008 to $26,294 per year in 2021.

.

Attached Files

Summary_of_Memb._Int.__Value_Pro_Forma.xls (26.5 KB, 27 views)

DC4MS

Here is the much more detailed Membership Interest Value pro forma spreadsheet.

This is more interesting as it details the estimated Residence Portfolio Value, the value of membership interest with the accurate commissions deducted, fross liquidation value, and net liquidation value.

The total net profit and ROI are also summarized.

The ROI based on a 5% RE appreciation model grows from 13% in the first year to an impressive 284% after 15 years. Using a 10% appreciation will have a ROI of 377% after 15 years.

.

Attached Files

Membership_Interest_Value_Pro_Forma.xls (58.0 KB, 28 views)