Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. Our approach to financial modeling, is to make the component modular, and create integration among the components. We had experiences in many industries (manufacturing, food beverage, energy utilities, etc) , and subject areas (ex. tax planning, cash flow planning, product profitability) with various clients within Indonesia, integrated to their ERP systems including SAP and Oracle.
Our integration cover not only connection among components (ex. sales, opex, capex, financial statements) but also with external data sources (ERP, custom applications)
A good financial model should allow last minute changes (ex. new products, transferred business units) without significant project delays.
Important assumptions (ex. Exchange rate, UMR, fuel price) to calculate the financial model should be used in the model to allow what If simulation.
- Before picking the expensive tools, start with spreadsheet (Excel/Google Sheet) first.
- Analyze the model backwards, from Reporting to Assumptions. Involve key users in gathering model requirements
- Mark big ticket items, pay special attention to controllable ones
- Don’t collect too many data. Consider your company growing stages in collecting data
- Analyze key business drivers in creating suitable assumptions