TRAINING FINANCIAL MODELLING FOR CAPITAL INVESTMENT PLANNING

Table of Contents Toggle TRAINING APLIKASI FINANCIAL MODELING

TRAINING MANAJEMEN AKUNTANSI KEUANGAN training Perencanaan Modal & Investasi di jakarta

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.