The course starts by focusing on the advance use of excel in Modeling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimization and forecasting into the models. With the help of the course director and a proven step-by-step approach, delegates will then construct models of different types, delegates will then construct models of different types. Delegate will leave this intensive two-days course the ability to effectively apply modeling techniques in Excel in a wide range of practical techniques in Excel in a wide range of practical scenarios.
You will need to put Financial Modeling into practice. This will be achieved by hands-on training and guidance from your trainers who will combine both real life and simulated exercise, using Excel and xcelsius as a base for your spreadsheet.
Workshop Outline
Day One
AM
- Financial Modeling Best Practices
- Setting the Stage
- Accounting for Modeling
- The Model Building Toolbox
- Building a Pilot Model
- Circular References and Iterative Calculations
- Variations on Balancing Plugs
PM
Day Two
AM
PM
Who Should Attend?
Course materials
You receive full course notes, plus a CD full of practical templates, exercises & solutions, reference guides, add-ins 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 pre-installed for this course (Ms. Excel 2007 & 2010 Recommended).
Workshop Leader
Purwadi “Peterson” Nitimidjojo, Is an outstanding financial modeler with commercial banking and leasing experience and with an extensive business network among major Indonesian banks and firms. Expert in designing proprietary analytical products that meet wide-ranging user needs; utilize the latest user-friendly technologies (@RISK, DecisionTools Suite, Crystal Ball, Xcelsius); and reinforce integrity of project analysis which significantly impacts the bottom line by developing robust and user-friendly Excel-based tools enabling firms to transact more business with greater clarity and fewer staff.
Graduated from Bandung Institute of technology since 1984 and have experience in the field of finance for domestic companies and overseas. Moreover become experts trainer in the field of financial modeling in seminars and training in Indonesia and Singapore.
Investment
Yes, enough to Rp. 5.500.000, - you will learn from the best and directly to the experts whoare experienced. For ticket reservations please Klik in Here -> Contact Us.
Investment:
First early bird before 13 January: Rp. 5,500,000,
Second early bird before 20 January: Rp.5,800,000,
Registration after 20 January: Rp.6,000,000,
Including:
Message Ticket:
Funds that you spend, comparable to what you would get even far greater than what youspend. For ticket reservations this workshop please contact us:
Fill in order form -> Yes, Order Now
If You Have Questions Please Contact Us, or Via Sms (CS: 085-711-611-924)
Payment
payment confirmation Via SMS 085-711-611-924 or via email to Sales@TiketTraining.com
- Preparing to Build a Full Model
- Building an Integrated Financial Model
- The Cash Flow Statement
- The Cash Sweep
- Financial Ratios
- Forecasting Guidelines
Day Two
AM
- Dynamic Chart & VBA-driven Number Formatting
- Sensitivity using Data Table
- Scenario Analysis using Scenario Manager
- VBA-driven Scenario Analysis
- Optimization using Solver and Evolver
PM
- Xcelsius – How It works
- Xcelsius Dashboard for Dynamic Report Presentation
- Xcelsius Dashboard for Dynamic Sensitivity Analysis
- Tips & Tricks
- Questions & Answers
Who Should Attend?
- Manager of Strategic & Corporate Pallning
- Financial Controller
- Financial & Business Analyst
- Corporate Finance Personnel
- Treasury Personnel
- Risk Managers
- Account Officers
- Credit Reviewer
- Finance & Accounting Staffs
- Corporate Planning Staffs
Course materials
You receive full course notes, plus a CD full of practical templates, exercises & solutions, reference guides, add-ins 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 pre-installed for this course (Ms. Excel 2007 & 2010 Recommended).
Workshop Leader
Purwadi “Peterson” Nitimidjojo, Is an outstanding financial modeler with commercial banking and leasing experience and with an extensive business network among major Indonesian banks and firms. Expert in designing proprietary analytical products that meet wide-ranging user needs; utilize the latest user-friendly technologies (@RISK, DecisionTools Suite, Crystal Ball, Xcelsius); and reinforce integrity of project analysis which significantly impacts the bottom line by developing robust and user-friendly Excel-based tools enabling firms to transact more business with greater clarity and fewer staff.
Graduated from Bandung Institute of technology since 1984 and have experience in the field of finance for domestic companies and overseas. Moreover become experts trainer in the field of financial modeling in seminars and training in Indonesia and Singapore.
Investment
Yes, enough to Rp. 5.500.000, - you will learn from the best and directly to the experts whoare experienced. For ticket reservations please Klik in Here -> Contact Us.
Investment:
First early bird before 13 January: Rp. 5,500,000,
Second early bird before 20 January: Rp.5,800,000,
Registration after 20 January: Rp.6,000,000,
Including:
- Module training,
- Flash Disc,
- Certificate,
- Lunch,
- Coffee Break
Message Ticket:
Funds that you spend, comparable to what you would get even far greater than what youspend. For ticket reservations this workshop please contact us:
Fill in order form -> Yes, Order Now
If You Have Questions Please Contact Us, or Via Sms (CS: 085-711-611-924)
Payment
payment confirmation Via SMS 085-711-611-924 or via email to Sales@TiketTraining.com
