|
|
|
| | | | | | | | | | | | | | | | | | | | Market Comparison of plazas | Property 1 | Property 3 | Property 4 | Property 6 | Property 7 | Property 8 | Property 9 | Property 10 | Property 11 | Property 13 | Property 14 | Property 15 | Property 17 | Property 18 | Property 19 | Property 20 | Property 21 | Property 22 | Address | | | | | | | | | | | | | | | | | | | Number of units | 19 | 8 | 16 | 5 | 4 | 7 | 8 | 19 | 10 | 6 | 4 | 4 | 7 | 8 | 8 | 10 | 10 | 10 | List Price | 1650000 | 1495000 | 1750000 | 1169000 | 1399888 | 1490000 | 2080000 | 4390000 | 1100000 | 1100000 | 1450000 | 1599000 | 1436000 | 1150000 | 1675000 | 1015555 | 4390000 | 1475000 | Sale price (negotiated - market price) | 1567500 | 1420250 | 1662500 | 1110550 | 1329893.6 | 1415500 | 1976000 | 4170500 | 1045000 | 1045000 | 1377500 | 1519050 | 1364200 | 1092500 | 1591250 | 964777.25 | 4170500 | 1401250 | Initial Investment | 391875 | 355062.5 | 415625 | 277637.5 | 332473.4 | 353875 | 494000 | 1042625 | 261250 | 261250 | 344375 | 379762.5 | 341050 | 273125 | 397812.5 | 241194.313 | 1042625 | 350312.5 | Mortgage Amount | 1175625 | 1065187.5 | 1246875 | 832912.5 | 997420.2 | 1061625 | 1482000 | 3127875 | 783750 | 783750 | 1033125 | 1139287.5 | 1023150 | 819375 | 1193437.5 | 723582.938 | 3127875 | 1050937.5 | Potential rent income | 228184 | 209406 | 243896 | 115896 | 133800 | 143000 | 213236 | 348700 | 123433 | 153760 | 160236 | 163889 | 150600 | 108000 | 150000 | 114118 | 377600 | 205321 | Vacancy & credit losses (3.5%) | 7986.44 | 7329.21 | 8536.36 | 4056.36 | 4683 | 5005 | 7463.26 | 0 | 4320.155 | 5381.6 | 5608.26 | 5736.115 | 5271 | 5400 | 7500 | 3994.13 | 13216 | 7186.235 | Effective rental income | 220197.56 | 202076.79 | 235359.64 | 111839.64 | 129117 | 137995 | 205772.74 | 348700 | 119112.845 | 148378.4 | 154627.74 | 158152.885 | 145329 | 102600 | 142500 | 110123.87 | 364384 | 198134.765 | Other income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Gross operating income | 220197.56 | 202076.79 | 235359.64 | 111839.64 | 129117 | 137995 | 205772.74 | 348700 | 119112.845 | 148378.4 | 154627.74 | 158152.885 | 145329 | 102600 | 142500 | 110123.87 | 364384 | 198134.765 | Operating expenses | 56892.0 | 84248.0 | 83940.0 | 7774.0 | 14600.0 | 0.0 | 22681.0 | 0.0 | 19913.0 | 45200.0 | 34278.0 | 0.0 | 14200.0 | 0.0 | 0.0 | 27889.0 | 0.0 | 80735.4 | Net operating income | 163305.6 | 117828.8 | 151419.6 | 96000.0 | 114517.0 | 137995.0 | 183091.7 | 348700.0 | 99199.8 | 103178.4 | 120349.7 | 158152.9 | 131129.0 | 102600.0 | 142500.0 | 82234.9 | 364384.0 | 117399.3 | Annual debt service incl.principal | 92367.7 | 83690.8 | 97965.7 | 65441.0 | 78366.2 | 83410.8 | 116439.2 | 245754.0 | 61578.5 | 61578.5 | 81171.6 | 89512.7 | 80387.9 | 64377.5 | 93767.2 | 56851.2 | 245754.0 | 82571.2 | Principal paid (1 year re-cap/equity build-up) | 20400.5 | 18484.1 | 21636.9 | 14453.4 | 17308.1 | 18422.2 | 25717.0 | 54277.6 | 13600.4 | 13600.4 | 17927.7 | 19769.9 | 17754.6 | 14218.5 | 20709.6 | 12556.3 | 54277.6 | 18236.8 | Interest paid only | 71967.2 | 65206.6 | 76328.9 | 50987.7 | 61058.2 | 64988.6 | 90722.3 | 191476.4 | 47978.1 | 47978.1 | 63243.9 | 69742.8 | 62633.3 | 50159.0 | 73057.6 | 44295.0 | 191476.4 | 64334.3 | Cash flow before taxes | 70937.8 | 34138.0 | 53453.9 | 30559.0 | 36150.8 | 54584.2 | 66652.5 | 102946.0 | 37621.4 | 41599.9 | 39178.1 | 68640.2 | 50741.1 | 38222.5 | 48732.8 | 25383.7 | 118630.0 | 34828.2 | Return CFBT CFBT/In Inv per unit | 3733.6 | 4267.3 | 3340.9 | 6111.8 | 9037.7 | 7797.7 | 8331.6 | 5418.2 | 3762.1 | 6933.3 | 9794.5 | 17160.1 | 7248.7 | 4777.8 | 6091.6 | 2538.4 | 11863.0 | 3482.8 | Tax liability | 11823.0 | 5689.7 | 8909.0 | 5093.2 | 6025.1 | 9097.4 | 11108.8 | 17157.7 | 6270.2 | 6933.3 | 6529.7 | 11440.0 | 8456.9 | 6370.4 | 8122.1 | 4230.6 | 19771.7 | 5804.7 | Cash flow after taxes | 59114.9 | 28448.4 | 44544.9 | 25465.8 | 30125.6 | 45486.8 | 55543.8 | 85788.3 | 31351.1 | 34666.6 | 32648.5 | 57200.2 | 42284.3 | 31852.1 | 40610.7 | 21153.1 | 98858.3 | 29023.5 | Return CFBT CFBT/In Inv (cash on cash) | 18.1% | 9.6% | 12.9% | 11.0% | 10.9% | 15.4% | 13.5% | 9.9% | 14.4% | 15.9% | 11.4% | 18.1% | 14.9% | 14.0% | 12.3% | 10.5% | 11.4% | 9.9% | Return CFAT CFAT/In Inv (cash on cash) | 15.1% | 8.0% | 10.7% | 9.2% | 9.1% | 12.9% | 11.2% | 8.2% | 12.0% | 13.3% | 9.5% | 15.1% | 12.4% | 11.7% | 10.2% | 8.8% | 9.5% | 8.3% | Return CFBT CFBT/In Inv (modified) | 23.3% | 14.8% | 18.1% | 16.2% | 16.1% | 20.6% | 18.7% | 15.1% | 19.6% | 21.1% | 16.6% | 23.3% | 20.1% | 19.2% | 17.5% | 15.7% | 16.6% | 15.1% | Cap. Rate | 10.4% | 8.3% | 9.1% | 8.6% | 8.6% | 9.7% | 9.3% | 8.4% | 9.5% | 9.9% | 8.7% | 10.4% | 9.6% | 9.4% | 9.0% | 8.5% | 8.7% | 8.4% | Gross income multiplier | 7.5% | 7.4% | 7.4% | 10.5% | 10.8% | 10.8% | 10.1% | 12.6% | 9.2% | 7.4% | 9.4% | 10.1% | 9.9% | 11.2% | 11.8% | 9.2% | 12.0% | 7.4% | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
|
|