O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required