Financial Modeling

Overview

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