Developing the Excel Model
A model for a business case built using Excel synthesizes concepts and methods that you have already learned about in this book: income statement formation (discussed in Chapter 1, “Working with Income Statements”), cash flow analysis (in Chapter 5, “Working Capital and Cash Flow Analysis”), budget planning (in Chapter 8, “Budgeting and Planning Cycle”), and forecasting (in Chapter 9, “Forecasting and Projections”).
The first step in developing the model is to create a pro forma income statement. The pro forma income statement takes into account the relevant benefits and costs involved in the proposed course of action.
Case Study: A New Type of Wireless Phone
Your manufacturing company has been a market leader in the ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
