LBO/Financial Modelling

To complete the financial analysis and projection modelling for ongoing monitoring of the high yieldloans for an UK based commercial bankAnalyzing and spreading the historical financial statements in excelAnalysis of financial statements including Income Statement, Balance Sheet and Cash Flow Statement(incl. Free cash flow, funds from operations) of public and private companiesGoing through the supplementary schedules, notes and MD&A for the detailed breakups andnormalizing the financial statements for exceptional items to arrive at the true profitability figuresAnalyze 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 formaadjustment 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 dealAnalyzing the pro forma credit metrics like total leverage, interest coverage, fixed charge coverage etc.Analyzing the financial covenants applicable to the borrowerStrong understanding of financial projections based on management guidance, company budget andconsensus estimates. This will include creating various scenarios like management case, sponsorcase, upside and downside case etc.Screening the merger agreements and assessing synergies from the deal based on managementinputs and third party data sourcesStrong understanding of calculating IRR and various valuation techniques like DCF, Peer multiple andliquidation based recovery analysis for various debt pieces using recovery values for each asset typeConducting detailed Quality Checks and delivering to the clientResponsible for achieving 100% qualityMeeting strict deadlines and ability to work under pressureAbility to work individually and in the teamUpdate reporting manager on the tasks in hand, completed on a regular basisCommunicate with onshore Risk team for providing regular update and workflowsProvide inputs, involved in discussions and Implementing new ideas to generate efficiencyRequirements-MBA (Finance) / CFA / CA (CPA equivalent)Experience of 4 - 6 years in financial modeling and analysis using excelProficient in MS ExcelPrior experience of working on LBO models is preferredExcellent written and spoken communication skills