CIB Research & Analytics | Wholesale Payments Group Work Description:1. Ratio Analysis – WC Benchmarking & Cash flow- Performing WC & Cash mgt benchmarking by analyzing liquidity ratios for the client viz. the peers- Computing Net WC & leveraging Credit reports for analysis of sources of WC financing- Computing WACC along with Required Op. Liquidity and Reduction in Op. Liquidity using SD and LOESS methods2. CCC Analysis & JPM Solutions- Performing CCC analysis by computing & analyzing the DSO, DPO levels – suggesting solutions basis the same- Received banker & client appreciation for creating a dashboard in excel for Receivables Analytics project - DSO3. Regulatory/Industry Research- Worked on a Digital Banks project that involved analyzing the regulations around digital banks in India & abroad- Prepared industry decks on global Auto Supplier & Payments showcasing the business value chain, trends etc.

- Testing of Revenue, Employee Benefit and consumption for a hotel unit and assisted in application of Ind AS on security deposits discounting as well as Inter corporate loans for HO - Re-computed the interest on fixed deposits and SEIS income attributable to the hospitality sector- Obtained understanding of a hotel's revenue model from booking up till collection, management fee contracts and their impact on FS- Analysed a new lease agreement to determine the impact of lease liability discounting and its respective RTU asset- Finalized the financials for one of the subsidiaries of the hospitality client - Analysed the impact of new loan obtained starting from its terms, security, financial covenants to interest calculation, Ind AS accounting & disclosure- Assisted in segregation of debt and equity components in presentation of compound financial instruments- Analysed the changes made in Guidance note for Tax Audit 2014 in order to define the test steps- Tested clause 34(a), (b), (c) of the Tax audit form by analyzing the class of transactions in the  Statement of P&L from the point of view of Tax deductionClients: SAMHI Hotels, InterGlobe Hotels, Pernod Ricard India, Fidelity International

-Preparing of power point presentation for highlighting the issues identified during the engagement at the time of articleship - Review of Fixed Asset procurement, capitalization and disposal process ; Re-computation of depreciation as per Schedule II of Cos Act, 2013.- Testing of loans (including External Commercial Borrowings), Investments , Idle funds analysis along with Cash & Bank.- Analyzing the Swap arrangements undertaken by the company for hedging its foreign exchangeexposure such as Interest rate swap.- Verifying the duty drawback availed w.r.t to the amount of drawback, delays in submission ofdocuments, long pending drawback amounts & their write off.- Review of the Insurance coverage provided to assets and determining the risk pertaining to exportsales by considering the Inco terms.- Assisting in fraud Investigation undertaken for a food grain company having fictitious inventory inorder to identify the bogus purchase & sales including export transactions.Assignments undertaken : HCL Infosystems Limited, MPS Ltd, Sembcorp Green Infra Ltd, Project Husk.