Investment Appraisal & Capital Budgeting with Excel

17 April 2026, Fri | 9.00 am – 5.00 pm | Crystal Crown Hotel, Petaling Jaya

[HRD Corp Claimable Course]

Introduction

This practical 1-day workshop equips participants with the skills to evaluate business investment proposals using Excel. The programme focuses on real-world decision making, starting from profit and loss projections and translating them into project cash flows for proper investment appraisal.

The course avoids unnecessary accounting theory and instead emphasises application and hands-on Excel modelling, ensuring participants leave with a ready-to-use capital budgeting template applicable to real workplace scenarios.

Learning Outcome

By the end of this programme, participants will:

• Master capital budgeting and investment appraisal principles.
• Analyse cost behaviour and project viability via breakeven analysis.
• Build P&L-based project cash flows and risk models in Excel.
• Apply NPV, IRR, Payback, and PI techniques to evaluate projects.
• Utilize cost of capital and risk analysis to make data-driven recommendations.

Who Should Attend

Business Owners, Entrepreneurs, , Project Managers, Managers & Executives who involve in evaluating, approving or supporting capital investment decisions.

Methodology

Interactive lectures, discussion, case study & exercises

Course Outline

1) Foundations of Capital Budgeting & Cost Behaviour

• Capital budgeting and investment decision framework
• Break-even analysis as a planning and risk assessment tool

2) From P&L to Project Cash Flows

• Revenue and cost assumptions
• Incremental cash flow principle
• Initial investment (CAPEX and working capital)

3) Discount Rate & Investment Appraisal Techniques Using Excel

• Meaning and importance of Discount Rate/Cost of Capital
• Cost of debt and cost of equity (basic overview)

4) Risk Evaluation

• • Assessing Uncertainty in Investment Decisions

Trainer’s Profile

GERALD PERIES  received his Master of Business Administration and Bachelor of Science Degree in Finance from Southern Illinois University, U.S.A. Gerald has over 20 years’ experience in training and lecturing for various business organisations and private colleges &  universities. His areas of expertise are in Finance and Accounting. Gerald combines a wide range of practical and hands-on training experience in a challenging and interactive environment.

Participation Fee

REGISTER HERE

RM1,188.00 per person  – Fee inclusive of Tea-breaks, Lunch, Course Notes,
Certificate of Participation and 8% SST

HRD Corp Claimable Course – refer to the training brochure for claim details.