Pelatihan ini dirancang untuk memberikan pengetahuan praktis tentang desain system
keuangan perusahaan yang meliputi perencanaan keuangan, model penaksiran
keuangan serta pengendalian keuangan perusahaan. Pemahaman yang baik tentang
keuangan dapat memberikan keterampilan praktis tentang bagaimana cara mendesain
system keuangan yang efektif dan efisien.
OBJECTIVE
- Understand the concept in investment evaluation techniques
- Understand how to evaluate investments
- Knowing the techniques by making modeling capital budget
COURSE OUTLINE
- 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)
