$3,995,000
Investment Summary
- Monthly Cash Flow
- -$19,654
- Cap Rate
- -0.2%
- Cash-on-Cash Return
- -25.7%
- Debt Coverage Ratio
- -0.04
- Internal Rate of Return (5 years)
- -20.7%
Cash Flow
Net Operating Income (NOI) minus mortgage payments.
Calculation:
NOI - Mortgage Payments
Cap Rate (Market Value)
Capitalization Rate is a rate of return that compares the yearly Net Operating Income (NOI) to the market value.
Calculation:
NOI / Market Value
Cash-on-Cash Return (CoC)
Annual Cash Flow / Cash Invested
Calculation:
Annual cash flow divided by initial cash invested.
Debt Coverage Ratio (DCR)
Net Operating Income (NOI) divided by total debt payments.
Calculation:
NOI / Total Debt Payments
Internal Rate of Return (IRR)
A metric for assessing profitability over time. IRR is the discount rate at which the net present value (NPV) of all future cash flows (positive and negative) from an investment equals zero — including both periodic cash flow (such as rent) and a projected sale at the end of the holding period. It represents the expected annualized return, accounting for income, expenses, and the recovery of capital through a future sale.
Property Description
Steeped in luxury and sophistication, this home seamlessly blends timeless craftsmanship, premium designer finishes, and state-of-the-art technology. Thoughtfully designed for comfort, wellness, and entertainment, every element reflects precision, care, and refined living. Professionally decorated with carefully curated finishes, textures, and furnishings, the interior exudes both elegance and ease. The grand inviting foyer sets the tone for the opulent lifestyle that awaits in this spectacular Hidden Lakes residence. Host unforgettable gatherings in the soaring cathedral-style great room and elegant formal dining room. Accomplish your best work in the richly appointed library office, designed for both sophistication and productivity. At the heart of the home lies a masterfully renovated kitchen, reimagined with a raised ceiling to enhance openness and light. Custom cabinetry is beautifully complemented by leathered Taj Mahal quartzite, featured throughout the countertops, backsplash, and expansive center island. Gather family and friends around the built-in quartzite dining table that comfortably seats eight. Culinary excellence is further enhanced with Dual LaCornue ranges and Waterstone faucets. Additional appliance upgrades include two dishwashers, a 36-inch Sub-Zero refrigerator, and a matching 36-inch Sub-Zero freezer, installed side-by-side for seamless integration and superior performance. The custom-designed butler's pantry adds both functionality and flair, offering additional refrigeration and ample storage. No detail was overlooked in transforming this home's Spa-Inspired all-ensuite bathroom renovations, where elevated aesthetics meet exceptional functionality. Throughout the home, all bathroom faucets have been upgraded to Perrin & Rowe fixtures, renowned for their timeless elegance and superior craftsmanship. Extend your entertaining to the expansive walkout lower level, featuring a full-service kitchen and bar, controlled wine cellar and tasting room, game room, recreation room with a cozy fireplace, plus access to the backyard pool and hot tub oasis. Enjoy family movie nights in the state-of-the-art theater. Workout conveniently in the home gym. Escape to the primary ensuite featuring a sitting area and completely redesigned bathroom for a private spa retreat, highlighted by floor-to-ceiling marble, a solid cast iron nickel bathtub, and a luxurious steam shower equipped with a rainfall head and multi-setting body sprays. This renovation also includes an expansive custom-designed dream closet, seamlessly integrated into the suite to provide optimal convenience and style. The result is an atmosphere of pure tranquility and indulgence. This home boasts a comprehensive suite of mechanical upgrades engineered for comfort, efficiency, and peace of mind. Highlights include seven new air conditioning units for superior cooling, seven new upgraded heating systems that enhance energy efficiency and performance, and a fully modified ventilation system equipped with UV light filtration to ensure medical-grade air quality throughout. Additionally, two state-of-the-art, commercial-grade boilers provide consistent hot water and high-performance radiant heated floors. New sump pumps have been installed in the basement for added security, and the well pump has been replaced with a high-efficiency model. The smart-controlled sprinkler system is fully operable via smartphone for convenient irrigation management. Protect your family and your property with the newly installed comprehensive home security system, complete with surveillance cameras and remote monitoring capabilities. All major appliances and mechanical systems were professionally installed by ABT, with full warranties in place for added protection and peace of mind. Conveniently located to I-90, Metra station, Award-winning Barrington schools, The Arboretum Mall for your shopping and dining pleasure, Quaint Downtown Barrington, Churches, Parks and Recreation, & more!
Build Your Team
Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.
Agents
Match with investor-friendly agents who can help you find, analyze, and close your next deal
Lenders
Get the best funding…find investor-friendly lenders who specialize in your deal strategy
Property Managers
Transition to passive investing. Find a trusted property management partnership that lasts.
Tax Pros & Accountants
Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more
Location
Property Details
Parking
- Description: Attached, Garage, Garage On-Site, Garage Door Opener(s), Transmitter(s), Heated
- Details: Circular Driveway, Garage Door Opener, Heated Garage, On Site, Attached, Garage, Driveway
- Garage Spaces: 4
- Spaces Total: 4
Bedroom Information
- # of Bedrooms: 5
Bathroom Information
- # of Baths (Full): 5
- # of Baths (Total): 7.0
Interior Features
- # of Rooms: 16
- # of Stories: 2
- Basement: Yes
- Basement Description: Sump Pump, Finished, Full, Walk-Out Access
- Fireplace: Yes
Exterior Features
- Exterior Walls Materials: Masonry
- Foundation: Concrete Perimeter
- Roof Material: Shake
- Pool: Yes
HOA
- Has HOA: Yes
- HOA Fee: $11,000/annually
Land Information
- Land Use: Residential
- Land Use Subtype: Single Family Residential
Lot Information
- Parcel ID: 0122105002
- Lot Size: 0 sqft
Property Information
- Property Type: Single Family Residence
- Style: Traditional
- Year Built: 2007
Tax Information
- Annual Tax: $43,516
Utilities
- Water & Sewer: Well
- Heating: Natural Gas, Steam, Radiant, Zoned, Other, Radiant Floor
- Cooling: Ceiling Fan(s), Central Air, Zoned
Location
- County: Cook
Listing Details
Investment Summary
- Monthly Cash Flow
- -$19,654
- Cap Rate
- -0.2%
- Cash-on-Cash Return
- -25.7%
- Debt Coverage Ratio
- -0.04
- Internal Rate of Return (5 years)
- -20.7%
Cash Flow
Net Operating Income (NOI) minus mortgage payments.
Calculation:
NOI - Mortgage Payments
Cap Rate (Market Value)
Capitalization Rate is a rate of return that compares the yearly Net Operating Income (NOI) to the market value.
Calculation:
NOI / Market Value
Cash-on-Cash Return (CoC)
Annual Cash Flow / Cash Invested
Calculation:
Annual cash flow divided by initial cash invested.
Debt Coverage Ratio (DCR)
Net Operating Income (NOI) divided by total debt payments.
Calculation:
NOI / Total Debt Payments
Internal Rate of Return (IRR)
A metric for assessing profitability over time. IRR is the discount rate at which the net present value (NPV) of all future cash flows (positive and negative) from an investment equals zero — including both periodic cash flow (such as rent) and a projected sale at the end of the holding period. It represents the expected annualized return, accounting for income, expenses, and the recovery of capital through a future sale.
Purchase Details
Purchase PriceThe price paid for the property. Purchase price:
| $3,995,000 |
|---|---|
Amount FinancedThe amount of the purchase financed through a loan. Amount financed:
| -$3,196,000 |
Down paymentThe initial payment made towards the purchase. Down payment:
| $799,000 |
Closing CostsFees and expenses associated with purchasing a property, typically ranging from 2% to 5% of the home’s purchase price, paid at the end of a home purchase to cover services like lending, title transfer, and taxes. Closing costs:
| $119,850 |
Rehab CostsCosts incurred to repair or improve the property, including: roof, flooring, exterior siding, kitchen, exterior paint, bathrooms, etc. Rehab costs:
| $0 |
Initial Cash InvestedThe total initial cash invested in the property. Calculation:Down payment + Buying costs + Rehab costs Initial cash invested:
| $918,850 |
Square Feet (SQFT)The total square footage of the property. Square feet:
| 11,600 |
Cost Per Square FootCost per square foot of the property. Calculation:Purchase Price / Square Feet Cost per square foot:
| $344 |
Monthly Rent Per Square FootMonthly rent divided by the number of square feet. This ratio helps investors compare rental income efficiency across properties, markets, and unit sizes Calculation:Monthly Rent / Square Feet Monthly rent per square foot:
| $0.47 |
Financing Details
Loan AmountThe total sum of money borrowed from a lender to finance a property purchase. Calculation:Purchase Price - Down Payment
Loan amount:
| $3,196,000 |
|---|---|
Loan to Value Ratio (LTV)Loan amount divided by the market value of the property. Calculation:Loan Amount / Market Value
Loan to value ratio:
| 80.0% |
Loan TypeThe type of loan (e.g., fixed, adjustable).
Loan type:
| Amortizing |
TermThe loan repayment period in years.
Term:
| 30 years |
Interest RateThe percentage a lender charges on the borrowed amount of a loan, determining the cost of borrowing money.
Interest rate:
| 5.875% |
Principal & Interest (PI)The principal is the portion of the loan payment that reduces the loan balance. The interest is the lender's charge for borrowing money. Calculation:(P * r * (1 + r) ** n) / ((1 + r) ** n - 1) Where:
P = Loan amount (principal)
Principal & interest:
| $18,906 |
Property TaxesAnnual taxes levied by local governments on real estate properties. These taxes fund public services like schools, roads, and emergency services.
Property tax:
| $3,626 |
InsuranceThe costs for insurance coverage to protect against financial losses due to risks like fire, natural disasters, theft, liability, or tenant-related damages. Calculation:Assumes 7% of gross rental income, unless insurance rates are specified.
Insurance:
| $385 |
Private Mortgage Insurance (PMI)A fee that borrowers pay when they take out a conventional loan with a loan-to-value (LTV) ratio above 80%.
Private mortgage insurance (PMI):
| $0 |
Monthly PaymentThe fixed amount a borrower pays each month to repay a loan. It typically includes principal and interest (P&I) and may also cover property taxes, insurance, HOA fees, and PMI if escrowed. Monthly payment:
| $22,917 |
Operating Income
| % Rent | Monthly | Yearly | |
|---|---|---|---|
Gross RentThe total rental income received from tenants before deducting any expenses. Includes base rent, late fees, pet fees, parking fees, and other recurring charges.
Gross rent:
| $5,500 | $66,000 | |
Vacancy LossExpected loss of rent due to vacancies.
Vacancy loss:
(6%)
| 6% | -$330 | -$3,960 |
Operating IncomeGross rental income minus vacancy loss. Calculation:Gross rent - Vacancy loss
Operating income:
| $5,170 | $62,040 |
Operating Expenses
| % Rent | Monthly | Yearly | |
|---|---|---|---|
Property TaxesAnnual taxes levied by local governments on real estate properties. These taxes fund public services like schools, roads, and emergency services. | 66% | -$3,626 | -$43,516 |
InsuranceThe costs for insurance coverage to protect against financial losses due to risks like fire, natural disasters, theft, liability, or tenant-related damages. Calculation:Assumes 7% of gross rental income, unless insurance rates are specified. | 7% | -$385 | -$4,620 |
Property ManagementThe costs associated with hiring a property manager to handle the day-to-day operations of a rental property. Includes management fees, leasing fes, eviction fees, etc. Calculation:Assumes 8% of gross rental income. | 8% | -$440 | -$5,280 |
Repairs & MaintenanceOngoing costs for routine upkeep and minor fixes needed to keep a property in good working condition. Calculation:Assumes 5% of gross rental income. Varies by property age and condition. | 5% | -$275 | -$3,300 |
Capital ExpensesLarge, infrequent costs for major improvements or replacements, like a new roof, HVAC system, or appliances. Calculation:Assumes 5% of gross rental income. Varies by property age. | 5% | -$275 | -$3,300 |
HOA FeesRegular dues paid to a Homeowners Association for community maintenance, amenities, and management. Similar fees include: Condo Association Fees, Co-op Maintenance Fees, etc. | 17% | -$917 | -$11,004 |
Operating ExpensesRecurring costs required to maintain and manage a rental property, including property taxes, insurance, maintenance, repairs, utilities (if paid by the owner), property management fees, and other day-to-day expenses. Calculation:Insurance + Property Taxes + Property Management + Repairs & Maintenance + Capital Expenditures + HOA Fees | 108% | -$5,918 | -$71,020 |
Cash Flow
| Monthly | Yearly | |
|---|---|---|
Net Operating Income (NOI)The income generated from a property after deducting all operating expenses but before deducting mortgage payments, taxes, and capital expenditures. Calculation:Gross Operating Income - Operating Expenses
Net operating income:
| -$748 | -$8,976 |
Mortgage PaymentThe fixed amount a borrower pays each month to repay a loan. It typically includes principal and interest (P&I) and may also cover property taxes, insurance, HOA fees, and PMI if escrowed. | -$18,906 | -$226,872 |
Cash FlowNet Operating Income (NOI) minus mortgage payments. Calculation:NOI - Mortgage Payments | $19,654 | $235,848 |