From the course: Corporate Finance: Robust Financial Modeling
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Planning, planning, planning
From the course: Corporate Finance: Robust Financial Modeling
Planning, planning, planning
- Before you get too excited and start building your model, you need to consider the bigger picture. Hopefully, you plan to be in operation for quite a while, so this means that your financial models need to be built for the long term. Here's an example. Many years ago I was reviewing a client's financial model, a 10-year lifecycle costing, it was kind of producing the outputs it needed to, but I could just tell that the architecture of the model was fundamentally broken. By this I mean, it was nearly impossible to make any changes to the model, and this is essential. Also, the stakeholders were questioning the integrity of the outputs. After spending some time working through the 50-odd Excel worksheets, I eventually figured out that this model was kind of like a mansion that started its life as a little cottage with each room progressively added on one at a time as the owners decided that they need more rooms. My…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.