Aranca - Senior Consultant/Assistant Manager - Financial Modeling

- Provide advisory assistance to Clients during fund-raising transactions by way preempting investor queries and resolving them, coordinating, and collating all key information to be submitted to investors, preparing necessary analytical data, presentations and assisting with any other necessary activity in the process.

- Communicate and liaison with existing and prospective equity investors, bondholders, lenders, rating agencies, developers, and other important stakeholders to understand key requirements of the bid and the underlying business model.

- Detailed discussion with the client to understand their requirement and advise on the financing structure.

- Drive productivity through successful engagement planning of valuation assignment, resource allocation, guidance to junior analyst teams, standardization initiatives and following best practices in project life-cycle management.

- Keep up to date with latest developments in certain target industry sectors as well relevant accounting standards and tax regulations impacting transaction decision marking.

- Develop financial models to capture financial and operating KPIs and ad-hoc financial analysis to drive better decision-making and prioritization for Bid submission and assessment. Ideal candidate will have experience in simulating Financial modelling features including (but not limited to):

Income Statement :

- Bid Price and Volume sensitivity

- Project and Contractual Life considerations

- Booking and Billing schedules

- Capacity utilization assessment

- Construction, operating and maintenance costs

- Production driven salary and Wages schedules

- Commission structures

- Rent to Own asset simulation

- Debt financing arrangements

- Debt structure

- Repayment Structure and Tenure sensitivity

- Frequency and Moratorium sensitivity

- Distributions to equity

- Dividend pay-outs

- Earnout simulations for Bid executions.

- Capitalization

- IRR assessment

- Project and Equity IRR calculations