BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Open Forum Enterprise Pte Ltd - ECPv4.3.1.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Open Forum Enterprise Pte Ltd
X-ORIGINAL-URL:http://www.openforum.com.sg
X-WR-CALDESC:Events for Open Forum Enterprise Pte Ltd
BEGIN:VEVENT
DTSTART;VALUE=DATE:20170502
DTEND;VALUE=DATE:20170504
DTSTAMP:20260607T060422
CREATED:20161123T055926Z
LAST-MODIFIED:20170508T035634Z
UID:663-1493683200-1493942399@www.openforum.com.sg
SUMMARY:Financial Modelling for Public-Private Partnerships
DESCRIPTION:\n \t Overview \n \t Who will attend \n \t Trainer \n \t Case studies - Practical Exercise \n \t Partners \n \t Venue \n \t Industry Insights \n \t Brochure Download \n\n\n\nThe course is based around a single exercise which runs through all three days of the course.  You start with a blank Excel worksheet and develop a model using a step by step approach introducing each of Excel’s useful features as they are required.  By the end of the course you will have a model that is reliable\, robust and error-free.  This model will include a full set of accounts for a PPP project\, including; inflation\, sensitivity analysis\, DCF valuation\, LBO valuation\, macros\, data tables and graphics.\n\nKey Takeaways from Attending This Workshop:\n\n \tLearn how to write simple financial models that answer complex problems\n \tCreate models that are logically laid out\, easy to follow through and self-documenting\n \tWrite models that can easily be expanded as situations become more complex whilst maintaining their simplicity\n \tMaster how to make Excel work for you\, speeding up the model creation process\n \tProduce financial models that do not contain any errors\n\n \n\n\n\n \tAccountant\n \tCorporate Planner\n \tCorporate Financier\n \tStrategic Consultant\n\n                                        \n\n \n\n\n\nAfter gaining his MA in Engineering at Cambridge University\, Course Trainer joined KPMG and qualified as a chartered accountant in 1984\n\nHe then joined KPMG’s Management Consulting firm\, specialising in writing financial forecasts using a variety of spreadsheets.  During this time he realised the importance of setting work out clearly and how difficult that can be with spreadsheets.\n\nHaving developed his own spreadsheet methodology and applied it to numerous acquisition and other scenarios\, Course Trainer was asked to lecture it to other spreadsheet users and to clients\, including Schroeders\, SBC Warburg\, Hambros\, NM Rothschild and NatWest.\n\nCourse Trainer left KPMG to join UBS Warburg’s Education Department at the start of 1996.  There he continued to present his basic financial modelling course.  He also developed and presented courses covering the main technical topics that are essential knowledge for a corporate financier.\n\nIn April 1998\, Course Trainerleft Warburgs to set up as an independent management consultant\, specialising in educating and advising people about financial modelling.\n\nCourse Trainer also lectures to the MBA students at the London School of Business and Finance and at Kingston University.\n\nTestimonials:\n\n"An excellent lecturer and made the course very interesting."\n\n"Easy to understand\, with good examples putting work into context."\n\n"Taught me some great practical points about modelling."\n\n"Great communication skills and very broad experience in financial models."\n\n \n\n \n\n \n\n\n\nPractical Exercise 1\n\n \tStarting with a blank spread sheet and performing all the initial steps\n \tBuilding a simple model to calculate profit during the operational phase of a PPP project\n\nPractical Exercise 2\n\n \tEnhancing the operating profit model built in Practical Exercise 1\n \tIncluding all the required elements in an income statement in the model\n \tExtending the financial model time horizon to include the construction phase of the project\n\nPractical exercise 3\n\n \tAdding cash and interest calculations to the basic gross profit model built in PracticalExercise 2\n \tConducting calculations on senior debt\, time weighted average senior debt and interest on senior debt\n \tCalculating cash balance\, time weighted average cash and the interest on cash\n \tWorking out the net financing cost and including it in the income statement\n\nPractical Exercise 4\n\n \tWriting a balance sheet backing schedule using text function\n \tAdding all the backing schedules required for each value in the balance sheet and linking them to the appropriate places in the balance sheet and in the cash calculation built in Practical Exercise 3\n \tCompleting the balance sheet to ensure the model’s correctness\n\nPractical Exercise 5\n\n \tAdding sensitivity analysis to the full PPP financial models\n \tCalculating factors and linking these into the appropriate places in the model developed on Day 1\n \tCalculating the break points for each sensitivity factor\n\nPractical Exercise 6\n\n \tAdjusting the model built in practical exercise 5 to offer three different scenarios\n \tAdding three scenarios and a drop-down menu\n \tIncluding data tables and plotting graphs to show the effect on the results of varying input figures\n\nPractical Exercise 7 \n\n \tAdding a full DCF valuation to the model we have built\n \tCalculating the DCF valuation of the case study company\n\nPractical Exercise 8 \n\n \tAdding two extra layers of debt to the model which will be used to refinance the company\n \tPutting a new capital structure onto the existing company including both amortising and bullet repayment debts\n \tCalculating the surplus cash generated by the company\n \tAdding a cash waterfall for accelerated debt repayment\n\nPractical Exercise 9 \n\n \tAdding an LBO valuation to the model\n \tDetermining the LBO valuation of the case study company\n \tComparing the case study company’s LBO valuation to its DCF valuation\n\nPractical Exercise 10\n\n \tExtending the model’s time horizon\n \tAdding data tables and plotting graphs to show the effect on the results of a company of varying input data values\n\n \n\n\n\n\n \n\n \n\n\n\nInterested in partnering with us?\n\nPlease contact us to discuss your requirements.\nClick here to get in touch with us.\n\n \n\n\n\nWorkshop venue to be confirmed.\n\n \n\n\n\nWhy Public- Private Partnerships:\n\n“The real challenge is not a matter of money but a lack of bankable projects – a sufficient supply of commercially viable and sustainable infrastructure investments.”\nJim Yong Kim\, World Bank Group President \n\n“Developing countries now spend about US$1 trillion a year on infrastructure\, but maintaining current growth rates and meeting future demands would require investment of at least an estimated additional US$1 trillion a year through to 2020.”\nWorld Bank\n\n“The Asia and Pacific region requires infrastructure investment of at least $8 trillion until 2020.”\nAsian Development Bank\, PPP Operational Plan 2012 – 2020\n\n“The Government of India has announced that twenty-one road PPP projects bid out by the National Highways Authority of India (NHAI) did not get a single bidder during the fiscal year 2013-2014.”\nGovernment of India\n\n \n\n[contact-form-7 id="177" title="Financial Modelling for PPP"]\n\n\n\n\n\n
URL:http://www.openforum.com.sg/event/prepare-and-implement-successful-public-private-partnerships-2/
ATTACH;FMTTYPE=image/jpeg:http://www.openforum.com.sg/wp-content/uploads/2016/11/PPP-2-4-May-2017.jpg
ORGANIZER;CN="Open%20Forum%20Enterprise%20Pte%20Ltd":MAILTO:tickets@openforum.com.sg
END:VEVENT
END:VCALENDAR