I can create for you a KPI Analysis Module in Excel to calculate the performance based on chosen parameters. The performance reports show results per period, person, working group and company levels.
About me:
I am a financial expert and a guru in Excel/VBA/Macro. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios (INPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts.
I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.