Summary:
About Analyzing Whether to Add New Locations
I'll walk you step-by-step on how to decide whether a new location will likely increase profits or destroy value. I'll:
- Explore some of the key financial considerations when opening a new location.
- Describe how to project common revenue and expense items for a new location.
- Explain how to build a net contribution and cash flow forecast.
- Illustrate analysis methods like breakeven analysis and scenario analysis
- Demonstrate scenario analysis and sensitivity analysis with Excel’s Goal Seek, Scenario Manager, and Data Table functions
- Define common metrics like NPV, IRR, and Time to Breakeven. I’ll show multiple ways to analyze this in Excel. For Excel gurus, you can do this yourself. For others, this gives you an idea of what an accountant, analyst, or consultant can do for you.
- Reveal common decision mistakes people make when analyzing new locations and how to avoid these mistakes.
The modules and lessons are listed below. Click here for more detail about what's in this course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
Note: All resources for this course are in the Welcome and Overview lesson at the start of the course.
About the Teacher
Rob Stephens is the Founder of CFO Perspective, which provides continuing education courses for CPAs as well as financial management courses for business advisors and staff. He has been quoted in Forbes, U.S. News and World Report, Bloomberg Businessweek, and many other news sources. He is also the author of Conquering Cash Flow and KPIs and KPI Dashboards.
Rob has a 25-year career that includes serving as CFO, Director of Operations, and SVP of Finance. Rob is an adjunct instructor for the MBA program at Gonzaga University.
Rob holds a Masters of Science in Personal Financial Planning and a Graduate Certificate in Financial Therapy from Kansas State University. He received a B.A. in Business Administration from the University of Washington and is a CPA.
