Financial Modeling - Sr. Associate/ Delivery Lead/ Manager

Acuity Analytics; Gurugram District; Vor Ort; INR 1.200.000 - 1.800.000; Vollzeit

Zusammenfassung

Acuity Analytics in Gurgaon invites a finance professional to complete financial analysis and projection modelling for ongoing monitoring of high yield loans for a UK-based commercial bank. The role emphasizes spreading historical statements in Excel and analyzing Income Statement, Balance Sheet and Cash Flow.

You will project revenues and EBITDA, prepare capital structures and debt amortization schedules, assess credit metrics and covenants, and build scenario analyses.

Qualifikationen

• 5–10 years of post-qualification experience in financial modeling and analysis.
• Excellent written and spoken communication skills.
• MBA (Finance) / CFA / CA (CPA equivalent) is required.

Aufgaben

• Complete financial analysis and projection modelling for monitoring high yield loans for a UK-based bank.
• Analyze and spread historical financial statements in Excel.
• Analyze Income Statement, Balance Sheet and Cash Flow statements.
• Model operating metrics to project revenues and EBITDA.
• Prepare detailed capital structure and debt amortization schedules, including pro forma adjustments.
• Analyze pro forma credit metrics such as total leverage and interest coverage.
• Assess financial covenants applicable to the borrower.
• Develop scenarios based on management guidance, budget and consensus estimates.
• Screen merger agreements and assess synergies from the deal.
• Compute IRR and apply valuation techniques (DCF, peer multiples, liquidation recovery) for debt pieces.
• Conduct quality checks of work and deliver to client.

Kenntnisse

Excellent communication skills

Ausbildung

MBA (Finance) / CFA / CA (CPA equivalent)

Tools

MS Excel

Jobbeschreibung

Roles and Responsibilities

• To complete the financial analysis and projection modelling for ongoing monitoring of the high yield loans for an UK based commercial bank
• Analyzing and spreading the historical financial statements in excel
• Analysis of financial statements including Income Statement, Balance Sheet and Cash Flow
• Analyze the operating metrics to project the major line items like Revenues, EBITDA etc.
• Preparing detailed capital structure and debt amortization schedules (tranche wise) including pro forma adjustment for the acquisition.
• Analyzing the pro forma credit metrics like total leverage, interest coverage, fixed charge coverage etc.
• Analyzing the financial covenants applicable to the borrower
• Strong understanding of financial projections based on management guidance, company budget and consensus estimates. This will include creating various scenarios like management case, sponsor case, upside and downside case etc.
• Screening the merger agreements and assessing synergies from the deal based on management inputs and third party data sources
• Strong understanding of calculating IRR and various valuation techniques like DCF, Peer multiple and liquidation based recovery analysis for various debt pieces using recovery values for each asset type
• Conducting detailed Quality Checks of the work done by Analysts and finally delivering to the client

Desired Candidate Profile

• MBA (Finance) / CFA / CA (CPA equivalent)
• Post qualification experience of 5 - 10 years in financial modeling and analysis using excel is a must
• Proficient in MS Excel
• Excellent written and spoken communication skills

Location: Gurgaon

Notice Period: Immediate - 60 days