, , , , , , , , ,

Construction Draw Schedule: Accounting For True LTC

Mitigating A Common and Potentially Costly Error During Development Underwriting When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender…
a shopping center with robust sales and low occupancy cost
, , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting

When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you're buying are; or in other words,…
, , , , , , , ,

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…
a large commercial real estate building
, , ,

Refinance Risk Analysis Tool in Excel

Simply put, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the down side. Equity investors generally focus on an investment's internal rate of return, cash-on-cash return,…
, , , , , , ,

Physical Occupancy Calculation Model for Real Estate

As many of you know, I'm in the midst of moving my family from Milwaukee to Dallas, and quite frankly I'm getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than…
, , , , ,

Using an IRR Matrix to Determine Hold Period

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
, , , ,

3-Tiered Acquisition Debt Module

This is a debt module that will allow the user to add one to three tiers of debt to his or her DCF model. This excel file should be fairly intuitive and easy to understand and the entire model is on one sheet. Download it from the link below…
, , , ,

Real Estate Capital Account Tracking Tool

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…
, , , , , , , , ,

After Tax Analysis in Real Estate

When modeling real estate investments, industry practice is generally to stop at before tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily…