Excel金融建模课程教学大纲模版英文版.docxVIP

Syllabus of 《Financial Modeling Using Excel》Course Name： Financial Modeling Using Excel Course Code： Credits： 2.0Total Credit Hours：32Lecture Hours： 32Experiment Hours： Programming Hours：Practice Hours： Total Number of Experimental (Programming) Projects 0Where, Compulsory ( 0 ), Optional ( 0 ). School： 08 School of BusinessTarget Major： Finance I、Course Nature Aims The objective for this course is to develop the financial modeling skills used in the application of financial theory to practical problems in investment analysis, portfolio management, and valuation. In particular, the course will cover the application of Excel spreadsheet functions and visual basic programming to the statistical analysis of financial market data, the use of optimization models to determine mean-variance efficient allocations of financial assets, and the valuation of fixed income and derivative securities. Additional topics to be covered include, active portfolio management, simulation and retirement planning, and the valuation of exotic options and high yield bonds. II、Course Objectives . Moral Education and Character Cultivation. This course help students gain a comprehensive understanding of EXCEL financial modeling related knowledge through the study of theory and techniques of EXCEL financial modeling. Through the history of financial modelling and the process of establishing relevant theories and techniques, students will be able to understand how their predecessors thought during the development of financial modelling and how they overcame the obstacles encountered, helping them to develop a scientific mindset and a spirit of facing challenges in their work. From the perspective of the role of the discipline of financial modelling in Chinas innovation-driven development, and using the research work of outstanding contributors as the carrier, the education of socialist core values is integrated into the content and teaching process of the curriculum, highlighting value leadership