Hi All,
Can someone explain the difference between untrended ROC and trended ROC? My initial assumption was that Untrended Return on Cost = not stabilized (uses current rents; doesn't incorporate growth in rent) and Trended Return on Cost = stabilized return on cost (incorporates rent growth).
Is this accurate? Or am I missing something? I feel like I have seen instances where people refer to untrended stabilized ROC which makes me think I am not fully understanding.
| +24 | Hotel Recruiters | 14 | 3d |
| +15 | Senior Living Modeling Help | 5 | 1d |
| +15 | Rate Hikes | 5 | 1d |
| +12 | Leaving Self-employment for Commercial Real Estate Brokerage | 2 | 4d |
| +9 | REPE Analyst Firm Advice | 1 | 1d |
| +7 | KeyBank RE Underwriting | 7 | 6h |
| +6 | What are the best undergrad schools for placing in real estate finance? | 10 | 4h |
| +3 | LIHTC Syndicator Comp | 1 | 1d |
| +3 | BGO REPE LDN | 1 | 1d |
| +3 | Anyone familiar with Migsun Nehru Place, Greater Noida? Thoughts on investing here? | 3 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
This is correct. Some people also will trend OpEx as well but not all people.
I can't imagine anyone gets away with trending rents but not expenses. You've got to have a pretty naive lender/investor to pull that off.
Sorry I was being a little sloppy. I've seen some people trend expenses but not rents (ie use untrended rents and stabilized expenses).
Your assessment of untrended vs trended ROC is correct. In my experience, banks typically look at untrended yields as a conservative approach to sizing a construction or rehab loan. If rent growth stays stagnant, assuring the deal still works with untrended rents is important especially at this stage in the cycle.
Everyone used to look for a 100+ bps spread on today’s rent (untrended) with a conservative cap rate so really it was like 150+. Now everything is expensive and 100 (read 150) is really more like 50-75 so people started trending (inflating) rent so that it still gets to 100 bps on today’s actual (not at all conservative) cap rates. Sign of the times.
trended means you are assuming percentage growth on rent and expenses. Untrended means no growth.
In a development deal with a long predevelopment period / development timeline sometimes you'll trend construction costs too. So untrended ROC is todays rents at today's costs, and trended yield as of CO would include construction cost, opex, and rent escalation.
This is the best answer to the original question.
Curious what those of you out there (at equity shops) are utilizing for RETs in untrended and trended ROCs for purposes of gauging ROC- exit cap spreads. Are you assuming reassessed taxes (by applying assessment ratios and mill rates to a valuation derived from each respective NOI, incorporating reassessed RETs)?
I do. I look at reassessed taxes based on however there are calculated wherever you are reviewing the project (i.e. % of HC + land basis etc.) for static stabilized analysis. And then trend that number for CF projections to get to trended ROC. For places like CA, I also adjust the taxes on sale rather than just capping CF.
Maxime voluptate accusamus cupiditate id architecto aut sint. Similique et maiores neque eveniet ducimus ad sint. Aspernatur eveniet cum vitae et quod. Vitae porro doloribus omnis accusantium odio esse. Non temporibus quo deleniti. Corporis numquam necessitatibus consequatur ea porro aut ratione.
Sed ipsum ab consequatur numquam natus aut quasi. Magnam porro et cupiditate quam. Fugit quia optio quidem inventore. Consequatur nobis sit architecto assumenda excepturi totam.
Voluptatem adipisci reiciendis sunt odio sed eveniet praesentium nobis. Quod quidem non laborum animi. Omnis consectetur nemo necessitatibus aperiam eius. Alias rerum voluptatem maiores laudantium. Dolore dolores aperiam quia aut molestiae incidunt suscipit. Minima voluptate laboriosam molestias ullam ex rerum explicabo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...