9311 W WILLIAMS ST Tolleson AZ

July 6, 2011
Dani Beit-Or
Arizona, Blog, General Investing, Investment Properties, Phoenix, Single Family, US Real Estate

Real Estate Analysis Property Analysis

Download PDF Report
Disclaimer
This tool is provided “As Is”. All information is believed to be accurate, but not guaranteed. It is intended for the purpose of illustrative projections. The information provided is not intended to replace or substitute any legal, accounting, investment, real estate, tax or other professional advice, consultation or service. The author of this tool is not responsible nor liable for any damages arising from the use of the tool.

Executive Summary

Property Description

Name	9311 W WILLIAMS ST Tolleson? AZ
Address	9311 W WILLIAMS ST, Tolleson
Type	Singlefamily
Size	2224 SF
Rooms	3 bed. + 3 bath.
Purchase Price	$ 94,900
Rent	$ 950/month

Financing Overview

Purchase Price	$ 94,900
Down Payment	$ 18,980
Mortgage (30yr @ 5.50%)	$ 75,920
Loan-to-Value (LTV)	80.00 %
Closing Costs	$ 2,500
Total Aquisition Cost	$ 98,900

Income, Expenses and Cash Flow (Year 1)

Gross Operating Income (GOI)	$ 10,830
Total Expenses	$ 3,999
Net Operating Income (NOI)	$ 6,831
Annual Debt Service	$ 5,173
Rehabilitaion	$ 0
Cash Flow Before Taxes (CFBT)	$ 1,658
Income Tax Liability	$ 0
Cash Flow After Taxes (CFAT)	$ 1,658

Financial Analysis

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

Net Present Value (NPV)	$ 41,446
Internal Rate of Return (IRR)	11.91 %
Cash on Cash Return	7.21 %
Return on Equity (ROE)	7.21 %
Capitalization Rate	7.20 %
Gross Rent Multiplier (GRM)	8.32
Debt-coverage Ratio (DCR)	2.20
Operating Expense Ratio (OER)	36.93 %

Resale Analysis

Sale Price in year 15 (Appreciation:1%)	$ 110,176
Sale Proceeds (Before Tax)	$ 49,707
Optimal Holding Period (based on NPV)	30 years

Property Description

INVESTOR SPECIAL! HOUSE IS RENTED AND CASH FLOWING AT $950 A MONTH WITH TENANT IN PLACE TILL 5/1/2012. THIS IS A GREAT INVESTMENT OPPORTUNITY! SELLER HAS OTHER CASH FLOWING RENTED PROPERTIES ASK LISTING AGENT FOR INFORMATION!

Price	$ 94,900
Address	9311 W WILLIAMS ST, Tolleson, 85353 , AZ
Country	US
Year Built	2005
Type	Singlefamily
Size	2224 SF
Number of Bedrooms	3
Number of Bathrooms	3

Operation Effectiveness

The Annual Property Operating Data

Incomes		% of GOI
Gross Scheduled Rent Income	$ 11,400
Total Gross Income	$ 11,400
Vacancy loss	$ 570
Gross Operating Income	$ 10,830	100.00 %
Expenses
Repairs	$ 899	8.31 %
Manager	$ 1,140	10.53 %
Prop_Taxes	$ 1,000	9.23 %
Prop_Insurance	$ 600	5.54 %
HOA	$ 360	3.32 %
Total Expenses	$ 3,999	36.93 %
Net Operating Income	$ 6,831	63.07 %

Cash Flow (1st year)

Net Operating Income	$ 6,831	63.07 %
Annual Debt Service	$ 5,173	47.76 %
Rehabilitation	$ 0	0.00 %
Cash Flow Before Taxes (CFBT)	$ 1,658	15.31 %
Income Tax Liability	$ 0	0.00 %
Cash Flow After Taxes (CFAT)	$ 1,658	15.31 %

Gross scheduled income (GSI)

represents the total of monthly rents for the particular property, including the potential rents from vacant units and uncollectable rents.

Vacancy and Credit Loss

represents the part of the potential rental income that is lost because of unoccupied units or uncollectable rent from tenants.

Gross Operating Income (GOI)

is the actual income which is expected to be collected in the property.

Operating Expenses

are expenses necessary for maintaining the property and ensuring its continued ability to produce income (doesn't include mortgage payments or depreciation).

Net Operating Income (NOI)

is simply the gross operating income minus operating expenses.

Operating Ratios

Operating Expense Ratio	36.93 %
Break-Even Ratio	84.49 %

Cash Flow

represents 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.

Operating Expense Ratio

is the ratio of the operating expenses to the gross operating income (GOI).

Break-Even Ratio (BER)

is another benchmark used by mortgage lenders. It estimates 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.

Financial Effectiveness

Financial Measures

Net Present Value	$ 41,446
Internal Rate of Return	11.91 %
Profitability Index	2.80
House P/E Ratio	3.36
Annual Depreciation	$ 2,761

Holding period of 15 years and discount rate of 10% 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.

Net Present Value (NPV)

is probably the best measure of any investment thanks to its complexity. It takes 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. Therefore in contrast from most of the measurements, NPV count fully with the time value of money. More information and example is on the blog.

Internal Rate of Return (IRR)

is a rate which an investment will return over the estimated period of ownership. It is in fact the discount rate that produces NPV of zero.

Profitability Index

is very similar to NPV. It also calculates with the present values of future cash flows and discount rate, therefore it takes in account the time value of money. Profitability index is a ratio which shows if the present value of the cash flows is worth the initial investment.

House P/E Ratio

is often used when measuring other investment tools, such as stocks. The Real Estate P/E ratio counts with the initial investment and annual net operating income.

Investment Return Ratios

Cash on Cash Return	7.21 %
Return on Investment	11.34 %
Return on Equity	7.21 %
Capitalization Rate	7.20 %
Gross Rental Yield	12.01 %
Gross Rent Multiplier	8.32

Cash on Cash Return

is in fact equity dividend rate. It is a ratio between annual cash flow before taxes and the total initial investment, expressed as a percentage. It is not an exact measurement of an investment, because it does not take in account the future value of money.

Return on Investment

is very similar to Cash on Cash Return, but also takes in account appreciation of the property in the first year.

Return on Equity

is one of the financial measures used as well on other types of investments. In Real Estate the return means cash flow after taxes (CFAT) and equity is the initial investment.

Gross Rental Yield

can be used for a particular property or also as a market indicator when using median values of rent and house prices. It is counted from gross scheduled rent and initial investment.

Capitalization Rate

is calculated as ratio of the net operating income and the value of the property. It is in fact the discount rate, used for discounting the future income to determine its present value.

Gross Rent Multiplier

is counted as a ratio of market value of the property and gross scheduled income.

Financing Overview and Analysis

Acquisition Cost
Purchase Price	$ 94,900
Closing Costs	$ 2,500
Loan Costs	$ 1,500
Total	$ 98,900

Financing		% of Acq.
Down Payment + Costs	$ 18,980	19.19 %
Mortgage	$ 75,920	76.76 %
Loan to Value Ratio		80.00 %
Debt Coverage Ratio		2.20

Mortgage
Mortgage Amount	$ 75,920
Length	30 years
Interest Rate	5.50 %
Monthly Payment	$ 431.07

Long Term Financial Forecast

Year	0	1	5	10	15
Operational Analysis
Gross Scheduled Income	$ 0	$ 11,400	$ 11,863	$ 12,468	$ 13,104
Vacancy Loss	$ 0	$ 570	$ 593	$ 623	$ 655
Gross Operating Income	$ 0	$ 10,830	$ 11,270	$ 11,845	$ 12,449
Expenses	$ 0	$ 3,999	$ 4,162	$ 4,374	$ 4,597
Net Operating Income	$ 0	$ 6,831	$ 7,108	$ 7,471	$ 7,852
Financing
Mortgage Payment	$ 0	$ 5,173	$ 5,173	$ 5,173	$ 5,173
Payment Interest Part	$ 0	$ 4,150	$ 3,899	$ 3,497	$ 2,968
Payment Principal Part	$ 0	$ 1,023	$ 1,274	$ 1,676	$ 2,205
Cash Flow
Rehabilitation	$ 0	$ 0	$ 0	$ 0	$ 0
Cash Flow Before Taxes	$ -22,980	$ 1,658	$ 1,935	$ 2,298	$ 2,679
Depreciation	$ 0	$ 2,761	$ 2,761	$ 2,761	$ 2,761
Taxes	$ 0	$ 0	$ 0	$ 0	$ 0
Cash Flow After Taxes	$ -22,980	$ 1,658	$ 1,935	$ 2,298	$ 2,679

Shortened

Year	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
Operational Analysis
Gross Scheduled Income	$ 0	$ 11,400	$ 11,514	$ 11,629	$ 11,745	$ 11,863	$ 11,982	$ 12,101	$ 12,222	$ 12,345	$ 12,468	$ 12,593	$ 12,719	$ 12,846	$ 12,974	$ 13,104
Vacancy Loss	$ 0	$ 570	$ 576	$ 581	$ 587	$ 593	$ 599	$ 605	$ 611	$ 617	$ 623	$ 630	$ 636	$ 642	$ 649	$ 655
Gross Operating Income	$ 0	$ 10,830	$ 10,938	$ 11,048	$ 11,158	$ 11,270	$ 11,382	$ 11,496	$ 11,611	$ 11,727	$ 11,845	$ 11,963	$ 12,083	$ 12,204	$ 12,326	$ 12,449
Expenses	$ 0	$ 3,999	$ 4,039	$ 4,080	$ 4,120	$ 4,162	$ 4,203	$ 4,245	$ 4,288	$ 4,331	$ 4,374	$ 4,418	$ 4,462	$ 4,506	$ 4,552	$ 4,597
Net Operating Income	$ 0	$ 6,831	$ 6,899	$ 6,968	$ 7,038	$ 7,108	$ 7,179	$ 7,251	$ 7,323	$ 7,397	$ 7,471	$ 7,545	$ 7,621	$ 7,697	$ 7,774	$ 7,852
Financing
Mortgage Payment	$ 0	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173	$ 5,173
Payment Interest Part	$ 0	$ 4,150	$ 4,092	$ 4,031	$ 3,967	$ 3,899	$ 3,827	$ 3,751	$ 3,671	$ 3,586	$ 3,497	$ 3,402	$ 3,303	$ 3,197	$ 3,086	$ 2,968
Payment Principal Part	$ 0	$ 1,023	$ 1,080	$ 1,141	$ 1,206	$ 1,274	$ 1,346	$ 1,421	$ 1,502	$ 1,586	$ 1,676	$ 1,770	$ 1,870	$ 1,976	$ 2,087	$ 2,205
Cash Flow
Rehabilitation	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0
Cash Flow Before Taxes	$ -22,980	$ 1,658	$ 1,726	$ 1,795	$ 1,865	$ 1,935	$ 2,006	$ 2,078	$ 2,151	$ 2,224	$ 2,298	$ 2,373	$ 2,448	$ 2,524	$ 2,601	$ 2,679
Depreciation	$ 0	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761	$ 2,761
Taxes	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0	$ 0
Cash Flow After Taxes	$ -22,980	$ 1,658	$ 1,726	$ 1,795	$ 1,865	$ 1,935	$ 2,006	$ 2,078	$ 2,151	$ 2,224	$ 2,298	$ 2,373	$ 2,448	$ 2,524	$ 2,601	$ 2,679

Resale Analysis

Resale Price Evaluation Methods

The property is sold after 15 years.

Appreciation (1.00%)	$ 110,176
Cap Rate (7.20%) & NOI	$ 109,085
Gross Rent Multiplier	$ 109,085

Sale Proceeds

In the resale analysis we don't count with taxes which might occur when selling the property. The tax laws for the resale are rather complex and subjected to frequent changes, and are different in every country.

Projected Selling Price	$ 110,176
Costs of Sale (7.00%)	$ 7,712
Mortgage Balance Payoff	$ 52,757
Early Payoff Penalty (0.00 %)	$ 0
Sale Proceeds Before Tax	$ 49,707

Net Assets and Yield

Net Assets
Sale Proceeds Before Tax	$ 49,707
Down Payment	$ 18,980
Net Assets	$ 30,727
Yield
Annual Net Assets	$ 2,048
Average Cash Flow (After Taxes)	$ 2,157
Average Annual Yield	$ 4,206
Average Annual Return	4.43 %

Optimal Holding Period based on NPV

Holding Period	30 years
Max NPV	$ 113,734

Sensitivity Analysis

Loan to Value ratio

Your current LTV ratio is: 80.00%.

LTV	NPV	IRR
80.00 %	$ 41,446	11.91 %
0%	$ -32,197	5.05 %
10%	$ -27,625	5.40 %
20%	$ -23,053	5.81 %
30%	$ -18,481	6.30 %
40%	$ -13,909	6.90 %
50%	$ -9,337	7.64 %
60%	$ -4,766	8.62 %
70%	$ -194	9.94 %
80%	$ 4,378	11.91 %
90%	$ 8,950	15.33 %

This sensitivity analysis is using the configured holding period, the length and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

Mortgage Ammortization (Length)

Your current mortgage ammortization is 30 years.

Years	NPV	IRR
30	$ 41,446	11.91 %
5	$ -22,244	5.15 %
10	$ -17,030	5.00 %
15	$ -12,896	4.74 %
20	$ -3,944	8.35 %
25	$ 1,170	10.50 %
30	$ 4,378	11.91 %

This sensitivity analysis is using the loan amount and interest rate of the first mortgage and discount rate of 10%. It counts only with a conventional type of loan.

9311 W WILLIAMS ST Tolleson AZ

Real Estate Analysis Property Analysis

Executive Summary

Property Description

Financing Overview

Income, Expenses and Cash Flow (Year 1)

Financial Analysis

Resale Analysis

Property Description

Operation Effectiveness

The Annual Property Operating Data

Cash Flow (1st year)

Gross scheduled income (GSI)

Vacancy and Credit Loss

Gross Operating Income (GOI)

Operating Expenses

Net Operating Income (NOI)

Operating Ratios

Cash Flow

Operating Expense Ratio

Break-Even Ratio (BER)

Financial Effectiveness

Financial Measures

Net Present Value (NPV)

Internal Rate of Return (IRR)

Profitability Index

House P/E Ratio

Investment Return Ratios

Cash on Cash Return

Return on Investment

Return on Equity

Gross Rental Yield

Capitalization Rate

Gross Rent Multiplier

Financing Overview and Analysis

Resale Price Evaluation Methods

Sale Proceeds

Net Assets and Yield

Optimal Holding Period based on NPV

Loan to Value ratio

Mortgage Ammortization (Length)

———–

Real Estate Analysis Free provides Real Estate analysis, Real Estate Investment Software, Free reports and Sample Reports.

Leave a Comment

Cancel Reply