9427 W Illini St Tolleson AZ (Phoenix)

June 12, 2011

Dani BeitOr

Arizona, Blog, Investment Properties, Phoenix, Properties, Rental Property
Property Report : 9427 W Illini St Tolleson AZ
Category: Rental Property
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  9427 W Illini St Tolleson AZ 
Address  9427 W Illini St, Tolleson 
Type  Singlefamily 
Size  1386 SF 
Rooms  3 bed. + 2 bath. 
Purchase Price  $ 79,000 
Rent  $ 925/month 
Financing Overview
Purchase Price  $ 79,000 
Down Payment  $ 15,800 
Mortgage (30yr @ 5.50%)  $ 63,200 
LoantoValue (LTV)  80.00 % 
Closing Costs  $ 2,000 
Total Aquisition Cost  $ 83,000 
Income, Expenses and Cash Flow (Year 1)
Gross Operating Income (GOI)  $ 10,545 
Total Expenses  $ 2,509 
Net Operating Income (NOI)  $ 8,036 
Annual Debt Service  $ 4,306 
Rehabilitaion  $ 0 
Cash Flow Before Taxes (CFBT)  $ 3,730 
Income Tax Liability  $ 0 
Cash Flow After Taxes (CFAT)  $ 3,730 
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)  $ 56,407 
Internal Rate of Return (IRR)  21.88 % 
Cash on Cash Return  18.84 % 
Return on Equity (ROE)  18.84 % 
Capitalization Rate  10.17 % 
Gross Rent Multiplier (GRM)  7.12 
Debtcoverage Ratio (DCR)  2.58 
Operating Expense Ratio (OER)  23.79 % 
Resale Analysis
Sale Price in year 15 (Appreciation:1%)  $ 95,780 
Sale Proceeds (Before Tax)  $ 45,158 
Optimal Holding Period (based on NPV)  30 years 
Property Description
This is a 1386 square foot, single family home. It is located at 9427 W Illini St Tolleson, Arizona. The nearest schools are Union Elementary School , Underdown Junior High School and Tolleson Union High School.
Price  $ 79,000 
Address  9427 W Illini St, Tolleson, 85353 , AZ 
Country  US 
Year Built  2007 
Type  Singlefamily 
Size  1386 SF 
Number of Bedrooms  3 
Number of Bathrooms  2 
Operation Effectiveness
The Annual Property Operating Data
Incomes  % of GOI  
Gross Scheduled Rent Income  $ 11,100  
Total Gross Income  $ 11,100  
Vacancy loss  $ 555  
Gross Operating Income  $ 10,545  100.00 % 
Expenses  
Repairs  $ 500  4.74 % 
Manager  $ 999  9.47 % 
Prop_Taxes  $ 111  1.05 % 
Prop_Insurance  $ 539  5.12 % 
HOA  $ 360  3.41 % 
Total Expenses  $ 2,509  23.79 % 
Net Operating Income  $ 8,036  76.21 % 
Cash Flow (1st year)
Net Operating Income  $ 8,036  76.21 % 
Annual Debt Service  $ 4,306  40.84 % 
Rehabilitation  $ 0  0.00 % 
Cash Flow Before Taxes (CFBT)  $ 3,730  35.37 % 
Income Tax Liability  $ 0  0.00 % 
Cash Flow After Taxes (CFAT)  $ 3,730  35.37 % 
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  23.79 % 
BreakEven Ratio  72.16 % 
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).
Financial Effectiveness
Financial Measures
Net Present Value  $ 56,407 
Internal Rate of Return  21.88 % 
Profitability Index  3.85 
House P/E Ratio  2.46 
Annual Depreciation  $ 2,298 
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  18.84 % 
Return on Investment  22.83 % 
Return on Equity  18.84 % 
Capitalization Rate  10.17 % 
Gross Rental Yield  14.05 % 
Gross Rent Multiplier  7.12 
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  $ 79,000 
Closing Costs  $ 2,000 
Loan Costs  $ 2,000 
Total  $ 83,000 
Financing  % of Acq.  
Down Payment + Costs  $ 15,800  19.04 % 
Mortgage  $ 63,200  76.14 % 
Loan to Value Ratio  80.00 %  
Debt Coverage Ratio  2.58 
Mortgage  
Mortgage Amount  $ 63,200 
Length  30 years 
Interest Rate  5.50 % 
Monthly Payment  $ 358.84 
Long Term Financial Forecast
Year  0  1  5  10  15 
Operational Analysis  
Gross Scheduled Income  $ 0  $ 11,100  $ 11,551  $ 12,140  $ 12,759 
Vacancy Loss  $ 0  $ 555  $ 578  $ 607  $ 638 
Gross Operating Income  $ 0  $ 10,545  $ 10,973  $ 11,533  $ 12,121 
Expenses  $ 0  $ 2,509  $ 2,611  $ 2,744  $ 2,884 
Net Operating Income  $ 0  $ 8,036  $ 8,362  $ 8,789  $ 9,237 
Financing  
Mortgage Payment  $ 0  $ 4,306  $ 4,306  $ 4,306  $ 4,306 
Payment Interest Part  $ 0  $ 3,455  $ 3,246  $ 2,911  $ 2,471 
Payment Principal Part  $ 0  $ 851  $ 1,060  $ 1,395  $ 1,836 
Cash Flow  
Rehabilitation  $ 0  $ 0  $ 0  $ 0  $ 0 
Cash Flow Before Taxes  $ 19,800  $ 3,730  $ 4,056  $ 4,483  $ 4,931 
Depreciation  $ 0  $ 2,298  $ 2,298  $ 2,298  $ 2,298 
Taxes  $ 0  $ 0  $ 0  $ 0  $ 0 
Cash Flow After Taxes  $ 19,800  $ 3,730  $ 4,056  $ 4,483  $ 4,931 
Resale Analysis
Resale Price Evaluation Methods
The property is sold after 15 years.
Appreciation (1.00%)  $ 95,780 
Cap Rate (10.17%) & NOI  $ 90,828 
Gross Rent Multiplier  $ 90,808 
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  $ 95,780 
Costs of Sale (7.00%)  $ 6,705 
Mortgage Balance Payoff  $ 43,918 
Early Payoff Penalty (0.00 %)  $ 0 
Sale Proceeds Before Tax  $ 45,158 
Net Assets and Yield
Net Assets  
Sale Proceeds Before Tax  $ 45,158 
Down Payment  $ 15,800 
Net Assets  $ 29,358 
Yield  
Annual Net Assets  $ 1,957 
Average Cash Flow (After Taxes)  $ 4,318 
Average Annual Yield  $ 6,275 
Average Annual Return  7.94 % 
Optimal Holding Period based on NPV
Holding Period  30 years 
Max NPV  $ 122,358 
Sensitivity Analysis
Loan to Value ratio
Your current LTV ratio is: 80.00%.
LTV  NPV  IRR 
80.00 %  $ 56,407  21.88 % 
0%  $ 7,716  8.64 % 
10%  $ 3,910  9.25 % 
20%  $ 104  9.99 % 
30%  $ 3,702  10.84 % 
40%  $ 7,508  11.91 % 
50%  $ 11,313  13.28 % 
60%  $ 15,119  15.14 % 
70%  $ 18,925  17.72 % 
80%  $ 22,731  21.88 % 
90%  $ 26,537  30.47 % 
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  $ 56,407  21.88 % 
5  $ 569  10.16 % 
10  $ 4,910  11.79 % 
15  $ 8,351  14.16 % 
20  $ 15,803  18.07 % 
25  $ 20,061  20.41 % 
30  $ 22,731  21.88 % 
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.
Leave a Comment