《The application of Excel in Financial Management》Syllabus

Course Number:           2110020717

Course Name:           The application of Excel in financial management

Instructors:                    Wang Bing

Required Text:              Han Zhiliang. The application of Excel in financial management[M].Beijing: Tsinghua University Press，2020

Course Description:      This course is an elective course for financial management majors. Through the study of this course Students can fully master the basic skills of EXCEL spreadsheet operation, master the basic application of EXCEL spreadsheet in financial management, to develop students' analytical ability of using EXCEL spreadsheet in financial management application ability cultivate good professional ethics and professionalism; improve students' ability to analyze and solve practical financial management problems. Through learning this course, students can use EXCEL tools to enable financial managers to make judgments quickly and accurately in the complex and changeable financial environment，Make reasonable decisions.

Credits/Teaching hours

Outline of UG CPC Topics Covered in this Course:     (2 credits/32 Teaching Hours)

I. EXCEL Basics                                         2 Teaching hours

Section 1 EXCEL overview

Section 2 Administrative workbook

Section 3 Enter and edit data

Section 4 Administrative worksheet

Section 5 Print management

II. Calculation of time value of funds                         2 Teaching hours

Section 1 Calculation of the final value

Section 2 Calculation of present value

Section 3 The final and present value of the annuity

Section 4 Interest period and final value and present value

III. Internal long-term investment decisions                    2 Teaching hours

Section 1 Calculation of depreciation and cash flow

Section 2 A fundamental approach to long-term investment decisions

Section 3 Application of basic investment decision-making methods

IV. Securities investment analysis and decision                 2 Teaching hours

Section 1 Bond investment analysis

Section 2 Stock investment analysis

Section 3 Securities portfolio optimization decision

V. Cost of capital and capital structure                        2 Teaching hours

Section 1Capital costing

Section 2 Leverage analysis

VI. Financing forecast and decision analysis                   2 Teaching hours

Section 1Long-term financing decision

Section 2 Capital requirement forecast

VII. Current assets management                             2 Teaching hours

Section 1Cash management

Section 2 Accounts receivable management

Section 3Inventory control

VIII. Financial statement analysis and forecasting               2 Teaching hours

Section 1Financial statement analysis

Section 2 Financial data atlas analysis

VIIII. Practical training in class                             16 Teaching hours

               Total (Teaching hours)                                 32 

Summary of UG CPC Topics Covered in this Course:                   (32Teaching hours)