1330 Onaway Trl, Algonquin IL 60102

1330 Onaway Trl, Algonquin, IL 60102

Singlefamily: 3 bedrooms , 2 bathrooms

Year built: 1978, Size: 1152 SF

Investment strategy: Rental Property

Purchase Price$ 299,900

Rent$ 2,888/mo

Monthly Cash Flow$ 599

Cash on Cash Return10.18 %

Financial Analysis

Cash on Cash Return	10.18 %
Internal Rate of Return (IRR)	15.01 %
Capitalization Rate	9.43 %
Gross Rent Multiplier (GRM)	8.65
Debt-coverage Ratio (DCR)	1.34
Operating Expense Ratio (OER)	15.85 %
After Repair Value	$ 299,900

Financial Breakdown

Purchase Price	$ 299,900
Purchase Costs	$ 10,548
Repair/Construction Costs	$ 0
Total Capital Needed Total Capital Needed Includes all projects costs (except selling costs). Total Capital Needed Includes all projects costs (except selling costs).	$ 310,448
Financing	$ 239,920
Total Cash Needed Cash out of Pocket Shows rehabber's cash outlay. Cash out of Pocket Shows rehabber's cash outlay.	$ 70,528
Cash at Closing Cash at Closing This number includes down payment and loan points. Cash at Closing This number includes down payment and loan points.	$ 64,778
Cash During Rehab Cash During Rehab Shows the cash amount remaining to fund the purchase and rehab/construction. Cash During Rehab Shows the cash amount remaining to fund the purchase and rehab/construction.	$ 5,750

Operating Analysis

Rent	$ 2,888/mo
Gross Operating Income (GOI)	$ 33,616
Total Expenses	$ 5,328
Net Operating Income (NOI)	$ 28,288
Annual Debt Service	$ 21,105
Cash Flow Before Taxes (CFBT)	$ 7,183
Income Tax Liability	$ 117
Cash Flow After Taxes (CFAT)	$ 7,066

Welcome Home to this charming ranch nestled on the east side of The Fox River! Conveniently located near Downtown Algonquin, waterfront restaurants, night life, shopping, river fun, and more! Just a short drive to the Barrington Train Station! Step through the front door and be immersed in tons of natural lighting! Kitchen features Granite countertops and ample space for all your cooking needs! Relax on your rear deck at the end of a hard day and enjoy ever-changing views of the private, fenced-in rear yard! Have you been looking for the one ? Then we have the one for you!

Purchase Price	$ 299,900
Address	1330 Onaway Trl , Algonquin, 60102, IL
MLS^® #	12217620
Listing Agent	FRANK RUSIN
Year Built	1978
Type	Singlefamily
Size	1152 SF
Bedrooms	3
Bathrooms	2

Property History

Date	Price	Change	Event
12/17/2024	299900		Price Changed
11/25/2024	314900		Listed

Annual Property Operating Data

Incomes		% of GOI
Gross Scheduled Income Gross Scheduled Income (GSI) Represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents. Gross Scheduled Income (GSI) Represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.	$ 34,656
Total Gross Income	$ 34,656
Vacancy loss Vacancy and Credit Loss Part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants. Vacancy and Credit Loss Part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.	$ 1,040
Gross Operating Income Gross Operating Income (GOI) An actual income which is expected to be collected in the property. Gross Operating Income (GOI) An actual income which is expected to be collected in the property.	$ 33,616	100.00 %
Expenses Operating Expenses Expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn't include mortgage payments or depreciation). Operating Expenses Expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn't include mortgage payments or depreciation).
Insurance	$ 1,500	4.46 %
Property tax	$ 3,828	11.39 %
Total Expenses	$ 5,328	15.85 %
Net Operating Income Net Operating Income (NOI) Important measurement calculated as gross operating income minus operating expenses. Net Operating Income (NOI) Important measurement calculated as gross operating income minus operating expenses.	$ 28,288	84.15 %

Cash Flow (Year 1)

Net Operating Income	$ 28,288	84.15 %
Annual Debt Service	$ 21,105	62.78 %
Cash Flow Before Taxes (CFBT) Cash Flow All the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property. Cash Flow All the inflows and outflows of cash for a certain property (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.	$ 7,183	21.37 %
Income Tax Liability	$ 117	0.35 %
Cash Flow After Taxes (CFAT) Cash Flow All the inflows and outflows of cash (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property. Cash Flow All the inflows and outflows of cash (including mortgage payments). We can calculate cash flow before taxes (CFBT) or cash flow after taxes (CFAT) which is CFBT minus any tax liability arising from the operation of the property.	$ 7,066	21.02 %

Operating Ratios

Operating Expense Ratio Operating Expense Ratio Ratio of the operating expenses to the gross operating income (GOI). Operating Expense Ratio Ratio of the operating expenses to the gross operating income (GOI).	15.85 %
Break-Even Ratio Break-Even Ratio (BER) Another benchmark used by mortgage lenders, estimating how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less. Break-Even Ratio (BER) Another benchmark used by mortgage lenders, estimating how vulnerable is a certain property to defaulting on its mortgage if part of the rental income is declined. Most of the lenders are looking for BER of 85% or less.	78.63 %

Financial Measures

Net Present Value Net Present Value (NPV) Probably the best measure of any investment thanks to its complexity; taking into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. More information and an example on the blog. Net Present Value (NPV) Probably the best measure of any investment thanks to its complexity; taking into account all future cash flows including the selling price, and it converts all these amounts to their present values using discount rate required by the investor. More information and an example on the blog.	$ 226,183
Internal Rate of Return Internal Rate of Return (IRR) Rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero. Internal Rate of Return (IRR) Rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.	15.01 %
Profitability Index Profitability Index Similar to NPV, also calculates with the present values of future cash flows and discount rate. It shows whether the present value of the cash flows is worth the initial investment. Good investment should be above 1.0 Profitability Index Similar to NPV, also calculates with the present values of future cash flows and discount rate. It shows whether the present value of the cash flows is worth the initial investment. Good investment should be above 1.0	4.21
Annual Depreciation	$ 8,724

Holding period of 30 years and discount rate of 5.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 Cash on Cash Return Ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It does not take in account the future value of money. Cash on Cash Return Ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It does not take in account the future value of money.	10.18 %
Return on Investment Return on Investment Very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year. Return on Investment Very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.	22.94 %
Capitalization Rate Capitalization Rate Calculated as ratio of the net operating income and the value of the property. Capitalization Rate Calculated as ratio of the net operating income and the value of the property.	9.43 %
Gross Rental Yield Gross Rental Yield Used for a particular property or also as a market indicator when using median values of rent and house prices - counted from gross scheduled rent and initial investment. Gross Rental Yield Used for a particular property or also as a market indicator when using median values of rent and house prices - counted from gross scheduled rent and initial investment.	11.56 %
Gross Rent Multiplier Gross Rent Multiplier (GRM) Counted as a ratio of market value of the property and gross scheduled income. Gross Rent Multiplier (GRM) Counted as a ratio of market value of the property and gross scheduled income.	8.65

Financing		% of ARV
Down Payment	$ 59,980	20.00 %
HomeStyle	$ 239,920	80.00 %
Loan to Value Ratio Loan to Value Ratio Shows sum of all purchase and rehab loans divided by purchase price. Loan to Value Ratio Shows sum of all purchase and rehab loans divided by purchase price.		80.00 %
Loan to Cost Ratio Loan to Cost Ratio Shows sum of all purchase and rehab loans to construction cost (purchase price + repairs). Loan to Cost Ratio Shows sum of all purchase and rehab loans to construction cost (purchase price + repairs).		80.00 %
Debt Coverage Ratio		1.34

HomeStyle Financing of: Purchase + Repairs ($ 299,900)
Type	Amortized
Loan Amount	$ 239,920
Down payment (20%)	$ 59,980
Amortization	30 years
Interest Rate	7.99 %
Monthly Payment	$ 1,758.78

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	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
Operational Analysis
Gross Scheduled Income	0	34,656	35,349	36,056	36,777	37,513	38,263	39,028	39,809	40,605	41,417	42,245	43,090	43,952	44,831	45,728	46,642	47,575	48,527	49,497	50,487	51,497	52,527	53,577	54,649	55,742	56,857	57,994	59,154	60,337	61,544
Vacancy Loss	0	1,040	1,060	1,082	1,103	1,125	1,148	1,171	1,194	1,218	1,243	1,267	1,293	1,319	1,345	1,372	1,399	1,427	1,456	1,485	1,515	1,545	1,576	1,607	1,640	1,672	1,706	1,740	1,775	1,810	1,846
Gross Operating Income	0	33,616	34,289	34,974	35,674	36,387	37,115	37,857	38,615	39,387	40,175	40,978	41,798	42,634	43,486	44,356	45,243	46,148	47,071	48,012	48,973	49,952	50,951	51,970	53,010	54,070	55,151	56,254	57,379	58,527	59,697
Expenses	0	5,328	5,435	5,543	5,654	5,767	5,883	6,000	6,120	6,243	6,367	6,495	6,625	6,757	6,892	7,030	7,171	7,314	7,460	7,610	7,762	7,917	8,075	8,237	8,402	8,570	8,741	8,916	9,094	9,276	9,462
Net Operating Income	0	28,288	28,854	29,431	30,020	30,620	31,233	31,857	32,494	33,144	33,807	34,483	35,173	35,876	36,594	37,326	38,072	38,834	39,610	40,403	41,211	42,035	42,876	43,733	44,608	45,500	46,410	47,338	48,285	49,251	50,236
Loan Payment	0	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105	21,105
Payment Interest Part	0	19,097	18,931	18,750	18,555	18,344	18,115	17,867	17,599	17,308	16,993	16,652	16,283	15,883	15,451	14,982	14,474	13,925	13,329	12,685	11,987	11,231	10,413	9,526	8,566	7,527	6,401	5,183	3,863	2,433	886
Payment Principal Part	0	2,008	2,175	2,355	2,550	2,761	2,990	3,238	3,507	3,797	4,112	4,453	4,822	5,222	5,655	6,123	6,631	7,181	7,776	8,420	9,118	9,874	10,693	11,579	12,539	13,578	14,704	15,923	17,243	18,672	20,220
Cash Flow
Repairs/Construction	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Cash Flow Before Taxes	-70,528	7,183	7,749	8,326	8,914	9,515	10,127	10,752	11,389	12,039	12,702	13,378	14,068	14,771	15,489	16,221	16,967	17,729	18,505	19,297	20,105	20,930	21,770	22,628	23,503	24,395	25,305	26,233	27,180	28,145	29,130
Depreciation	0	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724	8,724
Taxes	0	117	300	489	685	888	1,098	1,317	1,543	1,778	2,023	2,277	2,541	2,817	3,105	3,405	3,719	4,046	4,389	4,748	5,125	5,520	5,935	6,371	6,829	7,312	7,821	8,358	8,925	9,523	10,156
Cash Flow After Taxes	-70,528	7,066	7,449	7,837	8,229	8,627	9,029	9,435	9,846	10,261	10,679	11,101	11,526	11,954	12,384	12,816	13,249	13,682	14,116	14,549	14,980	15,410	15,836	16,257	16,673	17,082	17,484	17,875	18,255	18,622	18,974

Note: All amounts in the table above are in $

Resale Price Evaluation Methods

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

Capitalization (9.43%) & NOI	$ 532,722
Appreciation (3.00%)	$ 727,936
Gross Rent Multiplier	$ 532,353

Sale Proceeds

Projected Selling Price	$ 532,722
Costs of Sale (3.50%)	$ 18,645
Net Sale Proceeds Before Tax	$ 514,077

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	$ 514,077
Investor Cash Outlay	$ 70,528
Net Assets	$ 443,549
Average Yield
Annual Net Assets	$ 14,785
Average Cash Flow (After Taxes)	$ 12,410
Average Annual Gain (After Taxes)	$ 27,195
Average Annual Yield (After Taxes)	9.07 %

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.

Property Report: 1330 Onaway Trl, Algonquin RENTAL

Property Report :

1330 Onaway Trl, Algonquin, IL 60102

Executive Summary