Login Success 
Accounting & Finance Accounting
Certificate for Module (Business Modeling with Excel in Financial Analysis)
證書(單元 : EXCEL財務分析與商業模式)
CEF Reimbursable Course
- Course Code
- AC145A
- Application Code
- 2235-AC145A
- QF Level
-
Financial assistance
Close QF Level panel
Continuing Education Fund
This course has been included in the list of reimbursable courses under the Continuing Education Fund.
- Credit
- 9
- Study mode
- Part-time
- Start Date
- To be advised
- Duration
- 3 months
- Language
- English
- Course Fee
- HK$6,000
- Enquiries
-
2867 84872861 0278
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.
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.
Programme Overview
Highlights
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
- Introduction to Business Modeling; excel spreadsheet is used to build:
• Cash Account Model
• Income Tax Model
• Rates Matrix Model
-
Using excel for analysis and Interpretation of Financial Statements
• Ratio Analysis
• Performance Indicators
• Performance Evaluation Model
• Pro Forma Statements Model
-
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
-
Concept of Time Value of Money
• Time value of Money Model
• Loan Amortization Model
• Retirement Account Model
-
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
-
Analysis of Capital Investments using excel
• Capital Budgeting Model
• Capital Structure Model
• Sensitivity Analysis
• Real and Financial Investments
-
Rationalisation of Portfolio Investment
• Return and Risk
• Factor Model Assumptions and Implications
• Allocation of Assets
• Risky Asset Portfolio Model
• Portfolio Optimization Model
-
Decision of Fixed Income Securities
• Different Kinds of Fixed Income Securities
• Characteristics of Different Securities and its Associated Benefits and Limitations
-
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
-
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 | ||
Modules & Class Details
Class Details
Certificate for Module (Business Modeling with Excel in Financial Analysis)Application Code 報名代碼：2235-AC145A |
|||||
|---|---|---|---|---|---|
|
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 & Entry Requirements
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 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)
|
Apply
Online Application Apply Now
Application Form Download Application Form
Enrolment MethodOnline Enrolment
HKU SPACE provides 24-hour online application and payment service for students to apply to selected award-bearing programmes and to enrol in most open admission courses (courses enrolled on a first come, first served basis) via the Internet. Applicants may settle the payment by using either "PPS by Internet" (not available via mobile phones), VISA or Mastercard online. Online WeChat Pay, Online AliPay and Faster Payment System (FPS) are also available for continuing enrolment in the same programme, if online service is offered.
For first time enrolment
-
Complete the online application form
Applicant may click the icon
on the top right-hand corner of the programme/course webpage to make online application, and then follow the instructions to fill in the online application form.
Some programmes/courses may admit by selection, and may require applicants to provide electronic copy of any required documents (e.g. proof of qualification) as indicated on the programme/course webpage. Only file format in doc, docx, jpg and pdf are supported. -
Make Online Payment
Pay the application or programme/course fees by either using:
"PPS by Internet" - You will need a PPS account and a PPS Internet password. For information on how to open a PPS account and how to set up a PPS Internet password, please visit http://www.ppshk.com.
*Credit Card Online Payment - Course fees can be paid by VISA or Mastercard including the “HKU SPACE Mastercard”.
* HKU SPACE Mastercard cardholders who wish to enjoy 10-month interest free instalment scheme must pay their tuition fees in person at any of our HKU SPACE Enrolment Centres.
To know more about first-time online application/enrolment and payment, please refer to the user guide of Online Application / Enrolment and Payment:
For continuing enrolment in the same programme
Selected programmes offer online continuing enrolment service. Programme staff will inform students if they offer this service and offer further enrolment details.
Online Payment can be made via "PPS by Internet" (not available via mobile phones), VISA or Mastercard, Online WeChat Pay, Online AliPay and Faster Payment System (FPS)
In Person / Mail
For first time enrolment
-
For first come, first served short courses, complete the Application for Enrolment Form SF26 and bring or post the completed form(s), together with the appropriate application/course fee(s) and any required supporting documents to any of the HKU SPACE enrolment centres.
[Download Enrolment Form SF26] -
Award-bearing and professional courses may require other information. Forms are usually available at the enrolment centres or on request from programme staff. Bring or post the completed form(s), together with the appropriate application/course fee(s) and any required supporting documents to any of the HKU SPACE enrolment centres.
For continuing enrolment in the same programme
-
The standard ‘Enrolment/Payment Slip’ is designed for students of award-bearing programmes or remaining programmes in a suite of programmes requiring continuing enrolment and it applies to most programmes.
-
Students should complete the “Enrolment/Payment Slip” which will be made available by relevant programme staff and return the slip to any HKU SPACE enrolment centre or post it to the relevant programme staff with appropriate fee payment.
Please refer to available Payment Methods for fee payment information. If you are in doubt about the procedures, please check the individual course details, or contact our programme staff or enrolment centres.
Please note the followings for programme/course enrollment:
- To make an application online, you will need a computer with connection to the Internet and a web browser with JavaScript enabled. Google Chrome is recommended.
- Applicants should not leave the online application idle for more than 10 minutes. Otherwise, applicants must restart the application process.
- Only Early Bird Discount is supported for Online Applicants (Application). To enjoy other types of discount, please visit one of our enrolment centres.
- During the online application process, asynchronous application and payment submission may occur. Successful payment may not guarantee successful application. In case of unsuccessful submission, our programme staff will contact you shortly.
- Applicants are reminded that they should only apply for the same programme/course once through counter or online application.
- For online enrolment, a payment confirmation page would be displayed after payment has been made successfully. In addition, a confirmation email would also be sent to your email account. You are advised to keep your payment confirmation for future enquiries.
- Fees paid are not refundable except as statutorily provided or under very exceptional circumstances (e.g. course cancellation due to insufficient enrolment).
- If admission is by selection, the official receipt is not a guarantee that your application has been accepted. We will inform you of the result as soon as possible after the closing date for application. Unsuccessful applicants will be given a refund of programme/course fee if already paid.
Disclaimer
The School provides a platform for online services for a selected range of products it offers. While every effort is made to ensure timeliness and accuracy of information contained in this website, such information and materials are provided "as is" without express or implied warranty of any kind. In particular, no warranty or assurance regarding non-infringement, security, accuracy, fitness for a purpose or freedom from computer viruses is given in connection with such information and materials.
The School (and its respective employees and subsidiaries) is not liable for any loss or damage in connection with any online payments made by you by reason of (i) any failure, delay, interruption, suspension or restriction of the transmission of any information or message from any payment gateways of the relevant banks and/or third party merchants for processing credit/debit/smart card or other payment facilitation mechanism; (ii) any negligence, mistake, error in or omission from any information or message transmitted from the said payment gateways; (iii) any breakdown, malfunction or failure of those gateways in effecting online payment service or (iv) anything arisen out of or in connection with the said payment gateways, including but not limited to unauthorised access to or alternation of the transmission of data or any unlawful act not permitted by the law.
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
