Right at the start a good financial analyst should assign responsibilities for the detailed management of the financial model build process.
One person should be in charge overall but may delegate modules to different team members working in parallel. Only the responsible person should make changes to the structure of each module: names, cells formulas, etc.
The financial analyst with overall responsibility must structure each module and organise and manage the flow of information between spreadsheet worksheets, modules and computers.
Define clearly the scope and objectives of the financial model and the scenarios that will be analyzed to the users and eventual audience of the financial model results. Be sure to be clear on your role in relation to the users and audience of the financial model results.
A good financial analyst should be able to manage several client interfaces at different levels and maintain overall control of the financial modeling project. Resist tendency of getting sucked into taking on more and more responsibilities – financial modelers are usually perceived to be on the critical path.
Visit Finance 3.0 - don't miss out on this high quality financial learning opportunity