Sorry, this job is no longer available.

(Loading More Opportunities)

Financial Modeling

Main Responsibilities
Analyzing and spreading the historical financial statements in excel
Analysis of financial statements including Income Statement, Balance Sheet and Cash Flow Statement (incl. Free cash flow, funds from operations) of public and private companies
Going through the supplementary schedules, notes and MD&A for the detailed breakups and normalizing the financial statements for exceptional items to arrive at the true profitability figures
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.
Analyze the operating metrics to project the major line items like Revenues, EBITDA etc.
Screening the merger agreements and assessing synergies from the deal based on management inputs and third party data sources
Preparing detailed capital structure and debt amortization schedules (tranche wise) including pro forma adjustment for the acquisition. Candidate should have strong understanding of various classes of debt (secured/unsecured/subordinated) and financing options used by the borrower for the deal
Analyzing the pro forma credit metrics like total leverage, interest coverage, fixed charge coverage etc.
Prepare liquidation based recovery analysis for various debt pieces using recovery values for each asset type
Analyzing the financial covenants applicable to the borrower
Strong understanding of calculating IRR and various valuation techniques like DCF, Peer multiple
Conducting detailed Quality Checks

Required Background
MBA (Finance) / CFA / CA (CPA equivalent) - MUST
Experience of 2 - 8 years in financial modeling
Proficient in MS Excel
Prior experience of working on LBO models is preferred
Excellent written and spoken communication skills
Gurugram, HR, IN