Transcription
Certificate in FinancialModelling and ValuationE-learningLearning and Development Academyby Grant Thornton Bharat
A programme for workingprofessionals andstudentsThe Certificate in Financial Modelling and ValuationE-Learning aims to provide working professionals andstudents practical exposure to financial modelling andvaluation, help them understand and build business aswell as valuation models. The programme will ensureconceptual knowledge is imparted with a perfectblend of industry practices. Our approach involvesfocusing on concepts through case studies to help ourparticipants relate the scenarios to their job roles.This programme will help you create financial modelsthat can be understood and easily implemented to gaininsights into the opportunities and risks being faced by businesses. It will also help you gauge theperformance of a financial asset or portfolio of a business project or any other investment.Learning outcomesUnderstand, refresh their MS Excel skills along withinterpreting financial statement peculiar to creating andworking around a financial modelBuild a financial modelling templateUnderstand the importance of managing data andrespective assumptions to build a financial modelBuild flexible cash flow models and learn the application ofthe discounted cash flows to build a financial modelLearn to calculate various measures of valuations such asWACC, CAPM, sensitivity analysis and concepts of IRRUnderstand the details of a project valuation model with thehelp of an integrated financial model and asset scheduleCertificate in Financial Modelling and Valuation E- LearningCreate and interpret an EPC and a CAPEX scheduleReport the progress of projects with the help of GANTTchartsBuild interactive excel dashboards with the help of sparklingpivots, map pivots, bar charts etc. including dynamic titlesLearn concepts of merger motivations and different kinds ofmergersUnderstand various approaches of valuation as required formergers and acquisitions transactions.Understand key drivers and inputs for mergersLearn accretion/dilution analysis and modelling a financingplan
Deliverables50 hours ofstudy 40 hours of course recordedvideos 8 hours of advance Excelprogramme 2 hours of other content andassessmentsGrant Thorntonpresentations ascourse materialsCertificate ofcompletionTwo-waycommunication andquery resolution from‘Ask an expert’Quiz and finalassessmentCase studiesLMS access of oneyearWho should attendInvestment bankersEquity researchersProfessionals working in corporate finance or M&A domainFees:INR 15,000plus taxesChartered AccountantsMBA finance and commerce graduatesProfessionals working in the finance domainFor further queries, please contact:Rohit GuptaManagerGrant Thornton Bharat LLPM: 91 98913 95363E: Rohit.Gupta1@in.gt.comCertificate in Financial Modelling and Valuation E- Learning
Features of e-learning and LMSQuery resolution within24 hoursOffer remote learners anengaging learning experienceTwo-way communicationthrough ‘Ask the expert’Cost-effectiveFlexible – learn anytimefrom anywhereAccessible on mobile andtabletsCertificate in Financial Modelling and Valuation E- Learning
Testimonials“The programme is a complete package thatprovides professional insights to the world ofFinancial Modelling and Valuations. The trainersare experts in their field and impart practicalknowledge through case studies. The hands-onexperience and support from trainers enhancedmy skills. I recommend this programme toanyone who wants to make financial models.“Kumar Arijit,Doon Business School““Really appreciate the best practices andemphasis on creating a fully-linked financialmodel for scenario analysis during the workshop.Satish Babu,Comviva TechnologiesLimited“Ishaan Arora,FinladderCertificate in Financial Modelling and Valuation E- Learning“The session was really good. The instructor wasable to explain concepts in detail and ensuredthat every one, irrespective of their proficiencylevels, was able to grasp. The content was goodtoo.““One of the best sessions I ever attended as astudent. The management was very helpful andcooperating. The instructors knowledgeable andalong with their unique method of teaching, theymade the course very special. I would stronglyrecommend this course to everyone.Balakrishnan Vijayan,Finance professional
E-learning agendaExcel refresher:Building integrated financial modelFreezing, sorting and conditional formattingWorking on Historical StatementsCreating Hyperlinks thought excel functionModeling Assumptions for Future ActionCOUNT related functionsRevenue Build-up – projecting the future revenuesLookup based functions (VLOOKUP, HLOOKUP)Cost Build-up – projecting the future costLookup based functions (INDEX and MATCH)Asset and Depreciation SchedulesSUMPRODUCT function and related casesDebt and Equity SchedulesText related functionsModeling the Financial Statements (P&L, BS and CFS)Date related functionsInterest income and breaking circularityConditional summation (SUMIFS)Combining text from a range of cells (TEXTJOIN)Getting value from a database using DGET functionData summarisation using Pivot Table and SlicerValuation related workingsCost of equity (CAPM) and post tax cost of debtComputing WACCAGGREGATE functionAbsolute valuation: Performing valuation using DCF (FCFFand Enterprise Value)Financial functions and creating loan amortizationRelative valuation: Comparable analysisPerforming sensitivity analysisCorporate finance and Investment BankingM&A AnalysisCorporate finance essentials (Capital budgeting, Timevalue of money, project evaluation methods)M&A evaluation case studyNPV CrossoverEvaluation in case of unequal livesProject evaluation casesInvestment Banking OverviewSearching and researching relevant reportsCollecting and projecting numbersMerger analysis – key drivers and inputsProjecting both companies' numbersSynergy benefitsStock payment and stake dilutionFinancial Modelling overviewModeling a financing planWhat is financial modelling?Pre merger profitability and EPSDeveloping an initial financial model using Telecom casestudyAccretion/dilution analysisCapex scheduleDrafting P&LValuation - Applying DCFCertificate in Financial Modelling and Valuation E- Learning
Data VisualisationData visualisation using chartsPresenting historical & projected data togetherCreating profit & loss BridgeDepicting variance analysisDynamic chart for dashboards using form control optionbuttons and combo boxFlexible chart using Scroll bar form control and Excel'sOFFSET functionProject finance modelProject finance case studySetting up required inputs and assumptions related to projectIncorporating contingency element as part of project costModelling Operating revenueOperating Cost drivers and computationFixed asset scheduleProject Financing - creating debt scheduleModelling Equity related schedules - Paid up capital and reserves& surplusPreparing financial statements - PL, BS and CFProject evaluation (Project IRR)Sensitivity analysis - evaluating impact of changes in key projectvariables on project profitabilityCertificate in Financial Modelling and Valuation E- Learning
Contact usTo know more, please visit www.grantthornton.in or contact any of our offices as mentioned below:NEW DELHINEW DELHIAHMEDABADBENGALURUNational Office,Outer Circle,L 41, Connaught Circus,New Delhi - 110001T 91 11 4278 70706th Floor, Worldmark 2,Aerocity,New Delhi - 110037T 91 11 4952 74007th Floor, Heritage Chambers,Nr Azad Society,Nehru Nagar,Ahmedabad - 3800155th Floor, 65/2, Block A,Bagmane Tridib,Bagmane Tech Park,CV Raman Nagar,Bengaluru - 560093T 91 80 4243 0700CHANDIGARHCHENNAIDEHRADUNGURGAONB-406A, 4th Floor,L&T Elante OfficeBuilding, Industrial AreaPhase I,Chandigarh - 160002T 91 172 4338 0007th Floor, Prestige Polygon471, Anna Salai, TeynampetChennai - 600 018T 91 44 4294 0000Suite No 2211, 2nd Floor,Building 2000, Michigan Avenue,Doon Express Business Park,Subhash Nagar,Dehradun - 248002T 91 135 2646 50021st Floor, DLF Square,Jacaranda Marg,DLF Phase II,Gurgaon - 122002T 91 124 462 8000HYDERABADKOCHIKOLKATAMUMBAI7th Floor, Block III,White House,Kundan Bagh, Begumpet,Hyderabad - 500016T 91 40 6630 82006th Floor,Modayil Centre Point,Warriam Road Junction,MG RoadKochi - 682016T 91 484 406 454110C Hungerford Street,5th Floor,Kolkata - 700017T 91 33 4050 800011th Floor, Tower IIOne International CenterSB Marg Prabhadevi (W)Mumbai 400013T 91 22 6626 2600MUMBAINOIDAPUNEKaledonia, 1st Floor, C Wing,(Opposite J&J Office),Sahar Road, Andheri East,Mumbai - 400 069Plot No. 19A, 2nd Floor,Sector – 16A,Noida 201301T 91 120 485 59003rd Floor, Unit No 309 to 312,West Wing, Nyati Unitree NagarRoad, Yerwada,Pune- 411006T 91 20 6744 8800For more information or for any queries, write to us at contact@in.gt.comFollow us @GrantThorntonIN 2020 Grant Thornton Bharat LLP. All rights reserved.“Grant Thornton Bharat” means Grant Thornton Advisory Private Limited, the sole member firm of Grant Thornton International Limited (UK) in India, and those legal entities which are its relatedparties as defined by the Companies Act, 2013, including Grant Thornton Bharat LLP.Grant Thornton Bharat LLP, formerly Grant Thornton India LLP, is registered with limited liability with identity number AAA-7677 and has its registered office at L-41 Connaught Circus, New Delhi, 110001.References to Grant Thornton are to Grant Thornton International Ltd. (Grant Thornton International) or its member firms. Grant Thornton International and the member firms are not a worldwidepartnership. Services are delivered independently by the member firms.
The Certificate in Financial Modelling and Valuation E-Learning aims to provide working professionals and students practical exposure to financial modelling and valuation, help them understand and build business as well as valuation models. The programme will ensure conceptual knowledg
