When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 4 modules in this course
Discounted cash flow method means that we can find firm value by discounting future cash flows of a firm. That is, firm value is present value of cash flows a firm generates in the future. In order to understand the meaning of present value, we are going to discuss time value of money, first. That is, the value of $100 today is different from the value of $100 a year later. Then, what should be the present value of $100 that you are going to receive in 1 year? How about the value of $100 dollars that you are going to receive every year for next 10 years? How about forever? After taking this course, you are going to be able to find the present value of these types of cash flows in the future. Unlike most of finance courses, in this course, you are going to learn how to use excel to find present value of future cash flows. In addition to the present value, you are also going to learn how to find future value given investment; interest rate given investment and future cash flows, payments given interest rates, number of periods to wait given investment and interest rate, and so on. After learning the concept and how to find the time value of money, you are going to apply this to real world examples and company valuation. After taking this course, you will be ready to make an estimate of firm value by discounting its cash flows in the future.
Investing money is important decision because a dollar today is worth more than a dollar in the future. In this module, you will look at several methods for calculating future value as well as present value. After this module, you can solve challenging examples with excel.
1.3 Present Value of Multiple Cash Flows•6 minutes
1.4 NPV of Multiple Cash Flows•4 minutes
1.5 Present Value of Annuity•4 minutes
10 readings•Total 100 minutes
Instructions for beta test•10 minutes
Link to Course Evaluation Form•10 minutes
1.1 Slide•10 minutes
Excel Template•10 minutes
1.2 Slide•10 minutes
Quarterly Compounding•10 minutes
Continuous Compounding•10 minutes
1.3 Slide•10 minutes
1.4 Slide•10 minutes
1.5 Slide•10 minutes
4 assignments•Total 24 minutes
Practice Question 1-1•4 minutes
Practice Question 1-2•4 minutes
Practice Question 1-3•2 minutes
Week 1•14 minutes
1 discussion prompt•Total 10 minutes
Introduce yourself•10 minutes
Time Value of Money (2)
Module 2•2 hours to complete
Module details
In this module, you will focus on how to estimate number of periods, (annual) payment, and interest rate with excel. Furthermore, you will be able to predict the value a stream of cash flows. After this module, you can solve challenging examples with excel.
Yonsei University was established in 1885 and is the oldest private university in Korea.
Yonsei’s main campus is situated minutes away from the economic, political, and cultural centers of Seoul’s metropolitan downtown. Yonsei has 3,500 eminent faculty members who are conducting cutting-edge research across all academic disciplines. There are 18 graduate schools, 22 colleges and 133 subsidiary institutions hosting a selective pool of students from around the world.
Yonsei is proud of its history and reputation as a leading institution of higher education and research in Asia.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.