Financial Modeling - Sr. Associate/ Delivery Lead/ Manager

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

Interested Candidates please share CV's at [email removed]

Location: Gurgaon

Notice Period: Immediate - 60 days