I have an interview this week with a CRE brokerage firm and an Analyst sent me an OM on a portfolio of assets. He told me we'll be talking about the portfolio/properties and wanted me to think about a few questions. The questions include risks, valuing the portfolio, valuing each asset individually, would I buy the asset, and the "year 1 leveraged return for the asset". I've broken down multiple risks and performed a dcf calc for the portfolio and each asset based on the broker's future cash flows. I have my NPV for the portfolio and each asset so it's simply a yes/no depending on purchase price. I'm not sure what he is asking for when he says "year 1 leveraged return for the asset". I've assumed a purchase price for the portfolio and created a loan based on a 65% LTV. Is it as simple as inserting the purchase price and annual debt service into the Year 1 cash flow? I will eventually reach out to the analyst and ask him, but I wanted to see what you guys thought.
Trending Content - Real Estate Forum
| +16 | Senior Living Modeling Help | 5 | 2d |
| +16 | Rate Hikes | 8 | 1h |
| +12 | Leaving Self-employment for Commercial Real Estate Brokerage | 2 | 5d |
| +9 | REPE Analyst Firm Advice | 1 | 2d |
| +7 | KeyBank RE Underwriting | 7 | 21h |
| +7 | What are the best undergrad schools for placing in real estate finance? | 13 | 39m |
| +3 | Anyone familiar with Migsun Nehru Place, Greater Noida? Thoughts on investing here? | 3 | 5d |
| +3 | Overtime approval | 6 | 2h |
| +3 | LIHTC Syndicator Comp | 1 | 1d |
| +3 | BGO REPE LDN | 1 | 2d |
Career Resources
He's probably looking for cash-on-cash. [Cash flow to equity] / [equity basis]
calculate leveraged return by including the debt service payment in your hold years and inserting the cash paid (not the purchase price - the purchase price less the debt contribution).
@luv2speed So would this be correct for the return for Year 1?
Year 1: Cash Flow before Debt Service - Cash/Equity Paid - Annual Debt Service = Return for Year 1?
The analyst also told me he's not necessarily looking for the correct answers, but he wants to know that my thought process is correct. I appreciate the help.
The first year cash flow would not include the cash paid. That would be year zero or just separate. So you would divide the rest of the first year cash flow by the cash/equity paid to get the first year leveraged return.
Just a quick question here - so you're saying the Y1 CoC return includes the acquisition costs as well (in the numerator)? If so, would it make sense to say that, assuming no acquisition costs (or closing costs on my debt) that my Y1 Unlevered CoC should = my going in Cap Rate?
Esse quam ea ratione rem ut eligendi in. Totam est corrupti rem maxime qui.
Quibusdam voluptas fugiat doloremque. Et quis voluptatum ullam. Earum qui et ad molestiae architecto eos doloribus. Autem maxime vel quaerat alias voluptate sit provident.
Quos animi quibusdam sit atque. Amet praesentium ut labore non. Quia sit omnis consequatur sit occaecati ex at.
Aut amet provident hic quae. Quaerat aperiam optio animi quasi velit delectus et. Autem odit est quia magni eos iusto.
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...