Property Report: 117 Conroy RENTAL

Property Report :

117 Conroy

117 Conroy, Guelph,

Created on: Apr 14, 2025

Author: Rick Grimes

117 Conroy, Guelph,

Multifamily: 5 bedrooms , 2 bathrooms + 2 kitchens

Size: 1090 SF

Investment strategy: Rental Property

Purchase Price$ 320,000
Rent$ 1,975/mo
Monthly Cash Flow$ 499
Cash on Cash Return8.55 %

Financial Analysis

Cash on Cash Return 8.55 %
Internal Rate of Return (IRR) 21.64 %
Capitalization Rate 5.61 %
Gross Rent Multiplier (GRM) 13.50
Debt-coverage Ratio (DCR) 1.50
Operating Expense Ratio (OER) 22.98 %

Financial Breakdown

Purchase Price $ 320,000
Purchase Costs $ 6,000
Repair/Construction Costs $ 0
Total Capital Needed
$ 326,000
Financing $ 256,000
Total Cash Needed
$ 70,000
Cash at Closing
$ 64,000
Cash During Rehab
$ 6,000

Operating Analysis

Rent $ 1,975/mo
Gross Operating Income (GOI) $ 23,321
Total Expenses $ 5,358
Net Operating Income (NOI) $ 17,963
Annual Debt Service $ 11,979
Cash Flow Before Taxes (CFBT) $ 5,984
Income Tax Liability $ 0
Cash Flow After Taxes (CFAT) $ 5,984

117 Conroy

Purchase Price $ 320,000
Address 117 Conroy , Guelph, CA
Type Multifamily
Number of Units 2
Size 1090 SF
Bedrooms 5
Bathrooms 2
Kitchens 2
117 Conroy Guelph,
  • Multifamily

    Bldg type
  • 1,090

    SqFt
  • 5

    Beds
  • 2

    Baths

It wasn't possible to load comps automatically for this address. You can add them manually below.

Close filters
 
Property address Distance Beds Baths SqFt Bldg type Date sold Sale price $/SqFt Notes Edit
Average: $ 0 $ 0 /SqFt
Estimated ARV:
$ 0

Comps selected: 0

Annual Property Operating Data

Incomes % of GOI
Gross Scheduled Income
$ 23,700    
Total Gross Income $ 23,700  
Vacancy loss
$ 379  
Gross Operating Income
$ 23,321 100.00 %
Expenses
Repairs $ 1,185 5.08 %
Prop_taxes $ 2,673 11.46 %
Prop_insurance $ 1,500 6.43 %
Total Expenses $ 5,358 22.98 %
Net Operating Income
$ 17,963 77.02 %

Cash Flow (Year 1)

Net Operating Income $ 17,963 77.02 %
Annual Debt Service $ 11,979 51.37 %
Cash Flow Before Taxes (CFBT)
$ 5,984 25.66 %
Income Tax Liability $ 0 0.00 %
Cash Flow After Taxes (CFAT)
$ 5,984 25.66 %

Operating Ratios

Operating Expense Ratio
22.98 %
Break-Even Ratio
74.34 %

Financial Measures

Net Present Value
$ 90,686
Internal Rate of Return
21.64 %
Profitability Index
2.30
Annual Depreciation $ 9,309

Holding period of 10 years and discount rate of 10.00% were used for calculation of NPV and IRR. The rest of the financial measures are for the 1st year only and therefore don't provide such an exact information.

Investment Return Ratios

Cash on Cash Return
8.55 %
Return on Investment
31.41 %
Capitalization Rate
5.61 %
Gross Rental Yield
7.41 %
Gross Rent Multiplier
13.50
Financing
Down Payment $ 64,000
Loan $ 256,000
Loan to Value Ratio
80.00 %
Loan to Cost Ratio
80.00 %
Debt Coverage Ratio 1.50
Loan

Financing of: Purchase price ($ 320,000)

Type Amortized
Loan Amount $ 256,000
Down payment (20%) $ 64,000
Amortization 30 years
Interest Rate 2.40 %
Monthly Payment $ 998.25

This chart shows the process of accumulation of investor's equity. There is some equity created right at the beginning with the rehab/construction and later investor's equity is rising by paying off the principal of the loan and also by appreciation over the years. All the green parts is the cummulative equity belonging to the investor and the red part belongs to the lender.

Year
Operational Analysis
Gross Scheduled Income
Vacancy Loss
Gross Operating Income
Expenses
Net Operating Income
Loan Payment
Payment Interest Part
Payment Principal Part
Cash Flow
Repairs/Construction
Cash Flow Before Taxes
Depreciation 0
Taxes
Cash Flow After Taxes

Note: All amounts in the table above are in $

Resale Price Evaluation Methods

The property is sold after 10 years. Below is the resale price calculated using different methods.

Appreciation (5.00%) $ 521,246
Cap Rate (6.33%) & NOI $ 323,836
Gross Rent Multiplier $ 369,084

Sale Proceeds

Projected Selling Price $ 521,246
Costs of Sale (5.00%) $ 26,062
Net Sale Proceeds Before Tax $ 305,057

In the resale analysis we do not include any calculation for taxes that might be owed on sale of the property. The tax laws for the resale are rather complex and subjected to frequent changes.

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax $ 305,057
Investor Cash Outlay $ 70,000
Net Assets $ 235,057
Average Yield
Annual Net Assets $ 23,506
Average Cash Flow (After Taxes) $ 0
Average Annual Gain (After Taxes) $ 0
Average Annual Yield (After Taxes) 0.00 %

This charts shows Net Present Value (NPV) when property is sold in various years, i.e. when sold in 5th year, the NPV is calculated from 5 years of Cash Flow (including the selling price) and this NPV is displayed in year 5. Optimal holding period can be estimated, using this method - when NPV is the highest. Please note that appreciation growth can change these numbers greatly. It sometimes makes sense to sell the property even before the end of the mortgage term.

Sign in to edit this report, add or compare properties. Don't have an acount? Sign up now!