Excel Hands On: Creating Waterfall Calculations
- A Live, Interactive Excel Training Workshop
Waterfall calculations are used to allocate cash flow among two or more partners based upon agreed-upon return parameters. In this hands-on workshop join Excel expert David H. Ringstrom, CPA as he brings his prior commercial real estate experience to the foreground by walking you through assembling a waterfall calculation from scratch.
David's effective "show-twice" process first walks you through a procedure by way of detailed PowerPoint slides and then demonstrates the techniques firsthand in the 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 webcast.
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.
Continuing Education Credits
The sessions of the conference qualifies for
- 6 General Credit for all Accountant
- 3 CPD Credit for all CPA (CA)
- 3 CPE Credit for all CIA
- 3 CPE Credit for all CMA
- 3 CPE Credit of Computer Software and Applications for CPA (US)
- 2 CE Credit for all Maryland Tax Prep.
- 3 CE Credit for all CFIRS
- 3 CE Credit for all CWS
Recommended for
- CPAs, CFOs, and other professionals working in the fields of accountancy, finance, tax, and more
- CPA firms who want to upgrade their knowledge in excel charts
- Finance Personnel desiring to excel in waterfall design techniques
- Practitioners seeking to learn effective spreadsheet design techniques
David Ringstrom
CPA (US)
Date
Aug 13th, 2021
Time
01:00 PM – 02:30 PM
Waterfall Charts 101
If you use Excel quite often, you know firsthand about the benefits of charts. Graphical representation of your data turns to be very helpful when you want to make a comparison or pinpoint a trend at a glance.
Microsoft Excel has lots of predefined chart types, including column, line, pie, bar, radar, etc. In this online CPE session, we will go above and beyond creating basic graphs and have a closer look at a special chart type - the Waterfall chart in Excel. You will find out what a waterfall chart is and how helpful it can be. You will know the secret of creating a waterfall chart in Excel 2010 - 2016 and learn about different utilities that can do it for you in a minute
Major topics covered in this online CPE session:
- What is a Waterfall chart in Excel?
- How to build an Excel bridge chart
- Add-ins for creating waterfall charts
Learning Objectives
- To summarize the investment parameters to be incorporated into a waterfall calculation
- To apply formatting to multiple locations within a worksheet by way of the Format Painter feature.
- To Build a series of dates with the Fill Series command.
- To Build a series of self-updating dates with Excel's DATE function.
- 3 General credit of for all Accountant
- 1.5 CPD credit of for all CPA (CA)
- 1.5 CPE credit of for all CIA
- 1.5 CPE credit of for all CMA
- 1.5 CPE credit of Computer Software and Applications for all CPA (US)
- 1 CE credit of for all Maryland Tax Prep.
- 1.5 CE credit of for all CFIRS
- 1.5 CE credit of for all CWS
Subject Area:
Computer Software and Applications
Course Level:
Advance
Instuctional Method:
Group Internet Based
Pre-requisites:
Advance Preparation:
David Ringstrom
CPA (US)
Date
Aug 13th, 2021
Time
02:30 PM – 04:00 PM
Waterfall Profit Distribution Model
In this CPE session work side-by-side with David by starting with a blank worksheet and detailing every input and formula. Concepts covered include using range names, although David also provides cell address references to use in lieu of range names if desired. David contrasts the IRR versus XIRR worksheet functions for computing investment returns, and incorporates other worksheet functions including MIN, ROUND, DATE, SUMIF, and more. Extensive check figures are also incorporated into the model to ensure data integrity and ease of use in following the calculations through the tiers.
Major Topics covered:
- Building a waterfall calculation from scratch, starting with a blank worksheet.
- Computing the internal rate of return for a series of cash flows with the IRR function.
- Improving the integrity of spreadsheets by using SUMIF to lookup values in a more flexible fashion than VLOOKUP.
- Incorporating decisions into calculations with Excel's IF function.
- Maximizing worksheet cells by using custom number formats to display text within cells that contain numeric values.
- Returning the smallest value from two or more amounts by way of the MIN function.
- Saving time by using the AutoSum formula to sum multiple columns at once with a mouse click or a keyboard shortcut.
- Saving time writing formulas by choosing named ranges with the Use In Formula command.
Learning Objectives
- To recall the location of the Name Manager command within Excel's ribbon interface.
- To recall which menu contains the Fill Series command.
- To state the purpose of the Use In Formula command.
- 3 General credit of for all Accountant
- 1.5 CPD credit of for all CPA (CA)
- 1.5 CPE credit of for all CIA
- 1.5 CPE credit of for all CMA
- 1.5 CPE credit of Computer Software and Applications for all CPA (US)
- 1 CE credit of for all Maryland Tax Prep.
- 1.5 CE credit of for all CFIRS
- 1.5 CE credit of for all CWS
Subject Area:
Computer Software and Applications
Course Level:
Advance
Instuctional Method:
Group Internet Based
Pre-requisites:
Advance Preparation:
-
David Ringstrom
President
Excel Accountan...
I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:
- Microsoft Excel
- Microsoft Access
- Sage 50/Peachtree Accounting
- QuickBooks
Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:
- National Association of Certified Valuators and Analysts
- Institute of Real Estate Managers
- Georgia Society of CPAs
- South Carolina Society of CPAs
- Georgia Government Finance Officers Association
- Atlanta chapter, American Society of Women CPAs
- Perimeter Chapter, Georgia Society of CPAs
I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.
I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.
I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.
Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting
