Business Analysis Step-by-Step: How to build a Business Case

What do Executives mean when they ask for a Business Case, and what content to they expect in a robust Business Case? How can you think like an Executive to understand and weigh considerations like Net Present Value (NPV), Return on Investment (ROI), Payback period, Revenues, and Profits? How can you build a robust financial analysis, starting from scratch and covering everything from cash flows to key financial metrics to sensitivity analysis and key performance indicators? How do you build a dashboard that people can use to understand the business opportunity, and how do you ultimately package it all up for executive-level approval? In this step-by-step hands-on guide to financial modeling and executive-level business case development, you will learn all this and more. We will start by talking about Business Case fundamentals, including necessary content, key financial metrics and when an executive is likely to prioritize one over another, and how to use a framework to structure your opportunity in preparation for modeling. Then we will open Excel and build a robust financial model from the ground up, complete with Cash Flows, Summary Math, Key Financial Metrics, and Sensitivity Analysis – ultimately resulting in an intuitive and interactive Financial Dashboard. We’ll then organize and communicate the content in a powerful Executive Brief that will position your business opportunity for presentation, review and approval.