Projects

Selected Work

Models, tools and systems I have built in response to problems I encountered in finance, reporting and audit.

01Debt structure, repayment capacity and restructuring scenarios

Debt Restructuring Analysis

An analysis model that brings a company’s financial debt into a single inventory, compares it with cash generation capacity and makes the effect of different restructuring scenarios visible.

  • Debt Restructuring
  • Cash Flow
  • CFO
  • Scenario Analysis

02Gross to net, net to gross and employer cost

Payroll Simulator

A simulation tool that calculates pay from gross to net and net to gross, shows tax bracket transitions through the year and the total employer cost month by month.

  • Payroll
  • Tax
  • Budgeting
  • Simulation

03Scenario-based short-term cash management

13-Week Cash Flow & Early Warning Model

A management model that tracks the company’s 13-week cash outlook by scenario and makes critical cash levels visible in advance.

  • Cash Flow
  • FP&A
  • Scenario Analysis
  • CFO

04Integrated income statement, balance sheet and cash flow projection

Five-Year Business Plan and Three-Statement Projection

A financial planning model that turns a company’s five-year strategic goals into a linked income statement, balance sheet and cash flow projection.

  • Business Plan
  • Financial Modelling
  • FP&A
  • 3-Statement Model

05Comparing financial restructuring and liquidation scenarios

Restructuring vs. Liquidation Comparison Analysis

An analysis model that compares financial restructuring (FYY) and liquidation on the same assumptions, showing which route gives creditors the higher recovery.

  • Restructuring
  • Liquidation Analysis
  • Creditors
  • Valuation

06Diagnosis, cash control and improvement roadmap

Operational Turnaround Plan

A planning framework that diagnoses the sources of a company’s deteriorating performance with financial data, brings cash under control and ties improvement steps to measurable targets.

  • Turnaround
  • Performance Improvement
  • Cash Flow
  • CFO

07Preparing the financial schedules of a concordat process consistently

Concordat (Konkordato) Project File Module

A module that produces the financial schedules needed in a Turkish concordat (konkordato) process — repayment plan, cash flow projection, creditor list and liquidation comparison — from one data set, consistently with each other.

  • Konkordato
  • Restructuring
  • Cash Flow
  • Financial Reporting

08From trial balance to financial statements and notes

TFRS/IFRS Reporting Software

Reporting software that maps the statutory trial balance to the TFRS/IFRS and BOBİ FRS reporting structure, manages conversion entries and produces the financial statements and notes together with consistency checks.

  • TFRS
  • IFRS
  • BOBİ FRS
  • Financial Reporting
  • Automation

09A desktop analysis system for accounting data

E-Ledger Analysis Engine

An analysis engine for examining Turkish e-ledger (e-Defter) data in terms of account movements, unusual transactions and risk indicators.

  • Accounting
  • Audit Analytics
  • Python
  • Data

10Driver-based planning architecture

Budget & Forecast Management Model

A financial planning model that turns the budget from a static spreadsheet into a living management system of assumptions, actuals and forecasts.

  • Budgeting
  • Forecasting
  • FP&A
  • Management Reporting

11Management information architecture

Management Reporting & KPI System

A reporting system that brings financial and operational indicators together in a simple, comparable structure management can act on.

  • KPI
  • Management Reporting
  • Financial Analysis