Main content start
Change.每天多學一點 改變.可大可小

Accounting & Finance Accounting

Certificate for Module (Business Modeling with Excel in Financial Analysis)
證書(單元 : EXCEL財務分析與商業模式)

CEF Reimbursable Course

CEF Reimbursable Course

Course Code
AC145A
Application Code
2235-AC145A

Credit
9
Study mode
Part-time
Start Date
To be advised
Duration
3 months
Language
English
Course Fee
HK$6,000
Deadline on 03 Jul 2024 (Wed)
Enquiries
2867 8487
2861 0278
Apply Now

APPLICATION OPEN - July 2024 Intake - Please enroll ASAP!!! Online enrolment is welcome
七月份課程,現正接受報名,欲報從速,歡迎網上報名

Please pay attention to the deadline
請留意截止報名日期

請注意:課程學額有限,額滿即止,請盡早報名,不設留位服務
Please note: it is advisable to enrol well in advance as places are limited. There is no reservation service.

Special Announcement:

After completing the Certificate for Module (Business Modeling with Excel in Accounting), it is time to advance further upward and learn more tools to help decision making and financial analysis in your workplace.   The course "Business Modeling with Excel in Financial Analysis" is specially designed for you to articulate.  It will equip you with advanced financial analysis skill for building up models to solve problems.

Highlights

The programme aims to equip students with knowledge and skills to use Excel as a tool to build, analyse and interpret business models in accounting and finance, thereby enabling them to make appropriate strategic planning and business decisions.

Programme Details

On completion of the programme, students should be able to use excel to


1. develop business models for planning and decision making;
2. analyse and interpret elements of financial statements and performing sensitivity analysis;
3. prepare an optimal investment portfolio; and
4. mitigate contingent liability and financial risks.
 
Syllabus
  1. Introduction to Business Modeling; excel spreadsheet is used to build:

    • Cash Account Model

    • Income Tax Model

    • Rates Matrix Model

  2. Using excel for analysis and Interpretation of Financial Statements 

    • Ratio Analysis

    • Performance Indicators

    • Performance Evaluation Model

    • Pro Forma Statements Model

  3. Analysis of Business Value using excel formulae

    • Three Business Valuation Approaches such as:

    - Accounting-based

    - Economic-based

    - Quantitative-based

    • Relative Valuation Model

    • Intrinsic Valuation Model

  4. Concept of Time Value of Money  

    • Time value of Money Model

    • Loan Amortization Model

    • Retirement Account Model

  5. Calculating Value of Investments using Discount Rates by excel 

    • Dividend Discount Model

    • Capital Asset Pricing Model

    • Three Types of Discount Rates

        - Firm-based

        - Market-based

        - Weighted Cost of Capital

  6. Analysis of Capital Investments using excel

    • Capital Budgeting Model

    • Capital Structure Model

    • Sensitivity Analysis

    • Real and Financial Investments

  7. Rationalisation of Portfolio Investment 

    • Return and Risk

    • Factor Model Assumptions and Implications

    • Allocation of Assets

    • Risky Asset Portfolio Model

    • Portfolio Optimization Model

  8. Decision of Fixed Income Securities 

    • Different Kinds of Fixed Income Securities

    • Characteristics of Different Securities and its Associated Benefits and Limitations

  9. Options and Contingent Liability 

    • Options Contracts and Insured Assets

    • Contingent Claim Valuation

    • Replication Option Pricing Model

    • Delta-ratio Option Pricing Model

    • Risk-neutral Option Pricing Model

  10. Analysis of Financial Risks using excel

    • Measurement of Risk Exposure

    • Asset Price and Return

    • Returns Simulation Model

    • Value-at-Risk Model

    • Credit Risk Model

Assessment

4 Individual Practical Tasks consist of computations or small case studies; using excel for business and financial model building, financial and ratio analysis.  Questions can cover any areas of the syllabus.

Attendance Requirement

At least 70%

Award

Upon successful completion of the programme and achieve at least 70% of attendance, students will be awarded within the HKU system through HKU SPACE a  "Certificate for Module (Business Modeling with Excel in Financial Analysis)".

Application Code 2235-AC145A Apply Online Now
Apply Online Now

Class Details

Certificate for Module (Business Modeling with Excel in Financial Analysis)

Application Code 報名代碼:2235-AC145A

Venue:

To be confirmed (Hong Kong Island)

Meeting Date Day Time
1 21-Jul-2024 Sunday 13:00 - 16:30
2 28-Jul-2024 Sunday 13:00 - 16:30
3 4-Aug-2024 Sunday 13:00 - 16:30
4 11-Aug-2024 Sunday 13:00 - 16:30
5 18-Aug-2024 Sunday 13:00 - 16:30
6 25-Aug-2024 Sunday 13:00 - 16:30
7 1-Sep-2024 Sunday 13:00 - 16:30
8 8-Sep-2024 Sunday 13:00 - 16:30
9 15-Sep-2024 Sunday 13:00 - 15:00

A detailed timetable will be emailed to students one week before the class commences. 

Map and address: https://hkuspace.hku.hk/learning-centre

  • The course will be opened subject to sufficient enrolment.
  • While we will try to minimise any timetable changes, please note that issues of lecturer and room availability may sometimes make these unavoidable.
  • If you are applying to / have enrolled for more than one programme/course with HKU SPACE, please check to ensure that there are no scheduling conflicts before submitting your application.
  • HKU SPACE reserves all rights to make revisions or alternations to the course venue, schedule, content, tutor or other details if necessary.
  • 香港大學專業進修學院保留一切權利按需要更改課程的上課地點、時間、內容、導師或其他細節。

Fee

Course Fee
  • Course Fee : HK$6,000

Entry Requirements

Applicants shall hold an Associate Degree or a Higher Diploma by a recognised institution or equivalent.


Applicants with other qualifications will be considered on individual merit.

CEF

  • The CEF Institution Code of HKU SPACE is 100
CEF Courses
Certificate for Module (Business Modeling with Excel in Accounting)
證書(單元:EXCEL會計與商業模式)
COURSE CODE 33C126591 FEES $4,800 ENQUIRY 2867-8487
Continuing Education Fund Continuing Education Fund
This course has been included in the list of reimbursable courses under the Continuing Education Fund.

Certificate for Module (Business Modeling with Excel in Financial Analysis)

  • This course is recognised under the Qualifications Framework (QF Level [5])

Apply

Online Application Apply Now

Application Form Download Application Form

Enrolment Method
Payment Method
1. Cash, EPS, WeChat Pay Or Alipay

Course fees can be paid by cash, EPS, WeChat Pay or Alipay at any HKU SPACE Enrolment Centres.

2. Cheque Or Bank draft

Course fees can also be paid by crossed cheque or bank draft made payable to “HKU SPACE”. Please specify the programme title(s) for application and applicant’s name. You may either:

  • bring the completed form(s), together with the appropriate course or application fees in the form of a cheque, and any required supporting documents to any of the HKU SPACE enrolment centres;
  • or mail the above documents to any of the HKU SPACE Enrolment Centres, specifying “Course Application” on the envelope. HKU SPACE will not be responsible for any loss of personal information and payment sent by mail.
3. VISA/Mastercard

Applicants may also pay the course fee by VISA or Mastercard, including the “HKU SPACE Mastercard”, at any HKU SPACE enrolment centres. Holders of the HKU SPACE Mastercard can enjoy a 10-month interest-free instalment period for courses with a tuition fee worth a minimum of HK$2,000; however, the course applicant must also be the cardholder himself/herself. For enquiries, please contact our staff at any enrolment centres.

4. Online Payment

Online application / enrolment is offered for most open admission courses (enrolled on first come, first served basis) and selected award-bearing programmes. Application fees and course fees of these programmes/courses can be settled by using "PPS by Internet" (not available via mobile phones), VISA or Mastercard. In addition to the aforesaid online payment channels, new and continuing students of award-bearing programmes with available online service, they may also pay their course fees by Online WeChat Pay, Online Alipay or Faster Payment System (FPS). Please refer to Enrolment Methods - Online Enrolment  for details.

Notes

  • If the programme/course is starting within five working days, application by post is not recommended to avoid any delays. Applicants are advised to enrol in person at HKU SPACE Enrolment Centres and avoid making cheque payment under this circumstance.

  • Fees paid are not refundable except under very exceptional circumstances (e.g. course cancellation due to insufficient enrolment), subject to the School’s discretion. In exceptional cases where a refund is approved, fees paid by cash, EPS, WeChat Pay, Alipay, cheque, FPS or PPS by Internet will be reimbursed by a cheque, and fees paid by credit card will be reimbursed to the credit card account used for payment. 

  • In addition to the published fees, there may be additional costs associated with individual programmes. Please refer to the relevant course brochures or direct any enquiries to the relevant programme team for details.
  • Fees and places on courses cannot be transferrable from one applicant to another. Once accepted onto a course, the student may not change to another course without approval from HKU SPACE. A processing fee of HK$120 will be levied on each approved transfer.
  • HKU SPACE will not be responsible for any loss of payment, receipt, or personal information sent by mail.
  • For payment certification, please submit a completed form, a sufficiently stamped and self-addressed envelope, and a crossed cheque for HK$30 per copy made payable to “HKU SPACE” to any of our enrolment centres.
More Programmes of
Accounting