Informasi Seminar dan Training (Pelatihan) di Indonesia DIREKTORI TRAINING INDONESIA

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

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


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


  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.

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.


  • 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.