本门课程适用于前修课程包括《财务管理》或《财务分析》相关课程的专业和年级的经管类专业学生选修。
课程通过介绍excel在财务管理以及财务分析相关领域的应用,培养提高学生使用excel解决财务问题的能力。
本门课程目前实验模块包括：①Excel基本应用篇（4学时）②货币时间价值及个人理财篇（8学时）③信息收集及基本财务分析应用（6学时）④投资决策及盈亏平衡分析（6学时）⑤方案分析及敏感性分析应用（2学时）⑥风险管理及证券价值分析（6学时）⑦平时测试及期末考评（4学时），总计36学时。
课程考核方式：平时测试及作业占60%+期末考评占40%。
Excel Application in Finance
The course is suitable for the students whose pre-courses including Financial Management or Financial Analysis courses. Through the introduction of Excel Application in the field of financial management and financial analysis, it cultivates the students to use excel to solve financial problems. The course includes 7 experiment modules at present: (1)the basic Excel Application (2) the time value of money and the personal finance report (3)how to gather the information and the basic financial analysis application (4) the investment decisions and break-even analysis (5)the solutions analysis and sensitivity analysis applications (6 )Risk Management and the analysis of Securities Value (7)the final evaluation. Course assessment methods: normal tests and assignments (60% + final assessment (60%).
