Training Financial Modelling for Capital Investment Planning
Venue:
Hotel Intercontinental Mid Plaza Jakarta
Jl. Jendral Sudirman Kav. 10-11, Jakarta 10220
Objective:
- Understand the concept in investment evaluation techniques
- Understand how to evaluate investments
- Knowing the techniques by making modeling capital budget
Syllabus:
- Making Investment Decision
- The Investment Problem and Capital Budgeting
- Cash Flow Estimation
- Investment Evaluation Techniques
- Payback period
- Net Present Value (NPV)
- Internal Rate of Return (IRR)
- Profitability Index (PI)
- Comparing Evaluation Techniques
- Incorporating Risk in the Capital Budgeting Decision
- Ranking
- Capital Rationing
- Mutually Exclusive Investments
- Analyzing the Lease versus Borrow to Buy
- Case Studies
- Modelling Capital Budget using Ms. Excel
- Capital Budgeting model layout design
- Combo box for avoiding error in inputting assumptions
- Utilizing combo box’s ‘cell link’ by another formulas
- DATE function
- OFFSET function
- Combining numbers and text
- NPV Function
- XNPV Function
- Conditional Formatting for results identification
- Data Table tool for project sensitivity analysis
- Dynamic chart
- Management summary
- Using Capital Budgeting Model
- Project appraisal Model
- Capital rationing model (selecting some projects within the limited budget)
Who should attend?
Finance & Accounting Staff and Manager, Strategic & Corporate Planner, Financial Controller, Financial & Business Analysts, Risk Manager, Credit Analyst & Reviewer, Investment Analysis, Equity Analyst, Investment Banker, Corporate Finance Officer, Corporate Planner, Project Analyst, Treasury Manager,General Manager, Corporate & Government Officer, Business Owner, Business Advisor or anyone who has strong passion for Financial Modeling.
Trainer:
Mariawati Lim
Maria has over 16 year’s experiences in the field of financial advisory services in one of the big four. As a financial model trainer, Maria has been providing training, both public and in- house to more than 1,500 professionals from various companies.
Noted:
- Please bring your own laptop with Microsoft Excel 2007 or 2010 installed
- This training is paperless so you will receive full course notes in a USB full of practical templates, exercises & solutions, reference guides, add-ins and other useful tools.
- Training will be delivered in Bahasa Indonesia
- You will receive a Certificate of Completion, a recognition of your accomplishment, skills & knowledge learned after completion of this course
- It is assumed that participants know how to navigate confidently in Excel, create and use simple formulas.