REIT Valuation: Crash Course

No video

REIT Valuation: Crash Course

Рет қаралды 72,551

Mergers & Inquisitions / Breaking Into Wall Street

Күн бұрын

Пікірлер: 65

@gatsbyliu1084 Жыл бұрын

No bull shit, no advertisements, no fake courses, and only legit content. This channel is so under rated !

@financialmodeling Жыл бұрын

Thanks for watching! (Note: We do offer courses. But we try hard to make them "not fake.")

@eagerbeever22 2 жыл бұрын

This is by far the Best Video I've found on REIT Valuation on any channel ! Great Job !

@financialmodeling 2 жыл бұрын

Thanks for watching!

@pilarrojas965 8 ай бұрын

Amazing! saving for the courses!

@financialmodeling 8 ай бұрын

Thanks for watching!

@nicolassuarezblog 4 жыл бұрын

GREAT work, thanks for sharing, really good, king regards

@financialmodeling 4 жыл бұрын

Thanks for watching!

@safeershahid9150 6 ай бұрын

Sir your channel is just superb. Really attractive and competent content and material. but i can't find the practice sheets for practice. please provide the Practice files as well. that will be so nice of you!

@financialmodeling 6 ай бұрын

You can click "More" or "Show More" under the video or go to the first pinned comment on newer ones to get the resources.

@xstriker831 5 жыл бұрын

Thank you so much, this was helpful

@financialmodeling 5 жыл бұрын

Thanks for watching!

@yoelherman1951 6 жыл бұрын

Thanks a lot. Two question about this topic: (1)What’s the purpose of the “minimum cash balance” in the model, and why is it calculated as a percentage of operating expenses? (2)By assuming a declining Change in WC % of revenue, you're actually assuming that’s the company credit relation with is customers and suppliers in getting better over time, right?

@financialmodeling 6 жыл бұрын

All companies need a certain amount of cash to operate, pay employees, pay for expenses that come up, etc. The Change in WC here is so small that it's almost irrelevant, but yes, if it decreases, the company's position relative to suppliers and customers improves over time.

@FConradez77 3 жыл бұрын

Amazing video, very informative

@financialmodeling 3 жыл бұрын

Thanks for watching!

@franco521 6 жыл бұрын

Beautiful video, thank you!

@financialmodeling 6 жыл бұрын

Thanks for watching!

@alfredlee4629 3 жыл бұрын

Thanks for this informative video !

@financialmodeling 3 жыл бұрын

Thanks for watching!

@Gid-J Жыл бұрын

Can you do a Reit valuation for Canada pls?

@financialmodeling Жыл бұрын

We have IFRS-based examples and one Canadian deal example in our Real Estate Modeling course (for Pure Industrial REIT). Not focused on real estate in this channel currently, but may revisit it in the future.

@vapa5761 4 жыл бұрын

Great Video, glad I found your channel. So I just checked out your website and am keen in purchasing your BIWS platinum package. So if I happen to buy this, would I be provided with the template for your reit modelling ?

@financialmodeling 4 жыл бұрын

Thanks. Yes, you will have access to all the REIT modeling and valuation templates in the course if you purchase the Platinum package.

@Luke-nh5tu 10 ай бұрын

what book would you recommend ro study source to go into more depth of REIT valuation?

@financialmodeling 10 ай бұрын

I have not really seen in-depth books on the topic. Green Street has some good materials. We also offer a comprehensive course on real estate (properties and REITs): breakingintowallstreet.com/real-estate-modeling/

@Perfectvlogss26 Жыл бұрын

Can you please let us know we can get this excel sheet

@financialmodeling Жыл бұрын

Click "Show More" and scroll to the links.

@methioswar2916 Жыл бұрын

Still to complicated for me. Any tips as to where to start?

@financialmodeling Жыл бұрын

We might eventually publish a simplified or short version of this. Unfortunately, it is a relatively complicated/specialized topic, so I don't think there's an easy approach to learning everything.

@mickxdz 6 жыл бұрын

Awesome work, do you mind sharing the european reit spreadsheet?

@financialmodeling 6 жыл бұрын

It's inside our Real Estate course. We may do something separately on that example here in a future video.

@quietlike 5 жыл бұрын

Did you create the soreadsheets or are they available from each reit? Thanks so much for the in depth tutorial

@financialmodeling 5 жыл бұрын

We created these from scratch. REITs do disclose some financial information in Excel format, but not in a way that's ready to use in a financial model.

@wheresmyhandle 5 жыл бұрын

Hi thanks for the vid! Is the simple projection model spreadsheet available? I don’t see any links... thanks!

@financialmodeling 5 жыл бұрын

Click "Show More". Scroll to Resources. Click the links.

@alexdu9009 4 жыл бұрын

hi, a question about REIT's risk exposure to their counter party please. Who determine the fair market value of the mortgage assets? Can the counter parties/lenders take ownership of the pledged assets if the counter party solely determine the assets value is below the loan lend to the REIT? in other words, is the REIT in control on timing of sales of assets during crisis time?much appreciate your response.

@financialmodeling 4 жыл бұрын

Mortgages on a REIT's Balance Sheet are recorded at historical cost. They are marked to market only in a valuation, like the NAV model, or in a liquidation/restructuring/bankruptcy scenario. Lenders cannot seize the assets just because their market value has fallen - the REIT itself would also have to be in serious trouble.

@veryclearwater 6 жыл бұрын

Great work. Can you also do a commercial real estate REITs as well?

@financialmodeling 6 жыл бұрын

??? I don't understand your question. We have case studies on individual properties if that is what you are asking about.

@user-pi9tz7ij4f 5 жыл бұрын

Hotel would be commercial real estate! on this video!

@davidluo1234 3 жыл бұрын

Do REITs purchase properties unlevered or do they take out a mortgage on each property? Is the debt on a REIT's balance sheet representative of the mortgages they have taken or is it further back leverage?

@financialmodeling 3 жыл бұрын

Virtually all REIT deals use leverage because REITs do not have much cash on-hand to use for acquisitions. The Debt on a REIT's Balance Sheet is mostly property-level Debt used to fund acquisitions and developments.

@davidluo1234 3 жыл бұрын

So that means a REIT cannot take the money it has raised from debt and equity to just purchase the equity portion of a property, kind of like what a PE fund does with its portcos? Instead, the debt is used as a mortgage by the REIT directly instead of using bank loans?

@financialmodeling 3 жыл бұрын

@@davidluo1234 It varies by the deal. REITs tend to have both property-level and corporate-level debt.

@Gmanation765 5 жыл бұрын

When valuating a REIT, are you using the trust's financials, or the financials for the L.P.? I've found most REITs are set up this way, and am wondering best practice for truly capturing performance of the reit. Cheers!

@financialmodeling 5 жыл бұрын

It depends on how you've set up the model, but you should capture all the REIT's outstanding shares, including OP and DownREIT units, in the analysis. So you should use whichever filing gives the information on all the shares and dilutive securities associated with the REIT.

@danieldesantiago9902 4 жыл бұрын

Where do you find all this info for a company??? its not as easy as looking in the financial statements like for stocks

@financialmodeling 4 жыл бұрын

If the REIT is publicly traded, Google [REIT Name] "investor relations" and you can find the information there. You can look up Cap Rates based on market data from the big real estate brokerage firms, such as CBRE, JLL, etc.

@LifeStyleGoalsS 2 жыл бұрын

can you share the excel?

@financialmodeling 2 жыл бұрын

Click "Show More" and follow the links.

@TheUnknownNexus Жыл бұрын

Can we do an LBO on a REIT?

@financialmodeling Жыл бұрын

Yes, but they're not that common because IRRs tend to be lower, REITs are very capital intensive, and it's difficult to add much additional leverage to most REITs.

@TheRasins 6 жыл бұрын

Why do you say that an advantage of DCF is that you don't have to forecast debt,interest?

@financialmodeling 6 жыл бұрын

Because in an Unlevered DCF, you don't need those items since you are only calculating Free Cash Flow to Firm AKA Unlevered Free Cash Flow. It better represents all investors in the company and requires less work/time spent forecasting.

@jackkulinski8132 4 жыл бұрын

Can anyone give me an idea about the REIT ticker symbol "TWO"? It's trading around $4 right now. P/B ratio is 0.30. It seems like a steal right now but I don't know

@caseyle4447 4 жыл бұрын

I wouldn't invest in it. I just looked at their balance sheet and they have so much in liabilities. Also, they had a net loss in 2018.

@jackkulinski8132 4 жыл бұрын

@@caseyle4447 Appreciate it. Thanks

@Progameroms 3 жыл бұрын

you are top notch

@financialmodeling 3 жыл бұрын

Thanks for watching!

@beyondthenorm1257 4 жыл бұрын

what software are you using'''looks great

@financialmodeling 4 жыл бұрын

Excel, PowerPoint, Camtasia

@galoreweezing5224 4 жыл бұрын

This walk through is damn fast

@financialmodeling 4 жыл бұрын

Yes, that's why it's a "Crash Course" rather than a book or 1-hour-long video. We do have written versions of these tutorials within our courses, and the material is typically broken up differently (focusing on one concept in 10-20 minutes rather than presenting everything at once).

@galoreweezing5224 4 жыл бұрын

I nearly crashed myself pepelaugh