Example: air traffic controller

Introduction to Financial Modelling - PwC: Audit …

Introduction to Financial Modelling 2-day workshop PwC’s Academy Benefits of attending A financial model has become a critical tool used by organisations to




Link to this page:

Please notify us if you found a problem with this document:

Other abuse

Text of Introduction to Financial Modelling - PwC: Audit …

Introduction to Financial Modelling2-day workshopPwC s AcademyBenefits of attendingA financial model has become a c ritical tool used by o rganisationsto understand business risks and make important strategic decisions. An effec tive model is robust and flexible, yet user-friendly, so that it c an be used to analysethe impact of o perational parameters on the value and v iability o f a business. With a go o d understanding of the key steps involved in financial mo delling, participants will be able to build a well-structured and robust mo del and use it to solve important business problems. Participants will able to appreciate the use o f the financial model as a powerful tool to c o mmunicate complex financial analyses and simulation results to stakeholders. This wo rkshop will cover the basic financial modelling principles, best practices in financial modelling and excel functions frequently used in mo dels. Participants will also learn how to use model auditing tools to c heck fo r model errors. Learning is achieved via practical examples and gro up discussions which reinforce the theory; c ase studies and Excel-based exercises which allows participants to have hands-on experience with financial models. Course Prerequisites: Participants are assumed to have some prior kno wledge o f basic accounting c oncepts and Microsoft Excel. Who should attend?Finance professionals inv olved in budgeting and inv estment analysis o r anyone who uses financial mo dels fo r business dec isions, financial planning and analysis. ObjectiveTo pro vide participants w ith an understanding o f financial modelling and enable them to develop ro bust financial models using Excel to make better inv estment financial professionals build robust and flexible models for better analysis and decision agendaPwC s AcademyFin ancial Modelling Overview Understand the common uses o f financial mo dels and the key design c onsiderations o f a mo del. Understand that a financial model is c o mprised o f 3 distinct sections, namely data inputs, calculations and model o utputs. A ppreciate the process involved in developing a financial Practices of Financial Modelling To be aware o f the best practices used in building c lear and auditable financial Excel Functions in Modelling To be familiar with the use o f date functions, range names, data validation, lo gic functions (if, o r, and, not, masks), conditional formatting and array lookup functions (index, match, lo o kup, vlookup, hlookupand offset).Steps to Building a 3-statement Model Understand how to set up the model timing, flags and masks. Building up the Profit & Lo ss statement ( revenue, costs o f goods so ld, o perating expenses). Building up the Balance sheet ( Capex and Depreciation Sc hedules, Account Receivables, A c count Payables, Debt balances and interest ex penses, shareholders equity and retained earnings account). Building up the c ash flow statement ( Cash flow fro m o perations, net working c apital c hanges, Cash flo w from investment, cash flo w from financing).I nvestment A ppraisal T ools Be able to perform Free Cash Flow and Discounted Cash flo w Audit Understand the common procedures used to check a mo del for outlineAbout your workshop leadersOliv er RedrupOliv eris a Director of PwCSingapore. Oliver regularly conducts external and internal training c o urses on financial modelling and infrastructure c o ntracts and financing has wo rked across multiple industries with a fo cus on large sc ale infrastructure projects and transportation service c ontracts whic h requires complex project financing so lutions. Registration fees(includes 7% GST)Pw C C lients & Alumni: S$925Pu b l ic: S $995G r oup discount of 1 0% for 2 or m ore pa rticipantsHow to registerTo register, simply select the course via o ur Training Calendar ( ) and c lick o n the chosen c ourse date to access the digital registration fo rm. Fo r any further queries, please email ac KangRebeccais a Senior Manager o f PwCSingapore. Rebecca has extensive experience in financial mo delling, deal structuring, c apital raising, go vernment and bid advisory. She has developed and reviewed c omplex and dynamic financial mo dels fo r infrastructure projects spanningv arious sectors, countries and financing structures. Da y 1-Fin ancial Model ling Ov erview-Best Pr actic es of Financial Model ling-Usefu l Ex cel Functions-Bu il ding up the Profit and Loss S tatem entDa y 2-Bu il ding up the Ba lance S heet-Bu il ding up the C ash Fl ow S tatement-In v estment Appraisal T ools-Model A udit 201 8 PricewaterhouseCoopers Advisory Services PteLtd is part of the network of member firms of PricewaterhouseCoopers Intern ational Limited, eac h of which is a separate and independent legal entity.

Related search results