Rental Properties: Cash Cow Or Money Pit?

Real estate investors must have basic valuation skills to make buy, sell, or hold decisions. Real estate investment companies have developed sophisticated valuation models to aid them in making investment decisions. However, by using spreadsheet tools an individual can produce an adequate valuation on most income-producing real estate. This would include residential real estate purchased as residential rental property.

SEE: Tips For The Prospective Landlord

Valuing real estate using discounted cash flow or capitalization methods is similar to valuing stocks or bonds. The only difference is that cash flows are derived from leasing space as opposed to selling products and services. Read on to find to out how any investor can create a valuation satisfactory enough to weed through prospective investment opportunities.

Individual Valuations
Some individuals feel that producing a valuation is unnecessary if a certified appraisal has been completed. However, an investor's valuation may differ from an appraisal for several reasons. The investor may have different opinions about the property's ability to attract tenants or the lease rates that tenants are willing to pay. As a prospective purchaser or seller, the investor may feel that the property has more or less risk than the appraiser. Appraisers are compelled to conduct separate assessments of value. They include the cost to replace the property, a comparison of recent and comparable transactions and an income approach. Some of these methods commonly lag the market, underestimating value during uptrends, and overvaluing assets in a downtrend.

Finding opportunities in the real estate market involves finding properties that have been incorrectly valued by the market. This often means managing a property to a level that surpasses market expectations. A valuation should provide one's estimate of the true income-producing potential of a property.

Real Estate Valuation
The income approach to evaluating real estate is similar to the process for valuing stocks, bonds, or any other income-generating investment. Most analysts use the discounted cash flow (DCF) method to determine an asset's net present value (NPV). NPV is the property value in today's dollars that will achieve the investor's risk adjusted return.The NPV is determined by discounting the periodic cash flow available to owners by the investor's required rate of return (RROR). Since the RROR is an investor's required rate of return for the risks involved, the value derived is a risk-adjusted value for that individual investor. By comparing this value to market prices, an investor is able to make a buy, hold, or sell decision.

Stock values are derived by discounting dividends, bond values by discounting interest coupon payments. Properties are valued by discounting net cash flow or the cash available to owners after all expenses have been deducted from leasing income. Valuing a property involves estimating all the rental revenues and then deducting all expenses required to execute and maintain those leases.

SEE: Exploring Real Estate Investments: Finding Investment Value

All income estimates come directly from leases. Leases are contractual agreements between tenants and a landlord. All rent and contractual increases in rent (escalations) will be spelled out in the leases, as well as options for space and rent concessions. Owners also recoup part or all of the property expenses from tenants. The manner in which this income is collected is also stated in the lease contract. There are three main types of leases:

  • Full-service leases
  • Net leases
  • Triple-net (NNN) leases
In full-service leases, tenants do not pay anything in addition to rent. In net leases, tenants usually pay their portion of the increase in expenses for the period after they move into the property. In triple-net leases, the tenant pays a pro-rata share of all property expenses.

The following are the types of expenses that have to be considered when preparing an income valuation:

  • Leasing costs
  • Management cost
  • Capital costs
Leasing costs refer to the expenses necessary to attract tenants and to execute leases. Management costs refer to property level expenses, such as utilities, cleaning, taxes, etc. as well as any costs to manage the property. Income less operating expenses equals net operating income (NOI). NOI is the cash flow derived from normal operations of the property. Cash flow is then derived by subtracting capital costs from NOI. Capital costs are any periodic capital outlays to maintain the property. These include any capital for leasing commissions, tenant improvements, or capital reserves for future property upgrades.

Valuation Example
Once periodic cash flows are determined, they can be discounted back to determine property value. Figure 1 shows a simple valuation design that can be adjusted to value most properties.

Assumption Value Assumption Value
Growth in Income Yr1-10 (g) 4% Growth in Income Yr11+ (g) 3%
RROR (K) 13% Expenses % of Income 40%
Capital Expenses $10,000 Reversion Cap Rate (K-g) 10%
Figure 1

The valuation assumes a property that creates annual rental income of $100,000 in year one, which grows by 4% annually and 3% after year 10. Expenses are estimated at 40% of income. Capital reserves are modeled at $10,000 per year. The discount rate, or RROR, is set at 13%. The capitalization rate for determining the reversion value of the property in year 10 is estimated at 10%. In financial terminology, this capitalization rate equals K-g, where K is the investor's RROR (required rate of return) and g is the expected growth in income. K-g is also known as the investor's required income return, or the amount of the total return that is provided by income.

The value of the property in year 10 is derived by taking the estimated NOI for year 11 and dividing it by the capitalization rate. Assuming the investor's required rate of return stays at 13% then the capitalization would equal 10%, or K-g (13% -3%). In Figure 2, NOI in year 11 is $88,812. After periodic cash flows are calculated, they are then discounted back by the discount rate (13%) to derive the NPV of $58,333.

Item Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7 Yr8 Yr 9 Yr 10 Yr 11

Income
100 104 108.16 112.49 116.99 121.67 126.54 131.60 136.86 142.33 148.02
Expenses -40 -41.60 -43.26 -45 -46.80 -48.67 -50.62 -52.64 -54.74 -56.93 -59.21
Net Operating Income (NOI) 60 62.40 64.896 67.494 70.194 73.002 75.924 78.96 82.116 85.398 88.812
Capital -10 -10 -10 -10 -10 -10 -10 -10 -10 -10 -
Cash Flow (CF) 50 52.40 54.90 57.49 60.19 63 65.92 68.96 72.12 75.40 -
Reversion - - - - - - - - - 888.12 -
Total Cash Flow 50 52.40 54.90 57.49 60.19 63 65.92 68.96 72.12 963.52 -
Dividend Yield 9% 9% 9% 10% 10% 11% 11% 12% 12% 13% -

Figure 2 (in thousands of dollars)

Figure 2 provides a basic format that can be used to value any income-producing or rental property. Investors purchasing residential real estate as rental property should prepare valuations to determine whether rental rates being charged are adequate enough to support the purchase price being paid. Although appraisers will often use a 10-year cash flow by default, investors should produce cash flows that mirror the assumptions on which the property is assumed to be purchased. This format, although simplified, can be adjusted to value any property, regardless of complexity. Even hotels can be valued this way. Just think of nightly room rentals as one-day leases.

SEE: 8 Must-Have Numbers For Evaluating A Real Estate Investment

Buy, Sell or Hold
When purchasing a property, if an investor's assessed value is greater than the seller's offer or appraised value, then the property can be purchased with a high probability of receiving the RROR. Conversely, when selling a property, if the assessed value is less than a buyer's offer, the property should be sold. In addition, if the assessed value is in line with the market and the RROR offers an adequate return for the risk involved, the owner may decide to hold the investment until there is a disequilibrium between the valuation and market value.

Value can be defined as the greatest amount that someone would be willing to pay for a property. When purchasing an asset, financing should not affect the ultimate value of the property because each buyer has different financing options available. However this is not the case for investors who already own properties that have been financed. Financing must be considered when deciding on an appropriate time to sell because financing structures, such as prepayment penalties, can rob the investor of his or her sale's proceeds. This is important in cases where investors have received favorable financing terms that are no longer available in the market. The existing investment with debt may provide better risk-adjusted returns than can be achieved when reinvesting the prospective sales proceeds. Adjust risk RROR to include the additional financial risk of mortgage debt.

The Bottom Line
Whether buying or selling, it is possible to produce a valuation model accurate enough to assist in the decision-making process. The math involved in creating the model is relatively straightforward and within the grasp of most investors. After gaining some rudimentary knowledge about local market standards, lease structures and how income and expenses work in different property types, one should be able to forecast future cash flows.

SEE: Tax Deductions For Rental Property Owners

More From Investopedia

--

Get stories like this on the Yahoo app and discover more every day.
Download it now.
Loading...
  • VW's Skoda to ponder U.S. production amid market push Reuters - 8 minutes ago

    Volkswagen's (VOWG_p.DE) Czech division Skoda said it will assess the possibility of building cars in the United States as it considers selling in the world's second largest auto market where its parent continues to grapple with an emissions … More »

  • Bunker-busting bombs close Aleppo underground schools: charity
    Bunker-busting bombs close Aleppo underground schools: charity AFP News - 33 minutes ago

    Bunker-busting bombs are putting children in so much danger in Syria's Aleppo that they won't even be able to return to underground schools when classes resume this weekend, a charity said Friday. The "ferocious assault" on Aleppo could deprive … More »

  • Most Asian Index Futures Drop Amid Bank Rout; Oil, Copper Swing Bloomberg - 41 minutes ago

    Shares in New Zealand fell early Friday with U.S. index futures, as contracts on equity gauges in Japan, Australia and South Korea foreshadowed losses. Financial stocks drove the S&P 500 Index lower last session amid concern over Deutsche Bank AG … More »

  • Elliott Management takes 8.1 percent stake in Mentor Graphics Reuters - 53 minutes ago

    (Reuters) - Activist hedge fund Elliott Management said it picked up an 8.1 percent stake in electronics hardware supplier Mentor Graphics Corp (MENT.O), a few months after Carl Icahn exited the company. ... … More »

  • Obama, Merkel condemn 'barbarous' Russian, Syrian strikes on Aleppo
    Obama, Merkel condemn 'barbarous' Russian, Syrian strikes on Aleppo AFP News - 1 hour 1 minute ago

    US President Barack Obama and German Chancellor Angela Merkel condemned what they called "barbarous" Russian and Syrian regime airstrikes on Aleppo during a phone call Thursday, the White House said. The Syrian government and its ally Russia "bear … More »

  • Deutsche Bank shares sink 7% as hedge funds pull money out AFP - 1 hour 19 minutes ago

    Deutsche Bank shares sank seven percent Thursday after news that a number of hedge funds had pulled money out of the German giant amid worries over its financial strength. The move to sell off the German ... … More »

  • Signoff creates savings funds for private California workers
    Signoff creates savings funds for private California workers Associated Press - 1 hour 22 minutes ago

    Nearly 7 million California workers will be automatically enrolled in a retirement savings account under legislation Gov. Jerry Brown signed Thursday in an attempt to address growing fears that many workers ... … More »

  • Saudi warns of 'disastrous consequences' over US 9/11 law
    Saudi warns of 'disastrous consequences' over US 9/11 law AFP News - 1 hour 25 minutes ago

    Saudi Arabia on Thursday warned of "disastrous consequences" from a United States law allowing 9/11 victims to sue the kingdom, in a major spike in tension between the longstanding allies. The warning came after the US Congress voted overwhelmingly … More »

  • ECB's Nowotny says Europe not facing new banking crisis
    ECB's Nowotny says Europe not facing new banking crisis Reuters - 1 hour 27 minutes ago

    European Central Bank Governing Council member Ewald Nowotny said on Thursday he did not believe that Europe faced a new banking crisis similar to that seen in 2007 and 2008, but the financial sector was clearly in a transitional phase. During the … More »

  • Airbus Group to merge with its jetmaking unit - sources
    Airbus Group to merge with its jetmaking unit - sources Reuters - 1 hour 28 minutes ago

    Airbus Group SAS is likely to merge with its main planemaking unit, Airbus SAS, as part of a corporate restructuring being finalised on Thursday, people familiar with the matter said. A spokesman for Airbus Group (AIR.PA) declined to comment. The … More »

  • Business Highlights Associated Press - 1 hour 28 minutes ago

    ___ House lawmakers heap blistering criticism on Wells Fargo CEO Angry lawmakers heaped another round of blistering criticism on Wells Fargo's CEO, pressing Thursday for details about what senior managers ... … More »

  • The real reason Salesforce is complaining to regulators about the Microsoft-Linkedin deal
    The real reason Salesforce is complaining to regulators about the Microsoft-Linkedin deal Business Insider - 1 hour 33 minutes ago

    Salesforce Salesforce CEO Marc Benioff Salesforce lost its … Continued The post The real reason Salesforce is complaining to regulators about the Microsoft-Linkedin deal appeared first on Business Insider. … More »

  • US hedge fund to pay $400 million in African bribery case Associated Press - 1 hour 35 minutes ago

    A major Wall Street hedge fund has agreed to pay more than $400 million to settle charges accusing it of using a web of brazen middlemen to pay bribes to African officials, authorities said Thursday. The ... … More »

  • Dollar's movements split on forex markets AFP - 1 hour 37 minutes ago

    The dollar fell slightly against the euro on currency markets on Thursday but gained against the yen and the pound. Analysts pointed to rising crude prices but falling stock markets as countervailing pressures ... … More »

  • Xi’s $420 Billion China Rail Push Lures First Private Investment Bloomberg - 1 hour 50 minutes ago

    Shanghai Fosun High Technology Co. signed an agreement with the provincial government of Zhejiang in eastern China to buy a controlling stake in a 46.2 billion yuan ($6.9 billion) high-speed project linking the cities of Hangzhou and Taizhou, the … More »

  • Vietnam Sugar Producer Plans $600 Million Singapore Listing Bloomberg - 1 hour 50 minutes ago

    Ahead of the planned share sale, the group’s Thanh Thanh Cong Tay Ninh SC or TTC Sugar, will merge with another sugar company to create a combined entity worth $200 million and Vietnam’s largest sugar company, group officials said in an interview. … More »

  • Deutsche Bank worries hit US stocks
    Deutsche Bank worries hit US stocks AFP News - 1 hour 51 minutes ago

    US stocks tumbled Thursday after a report on withdrawals from Deutsche Bank revived worries about the health of one of the world's largest banks. News of the withdrawals sent a shudder through Wall Street, where trade had been muted earlier in the … More »

  • Senator: Education Dept. mishandling Corinthian student debt
    Senator: Education Dept. mishandling Corinthian student debt Associated Press - 2 hours 4 minutes ago

    The Education Department is pursuing debt collection — rather than debt relief — for nearly 80,000 former students of Corinthian Colleges, despite federal and state findings that the now-defunct for-profit ... … More »

  • 3Q Fund Review: A welcome return to strong, steady returns Associated Press - 2 hours 10 minutes ago

    It was a good summer for fund investors, as calm and strong markets around the world lifted most categories to gains from July into September. The third quarter's smooth ascent was a turnaround from the ... … More »

  • AP Explains: What does OPEC's tentative deal mean for oil?
    AP Explains: What does OPEC's tentative deal mean for oil? Associated Press - 2 hours 16 minutes ago

    OPEC nations have agreed in theory that they need to reduce their production to help boost global oil prices during a meeting in Algeria, but a major disagreement between regional rivals Saudi Arabia and ... … More »

  • MSCI Still Monitoring China A Shares After ‘Positive’ Signs Bloomberg - 2 hours 24 minutes ago

    MSCI said it has seen a “marginal” drop in the number of suspended mainland shares after Shanghai and Shenzhen exchanges released stock suspension rules in late May. The announcement comes after MSCI in June cited accessibility issues among the … More »

  • Oil rises close to $50/bbl; doubts on OPEC plan cap gains
    Oil rises close to $50/bbl; doubts on OPEC plan cap gains Reuters - 2 hours 29 minutes ago

    Oil jumped more than 1 percent on Thursday, with Brent nearing $50 a barrel on optimism over OPEC's first planned output cut in eight years, although gains were limited by doubts the reduction would make a substantial dent in the global crude glut. … More »

  • Oil rises close to $50/barrel; doubts on OPEC plan cap gains
    Oil rises close to $50/barrel; doubts on OPEC plan cap gains Reuters - 2 hours 30 minutes ago

    Oil jumped more than 1 percent on Thursday, with Brent nearing $50 (39 pounds) a barrel on optimism over OPEC's first planned output cut in eight years, although gains were limited by doubts the reduction would make a substantial dent in the global … More »

  • Stocks Fall as Deutsche Bank Woes Roil Lenders; Treasuries Climb Bloomberg - 2 hours 33 minutes ago

    Equities erased gains after Bloomberg News reported about 10 hedge funds that do business with the German lender have moved to reduce their financial exposure. Traders pushed down the value of equities after the report on Deutsche Bank rekindled … More »

  • ECB's Lautenschlaeger says bank needs to craft exit from stimulus  Reuters - 2 hours 33 minutes ago

    FRANKFURT (Reuters) - The European Central Bank should not provide further stimulus, including through stock or bond purchases, but needs to carefully craft its exit from asset buys to avoid turbulence, ... … More »

 
Recent Quotes
Symbol Price Change % Chg 
Your most recently viewed tickers will automatically show up here if you type a ticker in the "Enter symbol/company" at the bottom of this module.
You need to enable your browser cookies to view your most recent quotes.
 
Sign-in to view quotes in your portfolios.

MARKET MOVERS

  • Most Actives
    Most Actives
    NamePriceChange% Chg
    0.16+0.01+5.96%
    N21.SI
    0.112+0.003+2.75%
    40E.SI
    0.285+0.010+3.64%
    5ME.SI
    0.13+0.01+6.56%
    A50.SI
    0.107+0.002+1.90%
    40F.SI
  • % Gainers
    % Gainers
    NamePriceChange% Chg
    0.13+0.02+16.07%
    BEH.SI
    0.119+0.015+14.42%
    A7S.SI
    0.34+0.04+13.33%
    AYV.SI
    0.395+0.045+12.86%
    BQF.SI
    0.182+0.020+12.35%
    BGO.SI
  • % Losers
    % Losers
    NamePriceChange% Chg
    0.154-0.013-7.78%
    5WJ.SI
    0.16-0.01-5.88%
    5G1.SI
    0.185-0.011-5.61%
    B7K.SI
    0.100.00-4.76%
    42D.SI
    0.142-0.007-4.70%
    5AM.SI

Market Data

  • Currencies
    Currencies
    NamePriceChange% Chg
    1.3648+0.0008+0.06%
    USDSGD=X
    1.5307+0.0007+0.05%
    EURSGD=X
    1.7686+0.0005+0.03%
    GBPSGD=X
    74.1600+0.089+0.12%
    SGDJPY=X
    5.6810-0.003-0.05%
    SGDHKD=X
    3.0215-0.0014-0.05%
    SGDMYR=X
    9,538.1689-4.5439-0.05%
    SGDIDR=X
    4.8833-0.0037-0.08%
    SGDCNY=X
    1.04090.000.00%
    AUDSGD=X
  • Commodities
    Commodities
    NamePriceChange% Chg
    1,325.10-0.90-0.07%
    GCZ16.CMX
    19.16-0.03-0.15%
    SIZ16.CMX
    95.01-0.66-0.69%
    ^XAU
    2.190.00-0.14%
    HGZ16.CMX
    43.85+0.41+0.94%
    CLV16.NYM
  • Bonds
    Bonds
    TreasuryYield (%)Yield Change
    1.12-0.01
    ^FVX
    1.56-0.01
    ^TNX
    2.28-0.01
    ^TYX