Docstoc

Mortgage Amortization

Document Sample
Mortgage Amortization Powered By Docstoc
					dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                                                                                                            DVC Analysis                                                5/16/2012, 5:31 PM




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

                       Price and Mortgage Calculations                                                                   Overall Annual Cost Analysis
     Purchased From (Drop Down Menu)                                             DVC              Resort (Drop Down Menu)                                       SSR    Resorts    DP     Mort Yrs   Inflation
      Number of Points Purchased                                                 200              Date DVC Purchased (mm/dd/yyyy)                       July 1, 2005     BCV      5%        1       1.00%
      Net Price per Point (after discounts)                                      $85              Date DVC Rights Expiration Date                   January 31, 2052    BW V      10%       3       1.50%
      Total Purchase (excluding any Closing Costs)                           $17,000              Usable DVC Period in Years                                      46     HHI      15%       5       2.00%
      Down Payment(Drop Down Menu)                                              100%              Maintenance Dues per Point                                  $3.98     OKW       20%       7       2.50%
      Down Payment Amount                                                    $17,000              Maintenance Dues First Year                               $796.00      SSR      25%      10       3.00%
      Mortgage Principal                                                           $0             Estimated Annual Inflation (Drop Down Menu)                 1.00%      VB       30%      15       3.50%
      Fixed Mortgage Interest Rate                                          10.750 %              Historical Dues Inflation (Reference Only)                  2.69%     VW L      35%      20       4.00%
      Payment Years (Drop Down Menu)                                              7.0             Sum of All Years Increases                            $11,512.69                40%      25       4.50%
      Payments per Year                                                            12             Sum of Annual Dues Until Expiration                   $48,128.69     Buy Type   50%      30       5.00%
      Total Number of Payments                                                     84             Sum Purchase, Dues, Interest                          $65,128.69       DVC      75%               5.50%
      Total Interest for Entire Loan                                           $0.00              Possible Total Interest Loss                          $22,686.57      Resale    100%              6.00%
      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                                 $1,909.03
     1st Yr Monthly Payment w/Dues                                            $66.33              Overall Avg Cost w/o Interest Loss                      $1,415.84

                           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 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                             2 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                             3 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                             4 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                             5 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                             6 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                                               DVC Analysis                                                              5/16/2012, 5:31 PM




                                   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%    $796.00 $796.00                    1.00%   $17,000.00
         2               $0.00             $0.00          $0.00         $0.00          $0.00           2           1.00%    $803.96    $7.96       $7.96       1.00%   $17,170.00
         3               $0.00             $0.00          $0.00         $0.00          $0.00           3           1.00%    $812.00   $16.00      $23.96       1.00%   $17,341.70
         4               $0.00             $0.00          $0.00         $0.00          $0.00           4           1.00%    $820.12   $24.12      $48.08       1.00%   $17,515.12
         5               $0.00             $0.00          $0.00         $0.00          $0.00           5           1.00%    $828.32   $32.32      $80.40       1.00%   $17,690.27
         6               $0.00             $0.00          $0.00         $0.00          $0.00           6           1.00%    $836.60   $40.60     $121.00       1.00%   $17,867.17
         7               $0.00             $0.00          $0.00         $0.00          $0.00           7           1.00%    $844.97   $48.97     $169.97       1.00%   $18,045.84
         8               $0.00             $0.00          $0.00         $0.00          $0.00           8           1.00%    $853.42   $57.42     $227.39       1.00%   $18,226.30
         9               $0.00             $0.00          $0.00         $0.00          $0.00           9           1.00%    $861.95   $65.95     $293.35       1.00%   $18,408.56
        10               $0.00             $0.00          $0.00         $0.00          $0.00           10          1.00%    $870.57   $74.57     $367.92       1.00%   $18,592.65
        11               $0.00             $0.00          $0.00         $0.00          $0.00           11          1.00%    $879.28   $83.28     $451.20       1.00%   $18,778.58
        12               $0.00             $0.00          $0.00         $0.00          $0.00           12          1.00%    $888.07   $92.07     $543.27       1.00%   $18,966.36
        13               $0.00             $0.00          $0.00         $0.00          $0.00           13          1.00%    $896.95 $100.95      $644.23       1.00%   $19,156.03
        14               $0.00             $0.00          $0.00         $0.00          $0.00           14          1.00%    $905.92 $109.92      $754.15       1.00%   $19,347.59
        15               $0.00             $0.00          $0.00         $0.00          $0.00           15          1.00%    $914.98 $118.98      $873.13       1.00%   $19,541.06
        16               $0.00             $0.00          $0.00         $0.00          $0.00           16          1.00%    $924.13 $128.13    $1,001.26       1.00%   $19,736.47
        17               $0.00             $0.00          $0.00         $0.00          $0.00           17          1.00%    $933.37 $137.37    $1,138.63       1.00%   $19,933.84
        18               $0.00             $0.00          $0.00         $0.00          $0.00           18          1.00%    $942.71 $146.71    $1,285.34       1.00%   $20,133.18
        19               $0.00             $0.00          $0.00         $0.00          $0.00           19          1.00%    $952.13 $156.13    $1,441.47       1.00%   $20,334.51
        20               $0.00             $0.00          $0.00         $0.00          $0.00           20          1.00%    $961.65 $165.65    $1,607.13       1.00%   $20,537.85
        21               $0.00             $0.00          $0.00         $0.00          $0.00           21          1.00%    $971.27 $175.27    $1,782.40       1.00%   $20,743.23
        22               $0.00             $0.00          $0.00         $0.00          $0.00           22          1.00%    $980.98 $184.98    $1,967.38       1.00%   $20,950.66
        23               $0.00             $0.00          $0.00         $0.00          $0.00           23          1.00%    $990.79 $194.79    $2,162.18       1.00%   $21,160.17
        24               $0.00             $0.00          $0.00         $0.00          $0.00           24          1.00%   ######## $204.70    $2,366.88       1.00%   $21,371.77
        25               $0.00             $0.00          $0.00         $0.00          $0.00           25          1.00%   ######## $214.71    $2,581.59       1.00%   $21,585.49
        26               $0.00             $0.00          $0.00         $0.00          $0.00           26          1.00%   ######## $224.82    $2,806.40       1.00%   $21,801.34
        27               $0.00             $0.00          $0.00         $0.00          $0.00           27          1.00%   ######## $235.02    $3,041.43       1.00%   $22,019.36
        28               $0.00             $0.00          $0.00         $0.00          $0.00           28          1.00%   ######## $245.33    $3,286.76       1.00%   $22,239.55
        29               $0.00             $0.00          $0.00         $0.00          $0.00           29          1.00%   ######## $255.75    $3,542.51       1.00%   $22,461.95
        30               $0.00             $0.00          $0.00         $0.00          $0.00           30          1.00%   ######## $266.27    $3,808.77       1.00%   $22,686.57
        31               $0.00             $0.00          $0.00         $0.00          $0.00           31          1.00%   ######## $276.89    $4,085.66
        32               $0.00             $0.00          $0.00         $0.00          $0.00           32          1.00%   ######## $287.62    $4,373.28
        33               $0.00             $0.00          $0.00         $0.00          $0.00           33          1.00%   ######## $298.45    $4,671.73
        34               $0.00             $0.00          $0.00         $0.00          $0.00           34          1.00%   ######## $309.40    $4,981.13
        35               $0.00             $0.00          $0.00         $0.00          $0.00           35          1.00%   ######## $320.45    $5,301.58
        36               $0.00             $0.00          $0.00         $0.00          $0.00           36          1.00%   ######## $331.62    $5,633.20
        37               $0.00             $0.00          $0.00         $0.00          $0.00           37          1.00%   ######## $342.89    $5,976.09
        38               $0.00             $0.00          $0.00         $0.00          $0.00           38          1.00%   ######## $354.28    $6,330.37
        39               $0.00             $0.00          $0.00         $0.00          $0.00           39          1.00%   ######## $365.78    $6,696.15



                                                                                         7 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis                                                  5/16/2012, 5:31 PM




        40                $0.00            $0.00   $0.00   $0.00    $0.00         40   1.00%   ########   $377.40    $7,073.55
        41                $0.00            $0.00   $0.00   $0.00    $0.00         41   1.00%   ########   $389.14    $7,462.69
        42                $0.00            $0.00   $0.00   $0.00    $0.00         42   1.00%   ########   $400.99    $7,863.68
        43                $0.00            $0.00   $0.00   $0.00    $0.00         43   1.00%   ########   $412.96    $8,276.63
        44                $0.00            $0.00   $0.00   $0.00    $0.00         44   1.00%   ########   $425.05    $8,701.68
        45                $0.00            $0.00   $0.00   $0.00    $0.00         45   1.00%   ########   $437.26    $9,138.94
        46                $0.00            $0.00   $0.00   $0.00    $0.00         46   1.00%   ########   $449.59    $9,588.52
        47                $0.00            $0.00   $0.00   $0.00    $0.00         47   1.00%   ########   $462.05   $10,050.57
        48                $0.00            $0.00   $0.00   $0.00    $0.00         48   1.00%   ########   $474.63   $10,525.20
        49                $0.00            $0.00   $0.00   $0.00    $0.00         49   1.00%   ########   $487.33   $11,012.53
        50                $0.00            $0.00   $0.00   $0.00    $0.00         50   1.00%   ########   $500.17   $11,512.69
        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



                                                                     8 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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



                                                                     9 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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



                                                                    10 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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



                                                                    11 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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



                                                                    12 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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



                                                                    13 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls                           DVC Analysis   5/16/2012, 5:31 PM




        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




                                                                    14 of 16
dd27b28b-5711-4846-8776-e0bf485b3c2e.xls   DVC Analysis   5/16/2012, 5:31 PM




                                            15 of 16
                                                                             Disney Vacation Club Availability
                                                                        "Best Information" as of January 5, 2006, 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                 2006
    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                               BCV   $   4.48
Ann Pts / Unit         6,102               12,810                 16,665                18,912                                                                                                     $4.61        BWV   $   4.69
Annual Points         122,040              345,870                733,260               851,040                                                                            1,990,644                            HHI   $   4.34
    BWV                 97                   130                                          149                  7                                        383                   511                               OKW   $   4.24
Ann Pts / Unit         5,358               10,585                                       15,943              36,204                                                                                 $4.69        SSR   $   3.98
Annual Points         519,726             1,376,050                                    2,375,507            253,428                                                        4,388,970                            VB    $   5.27
    OKW                                                             274                   230                 27                                        531                   731                               WLV   $   4.61
Ann Pts / Unit         5,099               10,281                 13,929                15,380              23,082                                                                                 $4.24
Annual Points                                                    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.48
Annual Points         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.34
Annual Points                                                    1,189,856              325,836             140,305                                                        1,606,317
    SSR                                                             453                   544                 34                                       1,031                 1,512
Ann Pts / Unit         6,258               11,532                 21,491                21,491              46,443                                                                                 $3.98
Annual Points                                                    9,742,511            11,691,013           1,579,048                                                       22,322,195
     VB                                                             18                     36                  6                   112                  172                    200
Ann Pts / Unit         6,258               11,532                 15,656                17,790              28,061                6,258                                                            $5.27
Annual Points                                                     281,808               640,440             168,366              700,896                                    1,737,765
                                 All views are "standard" and does not include "prefered view" points.                                                 2,563                  3,516
                                                                                                                                                                           42,896,359


                                                           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               2006
   Resort               $62                  $68                    $72                   $78                 $84                  $90                  $95                    $100              Dues Paid
    VWL          $     123,419,909    $     135,363,772     $      143,326,346    $      155,270,209   $     167,214,071    $     179,157,933    $     189,111,152    $       199,064,370   $       9,176,867
    BWV          $     272,116,120    $     298,449,938      $     316,005,816    $      342,339,634   $     368,673,452    $     395,007,270    $     416,952,119    $       438,896,967   $      20,584,268
    OKW          $     479,746,402    $     526,173,474      $     557,124,854    $      603,551,926   $     649,978,997    $     696,406,068    $     735,095,294    $       773,784,520   $      32,808,464
    BCV          $     192,982,645    $     211,658,384      $     224,108,878    $      242,784,617   $     261,460,357    $     280,136,097    $     295,699,214    $       311,262,330   $      13,944,552
     HHI         $      99,591,660    $     109,229,562      $     115,654,830    $      125,292,733   $     134,930,636    $     144,568,538    $     152,600,124    $       160,631,709   $       6,971,416
    SSR          $    1,383,976,097   $    1,517,909,267     $    1,607,198,048   $    1,741,131,219   $    1,875,064,389   $    2,008,997,560   $    2,120,608,535   $     2,232,219,511   $      88,842,337
     VB          $     107,741,411    $     118,168,000      $     125,119,058    $      135,545,647   $     145,972,235    $     156,398,823    $     165,087,647    $       173,776,470   $       9,158,020
    Total        $    2,659,574,244   $    2,916,952,396     $    3,088,537,831   $    3,345,915,984   $    3,603,294,137   $    3,860,672,289   $    4,075,154,083   $     4,289,635,877   $     181,485,924




                                                      Maintenance Fees History Per Point (US$)
    Year               OKW                  BWV                     VB                VB(sub)                 HH                  VWL                  BCV                   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
    2006               $4.24                $4.69                  $5.27                $4.12                $4.34                $4.61                $4.48                 $3.98                 $3.97
    2005               $3.86                $4.41                  $4.87                $4.87                $4.04                $4.35                $4.27                 $3.83                 $1.92
    2004               $3.68                $4.25                  $4.67                $4.67                $3.86                $4.22                $4.17                 $3.80                 $3.69
    2003               $3.49                $4.11                  $4.37                $4.37                $3.69                $4.05                $3.97                                       $4.01
    2002               $3.22                $3.92                  $4.17                $3.33                $3.49                $3.80                $3.77                                       $3.67
    2001               $3.13                $3.83                  $3.98                $2.70                $3.32                $3.63                                                            $3.43
    2000               $3.16                $3.94                  $4.07                $2.87                $3.25                $3.62                                                            $3.49
    1999               $3.16                $4.02                                       $2.82                $3.18                                                                                 $3.30
    1998               $3.17                $3.94                                       $2.76                $3.20                                                                                 $3.27
    1997               $3.14                $3.84                                       $2.90                $3.16                                                                                 $3.26
    1996               $2.99                $3.70                                       $2.82                $3.16                                                                                 $3.17
    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.12                $4.04                  $4.46                 $3.36               $3.48                $4.01                $4.12                  $3.91                 $3.11
  Median              $3.14                $3.94                  $4.27                 $2.89               $3.29                $3.93                $4.07                  $3.82                 $3.26




                                      Maintenance Fees History - Increase/Decrease Percentages
    Year               OKW                   BWV                    VB                 VB(sub)                HH                   VWL                  BCV                   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
    2006               9.0%                 6.0%                   7.6%                -18.2%                6.9%                 5.6%                 4.7%                  3.8%                    2.7%
    2005               4.7%                 3.6%                   4.1%                  4.1%                4.5%                 3.0%                 2.3%                  0.8%                    3.3%
    2004               5.2%                 3.3%                   6.4%                  6.4%                4.4%                 4.0%                 4.8%                                          4.9%
    2003               7.7%                 4.6%                   4.6%                23.8%                 5.4%                 6.2%                 5.0%                                          8.2%
    2002               2.8%                 2.3%                   4.6%                18.9%                 4.9%                 4.5%                                                               6.3%
    2001              -1.0%                -2.9%                  -2.3%                 -6.3%                2.1%                 0.3%                                                              -1.7%
    2000               0.0%                -2.0%                                         1.7%                2.2%                                                                                    0.5%
    1999              -0.3%                 2.0%                                         2.1%               -0.6%                                                                                    0.8%
    1998               0.9%                 2.5%                                        -5.1%                1.3%                                                                                   -0.1%
    1997               4.8%                 3.6%                                         2.8%                                                                                                        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.3%                   4.2%                 3.0%                 3.1%                 3.9%                 4.2%                  2.3%                   3.0%
  Median               2.7%                 2.5%                   4.6%                 2.8%                 2.2%                 4.0%                 4.8%                   n/a                   2.7%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:5/17/2012
language:
pages:16
fanzhongqing fanzhongqing http://
About