|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/time-value-of-money-with-excel/
课程评论：没有评论
**课程名称：** Excel中的货币时间 G9_ 价值 **课程概述：** 本课程旨在教授学员货币时间价值（TVM）的核心概念及其在金融领域的实际应用，并重点强调如何利用Microsoft Excel进行相关计算。许多银行、非银行金融公司（NBFCs）、以及先买后付（Hire-Purchase）和租赁公司等金融机构，在招聘个人银行家、信贷分析师、贷款专员、贷款产品经理等职位时，都高度重视求职者对货币时间价值概念的掌握程度以及MS-Excel的操作能力。通过搜索相关职位的招聘信息，可以发现其市场需求量巨大。 本课程将带您学习TVM在实际情境中的应用，包括储蓄增长、定期存款、养老金、等额本息（EMI）计算、贷款明细表（Loan Schedules）、以及偿债基金（Sinking Fund）的构建等。您将学习如何运用TVM的原理进行重要的计算，例如未来价值（Future Value）、年金未来价值（Future Value of Annuity）、现值（Present Value）、以及年金现值（Present Value of Annuity）等，并掌握在Microsoft Excel中执行这些计算的高效方法。 完成本课程后，您将对货币时间价值建立起扎实的理解，从而能够做出更明智的商业决策。
Many Banks, NBFCs, Hire-Purchase Companies, Leasing Companies recruit thousands of candidates with thorough knowledge in time value of money concepts and expertise in MS-Excel as Personal Banker, Credit Analyst, Loan Officer, Product Manager (Loan) etc. Search job portals with these designations, for your surprise you find thousands of openings at any given point of time. In this course you will learn practical applications of time value of money like savings growth, recurring deposits, pension funds, EMI calculation, Loan Schedules, sinking fund etc. This course introduces you to the concepts of time value of money and shows you how to perform important calculations life future value, future value of annuity, present value, present value of annuity using Microsoft Excel. In this course, you will develop a solid understanding of the time value of money that prepare you to make smart business decisions.
