Financial Modeling from zero to a Master – 18-19 September 2014 – Four Seasons Hotel 2-day practical workshop: Financial Modeling From zero to Master Take your analytical skill to the next level….and design world class models…in just 2 days  18 – 19 September 2014 – Four Seasons Hotel Jakarta, Jalan H.R. Rasuna Said Financial Modeling techniques allow business users to improve the reliability, quality and timeliness of their decision making. Modeling techniques are now used in many different areas, such as capital budgeting, investment appraisal, business valuation, financial analysis and forecasting. With a model-by-model approach, this course will guide you through the various techniques, providing you with a comprehensive understanding of Modeling, covering such issues as scenario analysis, forecasting and Solver analysis, as well as how each technique can practically be applied through the use of Excel, VBA and other tools. Who should attend: Your Presenter • Finance Managers & Supervisors Tri Gunawan Bayu Aji SE Ak, MM, CMA,CFM Bayu is a practitioner in Business Development, Corporate Finance, Management Accounting, Business Planning and Budgeting with years of solid experience in various industries such as manufacturing, distribution, Financial Institution, Shipping Line and Port Operator. He graduated from Accounting Department of UNPAD and obtain MM Degree from LPPM Jakarta. He has extensive experiences in giving public workshop; in-house training and lectures specialized in Financial Analysis and Financial Modeling. He learnt directly from Financial Modeling Gurus Dr. Richard Capps, Dr. Robert Graham and Dr. Ian Beamen. His team members are also practitioners from the biggest Beverages Company and Telecommunication Company, and having many experience in giving Financial Modeling Workshop. He and his team have already trained more than 500 professionals from many organization, with positive feedbacks and results. Benefits from attending this course: • Learn new ways to improve efficiencies in your financial modeling processes by gaining valuable skills • Discover a range of sophisticated techniques that will improve the usability and reliability of your financial models • Learn how to integrate & align your financial models with business strategy • Learn how to properly incorporate imprecise data and allow for uncertainties in model assumptions and variables • See how to properly utilize spreadsheet modeling best practices into action to create better financial models • Learn to optimize scenarios, sensitivity and risk analysis into financial modeling in the effective way Contact: Magdalena – 0815-86727350 / 0896-40528375 www.bayufinance.com • Business & Finance Analysts • Strategic Planners • Project Financiers & Lenders • Budget Analysts and Financial Planners • Corporate Finance Managers • Management Accountant • Etc… “It’s great workshop. I have gained the right skill and knowledge I need to do my job better” Financial, Reporting and Analysis Manager – Coca-Cola Bottling Indonesia “Bayu is a very resourceful person not only in Excel and Financial Modeling but in other areas” Financial, Planning and Analysis Manager – Sari Husada Email to: [email protected] Financial Modeling from zero to a Master – 18-19 September 2014 – Four Seasons Hotel Day 1 Principles of Financial Modeling Excel Fundamental Capital Budgeting • • • • • • • • • • • • • • • The NPV rule for judging investments and projects • The IRR rule for judging investments • NPV or IRR, which to use Basic Design Objective of Financial Modeling User Interface Key Variables and Rules Layout of good financial modeling Management Reporting Testing Protection and Documentation Learn how to use function If offset, match and index Linking data Formatting Data Validation Built simple macro using recording • Using range names Performance Management Advanced Financial Modeling - Workshop • • • • • • • • • • • • Financial Ratio understanding Profitability Ratio Liquidity Ratio Operating Ratio Modeling Plan the model – the outputs for analysis, the inputs for flexing Formatting and Layout Build intuitive model: Font Formatting, Color and Input Advanced Menu: Combo Box, Scroll Bar, List Box and other Menu Building summary and documentation in your model Using Comment and Data Validation Build Graph, creating interactive graph Day 2 Advanced Financial Modeling Workshop…continue • Build Dynamic Chart using advanced menu, and use menu as inputs • Put Sensitivity on your financial modeling • Build Sensitivity Chart • Build Scenario using Advanced Menu and VBA to automatically query • Layout and flow of the model • Build Goalseek using Advanced Menu and VBA to automatically target • Build Interactive Chart • Using Solver and build VBA for Scenario • Create dynamic range using Names Group Discussion, Building Financial Modeling • You will learn how to add combo box, list box and other menu • You will build a simple menu • You will add input/ output to your model by using menu, validation and comment • You will learn how to use macro and vba to automatically input or result • You will learn how to create, manage, and present multiple scenarios and perform sensitivity analysis Tips and Tricks in building a good and interactive financial modeling • • • • • Using Pivot Table Advanced Data Validation Using YTD function Building Advanced Interactive Chart Using sumproduct, sumif and building mega formula into your financial modeling • Use advanced features to link into your model to a database (local or web database) • Xcelsius Dashboard • MACRO editing to minimize complications Contact: Magdalena – 0815-86727350 / 0896-40528375 • • • • • • • Model automation using controls to enhance usability Build Waterfall Chart Forecasting Linear regression, Moving Average and seasonality Building Function using Visual Basic Application for Excel Monte Carlo analysis Optimization, break even analyzer, data tables, function driven • Create Add-in • Reporting and Dashboard www.bayufinance.com Email to: [email protected] Financial Modeling from zero to a Master – 18-19 September 2014 – Four Seasons Hotel In-house training, we will come to you! If you have a team of 10 or more why not hold a private course? We have successfully arranged in house sessions We have various experience on inhouse trainings with positive feedbacks and results!! COURSE SCHEDULE Registration 8.30 am Course Begins 9.00 am Morning Break 10.30 am Lunch 12.00 pm Afternoon Break 3.30 pm Close 5.30 pm Weekend Class We offer you weekend class (Saturday and Sunday) in deepening your Excel and Financial Modeling skill, the class will start with minimum 5 persons Venue: PPM Training Center, free Wi-Fi, Lunch, and Coffee break Contact Ms. Magdalena on: Mobile: 0815-86727350 0896-40528375 [email protected] [email protected] www.bayufinance.com Learn the most effective ways to design, cross check and Structure your Financial models Build robust and flexible models so you can perform add-ins and make amendments while maintaining the integrity of your spreadsheets Learn to create and compare scenarios – base case, best case and worst case Save hours of modeling manipulating time. Get the job done faster and painlessly Course materials You receive full course notes, plus a USB full of practical templates, exercises & solutions, reference guides, addins and other useful tools that can be used to efficiently build effective and robust financial models. Certificate of Completion Upon completion of this course, you will receive a Certificate of Completion, a recognition of your accomplishment, skills and knowledge learned from this course. Laptops required You will be required to bring along a laptop computer with Microsoft Excel (2007 or 2010) pre-installed for this course. If you do not have access to a laptop computer, please let us know when you register for the course and we can provide you a quotation for laptop rentals FINANCIAL MODELLING FROM ZERO TO A MASTER Recent Attendee • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • Coca-Cola Bottling Indonesia Coca-Cola Distribution Indonesia Novartis ExxonMobil PriceWaterhouseCoopers Cognis Indonesia Astra Honda Motor Kantor Kita Coca-Cola Indonesia Australian Development Scholarship PT HM Sampoerna Jakarta International Container Terminal MCX Asia BNI 46 PT Siemens Indonesia Jakarta Stock Exchange Goodyear Trocaire Medco Energi Abbott Elang Mahkota Exspan Aelindo Halin Marine Ramboll Telecom Hutchison Telco Danone Nusa Dua Graha Bank DKI Sari Husada Trakindo JICT GMF AeroAsia PNM Investment World Bank Kaltim Parna Industri (KPI) KPEI Premier Qualitas CIMB Niaga Indonesia Comnet Plus Persada Sukses Makmur Pertamina Hulu Energy Bank Kesawan Hotel Intercontinental Alfamart Ferrier Hodgson King Halim Pamitramas Mulia CMNP TNT Etc… All the resources you need to do your job better! Practical hands-on case studies Take home the best practice templates which you have used in the workshop. These can be built on to help you enhance your knowledge & skills Check us on Facebook: Financial Modeling Indonesia Our Website www.bayufinance.com Contact: Magdalena – 0815-86727350 / 0896-40528375 www.bayufinance.com Email to: [email protected] Financial Modeling from zero to a Master – 18-19 September 2014 – Four Seasons Hotel Course Registration Form Limited Seats This course is limited seats, to facilitate interaction between you and the trainer, so seek approval and register as soon as possible. Package Before 30 August 2014 Regular In house Private Registration Fee Rp. 5,500,000 Rp. 6,000,000 Contact Us Contact Us We’ll give you special discount for sending two or more delegates Delegate details 1 2 3 4 5 Name: Job Title: Phone: Email: Name: Job Title: Phone: Email: Name: Job Title: Phone: Email: Name: Job Title: Phone: Email: Name: Job Title: Phone: Email: Company details Company Name: Industry Address: Fax: Postcode: Tel: COMPLETE AND RE-EMAIL this form to [email protected] or [email protected] Contact: Magdalena – 0815-86727350 / 0896-40528375 www.bayufinance.com Email to: [email protected]