This video presentation will:
- 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.
Course No. S008
Format: Online video with final exam
Instructional Delivery Method: QAS Self-Study
Prerequisites: None
Advance Preparation: None
Level: Overview
CPE Credit: 4 hrs.
Field of Study: Management Services: Technical
Course expiration: You have one year from date of purchase to complete the course.
Course Revision Date: September 2023