Course Information
Price
HKD 33,450
CEF Reimbursable
CEF Reimbursable
Study Mode
Location
-
Course Overview
Assessment Methods / 評核方式
(A) Assessment Items and Their Weightings: (1) Coursework* (100%) [*Coursework: assignments and laboratory work] (B) Completion Requirements: (1) Overall passing mark: 40% (C) CEF Reimbursement Requirements: (1) Attendance: 70% (2) Overall passing mark: 50%
Entry Requirement / 入學要求
Bachelor's Degree holders
Instructor's Qualifications / 導師資歷
Master degree/PhD in relevant disciplines (e.g. Accounting, Finance)
QR Number / 資歷名冊登記號碼
15/002938/L6
QF Level / 資歷架構級別
6
CEF Registration Invalid From / 基金課程登記失效日期
01-APR-27
(A) Assessment Items and Their Weightings: (1) Coursework* (100%) [*Coursework: assignments and laboratory work] (B) Completion Requirements: (1) Overall passing mark: 40% (C) CEF Reimbursement Requirements: (1) Attendance: 70% (2) Overall passing mark: 50%
Entry Requirement / 入學要求
Bachelor's Degree holders
Instructor's Qualifications / 導師資歷
Master degree/PhD in relevant disciplines (e.g. Accounting, Finance)
QR Number / 資歷名冊登記號碼
15/002938/L6
QF Level / 資歷架構級別
6
CEF Registration Invalid From / 基金課程登記失效日期
01-APR-27
What You’ll Learn
(1) Introduction to numerical computations in spreadsheets (7 hours) (2) Introduction To statistical computations In spreadsheets (7 hours) (3) Calculating risk and return of portfolio on a spreadsheet (7 hours) (4) Implementing CAPM model on a spreadsheet (6 hours) (5) Implementing binomial tree for option pricing using VBA (6 hours) (6) Implementing Monte Carlo simulation using VBA (6 hours)
