Microsoft Excel is the global standard spreadsheet tool with an extremely wide range of applications. Unfortunately, the numerous Microsoft Excel books and online Microsoft Excel lessons do not and cannot address the unique Excel and financial modelling needs of individuals or organizations.
This 2-day workshop aims to upgrade the skills of managers on business valuation, discounted cash flow, scenario planning for decision making, capital budgeting and cost of capital, financial analysis and project finance by using Excel applications.
Participants will learn how to plan and build a project finance cash flow model where each modelling topic will focus on detailed practical methods. Topics covered include customized period counters for project finance, key project finance metrics, impact of asset assumptions and modelling in a project finance environment, debt modelling, taxation calculations, valuations and analysis for typical project finance return metrics.
This course will be delivered with two trainers and a local facilitator to accommodate a range of participant skills, assist attendees with practical examples, and provide local context.
Training will include morning, afternoon and lunch breaks.
DAY I - Excel and Project Finance
Introduction to Excel
Navigation, Excel functions and formulas
Advanced Excel tools for financial modelling
Introduction to Project Finance
Introduction to Financial Modelling
Financial Statements and Key Metrics
DAY 2 - Financial Modelling
Assets, construction phasing and book versus tax depreciation
Operational modelling, production, revenue, variable and operating costs
Debt modelling and sculpting
Taxation, including Deferred Tax Assets & Liabilities
Sensitivities and Scenario Handler
Valuations and analysis, Project IRR/NPV, Equity IRR/NPV
The seminar is limited to 15 participants. Act now, don't miss the deadline.
More info regarding the seminar please contact Financial Club Jakarta :
Ms Lita Hidayati at 087774520669 or email to firstname.lastname@example.org.