Senior Consultant/Assistant Manager – Financial Modeling

Aranca; India; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Aranca, a global research and advisory firm, seeks a highly skilled financial modeller to support fund-raising transactions for strategic clients in India. You will develop robust project finance models, analyze key KPIs, and prepare presentations for investors, lenders and rating agencies.

In this role you will coordinate with deal teams to gather data, challenge assumptions, and ensure timely delivery of analytical outputs across the bid process.

Qualifications

• Advanced ability in developing project financial models and budgeting tools.
• Experience with INDEX and OFFSET functions; proficient in scenario analysis.
• Ability to convey corporate finance concepts to non-financial clients.
• Understanding of debt funding, bid pricing, and contract structures.
• Strong organizational and time-management skills; detail-oriented.

Responsibilities

• Provide advisory support during fund-raising by compiling data and preparing analyses and presentations.
• Communicate with investors, lenders, rating agencies, and other stakeholders to capture bid requirements.
• Develop financial models to capture KPIs and perform ad-hoc analysis for bid submissions.
• Simulate bid pricing, debt structures, and equity IRR for decision making.

Skills

Advanced financial modelling

Project budgeting & forecasting

Scenario analysis

Corporate finance communication

Debt funding understanding

Time management & organization

Tools

Excel

Excel Macros

VBA

Job description

• 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.
• 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

Key Set:

• Advanced ability in developing project financial models, budgeting and forecasting tools.
• Prior experience with INDEX, OFFSET functions along with high competence in Scenario analysis and Macros
• Proven ability to understand and convey Corporate Finance concepts to Client’s non-financial members.
• Understanding of Debt funding, contract structures, Bid pricing, and deferred payment plans.
• Strong organizational and time management skills for managing and coordinating a variety of tasks simultaneously.
• Detail oriented with high level of attention to accuracy.

About Company

Founded in 2003, Aranca is a global research and advisory firm empowering decision makers from Fortune 500 companies, financial institutions, Private Equity and high potential start-ups with intelligence and insights to make better business decisions.

We enable this by bringing to play the right mix of the best data, the best methodologies, and the best talent to deliver value to our clients.