Hi! i am Benny, from Indonesia! I am working as a Corporate Strategist (Senior Research Analyst). I am doing financial model and valuation for project-based business case.
In creating financial model architecture, I differentiate the input, process / engine, and output.
In the input sheet, I always do detail breakdown so the user can manually change the assumptions based on their needs. In addition, I put blue color meaning that it is a hardcoded number.
In the process sheet, I create the sheets based on the complexity of the model. For example, in the Telco company, I will put a subscriber sheet (breakdown in based on the city) in a separate sheet therefore it will be easy to be understood and link to the financial statement
In the output sheet, I separate the P&L, Balance Sheet, Cash Flow and the valuation sheet
In summary, I can create a basic to complex financial model based on your needs. Hope we can work together
Thanks!