IREM.org
0

Creating Real Estate Models in Microsoft Excel

Member price:

$59.00

Your price:

$ 99.00

5/19/2021

11 am PT / 12 pm MT / 1 pm CT / 2 pm ET
*approximate length: 45 minutes to 1 hour

Presenter: David Ringstrom, CPA

In this presentation Excel expert David H. Ringstrom, CPA brings his prior commercial real estate experience to the foreground again. David will walk you through building a simplified real estate proforma. The discussion will include worksheet functions such as SUMIF for looking up numbers from profit & loss reports and other sources, contrasting IRR and XIRR, as well as using CUMIPMT and CUMPRINC to eliminate building and referencing amortization tables when calculating debt service. You'll see how to build a waterfall chart to illustrate NOI (net operating income) for a given year, along with keyboard shortcuts such as the F4 key for toggling absolute references and Ctrl-R for copying formulas to the right. Along the way David will cover nuances such as opening CSV files in Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the session.

Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics Covered:

  • Opening .CSV files versus opening Excel workbooks
  • Calculating the principal portion of a loan paid during a specific time period by way of the CUMPRINC function
  • Computing the internal rate of return for a series of cash flows with the IRR function
  • Transforming dates and numbers into various formats without retyping by way of custom number formats
  • Using a keyboard shortcut so you’ll never have to manually type $ signs in a formula again
  • Using the SUMIFS function to sum values based on multiple criteria
  • Understanding how XIRR provides more accurate return calculations than IRR, as well as computing returns on irregular cash flow distributions when needed
  • Utilizing the CUMIPMT worksheet function to calculate interest amounts for any period of a loan without utilizing an amortization table
  • Jump-starting spreadsheet projects using free, prebuilt templates in Excel
  • Contrasting sending reports to Excel versus exporting to comma-separated value (CSV) files

Learning Objectives:

  • Identify the worksheet function that enables you to calculate a return for a series of cash flows distributed at irregular dates
  • Recall the keyboard shortcut that enables you to transfer the contents of a cell across a row of adjacent cells that you’ve selected
  • State which character signifies an absolute reference within a formula

David H. Ringstrom David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Close
Our site uses cookies to improve your visiting experience. Please view our Cookie and Privacy Policy.
Got it