Perlu pelatihan untuk anda atau perusahaan anda?

Cari Disini. Atau hubungi kami melalui SMS/CALL/WA: 0819.9793.1188

Training Financial Modelling for Capital Investment Planning

Schedule
21 – 22 July 2016

Venue:
Hotel Intercontinental Mid Plaza Jakarta
Jl. Jendral Sudirman Kav. 10-11, Jakarta 10220

Objective:

  1. Understand the concept in investment evaluation techniques
  2. Understand how to evaluate investments
  3. Knowing the techniques by making modeling capital budget

Syllabus:

  1. Making Investment Decision
    • The Investment Problem and Capital Budgeting
    • Cash Flow Estimation
  2. Investment Evaluation Techniques
    • Payback period
    • Net Present Value (NPV)
    • Internal Rate of Return (IRR)
    • Profitability Index (PI)
    • Comparing Evaluation Techniques
  3. Incorporating Risk in the Capital Budgeting Decision
  4. Ranking
    • Capital Rationing
    • Mutually Exclusive Investments
  5. Analyzing the Lease versus Borrow to Buy
  6. Case Studies
  7. 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
  8. 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

Registration Fee:
Regular IDR 6,500,000

Get discount 10% for register 2 person