Docstoc

Mortgage Amortization

Document Sample
Mortgage Amortization Powered By Docstoc
					c9b84948-4caa-444b-8269-cf9c259a4391.xls                                                 DVC Analysis                                                     7/25/2011, 1:08 AM




                                                                 DVC Mortgage Loan Analysis
                                                    Input Information in all RED cells. If puchase is paid in full, input 100% for downpayment.
                                                                                         Rev January 2007

                      Price and Mortgage Calculations                                                                   Overall Annual Cost Analysis
     Purchased From       (Drop Down Menu)                                       DVC             Resort (Drop Down Menu)                                           SSR
     Number of Points Purchased                                                  200            Date DVC Purchased (mm/dd/yyyy)                            July 1, 2005
     Net Price per Point (after discounts)                                       $85            Date DVC Rights Expiration Date                        January 31, 2052
     Total Purchase (excluding any Closing Costs)                           $17,000             Usable DVC Period in Years                                           46
     Down Payment(Drop Down Menu)                                               100%            Maintenance Dues per Point                                       $4.62
     Down Payment Amount                                                    $17,000             Maintenance Dues First Year                                    $924.00
     Mortgage Principal                                                            $0           Estimated Annual Inflation (Drop Down Menu)                      1.00%
     Fixed Mortgage Interest Rate                                           10.750 %            Historical Dues Inflation (Reference Only)                       3.04%
     Payment Years (Drop Down Menu)                                               7.0           Sum of All Years Increases                                 $13,363.98
     Payments per Year                                                             12           Sum of Annual Dues Until Expiration                        $55,867.98
     Total Number of Payments                                                      84           Sum Purchase, Dues, Interest                               $72,867.98
     Total Interest for Entire Loan                                            $0.00            Possible Total Interest Loss                               $22,686.57
     Total Purchase Cost (Purchase+Interest)                             $17,000.00             Possible Annual Interest Loss                                  $493.19
     Mortgage Start Date                                               Not Applicable           Possible Annual IRS Deduction                                    $0.00
    1st Yr Monthly Mortgage Payment                                            $0.00            Overall Avg Annual Cost                                      $2,077.27
    1st Yr Monthly Payment w/Dues                                            $77.00             Overall Avg Cost w/o Interest Loss                           $1,584.09

                          Overall Cost includes Interest Loss assuming Downpayment deposited in savings at 1% under inflation remains on deposit.
                               Overall Cost is also computed without using Downpayment lost savings, to be used as a simple cost calculation.
                                  Overall and Average costs and inflation factors are over total DVC period and averaged by total years used.
                                 IRS possible deduction credit based upon 20% net bracket, if you are able to claim interest as 2nd mortgage.
                     If "Resale" is selected for Purchased From, $450 is automatically included into total DVC cost and Downpayment for Closing Costs.
                               This is for information/illustration purposes only, no calculations or assumptions or tax estimates are guaranteed.
                                     For "Drop Down Menus", place mouse over cell and Right-click, then select choice from available list.
                                                        For miscellaneous information on each DVC Resort, go to last tab.




                                                                                           1 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                                                DVC Analysis                                                              7/25/2011, 1:08 AM




                                   Loan Amortization Table                                                    Dues Inflation Calculation                     Interest Loss
     Sale Price     Loan Amt        Interest Rate   Loan Payment    Total Paid   Total Interest             Older Properties expire on January-2042           30-Year Mortgage
    $17,000.00       $0.00            10.750%          $0.00       $17,000.00       $0.00              SSR is January-2052. Other may be up to 50-Years.          Maximum


     Payment       Beginning        Mortgage         Mortgage       Ending       Cumulative            Year       Dues       Annual   Annual     Accum      Inflation   Acc Bank
     Number         Balance          Interest        Principal      Balance       Interest                      Inflation     Dues   Increase   Increase    Minus 1%     Interest
         1               $0.00             $0.00           $0.00         $0.00          $0.00           1           1.00%    $924.00 $924.00                    1.00%   $17,000.00
         2               $0.00             $0.00           $0.00         $0.00          $0.00           2           1.00%    $933.24    $9.24       $9.24       1.00%   $17,170.00
         3               $0.00             $0.00           $0.00         $0.00          $0.00           3           1.00%    $942.57   $18.57      $27.81       1.00%   $17,341.70
         4               $0.00             $0.00           $0.00         $0.00          $0.00           4           1.00%    $952.00   $28.00      $55.81       1.00%   $17,515.12
         5               $0.00             $0.00           $0.00         $0.00          $0.00           5           1.00%    $961.52   $37.52      $93.33       1.00%   $17,690.27
         6               $0.00             $0.00           $0.00         $0.00          $0.00           6           1.00%    $971.13   $47.13     $140.46       1.00%   $17,867.17
         7               $0.00             $0.00           $0.00         $0.00          $0.00           7           1.00%    $980.84   $56.84     $197.31       1.00%   $18,045.84
         8               $0.00             $0.00           $0.00         $0.00          $0.00           8           1.00%    $990.65   $66.65     $263.96       1.00%   $18,226.30
         9               $0.00             $0.00           $0.00         $0.00          $0.00           9           1.00%   ########   $76.56     $340.52       1.00%   $18,408.56
        10               $0.00             $0.00           $0.00         $0.00          $0.00           10          1.00%   ########   $86.57     $427.08       1.00%   $18,592.65
        11               $0.00             $0.00           $0.00         $0.00          $0.00           11          1.00%   ########   $96.67     $523.76       1.00%   $18,778.58
        12               $0.00             $0.00           $0.00         $0.00          $0.00           12          1.00%   ######## $106.88      $630.63       1.00%   $18,966.36
        13               $0.00             $0.00           $0.00         $0.00          $0.00           13          1.00%   ######## $117.19      $747.82       1.00%   $19,156.03
        14               $0.00             $0.00           $0.00         $0.00          $0.00           14          1.00%   ######## $127.60      $875.42       1.00%   $19,347.59
        15               $0.00             $0.00           $0.00         $0.00          $0.00           15          1.00%   ######## $138.11    $1,013.53       1.00%   $19,541.06
        16               $0.00             $0.00           $0.00         $0.00          $0.00           16          1.00%   ######## $148.74    $1,162.27       1.00%   $19,736.47
        17               $0.00             $0.00           $0.00         $0.00          $0.00           17          1.00%   ######## $159.46    $1,321.73       1.00%   $19,933.84
        18               $0.00             $0.00           $0.00         $0.00          $0.00           18          1.00%   ######## $170.30    $1,492.03       1.00%   $20,133.18
        19               $0.00             $0.00           $0.00         $0.00          $0.00           19          1.00%   ######## $181.24    $1,673.27       1.00%   $20,334.51
        20               $0.00             $0.00           $0.00         $0.00          $0.00           20          1.00%   ######## $192.29    $1,865.56       1.00%   $20,537.85
        21               $0.00             $0.00           $0.00         $0.00          $0.00           21          1.00%   ######## $203.46    $2,069.02       1.00%   $20,743.23
        22               $0.00             $0.00           $0.00         $0.00          $0.00           22          1.00%   ######## $214.73    $2,283.75       1.00%   $20,950.66
        23               $0.00             $0.00           $0.00         $0.00          $0.00           23          1.00%   ######## $226.12    $2,509.86       1.00%   $21,160.17
        24               $0.00             $0.00           $0.00         $0.00          $0.00           24          1.00%   ######## $237.62    $2,747.48       1.00%   $21,371.77
        25               $0.00             $0.00           $0.00         $0.00          $0.00           25          1.00%   ######## $249.23    $2,996.72       1.00%   $21,585.49
        26               $0.00             $0.00           $0.00         $0.00          $0.00           26          1.00%   ######## $260.97    $3,257.68       1.00%   $21,801.34
        27               $0.00             $0.00           $0.00         $0.00          $0.00           27          1.00%   ######## $272.82    $3,530.50       1.00%   $22,019.36
        28               $0.00             $0.00           $0.00         $0.00          $0.00           28          1.00%   ######## $284.79    $3,815.29       1.00%   $22,239.55
        29               $0.00             $0.00           $0.00         $0.00          $0.00           29          1.00%   ######## $296.87    $4,112.16       1.00%   $22,461.95
        30               $0.00             $0.00           $0.00         $0.00          $0.00           30          1.00%   ######## $309.08    $4,421.24       1.00%   $22,686.57
        31               $0.00             $0.00           $0.00         $0.00          $0.00           31          1.00%   ######## $321.41    $4,742.65
        32               $0.00             $0.00           $0.00         $0.00          $0.00           32          1.00%   ######## $333.87    $5,076.52
        33               $0.00             $0.00           $0.00         $0.00          $0.00           33          1.00%   ######## $346.45    $5,422.96
        34               $0.00             $0.00           $0.00         $0.00          $0.00           34          1.00%   ######## $359.15    $5,782.11
        35               $0.00             $0.00           $0.00         $0.00          $0.00           35          1.00%   ######## $371.98    $6,154.09
        36               $0.00             $0.00           $0.00         $0.00          $0.00           36          1.00%   ######## $384.94    $6,539.04
        37               $0.00             $0.00           $0.00         $0.00          $0.00           37          1.00%   ######## $398.03    $6,937.07
        38               $0.00             $0.00           $0.00         $0.00          $0.00           38          1.00%   ######## $411.25    $7,348.32
        39               $0.00             $0.00           $0.00         $0.00          $0.00           39          1.00%   ######## $424.60    $7,772.92



                                                                                          2 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis                                                  7/25/2011, 1:08 AM




        40                $0.00            $0.00   $0.00   $0.00    $0.00         40   1.00%   ########   $438.09    $8,211.01
        41                $0.00            $0.00   $0.00   $0.00    $0.00         41   1.00%   ########   $451.71    $8,662.72
        42                $0.00            $0.00   $0.00   $0.00    $0.00         42   1.00%   ########   $465.47    $9,128.19
        43                $0.00            $0.00   $0.00   $0.00    $0.00         43   1.00%   ########   $479.36    $9,607.55
        44                $0.00            $0.00   $0.00   $0.00    $0.00         44   1.00%   ########   $493.40   $10,100.94
        45                $0.00            $0.00   $0.00   $0.00    $0.00         45   1.00%   ########   $507.57   $10,608.51
        46                $0.00            $0.00   $0.00   $0.00    $0.00         46   1.00%   ########   $521.89   $11,130.40
        47                $0.00            $0.00   $0.00   $0.00    $0.00         47   1.00%   ########   $536.34   $11,666.74
        48                $0.00            $0.00   $0.00   $0.00    $0.00         48   1.00%   ########   $550.95   $12,217.69
        49                $0.00            $0.00   $0.00   $0.00    $0.00         49   1.00%   ########   $565.70   $12,783.39
        50                $0.00            $0.00   $0.00   $0.00    $0.00         50   1.00%   ########   $580.59   $13,363.98
        51                $0.00            $0.00   $0.00   $0.00    $0.00
        52                $0.00            $0.00   $0.00   $0.00    $0.00
        53                $0.00            $0.00   $0.00   $0.00    $0.00
        54                $0.00            $0.00   $0.00   $0.00    $0.00
        55                $0.00            $0.00   $0.00   $0.00    $0.00
        56                $0.00            $0.00   $0.00   $0.00    $0.00
        57                $0.00            $0.00   $0.00   $0.00    $0.00
        58                $0.00            $0.00   $0.00   $0.00    $0.00
        59                $0.00            $0.00   $0.00   $0.00    $0.00
        60                $0.00            $0.00   $0.00   $0.00    $0.00
        61                $0.00            $0.00   $0.00   $0.00    $0.00
        62                $0.00            $0.00   $0.00   $0.00    $0.00
        63                $0.00            $0.00   $0.00   $0.00    $0.00
        64                $0.00            $0.00   $0.00   $0.00    $0.00
        65                $0.00            $0.00   $0.00   $0.00    $0.00
        66                $0.00            $0.00   $0.00   $0.00    $0.00
        67                $0.00            $0.00   $0.00   $0.00    $0.00
        68                $0.00            $0.00   $0.00   $0.00    $0.00
        69                $0.00            $0.00   $0.00   $0.00    $0.00
        70                $0.00            $0.00   $0.00   $0.00    $0.00
        71                $0.00            $0.00   $0.00   $0.00    $0.00
        72                $0.00            $0.00   $0.00   $0.00    $0.00
        73                $0.00            $0.00   $0.00   $0.00    $0.00
        74                $0.00            $0.00   $0.00   $0.00    $0.00
        75                $0.00            $0.00   $0.00   $0.00    $0.00
        76                $0.00            $0.00   $0.00   $0.00    $0.00
        77                $0.00            $0.00   $0.00   $0.00    $0.00
        78                $0.00            $0.00   $0.00   $0.00    $0.00
        79                $0.00            $0.00   $0.00   $0.00    $0.00
        80                $0.00            $0.00   $0.00   $0.00    $0.00
        81                $0.00            $0.00   $0.00   $0.00    $0.00
        82                $0.00            $0.00   $0.00   $0.00    $0.00
        83                $0.00            $0.00   $0.00   $0.00    $0.00
        84                $0.00            $0.00   $0.00   $0.00    $0.00
        85                $0.00            $0.00   $0.00   $0.00    $0.00
        86                $0.00            $0.00   $0.00   $0.00    $0.00
        87                $0.00            $0.00   $0.00   $0.00    $0.00
        88                $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     3 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        89                $0.00            $0.00   $0.00   $0.00    $0.00
        90                $0.00            $0.00   $0.00   $0.00    $0.00
        91                $0.00            $0.00   $0.00   $0.00    $0.00
        92                $0.00            $0.00   $0.00   $0.00    $0.00
        93                $0.00            $0.00   $0.00   $0.00    $0.00
        94                $0.00            $0.00   $0.00   $0.00    $0.00
        95                $0.00            $0.00   $0.00   $0.00    $0.00
        96                $0.00            $0.00   $0.00   $0.00    $0.00
        97                $0.00            $0.00   $0.00   $0.00    $0.00
        98                $0.00            $0.00   $0.00   $0.00    $0.00
        99                $0.00            $0.00   $0.00   $0.00    $0.00
        100               $0.00            $0.00   $0.00   $0.00    $0.00
        101               $0.00            $0.00   $0.00   $0.00    $0.00
        102               $0.00            $0.00   $0.00   $0.00    $0.00
        103               $0.00            $0.00   $0.00   $0.00    $0.00
        104               $0.00            $0.00   $0.00   $0.00    $0.00
        105               $0.00            $0.00   $0.00   $0.00    $0.00
        106               $0.00            $0.00   $0.00   $0.00    $0.00
        107               $0.00            $0.00   $0.00   $0.00    $0.00
        108               $0.00            $0.00   $0.00   $0.00    $0.00
        109               $0.00            $0.00   $0.00   $0.00    $0.00
        110               $0.00            $0.00   $0.00   $0.00    $0.00
        111               $0.00            $0.00   $0.00   $0.00    $0.00
        112               $0.00            $0.00   $0.00   $0.00    $0.00
        113               $0.00            $0.00   $0.00   $0.00    $0.00
        114               $0.00            $0.00   $0.00   $0.00    $0.00
        115               $0.00            $0.00   $0.00   $0.00    $0.00
        116               $0.00            $0.00   $0.00   $0.00    $0.00
        117               $0.00            $0.00   $0.00   $0.00    $0.00
        118               $0.00            $0.00   $0.00   $0.00    $0.00
        119               $0.00            $0.00   $0.00   $0.00    $0.00
        120               $0.00            $0.00   $0.00   $0.00    $0.00
        121               $0.00            $0.00   $0.00   $0.00    $0.00
        122               $0.00            $0.00   $0.00   $0.00    $0.00
        123               $0.00            $0.00   $0.00   $0.00    $0.00
        124               $0.00            $0.00   $0.00   $0.00    $0.00
        125               $0.00            $0.00   $0.00   $0.00    $0.00
        126               $0.00            $0.00   $0.00   $0.00    $0.00
        127               $0.00            $0.00   $0.00   $0.00    $0.00
        128               $0.00            $0.00   $0.00   $0.00    $0.00
        129               $0.00            $0.00   $0.00   $0.00    $0.00
        130               $0.00            $0.00   $0.00   $0.00    $0.00
        131               $0.00            $0.00   $0.00   $0.00    $0.00
        132               $0.00            $0.00   $0.00   $0.00    $0.00
        133               $0.00            $0.00   $0.00   $0.00    $0.00
        134               $0.00            $0.00   $0.00   $0.00    $0.00
        135               $0.00            $0.00   $0.00   $0.00    $0.00
        136               $0.00            $0.00   $0.00   $0.00    $0.00
        137               $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     4 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        138               $0.00            $0.00   $0.00   $0.00    $0.00
        139               $0.00            $0.00   $0.00   $0.00    $0.00
        140               $0.00            $0.00   $0.00   $0.00    $0.00
        141               $0.00            $0.00   $0.00   $0.00    $0.00
        142               $0.00            $0.00   $0.00   $0.00    $0.00
        143               $0.00            $0.00   $0.00   $0.00    $0.00
        144               $0.00            $0.00   $0.00   $0.00    $0.00
        145               $0.00            $0.00   $0.00   $0.00    $0.00
        146               $0.00            $0.00   $0.00   $0.00    $0.00
        147               $0.00            $0.00   $0.00   $0.00    $0.00
        148               $0.00            $0.00   $0.00   $0.00    $0.00
        149               $0.00            $0.00   $0.00   $0.00    $0.00
        150               $0.00            $0.00   $0.00   $0.00    $0.00
        151               $0.00            $0.00   $0.00   $0.00    $0.00
        152               $0.00            $0.00   $0.00   $0.00    $0.00
        153               $0.00            $0.00   $0.00   $0.00    $0.00
        154               $0.00            $0.00   $0.00   $0.00    $0.00
        155               $0.00            $0.00   $0.00   $0.00    $0.00
        156               $0.00            $0.00   $0.00   $0.00    $0.00
        157               $0.00            $0.00   $0.00   $0.00    $0.00
        158               $0.00            $0.00   $0.00   $0.00    $0.00
        159               $0.00            $0.00   $0.00   $0.00    $0.00
        160               $0.00            $0.00   $0.00   $0.00    $0.00
        161               $0.00            $0.00   $0.00   $0.00    $0.00
        162               $0.00            $0.00   $0.00   $0.00    $0.00
        163               $0.00            $0.00   $0.00   $0.00    $0.00
        164               $0.00            $0.00   $0.00   $0.00    $0.00
        165               $0.00            $0.00   $0.00   $0.00    $0.00
        166               $0.00            $0.00   $0.00   $0.00    $0.00
        167               $0.00            $0.00   $0.00   $0.00    $0.00
        168               $0.00            $0.00   $0.00   $0.00    $0.00
        169               $0.00            $0.00   $0.00   $0.00    $0.00
        170               $0.00            $0.00   $0.00   $0.00    $0.00
        171               $0.00            $0.00   $0.00   $0.00    $0.00
        172               $0.00            $0.00   $0.00   $0.00    $0.00
        173               $0.00            $0.00   $0.00   $0.00    $0.00
        174               $0.00            $0.00   $0.00   $0.00    $0.00
        175               $0.00            $0.00   $0.00   $0.00    $0.00
        176               $0.00            $0.00   $0.00   $0.00    $0.00
        177               $0.00            $0.00   $0.00   $0.00    $0.00
        178               $0.00            $0.00   $0.00   $0.00    $0.00
        179               $0.00            $0.00   $0.00   $0.00    $0.00
        180               $0.00            $0.00   $0.00   $0.00    $0.00
        181               $0.00            $0.00   $0.00   $0.00    $0.00
        182               $0.00            $0.00   $0.00   $0.00    $0.00
        183               $0.00            $0.00   $0.00   $0.00    $0.00
        184               $0.00            $0.00   $0.00   $0.00    $0.00
        185               $0.00            $0.00   $0.00   $0.00    $0.00
        186               $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     5 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        187               $0.00            $0.00   $0.00   $0.00    $0.00
        188               $0.00            $0.00   $0.00   $0.00    $0.00
        189               $0.00            $0.00   $0.00   $0.00    $0.00
        190               $0.00            $0.00   $0.00   $0.00    $0.00
        191               $0.00            $0.00   $0.00   $0.00    $0.00
        192               $0.00            $0.00   $0.00   $0.00    $0.00
        193               $0.00            $0.00   $0.00   $0.00    $0.00
        194               $0.00            $0.00   $0.00   $0.00    $0.00
        195               $0.00            $0.00   $0.00   $0.00    $0.00
        196               $0.00            $0.00   $0.00   $0.00    $0.00
        197               $0.00            $0.00   $0.00   $0.00    $0.00
        198               $0.00            $0.00   $0.00   $0.00    $0.00
        199               $0.00            $0.00   $0.00   $0.00    $0.00
        200               $0.00            $0.00   $0.00   $0.00    $0.00
        201               $0.00            $0.00   $0.00   $0.00    $0.00
        202               $0.00            $0.00   $0.00   $0.00    $0.00
        203               $0.00            $0.00   $0.00   $0.00    $0.00
        204               $0.00            $0.00   $0.00   $0.00    $0.00
        205               $0.00            $0.00   $0.00   $0.00    $0.00
        206               $0.00            $0.00   $0.00   $0.00    $0.00
        207               $0.00            $0.00   $0.00   $0.00    $0.00
        208               $0.00            $0.00   $0.00   $0.00    $0.00
        209               $0.00            $0.00   $0.00   $0.00    $0.00
        210               $0.00            $0.00   $0.00   $0.00    $0.00
        211               $0.00            $0.00   $0.00   $0.00    $0.00
        212               $0.00            $0.00   $0.00   $0.00    $0.00
        213               $0.00            $0.00   $0.00   $0.00    $0.00
        214               $0.00            $0.00   $0.00   $0.00    $0.00
        215               $0.00            $0.00   $0.00   $0.00    $0.00
        216               $0.00            $0.00   $0.00   $0.00    $0.00
        217               $0.00            $0.00   $0.00   $0.00    $0.00
        218               $0.00            $0.00   $0.00   $0.00    $0.00
        219               $0.00            $0.00   $0.00   $0.00    $0.00
        220               $0.00            $0.00   $0.00   $0.00    $0.00
        221               $0.00            $0.00   $0.00   $0.00    $0.00
        222               $0.00            $0.00   $0.00   $0.00    $0.00
        223               $0.00            $0.00   $0.00   $0.00    $0.00
        224               $0.00            $0.00   $0.00   $0.00    $0.00
        225               $0.00            $0.00   $0.00   $0.00    $0.00
        226               $0.00            $0.00   $0.00   $0.00    $0.00
        227               $0.00            $0.00   $0.00   $0.00    $0.00
        228               $0.00            $0.00   $0.00   $0.00    $0.00
        229               $0.00            $0.00   $0.00   $0.00    $0.00
        230               $0.00            $0.00   $0.00   $0.00    $0.00
        231               $0.00            $0.00   $0.00   $0.00    $0.00
        232               $0.00            $0.00   $0.00   $0.00    $0.00
        233               $0.00            $0.00   $0.00   $0.00    $0.00
        234               $0.00            $0.00   $0.00   $0.00    $0.00
        235               $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     6 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        236               $0.00            $0.00   $0.00   $0.00    $0.00
        237               $0.00            $0.00   $0.00   $0.00    $0.00
        238               $0.00            $0.00   $0.00   $0.00    $0.00
        239               $0.00            $0.00   $0.00   $0.00    $0.00
        240               $0.00            $0.00   $0.00   $0.00    $0.00
        241               $0.00            $0.00   $0.00   $0.00    $0.00
        242               $0.00            $0.00   $0.00   $0.00    $0.00
        243               $0.00            $0.00   $0.00   $0.00    $0.00
        244               $0.00            $0.00   $0.00   $0.00    $0.00
        245               $0.00            $0.00   $0.00   $0.00    $0.00
        246               $0.00            $0.00   $0.00   $0.00    $0.00
        247               $0.00            $0.00   $0.00   $0.00    $0.00
        248               $0.00            $0.00   $0.00   $0.00    $0.00
        249               $0.00            $0.00   $0.00   $0.00    $0.00
        250               $0.00            $0.00   $0.00   $0.00    $0.00
        251               $0.00            $0.00   $0.00   $0.00    $0.00
        252               $0.00            $0.00   $0.00   $0.00    $0.00
        253               $0.00            $0.00   $0.00   $0.00    $0.00
        254               $0.00            $0.00   $0.00   $0.00    $0.00
        255               $0.00            $0.00   $0.00   $0.00    $0.00
        256               $0.00            $0.00   $0.00   $0.00    $0.00
        257               $0.00            $0.00   $0.00   $0.00    $0.00
        258               $0.00            $0.00   $0.00   $0.00    $0.00
        259               $0.00            $0.00   $0.00   $0.00    $0.00
        260               $0.00            $0.00   $0.00   $0.00    $0.00
        261               $0.00            $0.00   $0.00   $0.00    $0.00
        262               $0.00            $0.00   $0.00   $0.00    $0.00
        263               $0.00            $0.00   $0.00   $0.00    $0.00
        264               $0.00            $0.00   $0.00   $0.00    $0.00
        265               $0.00            $0.00   $0.00   $0.00    $0.00
        266               $0.00            $0.00   $0.00   $0.00    $0.00
        267               $0.00            $0.00   $0.00   $0.00    $0.00
        268               $0.00            $0.00   $0.00   $0.00    $0.00
        269               $0.00            $0.00   $0.00   $0.00    $0.00
        270               $0.00            $0.00   $0.00   $0.00    $0.00
        271               $0.00            $0.00   $0.00   $0.00    $0.00
        272               $0.00            $0.00   $0.00   $0.00    $0.00
        273               $0.00            $0.00   $0.00   $0.00    $0.00
        274               $0.00            $0.00   $0.00   $0.00    $0.00
        275               $0.00            $0.00   $0.00   $0.00    $0.00
        276               $0.00            $0.00   $0.00   $0.00    $0.00
        277               $0.00            $0.00   $0.00   $0.00    $0.00
        278               $0.00            $0.00   $0.00   $0.00    $0.00
        279               $0.00            $0.00   $0.00   $0.00    $0.00
        280               $0.00            $0.00   $0.00   $0.00    $0.00
        281               $0.00            $0.00   $0.00   $0.00    $0.00
        282               $0.00            $0.00   $0.00   $0.00    $0.00
        283               $0.00            $0.00   $0.00   $0.00    $0.00
        284               $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     7 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        285               $0.00            $0.00   $0.00   $0.00    $0.00
        286               $0.00            $0.00   $0.00   $0.00    $0.00
        287               $0.00            $0.00   $0.00   $0.00    $0.00
        288               $0.00            $0.00   $0.00   $0.00    $0.00
        289               $0.00            $0.00   $0.00   $0.00    $0.00
        290               $0.00            $0.00   $0.00   $0.00    $0.00
        291               $0.00            $0.00   $0.00   $0.00    $0.00
        292               $0.00            $0.00   $0.00   $0.00    $0.00
        293               $0.00            $0.00   $0.00   $0.00    $0.00
        294               $0.00            $0.00   $0.00   $0.00    $0.00
        295               $0.00            $0.00   $0.00   $0.00    $0.00
        296               $0.00            $0.00   $0.00   $0.00    $0.00
        297               $0.00            $0.00   $0.00   $0.00    $0.00
        298               $0.00            $0.00   $0.00   $0.00    $0.00
        299               $0.00            $0.00   $0.00   $0.00    $0.00
        300               $0.00            $0.00   $0.00   $0.00    $0.00
        301               $0.00            $0.00   $0.00   $0.00    $0.00
        302               $0.00            $0.00   $0.00   $0.00    $0.00
        303               $0.00            $0.00   $0.00   $0.00    $0.00
        304               $0.00            $0.00   $0.00   $0.00    $0.00
        305               $0.00            $0.00   $0.00   $0.00    $0.00
        306               $0.00            $0.00   $0.00   $0.00    $0.00
        307               $0.00            $0.00   $0.00   $0.00    $0.00
        308               $0.00            $0.00   $0.00   $0.00    $0.00
        309               $0.00            $0.00   $0.00   $0.00    $0.00
        310               $0.00            $0.00   $0.00   $0.00    $0.00
        311               $0.00            $0.00   $0.00   $0.00    $0.00
        312               $0.00            $0.00   $0.00   $0.00    $0.00
        313               $0.00            $0.00   $0.00   $0.00    $0.00
        314               $0.00            $0.00   $0.00   $0.00    $0.00
        315               $0.00            $0.00   $0.00   $0.00    $0.00
        316               $0.00            $0.00   $0.00   $0.00    $0.00
        317               $0.00            $0.00   $0.00   $0.00    $0.00
        318               $0.00            $0.00   $0.00   $0.00    $0.00
        319               $0.00            $0.00   $0.00   $0.00    $0.00
        320               $0.00            $0.00   $0.00   $0.00    $0.00
        321               $0.00            $0.00   $0.00   $0.00    $0.00
        322               $0.00            $0.00   $0.00   $0.00    $0.00
        323               $0.00            $0.00   $0.00   $0.00    $0.00
        324               $0.00            $0.00   $0.00   $0.00    $0.00
        325               $0.00            $0.00   $0.00   $0.00    $0.00
        326               $0.00            $0.00   $0.00   $0.00    $0.00
        327               $0.00            $0.00   $0.00   $0.00    $0.00
        328               $0.00            $0.00   $0.00   $0.00    $0.00
        329               $0.00            $0.00   $0.00   $0.00    $0.00
        330               $0.00            $0.00   $0.00   $0.00    $0.00
        331               $0.00            $0.00   $0.00   $0.00    $0.00
        332               $0.00            $0.00   $0.00   $0.00    $0.00
        333               $0.00            $0.00   $0.00   $0.00    $0.00



                                                                     8 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls                           DVC Analysis   7/25/2011, 1:08 AM




        334               $0.00            $0.00   $0.00   $0.00    $0.00
        335               $0.00            $0.00   $0.00   $0.00    $0.00
        336               $0.00            $0.00   $0.00   $0.00    $0.00
        337               $0.00            $0.00   $0.00   $0.00    $0.00
        338               $0.00            $0.00   $0.00   $0.00    $0.00
        339               $0.00            $0.00   $0.00   $0.00    $0.00
        340               $0.00            $0.00   $0.00   $0.00    $0.00
        341               $0.00            $0.00   $0.00   $0.00    $0.00
        342               $0.00            $0.00   $0.00   $0.00    $0.00
        343               $0.00            $0.00   $0.00   $0.00    $0.00
        344               $0.00            $0.00   $0.00   $0.00    $0.00
        345               $0.00            $0.00   $0.00   $0.00    $0.00
        346               $0.00            $0.00   $0.00   $0.00    $0.00
        347               $0.00            $0.00   $0.00   $0.00    $0.00
        348               $0.00            $0.00   $0.00   $0.00    $0.00
        349               $0.00            $0.00   $0.00   $0.00    $0.00
        350               $0.00            $0.00   $0.00   $0.00    $0.00
        351               $0.00            $0.00   $0.00   $0.00    $0.00
        352               $0.00            $0.00   $0.00   $0.00    $0.00
        353               $0.00            $0.00   $0.00   $0.00    $0.00
        354               $0.00            $0.00   $0.00   $0.00    $0.00
        355               $0.00            $0.00   $0.00   $0.00    $0.00
        356               $0.00            $0.00   $0.00   $0.00    $0.00
        357               $0.00            $0.00   $0.00   $0.00    $0.00
        358               $0.00            $0.00   $0.00   $0.00    $0.00
        359               $0.00            $0.00   $0.00   $0.00    $0.00
        360               $0.00            $0.00   $0.00   $0.00    $0.00
        361               $0.00            $0.00   $0.00   $0.00    $0.00
        362               $0.00            $0.00   $0.00   $0.00    $0.00
        363               $0.00            $0.00   $0.00   $0.00    $0.00




                                                                     9 of 11
c9b84948-4caa-444b-8269-cf9c259a4391.xls   DVC Analysis   7/25/2011, 1:08 AM




                                            10 of 11
                                                                            Disney Vacation Club Availability
                                                                       "Best Information" as of January 5, 2007, and not guaranteed
                                                                           Based upon public information. Use/distribute freely.
                                                          For new information or corrections, please send email to TheRustyScupper@yahoo.com
   Disney            Deciated             Dedicated             Dedicated            Lockoff              Grand                 Inn                Total                Total                 2007
    DVC                                      One                   Two                 Two                                                        Actual              (Less 4%              Dues Per
   Resort             Studios             Bedroom               Bedroom             Bedroom                Villas             Rooms               Rooms              WDW Rental)             Point
    VWL                  20                   27                    44                  45                                                          136                  174
Ann Pts / Unit         6,102                12,810                16,665              18,912                                                                                                  $4.73
Total Ann Pts         122,040              345,870               733,260             851,040                                                                          1,990,644
    BWV                  97                  130                                       149                    7                                     383                  511
Ann Pts / Unit         5,358                10,585                                    15,943               36,204                                                                             $4.85
Total Ann Pts         519,726             1,376,050                                 2,375,507             253,428                                                     4,388,970
    OKW                                                            274                 230                   27                                     531                  731
Ann Pts / Unit         5,099               10,281                 13,929              15,380               23,082                                                                             $4.40
Total Ann Pts                                                   3,816,546           3,537,400             623,214                                                     7,737,845
    BCV                  36                   20                    78                  74                                                          208                  271
Ann Pts / Unit         6,408                12,810                16,665              19,218                                                                                                  $4.63
Total Ann Pts         230,688              256,200              1,299,870           1,422,132                                                                         3,112,623
     HHI                                                            76                  21                    5                                     102                  118
Ann Pts / Unit         5,275               10,241                 15,656              15,516               28,061                                                                             $4.98
Total Ann Pts                                                   1,189,856            325,836              140,305                                                     1,606,317
    AKV                  46                                        140                 250                   22                                     458                  680
Ann Pts / Unit         7,116                                      15,191              20,507               34,154                                                                             $4.62
Total Ann Pts         327,336                                   2,126,740           5,126,750             751,388                                                     8,082,248
    SSR                                                            360                 432                   36                                     828                 1,210
Ann Pts / Unit         6,258               11,532                 21,491              21,491               46,443                                                                             $4.12
Total Ann Pts                                                   7,736,700           9,284,040            1,671,933                                                    18,131,893
     VB                                                             18                  36                    6                 112                 172                   200
Ann Pts / Unit         6,258               11,532                 15,656              17,790               28,061              6,258                                                          $5.63
Total Ann Pts                                                    281,808             640,440              168,366             700,896                                  1,737,765
                                 All views are "standard" and does not include "prefered view" points.                                             2,360                 3,213
                                                                                                                                                                      38,706,056

                                                           Disney Vacation Club Resort " What If " Value (US$)
   Disney            If Points            If Points             If Points           If Points            If Points           If Points           If Points             If Points             Approx
    DVC               Sold at              Sold at               Sold at             Sold at              Sold at             Sold at             Sold at               Sold at               2007
   Resort               $62                  $75                   $85                 $95                  $100                $105                $110                  $100                Dues
    VWL          $     123,419,909    $     149,298,278     $     169,204,715   $     189,111,152   $      199,064,370   $     209,017,589   $     218,970,807   $      199,064,370    $       9,415,745
    BWV          $     272,116,120    $     329,172,725     $     373,062,422   $     416,952,119   $      438,896,967   $     460,841,815   $     482,786,664   $      438,896,967    $      21,286,503
    OKW          $     479,746,402    $     580,338,390     $     657,716,842   $     735,095,294   $      773,784,520   $     812,473,746   $     851,162,972   $      773,784,520    $      34,046,519
    BCV          $     192,982,645    $     233,446,748     $     264,572,981   $     295,699,214   $      311,262,330   $     326,825,447   $     342,388,563   $      311,262,330    $      14,411,446
     HHI         $      99,591,660    $     120,473,782     $     136,536,953   $     152,600,124   $      160,631,709   $     168,663,294   $     176,694,880   $      160,631,709    $       7,999,459
    SSR          $   1,124,177,354    $   1,359,891,961     $   1,541,210,889   $   1,722,529,817   $    1,813,189,281   $   1,903,848,745   $   1,994,508,209   $     1,813,189,281   $      74,703,398
    AKV          $     501,099,350    $     606,168,569     $     686,991,044   $     767,813,520   $      808,224,758   $     848,635,996   $     889,047,234   $      808,224,758    $      37,339,984
     VB          $     107,741,411    $     130,332,353     $     147,710,000   $     165,087,647   $      173,776,470   $     182,465,294   $     191,154,117   $      173,776,470    $       9,783,615
    Total        $   2,900,874,851    $   3,509,122,804     $   3,977,005,844   $   4,444,888,885   $    4,678,830,405   $   4,912,771,925   $   5,146,713,446   $     4,678,830,405   $     208,986,669




                                                      Maintenance Fees History Per Point (US$)
    Year               OKW                  BWV                    VB                  HH                  VWL                 BCV                 AKV                  SSR                Straight Line
                       Dues                 Dues                  Dues                Dues                 Dues                Dues                Dues                 Dues                 Average
                     Per Point            Per Point             Per Point           Per Point            Per Point           Per Point           Per Point            Per Point                Dues
    2007               $4.40                $4.85                 $5.63               $4.98                $4.73               $4.63               $4.62                $4.12                 $4.75
    2006               $4.24                $4.69                 $5.27               $4.34                $4.61               $4.48                                    $3.98                 $4.52
    2005               $3.86                $4.41                 $4.87               $4.04                $4.35               $4.27                                    $3.83                 $4.23
    2004               $3.68                $4.25                 $4.67               $3.86                $4.22               $4.17                                    $3.80                 $4.09
    2003               $3.49                $4.11                 $4.37               $3.69                $4.05               $3.97                                                          $3.95
    2002               $3.22                $3.92                 $4.17               $3.49                $3.80               $3.77                                                          $3.73
    2001               $3.13                $3.83                 $3.98               $3.32                $3.63                                                                              $3.58
    2000               $3.16                $3.94                 $4.07               $3.25                $3.62                                                                              $3.61
    1999               $3.16                $4.02                                     $3.18                                                                                                   $3.45
    1998               $3.17                $3.94                                     $3.20                                                                                                   $3.44
    1997               $3.14                $3.84                                     $3.16                                                                                                   $3.38
    1996               $2.99                $3.70                                     $3.16                                                                                                   $3.28
    1995               $2.84                                                                                                                                                                  $2.84
    1994               $2.70                                                                                                                                                                  $2.70
    1993               $2.63                                                                                                                                                                  $2.63
    1992               $2.56                                                                                                                                                                  $2.56
    1991               $2.51                                                                                                                                                                  $2.51
  Average             $3.23                 $4.13                $4.63               $3.64                $4.13               $4.22               $4.62                 $3.93                 $3.48
  Median              $3.16                 $3.98                $4.52               $3.41                $4.14               $4.22               $4.62                 $3.91                 $3.45




                                       Maintenance Fees History - Increase/Decrease Percentages
    Year               OKW                  BWV                    VB                  HH                   VWL                 BCV                 AKV                  SSR               Straight Line
                     Incr From            Incr From             Incr From           Incr From            Incr From           Incr From           Incr From            Incr From              Average
                     Prev Year            Prev Year             Prev Year           Prev Year            Prev Year           Prev Year           Prev Year            Prev Year              Increase
    2007               3.6%                 3.3%                  6.4%               12.9%                 2.5%                3.2%               100.0%                3.4%                   16.9%
    2006               9.0%                 6.0%                  7.6%                6.9%                 5.6%                4.7%                                     3.8%                    6.2%
    2005               4.7%                 3.6%                  4.1%                4.5%                 3.0%                2.3%                                     0.8%                    3.3%
    2004               5.2%                 3.3%                  6.4%                4.4%                 4.0%                4.8%                                                             4.7%
    2003               7.7%                 4.6%                  4.6%                5.4%                 6.2%                5.0%                                                             5.6%
    2002               2.8%                 2.3%                  4.6%                4.9%                 4.5%                                                                                 3.8%
    2001               -1.0%                -2.9%                 -2.3%               2.1%                 0.3%                                                                                -0.7%
    2000               0.0%                 -2.0%                                     2.2%                                                                                                      0.0%
    1999               -0.3%                2.0%                                     -0.6%                                                                                                      0.3%
    1998               0.9%                 2.5%                                      1.3%                                                                                                      1.6%
    1997               4.8%                 3.6%                                                                                                                                                2.8%
    1996               5.0%                                                                                                                                                                     5.0%
    1995               4.9%                                                                                                                                                                     4.9%
    1994               2.6%                                                                                                                                                                     2.6%
    1993               2.7%                                                                                                                                                                     2.7%
    1992               2.0%                                                                                                                                                                     2.0%
  Average              3.4%                 2.4%                  4.5%                4.0%                 3.7%                4.0%               100.0%                2.7%                   3.9%
  Median               2.7%                 3.3%                  4.6%                4.4%                 4.0%                4.7%               100.0%                3.4%                   3.0%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:7/25/2011
language:English
pages:11