Spreadsheet Modeling in Corporate Finance (CEF Approved)
CEF Course Code: 23C02275-1
CEF Institution Code: 548
Hands-on computer skills training for finance and business professionals!
 |
Course Description |  |
|
Application Procedure | |
|
Schedules/Enrol |
 |
 |
CEF Courses Home |
Spreadsheet is the most widely used tools in performing financial analysis and yet many finance professionals are not trained in using spreadsheets effectively and hence not being able to perform sensitivity analysis, feasibility studies and other common financial analysis.
The course provides students with relevant skills and techniques in performing financial analysis and is a practical hands-on program to complement theories learned at Universities and Business Schools .
Note that this course does NOT teach Excel VBA programming, but how to build spreadsheet models using Microsoft Excel features and functions.Course Duration
30 Hours
Course Prerequisites
Applicants should be computer-literate with a sound working knowledge of the Windows operating systems and Microsoft Excel 97, 2000, XP or 2003.
Course Content
The 30-hour course consists of the following 5 modules. Microsoft Excel 2003 will be used during hands-on practice.
- Using Formulas and Analytical tools
- Using Formula and Functions
- Using Pivot Table for data analysis
- Time Value of Money
- Present Value
- Future Value
- Annuity
- Asset Valuation
- Bond Valuation
- Stock Valuation
- Yield Curve
- Capital Budgeting
- Project NPV
- Cost-Reducing Project
- Break-even Analysis
- Three Valuation Methods
- Financial Planning
- Corporate Financial Planning
- Du Pont System of Ration Analysis
- Life-Cycle Financial Planning
Title of Award and Assessment Methods
Each module includes practicing exercises. Two projects will be assessed according to correct analysis and presentation using spreadsheets. Upon successful completion of the course, students will receive a Certificate of Achievement on Spreadsheet Modeling in Corporate Finance.
Course Fee
$5,100 ($1,020 after 80% subsidy from CEF upon successful completion of the course)
Schedules/Enrol
|
- Proceed with on-line
registration or send the completed enrolment form (download)
to Welkin Computer Training, 3/F, Righteous Centre, 585 Nathan Road,
Mongkok, Kowloon together with a cheque (made payable to Welkin Compuer
Training) for the program fee.
- Complete in the CEF Application Form (download)
and send it to Office of the Continuing Education Fund,
Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung,
New Territories, together with a photocopy of your HKID Card before course commencement.
- Applicants will receive application results from the Office of the CEF within 14 working days.