Tega Chikobava
Financial Analyst I Corporate Finance I Financial Modelling
New to Contra
Tega is ready for their next project!
Financial Modeling and Projection
What I Offer:
#Customized 3-statement financial model
#Financial projections
#Scenario & sensitivity analysis
#Clear assumptions page for easy updates and revisions
#Valuation models (DCF, multiples, or custom)
#Dynamic dashboards and charts in Excel or Power BI
Tools Used:
#Microsoft Excel (advanced formulas, pivot tables, financial templates)
#Power BI (interactive dashboards)
#Python (optional for automation or large datasets)
Deliverables:
#Fully editable Excel file with built-in formulas
#Visual financial summary or KPI dashboard
#Summary report with insights and recommendations
0
153
Data Analysis and Visualization
#Data Preparation and Cleaning
Gather and organize data from various internal systems (spreadsheets, databases, APIs, etc.).
Clean and validate datasets to ensure accuracy and consistency.
#Data Analysis and Reporting
Analyze business performance metrics and financial indicators.
Identify inefficiencies, cost leakages, and potential revenue growth areas.
Create automated dashboards and KPI reports using Excel, Power BI, or Python.
#Insights and Recommendations
Present findings in a clear, visual, and actionable way.
Provide recommendations to support business and operational decisions.
0
131
Financial Model Review, Audit & Optimization
Reviewed and enhanced existing financial models to improve accuracy, transparency, and usability.
Scope included:
Identifying and resolving formula errors and inconsistencies
Validating assumptions and ensuring logical flow across sheets
Stress-testing model outputs under different scenarios
Improving model structure, readability, and performance
Standardizing calculations and implementing best practices
Delivered clean, reliable models suitable for decision-making and stakeholder review.
0
65
Financial Modeling for Infrastructure / Energy Projects
Developed and refined dynamic financial models for infrastructure and energy projects, including full 3-statement integration and project finance structures.
Scope included:
Building revenue and cost drivers based on operational assumptions
Structuring debt and equity components (including repayment schedules and covenants)
Developing valuation modules (DCF, IRR, NPV)
Performing scenario and sensitivity analysis to assess key risks
Ensuring model flexibility for different transaction structures
Models were designed to support investment decisions and transaction analysis.
0
70
Google Sheet Dashboards - Automated Reporting & Data Management
I review existing dataset, recommend an optimal structure, and deliver a tailored dashboard that aligns with operational and strategic goals. Clean data structures, scalability, and insights.
#Developing custom dashboards with automated KPIs and performance metrics
#Organizing and restructuring data for efficiency and long-term maintainability
#Implementing dynamic filters, dropdowns, and standardized data-entry systems
#Consolidating information from multiple sheets or external sources
and automating calculations
#Producing periodic performance summaries and analytical reports
0
57