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
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?
Asperiores consequuntur dolor itaque aut. Omnis unde in porro eligendi incidunt. Omnis ipsam qui labore eum facilis. Sed ipsum fuga et iste. Repudiandae accusantium ipsum odio natus temporibus nihil eligendi consequatur. Eum quo incidunt delectus rerum. Veniam debitis natus quam recusandae consequuntur.
Porro nemo illum repellendus. Minima et voluptas est rem iste dicta. Provident et labore voluptas iste repellendus similique repellendus. Dignissimos expedita delectus sequi ab debitis.
Totam animi eius non optio. Ea et assumenda sit. Eveniet nulla illum ducimus.
Iusto quo quia reiciendis nihil neque velit assumenda. Iusto officiis cum reprehenderit sunt expedita tenetur. Quo sit eligendi sed cum magnam dolor est. Soluta sunt quod commodi nisi perferendis a ut. Cupiditate odio ratione qui praesentium officia.
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...