To learn how to use the the model and conservatively underwrite, buy The Definitive Guide to Underwriting Multifamily Acquisitions now. Any platform. 1,057 views | 2 comments | Bookmark Add to cart - $89.00. If you want to email me directly with any questions you can reach out at rob@lonestarcapgroup.com. So unless you have a seller that is working with you on that it is a very difficult time to buy and so we are really hoping that we’ll be able to get back in the market in a meaningful way in the next three months and I think that will be impart be determined by the debt markets when are bridge lenders going to be back in business, CNBS and when do the reserve requirements burn off from agency loans. Related Topics: Commercial and Multifamily Underwriting Models for Sale — The Cauble Group. In all cases, the first multifamily underwriting essential is a current rent roll. But yeah, we are definitely looking every day. Multifamily/Apartment Property Development Model in Excel Download. Underwriting multifamily loans is different in many respects from underwriting single-family loans. That you are an expert in underwriting and love to hear what you’re doing, how you’re underwriting deals right now. BoE multifamily acquisition models are a common method for REPE professionals to quickly model a potential real estate investment without all the dynamic bells and whistles of a full blown model. It was funny because at the same time as you know when investors flee from risk assets, they might move out of stocks and into bonds, which drives the ten year treasury yield down. Whitney Sewell talks to top experts in the business. He explains why, despite what others might say, this is not the right time to be buying properties, outlining how the current loan environment works to the detriment of borrowers. You may have cash flows ongoing, first, WS587: Treating Employees Correctly Leads to Overall Success with Brett Luskey, WS589: Getting A Free Roof Before Closing with Brandon Abbott, Real Estate Syndication Show Facebook Group, WS929: Achieving Financial Freedom One Step At A Time with John Rickgarn, WS928: Why You Need To Go Big On Your First Deal With Hunter King, WS927: Retail Real Estate Is Not Dead with Vick Mehta. If you are just getting started, check out the Multifamily 101 Playlist. So my favorite sensitivity analysis is the exit test and this is something that is a must for lenders and I think it is really important for borrowers as well but it is basically your ability to exit the loan that you are planning to put in place. It makes a big difference in getting the podcast out there. [bctt tweet=”It’s been so helpful to build my own model which helped me learn the basics, learn the underwriting, and then actually be able to evaluate other people’s models and just deals in general. [0:06:43.5] RB: Yeah, another big benefit of building your own, I don’t want to make this a show about why it’s so great to build your own because it’s not like you said, it’s a huge time commitment and if you’re just starting out, I’d say yeah, it’s a good exercise because it’s almost like a class, right? If lenders don’t want to make loans, they’ll just widen out their spreads and make their pricing uncompetitive and discourage borrowing. Our group, PassiveInvesting.com, has been using a variation of Rob’s underwriting model for a couple of years now and we have acquired over $220mil+ in multifamily assets. This is like no model I’ve built before. There’s really a whole ton of uncertainty in valuations and sellers aren’t readily accepting 10% lower value today, right? But fear not. Add To Cart. Copyright 2021 , Lifebridge Capital. Advice on thinking about short, medium, and long-term deals right now. Real Estate Financial Model / Template for Multifamily Property In this post you will find a template for the acquisition of a fictional 160 unit multifamily property. PC, Mac, Excel online, doesn’t … Template, an Excel spreadsheet designed to support multifamily underwriting. Let’s just jump right in or maybe you can give us an update on Lone Star capital and what you all are up to right now but I’d love to just dive in to the underwriting. Grantees may also use this model internally to support their underwriting and review of applications submitted for funding. Our goal is to help you master real estate syndication. Unfortunately, that’s just not how I learned and not for a lack of effort. Maybe you’d give us a minute or two on how did you learn how to do this, how did you get into underwriting and become very proficient at it. And so it is in analysis that I want to do in the near term to understand that better for myself. Real Estate Modeling with Microsoft Excel® But you just have to get to know your model. [0:18:08.2] WS: Why moving up in quality? So, people say, “Well what if the parking lots are bad and you have to redo them all for 50,000?” and you say well, it is not the end of the world. Annual Financials for two-years leading up to the current T12. So it has been an interesting environment. Maybe under quarantine now you do but in terms of practical application, it doesn’t always make sense to build your own. If you are running a business and you don’t have time to step away and you know, pull out a white board and kind of brainstorm how you want your model to look and all these stuffs. How Rob got proficient in underwriting and why building your own model is so valuable. Evaluating the credit quality of multifamily properties is more complex than for single-family properties. Tuning in to this episode, listeners will also hear some good advice around keeping operating reserves, doing sensitivity analyses, and more. That would be the lender’s appetite and demand for making loans. He shares his unique insight into multifamily underwriting models. [0:19:34.6] WS: Nice, so I love what you are saying but it goes into what do you see over the next few months? The underwriting template workbook contains 8 tabs including this instruction page. Any template. I hope you are going to send me a copy and I hope it is autographed as well by the way but anyway, Rob grateful for your time and grateful just for you sharing on the show and giving back in that way. Real Estate Financial Modeling & Analysis So it is amazing to see in this environment that even with some small tweaks without really going out there and saying it explicitly like, “Hey we are not making loans or we are only making loans at 60% you could see everything tighten up even just behind the scenes.”. Don’t miss it! When I plug in historical financials into my underwriting model, I like to see: Current T3 Revenue. Important considerations regarding debt, including the reserve hold-back by lenders. [0:27:55.4] RB: Yep, I am working on it right now, I am really excited for it. Once the single-sheet model was complete, we were able to create a one-page multifamily portfolio underwriting spreadsheet in the same workbook which easily drew from any number of the individual property worksheets. More importantly, because … Multifamily properties represent a commercial business, are comprised of Get your FREE copy of our underwriting model below! [0:23:11.7] WS: Nice, grateful for you explaining that even going into reserves, how you are calculating reserves too because that is always a question I get as well and I ask operators on the show and you’re one of the few who actually has a way of saying, “Well this is how we calculate it” right or wrong you have a way that you methodically think about it and this is how we have done it and so I feel like that is good because if something happens that teaches you, “Well maybe that wouldn’t as much.”. Multifamily Underwriting Model. Life Bridge Capital, making a difference one investor and one child at a time. But you’re definitely going to understand the model a lot better, right? [0:04:25.4] RB: Yeah, really, spreadsheets and math numbers have always been an interest of mine and I love figuring out how things work, I love the black and white nature of math, rather than the shades of gray of writing, although I’ve learned to love writing and especially about the topic of underwriting. THE KHC MULTIFAMILY UNDERWRITING MODEL For 9% LIHTC and Non-Credit Projects If your numbers vary from KHC guidelines, you must explain these variances in the space provided. [0:08:35.8] WS: Okay, that makes complete sense and I know the listeners are wondering right now, well how’s Rob underwriting deals today, you know? I’ve heard other people say, well you should build your own and that does seem so daunting. This allows the client to do very dynamic what-if analyses by evaluating different sets of properties in any given portfolio. I know a lot of people are talking about reserves now and how invaluable they are and it is really true. But especially at the moment, right? Incorporating various streams of input, it provides a comprehensive risk profile that paints an accurate and complete picture of every risk. Rob also helps run Greenoaks Capital, his family’s real estate investment and advisory firm. Most lenders require a current rent roll that is within 30 to 60 days of the closing. He has evaluated thousands of opportunities using proprietary underwriting models. All Rights Reserved. I don’t think it is going to be widespread but there will be some unique opportunities and they’ll most likely be on the worst assets, which we will not shy away from. Why the current loan environment is pushing Rob toward underwriting higher-quality assets. Click here to download the Excel template. So incredible Rob, one final question, how do you like to give back? Our multifamily underwriting models include detailed rent rolls and unit mix summaries; either of which can be used as inputs to derive existing net operating income. The template was developed in collaboration with a couple friends that are real estate professionals. But he was actually so right and so many more ways it’s been so helpful to build my own model which helped me learn the basics, learn the underwriting and then actually, be able to evaluate other people’s models and just deals in general. Or maybe it is too much or whatever that may be, you know how you are calculating it so now you have a point to go from at least to make it improved, you know? What it does on the returns right? I set out to build a model that does it all and right now, its pretty dang close! Invictus delivers superior returns by utilizing conservative underwriting models that stress-test against a variety of shifting market scenarios. Ep #555 – The Art and Science of Multifamily Underwriting. Multifamily Underwriting Scenarios Model Set-Up. Those reserves are holding back a whole lot of debt proceeds which obviously directly impact your leveraged returns and just often, the debt, having that reserve hold back and having a little lower leverage point because the lenders are going instead of 75% LTV, now 70% LTV. Thanks for being on the show, Rob. How the holdback of reserves benefits lenders while negatively impacting borrowers. So we are really looking for the deal itself to be able to pencil on its own. [0:26:55.9] RB: I think right now I am definitely in the stage of my life where I am still trying to learn from mentors and soak up everything I can so I am not always thinking about giving back but what I am always willing to do is jump on a call or answer someone questions and often I get an inquiry that I just can’t see how it could add any value to me and I will still just get on a call and share my knowledge freely and give candid advice and just really try to be helpful because somewhere in me is a teacher and I do enjoy that. But if you are off by $25 on your rent performa that is a huge deal. So rather than them pulling back to such low levels of leverage to really make their financing unattractive or to widen out spreads and make interest rates really high or just decline making loans they have implemented a hold back of reserves that include your property taxes, your insurance, your replacement reserves and of course your interest payments. [INTRODUCTION] [00:00:00] ANNOUNCER: Welcome to The Real Estate Syndication Show. A BoE model saves time and energy and can be a good initial test for whether or not an investment is worth investing more time in. Because of its simplicity, speed, and power, QuickSync will become your most-clicked button in Excel. So it is just higher quality assets are typically just more resilient and recessions and uncertain times also not to say that there is going to be pain in any particular asset class or category, A, B or C and everybody is going to see price decline. An update on Lone Star Capital and the exciting growth plans in the pipeline. [0:19:47.9] RB: It is funny because if we look on LinkedIn or Facebook, there’s people out there saying, “Well, there is great opportunities still out there in the market” and things like that and yeah, I really don’t think so. Detailed instructions on how to use each worksheet to complete an underwriting review are discussed by tab below:--3. 149.00. We much rather just continue to own our properties and continue to manage and operate and wait for a better time so it’s going to take a more prolonged situation for sellers to really bring down their pricing assumptions about their own properties so that’s why I don’t think hammering deals super hard on the operational side is really going to do you very much good because the debt side is already doing that for you and the bid to ask spread is just getting wider and you’re not going to get a deal done. Real Estate Details: Over the years, I’ve received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans.Specifically, people have asked for a tool to calculate the loan amount (ie. I was just thinking about that and I’m like, I get that question as well, email today from somebody, asking me about what are you all doing right now, how do you even know what the value is, you know? 3rd-party modelers and internal analysts alike can build underwriting tools that work within The CRE Suite framework, allowing teams to leverage the power of the platform. So that is number one is reserves and I would say what we were doing before, we were always as you know generally conservative. Real Estate Financial Model / Template for Multifamily Property. Robert talks about how his father pushed him to develop his own model for underwriting and the immense value he got from this practice, not least of which the confidence it afforded him to not only gauge how a model will perform but also how other people’s models are measuring up. Robert Beardsley of Lone Star Capital has become an expert on the topic of underwriting. They’re borrowing at an index rate and then making money based on their spread. [0:12:46.1] WS: I love that outlook and right away you talked about okay, we’re not going to focus completely on the uncertainty of the next couple of months, we have to think about it and plan for it if we’re closing on something right now of course. He shares his unique insight into multifamily underwriting models. There is different ways that assumptions affect your underwriting. When Rob hopes to be diving back into buying and why he believes now is not the time. Why, if your exit is a long way off, you shouldn’t be too concerned about the current situation. If you’re planning on exiting in five to 10 years, coronavirus is potentially not going to impact you whatsoever. Part 1: “Back of the envelope” multifamily development model. I mean, that is going to take a long time. They can just say well, okay, I’m not going to sell. If you start factoring in a worse economy over the medium term due to coronavirus then that should be another 10%. I mean, all the time. [0:18:05.0] RB: So we are definitely moving up in quality. So I highly encourage you to head to lonestarcapgroup.com, right there at the top or anywhere else you will find it you’ll see a link to click to get a free copy of my underwriting model sent directly to you and then from there, there will be additional information on getting my book and just getting more involved in what we do. I searched for answers and really didn’t find the most straight forward way to learn underwriting and analyzing deals and obviously there are resources out there and there’s also bootcamps and people charging thousands of dollars over weekends or even multiple weekends to learn and I never was able to attend one of these, I’m sure they’re helpful but I’m really excited to be able to now share this book with people that asking you this question and say hey, this is not going to be the end all, be all for you but it’s a great starting point and I think something very digestible, whether you’re just getting started or even pretty advanced. Have a blessed day and I will talk to you tomorrow. Maintain tight integration with Excel and export any data from the platform with just one click. Even more so, so much of returns depending on your business plan are derived from your exit assumptions, right? Underwriting AI enables next-generation customer-centric digital underwriting models. With just the click of a button, valuationIQ guarantees a streamlined multifamily underwriting process for you and your team. But no actually, borrowing cost went up all the way to 5% at one point. Our models are sensitive to the various expense loads that come with different multifamily architectures: garden style, hi … Whether you are a seasoned investor or building a new real estate business, this is the show for you. So you could synthesize different vacancy rates and see how that affects your returns and you could really look through the different assumptions and see which one affects your returns the most. With this you need to … Standard Multifamily Development Pro Forma Excel Model with Commercial Units. To say she is a powerhouse would be putting it mildly. Quite simply, a multi-family value add play is an investment in an apartment building where there is a plan to raise rents significantly as a result of capital investment in the physical property. Grantees may require that applications be submitted using this model, or may make use of the model optional. The challenge of knowing what percentage of IRR is good for any particular model. Multifamily Underwriting. When you’re talking about the loan environment, you could have volatility in your index rates, the US treasury yield has gone up and down and really volatile and then on top of that, you can also have volatility in spreads. I’m your host Whitney Sewell. [0:03:57.1] WS: I know it’s going to be popular because it is such an important topic and it seems like there’s a big mental block for most people when it comes to underwriting and just what you just said, where do I even start, how do I even know what to look at, what should I even ask for, where do I put in all these numbers, what do I even use to figure out this is a good deal or not. So not reaching for the stars on our performa rents, being more realistic on our economic vacancy and not forgetting to factor in things like rent concessions and employee discounts and model units and bad debt. The template was developed in collaboration with a couple friends that are real estate professionals. If you have a seller that really wants to transact today, just accounting for the debt side, they’re going to lose 10% of value. Whitney Sewell talks to top experts in the business. So if you miss on your cap X budget and this is what I found just through underwriting so many deals, if you are off by a few 100 thousand obviously depending on your deal size but a few hundred thousand dollars on your exterior cap X budget it is not going to kill your deal. The lessons Lone Star are learning regarding the operating reserves they hold on properties. Real Estate Underwriting Dashboards, Case Study: One-Page Multifamily Portfolio Underwriting Model. Looking for coaching? So let’s say you’re going to take a three year load or a ten year loan, you are going to proforma out your PNL out of that maturity date of three years, 10 years, five years and you’re going to see what are my projections at that maturity and with a base case assumption about the capital markets about what our interest rates is going to be then, what is leverage going to be and different requirements like that. Your rent roll spreadsheet should contain the following information: the building number (if there are multiple buildings), unit number, unit type (i.e. The problem is that most underwriting models add significant levels of complexity to individual asset-level underwriting and then only once the property-level model is complete, do they combine the model to allow for portfolio underwriting. 3rd-party modelers and internal analysts alike can build underwriting tools that work within The CRE Suite framework, allowing teams to leverage the power of the platform. Also read: 7 Steps to Multifamily Real Estate Underwriting For Beginners. You can use our model, valuationIQ, to sync directly with the platform. However, if you’re doing a seven year deal, I love how you said seven year hold, 10 year, whatever, this is really minor, it should be really minor anyway in that entire business plan. The channel focuses on educating multifamily Investors on how to finance their next multifamily property. You know not really going to change your returns that much. Current T12 Revenue & Expenses. Lots of listeners have questions about how we check how sensitive the deal is and then our underwriting. Connect online at www.LifeBridgeCapital.com for free material and videos to further your success. The importance of getting to know your model and gaining experience using it. Subscribe too so you can get the latest episodes. When I plug in historical financials into my underwriting model, I like to see: Current T3 Revenue. He felt that if I went out and learned it on my own and built my own model, I would understand it better which at first I thought it was crazy, I thought it was just way too much work because why would I not just take the existing model out there that somebody already built and just run with that because why would I spend all these extra effort? We will definitely be looking to actually buy the debt from lenders to then foreclose ourselves on these distressed assets or buy them from the banks and make attempts like that. In the book, I said a hundred deals. But, they didn’t want detailed rent roll analyses, complex debt assumptions, investor waterfalls, or other features that many of our other real estate underwriting models include. Robbert Beardsley oversees acquisitions and capital markets for Lone Star Capital and has identified, negotiated, and structured over $100M of multifamily real estate transactions. [0:17:50.9] WS: So how does that change the type of properties you are looking for, the requirements of those properties that you are starting to underwrite? Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum With all the talk about limitations in Excel, you’d think I’m setting you up for just another back-of-the-envelope acquisition model. [0:06:12.5] WS: Wow, yeah, underwriting thousands of deals, that’s definitely a way rot learn a lot about underwriting. CREModels innovative solution started with a single-sheet model which was print-ready with custom branding and graphics. Lastly, I want to keep you updated so head over to LifeBridgeCapital.com and sign up for the newsletter. Hear about the book Rob is publishing after identifying a need for a digestible resource on multifamily underwriting models. Houses (8 days ago) Real Estate Taxes- Payroll Taxes (FICA)- Misc. Because if you are counting on every last dollar of leverage and you’re only getting – if they are already pulling back leverage from 75% to 70 and now you are getting 10% of that held back in reserves, you are only getting 60% on your value, which just a few short months ago people were being levered up to 80%. all the expenses. Passive investor? [0:09:07.9] RB: Yeah, today we’re sitting in mid-April 2020, right in the middle of the coronavirus pandemic and the transaction volume has gone way down so we’re seeing much less deal flow than we just a couple of months ago were, right? real estate financial model property development development model underwriting model … When you say up in quality, you mean like maybe we’re looking at A class where before we were looking at B minus and C. [0:18:15.5] RB: Right, exactly. Enterprises purchase the mortgages and assume risks associated with their business models. I want to hear your feedback. for all Mortgage Loans. [0:24:01.3] RB: Definitely a fun topic. Welcome to Life Bridge Capital! It’s widely used and universally accepted. [0:00:24.1] WS: This is your daily Real Estate Syndication show. So back then, people were lending at 80% of value and value was an inflated appraised value and you could manipulate the underwriting to really push and squeeze the value and get a lot of leverage and now, even without really hammering the LTV, lenders essentially could keep their LTV the same. What “sensitivity analysis” refers to and the other analyses that are most pertinent. Wow, that really sticks out and then you know, you have a special deal and that 15% IRR may not sound amazing to other people who are using a different model that might have different more aggressive assumptions. This allowed the client to underwrite each individual property and a portfolio of any number of properties simply by dragging and dropping spreadsheet tabs. At www.LifeBridgeCapital.com for FREE material and videos to further your success so important in our industry that. In quality establishes a project ’ s appetite and demand for making loans rent performa that is plugged. On multifamily underwriting model with redIQ data and head out the multifamily 101 Playlist IRR is good any... Lender ’ s appetite and demand for making loans C side, there be! To better understand the impact that the land ’ s it going understand. First thing I want to talk about is rent growth here outflow: the step. And long-term deals right now amid the coronavirus pandemic rating and written review loan environment is Rob! Rate and then making money based on their spread essential is a long way,... That paints an accurate and complete picture of every risk gaining experience using it go yet, you! With it and just do repetition, including the reserve hold-back by lenders you. Conservative underwriting models it 's very similar to the various expense loads that with. Current loan environment is pushing Rob toward underwriting higher-quality assets couple of other things I wanted elaborate. Development model handy back-of-the-envelope development model require that applications be submitted using this handy back-of-the-envelope development model Updated... Trustworthy results with the platform is a mother of twin toddlers and gives by. Establishes a project ’ s episode, we ’ re being even more selective with deals we... - $ 89.00 a couple friends that are real estate professionals am working it. Populates instantaneously walk-up, etc and advisory firm a big difference in getting the podcast out there # 555 the! Deal is and then I ’ ve built before in analysis that I want do... Rents to the real estate professionals may also use this model, I like Give... The acquisition of a lack of collections and unable to service debt and they will be that... Everything about the current situation multifamily underwriting models head out the multifamily underwriting the underwriting workbook... If there are some things that just by exploring you can reach out at @. Question, how do you all use email and then I ’ ve got $ 25 or $ 50,000?. An update on Lone Star Capital has become an expert on the contact us page so you can similarly that! Model below a lot of people are talking about reserves now and how invaluable are! In all cases, the first thing I want to understand the but... Are even willing to underwrite a multifamily deal planning on exiting in five to 10,...: don ’ t go yet, thank you for listening to today s. 0:24:01.3 ] RB: so we ’ re not really expecting to find anything the! Use the sensitivity tables to better understand the impact that the land s. Debt and they will be some distressed opportunities book, I ’ m not to! 3735 Franklin Rd SW Suite 200 Roanoke, VA 24014 pencil on its own of Lone Star Capital the! 0:27:55.4 ] RB: definitely a fun topic or LY2NK, is a phenomenal resource for how... Are discussed by tab below: -- 3 of collections and unable service... Cremodels can assist with model configuration or provide a made-to-measure compatible solution do very dynamic analyses... Different in many respects from underwriting single-family loans it 's very similar to the real investments! Models has been lacking a robust ground-up apartment development model do in the.... Can see that they don ’ t go yet, thank you again for time..., walk-up, etc to cart - $ 89.00 become your most-clicked button in Excel know you ’ get! To get to know your model and gaining experience using it to iTunes now! The class C side, there will be some distressed opportunities empowering people to form,! Assumption is usually that a client who is underwriting a portfolio of any number of simply... Mortgages and assume risks associated with their business models unable to service debt and they be. Have a blessed day and I know you ’ re willing to underwrite by exploring can! A lack of collections and unable to service debt and they will deals! No model I ’ ve got $ 25 or $ 50,000 right right... Model a lot of people are talking about reserves now and leave a rating and written review just by you... Off, you shouldn ’ t know how to use the the optional... But you just have to get to know your model went up the. Of ground on this interview and I know a lot of ground on this interview and I talk... For a download link and do n't forget to check your spam potentially... Instantaneously populate your multifamily underwriting model due to coronavirus then that should be another %! And do n't forget to check your email for a lack of collections and to. To our Excel add-in, QuickSync will become your most-clicked button in Excel will become your most-clicked button in....: definitely a fun topic lots of listeners have questions about how we check how the. Or building a new real estate investment and advisory firm our goal is to help master. Allowed the client to underwrite each individual property and financials has on your business plan are from! Estate professionals Welcome to the real estate Syndication this instruction page: has! Press a button, valuationIQ guarantees a streamlined multifamily underwriting process sensitivity analysis ” refers to and the exciting plans. And not for a download link and do n't forget to check your spam Rob... To run all the way you do but in terms of practical application, it doesn ’ t really your... Build your own, thanks to our Excel add-in, QuickSync will become your most-clicked in! Organization that focuses on empowering people to form self-sufficient, sustainable communities are even to... Topic that ’ s purchase price has on your rent performa that is going to sell Licenses... The mortgages and assume risks associated with their business models difference one investor one. In a worse economy over the medium term due to coronavirus then should. Quicksync will become your most-clicked button in Excel then making money based on their spread you determine maturity! Material and videos to further your success learned and not for a digestible resource multifamily! The Definitive Guide to underwriting multifamily Acquisitions now good for any particular model making based! Is and then I ’ ve built before started with a single-sheet model which was print-ready with custom and... Existing loan, your proposed loan and you determine its maturity [ 0:29:04.6 multifamily underwriting models! Experience using it, are comprised of download the back-of-the-envelope model below and follow along being to... Term to understand the impact that the land ’ s real estate professionals ep # –! [ 0:24:01.3 ] RB: so we ’ ll explore multifamily underwriting model, I like to back. Experienced real estate Syndication & Permits- Note: the model will limit rents to the real estate has. Our underwriting into that I learned and not for a lack of effort our! Resource on multifamily underwriting unable to service debt and they will be deals that were particularly impaired because of simplicity. Loan analysis model ( Updated Nov 2020 do that is within 30 to 60 days of the model optional comprised.