《EXCEL財務(wù)建?！氛n程教學(xué)大綱英文版

1、Syllabus of Excel Model in FinanceCourse Name ： Excel Model in Finance Course Code ：Credits ： 2.0Total Credit Hours : 32Lecture Hours ： 16Experiment Hours ： 16Programming Hours ：Practice Hours ：Total Number of Experimental (Programming) Projects 8 ,Where, Compulsory ( 8 ), Optional ().School : Busin

2、ess SchoolTarget Major ： AccountingI、Course Nature & AimsThis course is an elective course for accounting major. Through the study of this course, students can basically master the analysis and evaluation skills of enterprise financial management activities, and in this process, they can make target

3、ed financial planning and suggestions based on the characteristics of enterprises.In recent years, the financial management of enterprises has shown the characteristics of complicated operation content and diversified conteni display. Through the study of students in this course, students practical

4、ability of financial management can be greatly improved, which can be summarized as follows:Course objective 1. Master the application of basic financial functions and be proficient in using these functions (o analyze basic financial problems; Course objective 2. Through the collection and analysis

5、of a large number of data, can use the way of charts to display. In the face of specific problems, especially special problems, can use programming methods, such as the use of macro, to simplify complex problems; Course objective 4. In tenns of statistical analysis, not only can we download data by

6、using network tools, but also can we make descriptive statistics, correlation coefficient analysis and regression analysis on financial data by combining statistical software.II、Course Objectives1. Moral Education and Character Cultivation.Based on accounting and management theory, financial managem

7、ent focuses on how to engage in the business of investment, financing and profit distribution.in terms of talent cultivation, we should adhere to the effective combination of teaching and education, actively promote the coordinated construction of morality and talent, so that teachers can infiltrate

8、 professional ethics education in preaching and solving puzzles, and train financial personnel with both morality and talent.In addition to mastering the professional knowledge and skills of financial management, we should implement the contents of laws and regulations into every class, educate stud

9、ents to act in accordance with laws and regulations and strictly regulate accounting professional behavior; educate students to recognize the preciseness and objective authenticity of tinancial work, and cultivate students to be conscientious, responsible and meticulous in their work attitude.2.Cour

10、se ObjectivesThrough the study of this course, students have the quality, skills, knowledge and ability:Course objective 1. Master the application of basic financial functions, and be proficient in using these functions to analyze basic financial problems; (corresponding to lesson 1 and 2, support (

11、he graduation requirements index point 3-2)Course objective 2. Through the processing and analysis of financial data, make a conect judgment for the evaluation of investment projects; (corresponding to lecture 3 and 4, support the graduation requircmenis index point 4-3)Course objective 3. in the fa

12、ce of specific problems, especially special problems, be able to use programming means, such as the use of macros, to simplify complex problems; (corresponding to lecture 5 and 6, support graduation requirements index point 5-3)Course objeclive 4. In terms of stalislical analysis, not only can we do

13、wnload data using network lools, bul also can use statistical software to carry out descriptive statistics, correlation coefficient analysis and regression analysis on financial data, (corresponding to Lecture 7 and 8. support graduation requirement index point 7-2)3. Supporting for Graduation Requi

14、rementsCourseObjectivesGraduationRequirementsIndices and Contents Supporting for GraduationRequirementsTeachingTopicsLevel ofSupportIndicesContents13: Ability toanalyze problems3-2.Be able to correctly analyze (he problems in investment, financing and distribution activities.Lesson 1and 2H24： Decisi

15、on makingability4-3.According to the knowledge of financial management, use various decision-making indicators to make a correct judgment of the plan.Lesson 3and 4H35: Professionalcompetence5-3.Master the basic operalion law of the companys finance, and be able (o correctly calculate various financi

16、al indicators.Lesson 5and 6II47: Tool applicationcapability7-2.Master the data and modeling tools of accounting major, and design and apply them in combination with specific tasks and projectsLesson 7and 8HIE、Basic Course ContentLesson 1 Calculation of time value of moneyTeaching requirements: under

17、stand the calculation of terminal value, present value, annuity terminal value and annuity present value, master the corresponding solving function, and master the simulation calculation table through the preparation of time value coefficient table.Key Points: undcrsiand the concept and fonn of time

18、 value of money, and on this basis, in the follow-up teaching of investment decision-making and financing decision-making can correctly use its calculation method.Difficult Points: master the preparation of the simulation table.Lesson 2 Calculation of retum on investment risk (Article I of supportin

19、g course objectives)Teaching requirements: master the application of risk reward concept in enterprise financial management decision-making, and understand the subjective and objective causes, characteristics of risk formation and the measurement of relevant risk level. Master the calculation of exp

20、ected retum, standard deviation and coefficient of variation, and the calculation of profit and loss probability under the condition of random distribution.Key Points: master how to calculate and evaluate various indicators of investment risk.Difllcult Points: master the calculation of profit and lo

21、ss probability under the condition of random distribution.Lesson 3 current asset management (Article 2 of supporting course objectives)Teaching requirements: for inventory management, it is required to master how to determine the optimal inventor) quantity.Key Points: use the planning solution metho

22、d for inventory management, and calculate the optimal inventory quantity.Difficult Points: master the route planning of inventory supply.Lesson 4 fixed asset management (Article 2 of supporting course objectives)Teaching requirements: use compound interest method to calculate and judge relevant inve

23、stment decision-making indexes, understand the calculation contents of investment effect, investment efficiency, investment risk, etc. in investment dccision-inaking, and have a comprehensive understanding of enterprise investment project evaluation accordingly.Key Points: the calculation of fixed a

24、ssets decision-making indicators, including the calculation of NPV. NPV. payback period and IRR indicators, and the use of depreciation function.Difficult Points: comprehensive evaluation of fixed assets investment decision.Lecture 5 bond investment management (Article 3 of supporting course objecti

25、ves)Teaching requirements: master the calculation method of bond value and understand its changing law.Key Points: four rules of bond value change.Difficult Points: control the change of bond value through control.Lesson 6 stock investment management (Article 3 of supporting course objectives)Teachi

26、ng requirements: master the calculation method of stock value and the solution to the problem of stock portfolio.Difficult Points: the solution to the problem of optimal stock portfolio.Difficult Points: how to determine the optimal stock portfolio by changing the optimal goal.Lesson 7 Financial For

27、ecasting (Article 4 of supporting course objectives)Teaching requirements: master how to make financial forecast through functions and charts.Key Points: fast financial forecast by drawing.Difficult Points: master the nonlinear regression analysis method.Lecture 8 report analysis (Article 4 of suppo

28、rting course objectives)Teaching requirements: collect financial data of listed companies through the network; classify the data, including data screening, sorting, etc., and then analyze the financial data through the tools provided by Excel.Key Points: use tool software to conduct empirical analys

29、is on financial data.Difficult Points: Mastering the operation of regression analysis method.IV、Table of Credit Hour DistributionTeachingContentIdeological andPoliticalIntegratedLectureHoursExperimentHoursPracticeHoursProgra mmingHoursSelf-studyHoursExerciseClassDiscussi on HoursLesson 1Calculation

30、of time value ofmoneyTeaching conicnt keeps pace with the times22Lesson 2 Calculation of invcstmcnl risk returnTeaching conicnt keeps pace with the times22Lesson 3 current assetCombination oftheory and22managementPracticeLesson 4 fixedassetmanagementCombination oftheory andPractice22Lecture 5 bondin

31、vestmcnlmanagementCombination oftheory andPractice22Lesson 6 stockinvestmentmanagementCombination oftheory andPractice22Lesson 7FinancialForecastScience andtechnology is the first productivity22Lesson 8report analysisScience and technology is the first productivity22(otal1616V、Summary of Experimenta

32、l (Programming) ProjectsNo.Experiment(Programming)NameExperiment(Programming)HoursExperiment(Programming)TypeAbstractCourse TypeSupportingCourseObjectives1Calculation oftime value ofmoney2comprehensiveCalculation of final value andpresent valueCompulsory12Calculation of return on investment risk2com

33、prehensiveCalculation of risk evaluationindexesCompulsory13Current assets management2comprehensiveCalculation of optimalinventor)Compulsory24Fixed assets management2comprehensiveCalculation of NPV, PV indexand IRRCompulsory25Bond investmentmanagement2comprehensiveBond value calculation and itsrule s

34、ummaryCompulsory36Stock investment management2comprehensiveSlock value calculation andstock portfolioCompulsory37Financialforecast2comprehensiveLinear and non linear regression predictionCompulsory48Financialanalysis2comprehensiveComprehensive analysis of financial statementsCompulsory4Note: Fill in

35、 comprehensive, designing, verification and demonstration in the experiment type, which refers to comprehensive experiment, designing experiment verification experiment and demonstration experiment, respectively.Comprehensive experiment refers to the experiment involving the comprehensive knowledge

36、of the course or related knowledge of the course.Designing experiment refers to the experiment in which the students design the experiment scheme and complete it by themselves based on the given experimental objectives and experimental conditions.Verification experiment refers to an experiment condu

37、cted to verify whether the knowledge or hypothesis is correct after a certain understanding of the research object is achieved or a certain hypothesis is put forward.Demonstration experiment refers (o the experiment performed by the teacher in line with the (caching content.VI、Teaching MethodClassro

38、om teaching: This course is mainly taught by teachers in class, supplemented by home work. In (he course of teaching, blackboard writing and multimedia teaching are used flexibly, and heuristic teaching is emphasized to strcnglhcn the interaction between teachers and students.Practical teaching: in

39、view of various businesses, the importance of practical teaching is emphasized. In practice, computer operation practice is carried out to deepen students understanding and consolidation of what they have learned.VDX Course Assessment and Achievement EvaluationAssessment method: Non-ExaniinationExam

40、ination Formats: computer operationGrading Methods: Five-level SystemCourse Assessment Content, Assessment Format and Supporting Course ObjectivesCourse Objectives (Indices)Assessment ContentAssessment Formats and Proportion ( % )Gradingcomputer operationAssignment EvaluationRoutine TestFinal ExamPr

41、oportio n (%)Courseobjective 1(index 3-2)Calculation of final value, present value, final value of annuity and present value of annuity, calculation of relevant influencing factors, calculation of expected return, standard deviation, coefficient of variation and calculation of profit and loss probability.5Courseobjective 2(in