CHAPTER EIGHTCASE STUDY 3:The Phone Factory Revisited

8.1 INTRODUCTION

Let us fast-forward the Phone Factory case study by two years. The plant has now been built, and we are ready to start operations. The market for mobile phones has turned out to be much larger than we had initially anticipated (two years ago). As a result, the factory has been built with a much bigger production capacity. Furthermore, demand for mobile phone handsets is so strong that the starting selling price is 50 percent higher than we had initially forecast. Sales are forecast to reach $6 million for the first year (about 30,000 handsets sold at an average of $200).

With the factory now up and running, your manager has asked for a revised 10-year financial model setting ...

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.