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