- This event has passed.
Creating Real Estate Models in Microsoft Excel 2022
June 15 @ 2:00 pm
June 15, 2022 | 2:00 PM ET | USA
In this presentation, CPA Excel expert David H. Ringstrom brings back his first experience in real estate sales. David walks you through building a simple real estate platform. Discussions include worksheets such as SUMIF for profit and loss statements and other findings, the distinction between IRR and XIRR, as well as the use of CUMIPMT and CUMPRINC to remove construction and orientation tables in the calculation of job losses. You’ll see a waterfall chart setting that shows the NOI (network spend) for that year, as well as a short keyboard, such as the F4 key to change full references and copy Ctrl-R formulas to the right. Along the way, David discusses nuances, such as opening CSV files in Excel.
David shows both methods: first, PowerPoint is a step-by-step slide, and second, an enrollment-based version of Microsoft 365 (formerly Office 365). David draws your attention to the differences between the old versions of Excel (2021, 2019, 2016, 2013, and earlier) both during the presentation and in his soft notes. David also offers an Excel workbook that contains most of the models he uses online.
Microsoft 365 is a registered product that provides new graphics updates as often as once a month. Fortunately, endless Excel licenses have a hidden set that doesn’t change. Permanent licenses are valid for a year, such as Excel 2019, Excel 2016, and so on.