《《EXCEL财务建模》课程教学大纲英文版.docx》由会员分享，可在线阅读，更多相关《《EXCEL财务建模》课程教学大纲英文版.docx（9页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
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 probab
42、ility.5Courseobjective 2(indicator 4-3)Using the method of planning solution to manage inventory, calculate the optimal inventory quantity, and calculate and judge the fixed assets decision index.10Courseobjective 3(indicator 5-3)Calculation of bond value.calculation of stock value and determination
43、 of optimal porliblio proportion.35Courseobjective 4(indicator 7-2)Using financial statement data to make financial forecast, and using tools to make empirical analysis.35Total201070100VH、Course ResourcesTextbooks : Zhang Ruijun. Computer financial management: financial nxxleling method and technolo
44、gy (M.China Renmin University Press. 2011Bibliography:1. Jing Xin, Wang Huachcng. Financial management. |M. China Renmin University Press, 20162. Han Liangzhi. Application of Excel in financial management. (MJ. Tsinghua University Press, 2009 Reading materials: NoIX、NotesPrerequisites: principles of
45、 western economics, accounting and managementFollow-up Courses: BigData TechnologyContents and Requirements of Students Self-study: To understand the latest theoretical progress of relevant majors, such as management, and to supplement the professional knowledge of financial management to meet the requirements of advancing with the times.Bilingual Teaching or Not: noRequirements and Proportion of Bilingual Teaching: noDiscipline and Considerations of Practice Session: no practice session.Notes: no