Junior Financial Analyst

• Maintain appropriate databases or other analyses to monitor, forecast and report on Headcount within the functional areas
• Assemble spreadsheets and draw charts and graphs used to illustrate technical reports
• Assist in the preparation of comprehensive KPI’s model (Financial & Business) in line with Company’s objectives and captures all relevant info needed to manage the business
• Prepare operating budgets based on previous figures or estimated revenue and expense reports
• Develop and improve processes related to expenditure, appropriate financial methods to better evaluate and measure performance
• Analyze expense trends and establish expense accruals
• Translate accounting data into meaningful management information
• Assist in development of financial models to analyze sales and other financial data
• Create and distribute various financial reports on a weekly, monthly, quarterly and annual basis
• Assist in the valuing of acquisition opportunities through historical data analysis
• Support month-end close process by preparing recurring and ad hoc reports, researching general ledger activity and variances to budget and prior year
• Provide analytical support to various treasury or cross-function initiatives and ad hoc projects
• Participate in new projects by processing simulations for new joint ventures and preparing business plans, study of the cash flow and P&L
• Prepare and monitor the performance of internal rate of return (IRR) studies for proposed outlets and new products
• Participate on project teams involving reporting or systems changes, and act as tester
• Participate in relevant projects and community activities as and when needed
• Develop excellent knowledge of the business units’ operating environments including market size, industry trends, competitors, brands, margins, retail outlets as well as advertising spend etc.
• Coordinate and collaborate with Business units’ management to gather, research, analyze and summarize financial data
• Support Marketing and Sales Teams in preparing P&L projection for promotions and launches, analysis of financial viability of new openings and marketing budget follow-up
• Develop Financial Strategic Planning, Annual Plan, Quarterly Plan updates, Budget, Forecast & reconciliation
• Review purchase cycle and analyze the Cash Flow on weekly basis to provide corrective actions if necessary
• Assist in the preparation of the Monthly Tableau de Bord (TDB), the Budget and the revised Budget TDB from individual company TDBs
• Prepare analysis and recommendations on monthly financial figures from business units compared to budget and last year and issue reports as required by the management
• Assist in monthly financial statements, forecast and annual budget process including profit and loss statements, gross margin analysis, balance sheet and Interest rate parity (IRP) and recommend action
• Analyze variance to budget/forecast and prepare reports explaining budgets deviations