Docstoc

model

Document Sample
model Powered By Docstoc
					Apartment pricing model
Address
CHMC area                                 ???
Unit                                      ???
Floor                                     ???
Area, sq.ft.                                        783
Estimated useful life                                60
Years used as own residence                           0
Income
Comparable monthly rent (all-inclusive)           1,625
Rent per sq ft                                      2.08
Vacancy rate                                        0.05
Total annual income                               1,544
Expense
Ongoing
Property taxes per year, % of cost                0.85%
Total tax per month                                 176
Condo fee per sq.ft.                                0.44
Total condo fee                                      345
Hydro bill                                           120
Water bill                                             0
Heating bill                                          60
Repairs per year                                     200
Repairs per month                                     17
Homeowner Insurance per year, % of cost           0.43%
Homeowner insurance per month                        89
Break-Even Inflation Rate                         2.00%
Margin of Error                                   1.00%
Growth assumption                                    3%
Total monthly cost                                  806
Net monthly cash flow                               738
Net annual cash flow                              8,856
One-time
Property cost                                   248,000
Spread                                            1.05%
Legal fee                                            800
Broker fee, first 100k, %                             7%
Broker fee, above 100k, %                             3%
Total broker fee                                 11,440
Property Transfer Tax                                  0
GST/PST, % of cost                                    0%
GST/PST                                             -
Appraisal fee                                       250
Survey fee                                          350
Inspection fee                                      250
Total one-time cost                             261,090
Available cash                                  100,000
Total borrowing amount                          161,090

Funding
Relatives                                       50%
Mortgage                                        50%
Total                                          100%

Funding maturity
Relatives                                         10
Mortgage                                           5

Funding rates
Mortgage                                       4.55%
Relatives                                      2.55%

Annual payments
Mortgage                                      18,373
Relatives                                      9,227
Total                                         27,600
Monthly payment during outlay period        2,299.98

Rate of return on investment (long-term)       5.05%
Government bond yield                          4.00%
Spread                                         1.05%

Monthly cash flow during outlay period      3,105.70

Checks
Mortgage Borrowing                            80,545
NPV mortgage payments                      $80,545.00
Parental borrowing                            80,545
NPV parental payments                      $80,545.00
Year                                             D                    property for tax purposes
            Inflation factor Net profit before tax epreciation of theTotal depreciation
        0                    1          8856.36              248000                9920
        1                 1.03       9122.0508               238080              9523.2
        2              1.0609      9395.712324             228556.8           9142.272
        3           1.092727       9677.583694          219414.528          8776.58112
        4        1.12550881        9967.911205         210637.9469         8425.517875
        5      1.159274074         10266.94854          202212.429          8088.49716
        6      1.194052297           10574.957         194123.9318         7764.957274
        7      1.229873865         10892.20571         186358.9746         7454.358983
        8      1.266770081         11218.97188         178904.6156         7156.184624
        9      1.304773184         11555.54103          171748.431         6869.937239
       10      1.343916379         11902.20727         164878.4937         6595.139749
       11      1.384233871         12259.27348          158283.354         6331.334159
       12      1.425760887         12627.05169         151952.0198         6078.080793
       13      1.468533713         13005.86324          145873.939         5834.957561
       14      1.512589725         13396.03914         140038.9815         5601.559259
       15      1.557967417         13797.92031         134437.4222         5377.496888
       16      1.604706439         14211.85792         129059.9253         5162.397013
       17      1.652847632         14638.21366         123897.5283         4955.901132
       18      1.702433061         15077.36007         118941.6272         4757.665087
       19      1.753506053         15529.68087         114183.9621         4567.358483
       20      1.806111235         15995.57129         109616.6036         4384.664144
       21      1.860294572         16475.43843         105231.9395         4209.277578
       22      1.916103409         16969.70159         101022.6619         4040.906475
       23      1.973586511         17478.79263          96981.7554         3879.270216
       24      2.032794106         18003.15641         93102.48519         3724.099408
       25        2.09377793        18543.25111         89378.38578         3575.135431
       26      2.156591268         19099.54864         85803.25035         3432.130014
       27      2.221289006          19672.5351         82371.12034         3294.844813
       28      2.287927676         20262.71115         79076.27552         3163.051021
       29      2.356565506         20870.59248          75913.2245          3036.52898
       30      2.427262471         21496.71026         72876.69552         2915.067821
       31      2.500080345         22141.61157          69961.6277         2798.465108
       32      2.575082756         22805.85991         67163.16259         2686.526504
       33      2.652335238         23490.03571         64476.63609         2579.065444
       34      2.731905296         24194.73678         61897.57065         2475.902826
       35      2.813862454         24920.57889         59421.66782         2376.866713
       36      2.898278328         25668.19625         57044.80111         2281.792044
       37      2.985226678         26438.24214         54763.00906         2190.520362
       38      3.074783478          27231.3894          52572.4887         2102.899548
       39      3.167026983         28048.33109         50469.58915         2018.783566
       40      3.262037792         28889.78102         48450.80559         1938.032223
       41      3.359898926         29756.47445         46512.77336         1860.510934
       42      3.460695894         30649.16868         44652.26243         1786.090497
       43        3.56451677        31568.64374         42866.17193         1714.646877
       44      3.671452273         32515.70306         41151.52505         1646.061002
       45      3.781595842         33491.17415         39505.46405         1580.218562
       46      3.895043717         34495.90937         37925.24549          1517.00982
       47      4.011895028         35530.78665         36408.23567         1456.329427
       48      4.132251879         36596.71025         34951.90624          1398.07625
       49      4.256219436         37694.61156         33553.82999           1342.1532
       50      4.383906019         38825.44991         32211.67679         1288.467072
51   4.515423199   39990.21341   30923.20972   1236.928389
52   4.650885895   41189.91981   29686.28133   1187.451253
53   4.790412472    42425.6174   28498.83008   1139.953203
54   4.934124846   43698.38592   27358.87688   1094.355075
55   5.082148592    45009.3375    26264.5218   1050.580872
56   5.234613049   46359.61763   25213.94093   1008.557637
57   5.391651441   47750.40616   24205.38329   968.2153317
58   5.553400984   49182.91834   23237.16796   929.4867184
59   5.720003014   50658.40589   22307.68124   892.3072497
60   5.891603104   52178.15807   21415.37399   856.6149597
                                 20558.75903
Tax             Expenses                                          outlay
                              Profit after tax Mortgage financing Parental financing outlay
         -              8,856         8856.36        18373.04902            9226.7653
         -              9,122      9122.0508         18373.04902            9226.7653
          73            9,396    9322.21463          18373.04902            9226.7653
         261
          12,000        9,678   9416.292947          18373.04902            9226.7653
         447            9,968   9520.617139          18373.04902            9226.7653
         632           10,267    9635.19764                     0           9226.7653
         815           10,575   9760.057077                     0           9226.7653
          10,000
         997           10,892   9895.230157                     0           9226.7653
       1,178           11,219   10040.76357                     0           9226.7653
       1,359           11,556   10196.71593                     0           9226.7653
       1,539
           8,000       11,902   10363.15769                     0                   0
       1,719           12,259   10540.17108                     0                   0
       1,899           12,627   10727.85013                     0                   0
       2,080           13,006   10926.30059                     0                   0
           6,000
       2,260           13,396   11135.63997                     0                   0
       2,442           13,798   11355.99752                     0                   0
       2,624           14,212   11587.51426                     0                   0
       2,808           14,638   11830.34302                     0                   0
           4,000
       2,993           15,077   12084.64852                     0                   0
       3,179           15,530   12350.60738                     0                   0
       3,367           15,996   12628.40822                     0                   0
           2,000
       3,557           16,475   12918.25179                     0                   0
       3,749           16,970      13220.351                    0                   0
       3,944           17,479   13534.93113                     0                   0
       4,141           18,003   13862.22988                     0                   0
              -
       4,341           18,543   14202.49756                     0                   0
                  1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
       4,544           19,100   14555.99724                     0                   0
       4,750           19,673   14923.00492                     0                   0
       4,959           20,263   15303.80971                     0                   0
       5,172           20,871   15698.71407                     0                   0
       5,389           21,497   16108.03395                     0                   0
       5,610           22,142   16532.09909                     0                   0
       5,835           22,806   16971.25323                     0                   0
       6,064           23,490   17425.85433                     0                   0
       6,298           24,195   17896.27494                     0                   0
       6,538           24,921   18382.90236                     0                   0
       6,782           25,668   18886.13903                     0                   0
       7,032           26,438   19406.40282                     0                   0
       7,287           27,231   19944.12735                     0                   0
       7,549           28,048   20499.76231                     0                   0
       7,816           28,890   21073.77387                     0                   0
       8,090           29,756   21666.64503                     0                   0
       8,370           30,649   22278.87601                     0                   0
       8,658           31,569   22910.98465                     0                   0
       8,952           32,516   23563.50686                     0                   0
       9,254           33,491   24236.99703                     0                   0
       9,564           34,496    24932.0285                     0                   0
       9,882           35,531   25649.19406                     0                   0
      10,208           36,597   26389.10639                     0                   0
      10,542           37,695   27152.39864                     0                   0
      10,886           38,825   27939.72489                     0                   0
11,238   39,990   28751.76075   0   0
11,601   41,190   29589.20393   0   0
11,973   42,426   30452.77478   0   0
12,355   43,698   31343.21698   0   0
12,748   45,009   32261.29808   0   0
13,152   46,360   33207.81023   0   0
13,567   47,750   34183.57082   0   0
13,993   49,183   35189.42317   0   0
14,432   50,658   36226.23728   0   0
14,883   52,178   37294.91057   0   0
                        Total
   Upfront cash investment         Monthly Live-in cash flow
               100000 -    118,743 -9895.29   11,371
                     0-     18,478 -1539.81    2,971
                     0-     18,278 -1523.13    2,906
                     0-     18,184 -1515.29    2,843
                     0-     18,079   -1506.6   2,782
                     0         408 34.03603    1,401
                     0         533 44.44098    1,382
                     0         668  55.7054    1,363
                     0         814 67.83319    1,345
                     0         970 80.82922    1,327
                     0      10,363 863.5965      738
                     0      10,540 878.3476      738
                     0      10,728 893.9875      738
                     0      10,926  910.525      738
             Series1 0      11,136    927.97     738
                     0      11,356 946.3331      738
                     0      11,588 965.6262      738
                     0      11,830 985.8619      738
                     0      12,085 1007.054      738
                     0      12,351 1029.217      738
                     0      12,628 1052.367      738
                     0      12,918 1076.521      738
                     0      13,220 1101.696      738
                     0      13,535 1127.911      738
                     0      13,862 1155.186      738
                     0      14,202 1183.541      738
55 58 61
                     0      14,556      1213     738
                     0      14,923 1243.584      738
                     0      15,304 1275.317      738
                     0      15,699 1308.226      738
                     0      16,108 1342.336      738
                     0      16,532 1377.675      738
                     0      16,971 1414.271      738
                     0      17,426 1452.155      738
                     0      17,896 1491.356      738
                     0      18,383 1531.909      738
                     0      18,886 1573.845      738
                     0      19,406    1617.2     738
                     0      19,944 1662.011      738
                     0      20,500 1708.314      738
                     0      21,074 1756.148      738
                     0      21,667 1805.554      738
                     0      22,279 1856.573      738
                     0      22,911 1909.249      738
                     0      23,564 1963.626      738
                     0      24,237  2019.75      738
                     0      24,932 2077.669      738
                     0      25,649 2137.433      738
                     0      26,389 2199.092      738
                     0      27,152    2262.7     738
                     0      27,940  2328.31      738
0   28,752    2395.98   738
0   29,589   2465.767   738
0   30,453   2537.731   738
0   31,343   2611.935   738
0   32,261   2688.442   738
0   33,208   2767.318   738
0   34,184   2848.631   738
0   35,189   2932.452   738
0   36,226   3018.853   738
0   37,295   3107.909   738

     5.05%
 8.6   3.79     32.594
 8.6   2.68     23.048
3.51   2.68     9.4068
5.38   3.93    21.1434
3.93   3.05    11.9865

               98.1787

              1056.786




 3.6    2.4       8.64
 3.2      7       22.4
 5.9    2.7      15.93
 4.3    6.4      27.52
 4.4    4.3      18.92

                 93.41

              1005.456



 99
168
 48
315

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:5/7/2012
language:English
pages:9