CHAPTER SIXCASE STUDY 1:Modeling the Outputs Sheets

Having completed all the necessary calculations, we are now ready to bring together the key results from our calculations in the Outputs sheets.

6.1 STEP 1: DECIDING ON THE CONTENT OF THE OUTPUTS SHEETS

Since we are looking to summarize the key results from the Calculations sheet, the first thing we must do is to decide what information and/or data should be included in such a summary. To this end, we refer to what we were asked to do in this case study, a question that we already dealt with during the project scoping stage (see Chapter 4).

The case study is about putting together a financial model for the construction and operation of a mobile phone factory. Given construction and operating ...

Get Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.