TEST
constante:
TGA:
dynaSourceNbrUnits:
| PERFORMANCE ANALYSIS WITH CMHC FINANCING 10-year Analysis | 10-year Analysis | ||
|---|---|---|---|
| Total Cash Out 727421.2674$ |
IRR: 3.996334266% | Debt Coverage Ratio: 1.1 | Cashflow/Door/Month 66.08483206$ |
| Cap Rate : 3.305073407% | Cash on Cash : 0.545088534% | Return on Investment : 0.016882922% | |
| Economic Value : 593672.4934 $ | Minimal Occupancy Ratio : 94.66407022% | Net Income Multiplier : 30.25651406 | |
| Area's Cap Rate (Laval, G5A) : % | |||
| Offered Price: | |||
| Pourcentage logements vacants | |||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash flow | 1440.771636 | 1982.013886 | 2530.481434 | 3086.269195 | 3649.473313 | 4220.191185 | 4798.521468 | 5384.564103 | 5978.420326 | 6580.192687 |
| Principal paid | 6282.491847 | 6665.095601 | 7070.999923 | 7501.623818 | 7958.472708 | 8443.143696 | 8957.331148 | 9502.832614 | 10081.55512 | 10695.52183 |
| Sub-Total | 7723.263483 | 8647.109487 | 9601.481357 | 10587.89301 | 11607.94602 | 12663.33488 | 13755.85262 | 14887.39672 | 16059.97545 | 17275.71451 |
| Capital appreciation | 23976 | 24455.52 | 24944.6304 | 25443.52301 | 25952.39347 | 26471.44134 | 27000.87016 | 27540.88757 | 28091.70532 | 28653.53943 |
| Total Equity | 31699.26348 | 33102.62949 | 34546.11176 | 36031.41602 | 37560.33949 | 39134.77622 | 40756.72278 | 42428.28429 | 44151.68077 | 45929.25394 |
| Cumulative Equity | 31699.26348 | 64801.89297 | 99348.00473 | 135379.4207 | 172939.7602 | 212074.5365 | 252831.2592 | 295259.5435 | 339411.2243 | 385340.4782 |
| Loan Financing | |
|---|---|
| Interest rate | |
| Amortization | |
| Down Payment % | |
| Down Payment $ | |
| Mortgage Amount | |
| Monthly Mortgage Payment | 3001.607576 |
| Mortgage payment incl CMHC premium | 996 $ |
| Capital appreciation rate | |
| Summary of Revenues | |||
|---|---|---|---|
| Potential gross income | 59760 | ||
| Vacancy/Bad debt | 1747.98 | ||
| Effective gross income | 58012.02$ | ||
| Operating expenses | 19340.8 $ | ||
| Operating expenses according to CMHC | 18390.8 $ | ||
| Net Income | 38671.22 | ||
| Net Income according to CMHC | 39621.22 | ||
| Annual mortgage cost | 36019.29091 | ||
| Annual cash flow | 0.545088534 | ||
| OPERATING EXPENSES | |
|---|---|
| Municipal and school taxes : | Insurance: |
| Electricity: | Heating oil: |
| Natural gas: | Snow removal |
| Equipment rental: | Lawn: |
| Internet: | Cable: |
| Other: | Number of Elevators: |
| Number of Household Appliances: | Number of Heat Pumps: |
| Annual expenses yearly increase: | |
| STANDARDIZED EXPENDITURES CMHC 2023 | |
|---|---|
| Maintenance : $ | Janitor : $ |
| Management : $ | Management (Percentage) : % |
| Elevator : $ | Household appliances : $ |
| Heat pumps : $ | |
| TOTAL OPERATING EXPENSES: 19340.8 $ | |
| GROSS REVENUE | |
|---|---|
| Rental income | |
| Parking revenue | |
| Laundry revenue | |
| Other | |
| Net income | 38671.22 |
| Annual gross revenue yearly increase | |
| POTENTIAL GROSS INCOME | 59760 |
| DOWNPAYMENT CALCULATION | |||
|---|---|---|---|
| Downpayment % | 15.00% | TRANSACTION FEES | |
| Economic value | 593672.4934 $ | 9% tax on CMHC loan premium | 2724.956745 $ |
| Mortgage amount | 231 814 $ | Subscription fees | 900 $ |
| Required down payment | 43 186 $ | Environmental analysis - Phase 1 | 1 500 $ |
| Other acquisition fees | 9 119 $ | Transfer fee | 2 528 $ |
| Total cash required | 52 305 $ | Notary & Inspection fees | 3 200 $ |
| 9 119 $ | |||
| COMPARABLE SOLD PROPERTIES | 12 months | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Address | Selling Price | Economic Value | Net Cash flow | ROI | NIM | Cap Rate | ||||||
| 16A Rue Laure-Conan, La Malbaie | $335 000 | $359 690 | 3 471 $ | 19.42% | 18.5 | 5.4% | ||||||
| AVERAGE | 500 000 $ | 497 859 $ | 3 564 $ | 19.22% | 17.4% | 19.7 | 5.1% | |||||
| 10-year Analysis | ||
|---|---|---|
| Actual Average Rent : | 515 $ | |
| IRR: | 19.42% | |
| Cashflow/Door/Month : | 66 $ | |
| Cap Rate : | 5.4% | |
| Return on Investment : | 19.4% | |
| Net Income Multiplier : | 18.5 | |
| Cash on Cash : | 7.8% | |
| Walk Score | Transit Score | Bike Score |
| 60 | 90 | 100 |
| APARTMENT | TYPE | RENT | HEATING |
|---|---|---|---|
| 1 | 4-1/2 | 900 $ | 1 |
| 1 | 4-1/2 | 900 $ | 1 |
| 1 | 4-1/2 | 900 $ | 1 |
OPTIMIZATION POTENTIAL ANALYSIS
| Unit | Actual average Rent | Average Rent for the Area (G5A) | Maximum Rent |
|---|---|---|---|
| Rooms | Germany | Germany | Germany |
| Lofts | Germany | Germany | Germany |
| 1-1/2 | Germany | Germany | Germany |
| 2-1/2 | Germany | Germany | Germany |
| 3-1/2 | Germany | Germany | Germany |
| 4-1/2 | Germany | Germany | Germany |
| 5-1/2 | Germany | Germany | Germany |
| 6-1/2 | Germany | Germany | Germany |
| 7-1/2 | Germany | Germany | Germany |
| Others | Germany | Germany | Germany |
| ACTUAL REVENUE ( All Apartments Occupied) |
|---|
| 37 080 $ |
| OPTIMIZATION - MINIMAL GOAL |
| 37 595 $ |
| OPTIMIZATION - IDEAL GOAL |
| 105 900 $ |
| IMPACT ON ECONOMIC VALUE | |
|---|---|
| Économic Value at time of purchase : | 359 690 $ |
| Économic Value after Optimization : | 1 588 232 $ |
| Increase of Economic Value : | 1 228 542 $ |
| Additional Potential Borrowing on Capital : | 859 979 $ |
| OTHER AREAS OF OPTIMIZATION | |
|---|---|
| Actual Situation | |
| Wifi supplied | |
| Heating Paid by Owner | |
| Storage Space Fee | |
| Parking Space Fee | |
| Laundry Room Fee | |
| Rented Hot Water Tank | |
| Property Renovated | |