《The application of Excel in Financial Management》Syllabus

Course Number:           2110020717

Course Name:           The application of Excel in financial management

Instructors:                    BingWang

Required Text:            ZhiliangHan. 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.

Credit hour/Teaching hours

This course covers an overview of the basic areas of business:     (2/32)

I.EXCEL Basics                                     2 Teaching hours

（一）EXCEL Overview

（二）Administrative workbook

（三）Enter and edit data

（四）Administrative worksheet

（五）Print management

II.Calculation of time value of funds                     2 Teaching hours

（一）Calculation of the final value

（二）Calculation of present value

（三）The final and present value of the annuity

（四）Interest period and final value and present value

III.Internal long-term investment decisions                 2 Teaching hours

（一）Calculation of depreciation and cash flow

（二）A fundamental approach to long-term investment decisions

（三）Application of basic investment decision-making methods

IV.Securities investment analysis and decision              2 Teaching hours

（一）Bond investment analysis

（二）Stock investment analysis

（三）Securities portfolio optimization decision

V.Cost of capital and capital structure                     2 Teaching hours

（一）Capital costing

（二）Leverage analysis

VI.Financing forecast and decision analysis                 2 Teaching hours

（一）Long-term financing decision

（二）Capital requirement forecast

VII.Current assets management                           2 Teaching hours

（一）Cash management

（二）Accounts receivable management

（三）Inventory control

VIII.Financial statement analysis and forecasting             2 Teaching hours

（一）Financial statement analysis

（二）Financial data atlas analysis

VIIII.Practical training in class                           16 Teaching hours

             Total (Teaching hours)                        32  Teaching hours

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

[There is no text below]