We may earn an affiliate commission when you visit our partners.
Hyun Han Shin
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/bhg3zu/valuation
Two deals to help you save
Save money when you learn. Here are two deals and offers that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until July 14
Coursera Plus Annual
Work toward what's next for your career with access to 10,000+ programs. Discover emerging skills and save.
Up to
40%
off
Get offer
Valid until August 30
Google AI App Builder
Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind
Take
100%
off
Get offer
What's inside
Syllabus
Time Value of Money (1)
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.
Read more
Syllabus
Time Value of Money (1)
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.
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Taught by Hyun Han Shin, who has an excellent reputation for their work in discounted cash flow and investment
Provides a strong foundation for beginners in the concept of time value of money
Develops core skills like finding present value, future value, and applying them to real-world company valuation
Utilizes Microsoft Excel extensively for practical applications and demonstrations
Lacks hands-on interactive materials or labs
Assumes basic familiarity with finance concepts, which may not be suitable for absolute beginners
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical startup valuation using dcf in excel
According to learners, this course offers a highly practical approach to valuing startups using the Discounted Cash Flow (DCF) method, with a specific and much-appreciated emphasis on using Excel. Students highlight that the instructor explains core concepts clearly, making it accessible even for those relatively new to finance. The focus on real-world applications and examples is frequently mentioned as a significant strength. While widely seen as a great starting point and solid introduction, some feedback indicates the pace can be fast or that it could benefit from greater depth on certain advanced topics. Overall, it provides valuable foundational skills for financial valuation.
Concepts applied to practical company scenarios.
"Applying the DCF method to real-world company examples helped solidify my understanding."
"The practical scenarios discussed were very relevant and useful."
"I appreciated seeing how the concepts are used in actual valuation contexts."
Excellent introduction to DCF valuation basics.
"This course serves as an excellent introduction to the discounted cash flow valuation method."
"It provides a solid foundation for anyone looking to understand how to value a company."
"A great starting point if you are new to financial modeling and valuation."
"Covers the necessary fundamentals comprehensively for beginners."
Instructor explains financial concepts simply.
"The instructor's explanations of time value of money and DCF were very clear and easy to follow."
"Complex financial ideas were broken down into understandable parts."
"I found the lectures to be well-structured and easy to grasp, even without a deep finance background."
Strong focus on using Excel for DCF calculations.
"The practical application of DCF using Excel spreadsheets was incredibly useful and is not something you find in many finance courses."
"I really liked how the course showed step-by-step how to perform the calculations in Excel."
"Learning to build these models directly in Excel makes the concepts much more tangible and applicable."
"This course really delivers on teaching you how to actually *do* DCF valuation using a spreadsheet."
May be too fast or lack depth for some.
"At times, the pace felt a bit rushed, especially when introducing new concepts."
"While great for basics, it could go into more depth on sensitivities or different valuation scenarios."
"Learners with a strong finance background might find it too introductory."
"I wish there were more advanced examples or discussion on dealing with uncertainty."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Valuation for Startups Using Discounted Cash Flows Approach with these
activities:
Review your notes from a previous finance course
Show steps
This will help you to refresh your memory on the basics of finance.
Browse courses on
Finance
Show steps
-
Gather your notes.
-
Review the notes.
Read 'Corporate Finance' by Jonathan Berk and Peter DeMarzo
Show steps
This book provides a comprehensive overview of corporate finance concepts, which will be essential for understanding the material covered in this course.
View
Corporate Finance, Global Edition
on Amazon
Show steps
-
Read the assigned chapters.
-
Take notes on the key concepts.
-
Complete the end-of-chapter exercises.
Follow the Excel tutorials on the Coursera platform
Show steps
These tutorials will provide you with the skills you need to use Excel to solve financial problems.
Browse courses on
Microsoft Excel
Show steps
-
Watch the videos.
-
Complete the practice exercises.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Join a study group with other students in this course
Show steps
This will allow you to discuss the course material with other students and get help with any problems you may be having.
Show steps
-
Find a study group.
-
Meet regularly with your group.
-
Discuss the course material.
-
Help each other with any problems.
Attend a finance conference or meetup
Show steps
This will allow you to network with other professionals in the finance industry.
Show steps
-
Find a finance conference or meetup.
-
Register for the event.
-
Attend the event.
-
Network with other attendees.
Solve DCF problems using the Excel templates provided by the instructor
Show steps
These problems will help you to apply the concepts you learn in this course to real-world scenarios.
Browse courses on
Discounted Cash Flow
Show steps
-
Download the Excel templates.
-
Input the required data.
-
Calculate the DCF.
Contribute to an open-source finance project
Show steps
This will allow you to gain experience with real-world finance projects.
Show steps
-
Find an open-source finance project.
-
Contribute to the project.
-
Get feedback from other contributors.
-
Submit your changes.
Create a financial model for a company of your choice
Show steps
This project will allow you to apply the skills you learn in this course to a real-world problem.
Browse courses on
Financial Modeling
Show steps
-
Choose a company.
-
Gather the necessary financial data.
-
Build the financial model.
-
Analyze the results.
-
Write a report.
Review your notes from a previous finance course
Show steps
This will help you to refresh your memory on the basics of finance.
Browse courses on
Finance
Show steps
Show steps
Show steps
- Gather your notes.
- Review the notes.
Read 'Corporate Finance' by Jonathan Berk and Peter DeMarzo
Show steps
This book provides a comprehensive overview of corporate finance concepts, which will be essential for understanding the material covered in this course.
View
Corporate Finance, Global Edition
on Amazon
Show steps
Show steps
Show steps
- Read the assigned chapters.
- Take notes on the key concepts.
- Complete the end-of-chapter exercises.
Follow the Excel tutorials on the Coursera platform
Show steps
These tutorials will provide you with the skills you need to use Excel to solve financial problems.
Browse courses on
Microsoft Excel
Show steps
Show steps
Show steps
- Watch the videos.
- Complete the practice exercises.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Join a study group with other students in this course
Show steps
This will allow you to discuss the course material with other students and get help with any problems you may be having.
Show steps
Show steps
Show steps
- Find a study group.
- Meet regularly with your group.
- Discuss the course material.
- Help each other with any problems.
Attend a finance conference or meetup
Show steps
This will allow you to network with other professionals in the finance industry.
Show steps
Show steps
Show steps
- Find a finance conference or meetup.
- Register for the event.
- Attend the event.
- Network with other attendees.
Solve DCF problems using the Excel templates provided by the instructor
Show steps
These problems will help you to apply the concepts you learn in this course to real-world scenarios.
Browse courses on
Discounted Cash Flow
Show steps
Show steps
Show steps
- Download the Excel templates.
- Input the required data.
- Calculate the DCF.
Contribute to an open-source finance project
Show steps
This will allow you to gain experience with real-world finance projects.
Show steps
Show steps
Show steps
- Find an open-source finance project.
- Contribute to the project.
- Get feedback from other contributors.
- Submit your changes.
Create a financial model for a company of your choice
Show steps
This project will allow you to apply the skills you learn in this course to a real-world problem.
Browse courses on
Financial Modeling
Show steps
Show steps
Show steps
- Choose a company.
- Gather the necessary financial data.
- Build the financial model.
- Analyze the results.
- Write a report.
Career center
Learners who complete Valuation for Startups Using Discounted Cash Flows Approach will develop knowledge and skills
that may be useful to these careers:
Financial Analyst
Financial Analyst
A Financial Analyst is responsible for using financial data to make recommendations for investment opportunities and new business ventures. This course may be helpful for Financial Analysts as it teaches how to use discounted cash flows to value startups, which is a valuable skill for making investment decisions.
Investment Banker
Investment Banker
An Investment Banker provides financial advice to companies and governments on mergers and acquisitions, capital raising, and other financial transactions. This course may be helpful for Investment Bankers as it teaches how to value startups, which is a skill that is used in many investment banking transactions.
Private Equity Associate
Private Equity Associate
A Private Equity Associate works for a private equity firm that invests in companies that are not publicly traded. This course may be helpful for Private Equity Associates as it teaches how to value startups, which is a skill that is used in the private equity industry.
Venture Capitalist
Venture Capitalist
A Venture Capitalist invests in early-stage companies with high growth potential. This course may be helpful for Venture Capitalists as it teaches how to value startups, which is a skill that is used to make investment decisions in the venture capital industry.
Corporate Finance Analyst
Corporate Finance Analyst
A Corporate Finance Analyst works for a company and is responsible for analyzing the company's financial performance and making recommendations on how to improve it. This course may be helpful for Corporate Finance Analysts as it teaches how to use discounted cash flows to value companies, which is a skill that is used in corporate finance.
Financial Planner
Financial Planner
A Financial Planner helps individuals and families plan for their financial future. This course may be helpful for Financial Planners as it teaches how to use discounted cash flows to value investments, which is a skill that is used in financial planning.
Accountant
Accountant
An Accountant prepares and examines financial records. This course may be helpful for Accountants as it teaches how to use discounted cash flows to value companies, which is a skill that is used in accounting.
Auditor
Auditor
An Auditor examines the financial records of companies to ensure that they are accurate and compliant with regulations. This course may be helpful for Auditors as it teaches how to use discounted cash flows to value companies, which is a skill that is used in auditing.
Tax Accountant
Tax Accountant
A Tax Accountant prepares and files tax returns for individuals and businesses. This course may be helpful for Tax Accountants as it teaches how to use discounted cash flows to value companies, which is a skill that is used in tax accounting.
Management Consultant
Management Consultant
A Management Consultant helps businesses improve their performance. This course may be helpful for Management Consultants as it teaches how to use discounted cash flows to value companies, which is a skill that is used in management consulting.
Data Analyst
Data Analyst
A Data Analyst collects, analyzes, and interprets data to help businesses make better decisions. This course may be helpful for Data Analysts as it teaches how to use discounted cash flows to value companies, which is a skill that is used in data analysis.
Financial Risk Manager
Financial Risk Manager
A Financial Risk Manager identifies, assesses, and manages financial risks. This course may be helpful for Financial Risk Managers as it teaches how to use discounted cash flows to value companies, which is a skill that is used in financial risk management.
Quantitative Analyst
Quantitative Analyst
A Quantitative Analyst uses mathematical and statistical models to analyze financial data. This course may be helpful for Quantitative Analysts as it teaches how to use discounted cash flows to value companies, which is a skill that is used in quantitative analysis.
Operations Research Analyst
Operations Research Analyst
An Operations Research Analyst uses mathematical and statistical models to solve business problems. This course may be helpful for Operations Research Analysts as it teaches how to use discounted cash flows to value companies, which is a skill that is used in operations research.
Actuary
Actuary
An Actuary uses mathematical and statistical models to assess financial risks. This course may be helpful for Actuaries as it teaches how to use discounted cash flows to value companies, which is a skill that is used in actuarial science.
For more career information including salaries, visit:
OpenCourser.com/course/bhg3zu/valuation
Reading list
We've selected 15 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Valuation for Startups Using Discounted Cash Flows Approach.
This classic investment guidebook provides timeless principles for value investing and avoiding common pitfalls. Graham's insights on the importance of margin of safety, intrinsic value, and long-term perspective are essential reading for any investor.
Save
This comprehensive guide to security analysis is considered the bible of value investing. It provides a step-by-step framework for evaluating companies and identifying undervalued opportunities.
Save
This authoritative guide to valuation methods and techniques is widely used by professionals in investment banking, private equity, and corporate finance. It provides detailed coverage of the discounted cash flow approach, comparable company analysis, and transaction multiples, making it an invaluable resource for anyone involved in valuing companies.
This concise guide to valuation provides a clear and practical explanation of the most common valuation methods used by investors and analysts. It covers a wide range of topics, from discounted cash flow analysis to comparable company analysis.
Save
This comprehensive corporate finance textbook provides a theoretical and practical foundation for understanding the principles and practices of corporate finance. It covers fundamental concepts such as time value of money, capital structure, and investment analysis, making it a valuable resource for students and practitioners alike.
This introductory corporate finance textbook provides a comprehensive overview of the principles and practices of corporate finance. It covers a wide range of topics, from financial statement analysis to capital budgeting.
This practical guide to financial modeling covers the essential techniques and tools used by financial analysts and investment bankers. It provides step-by-step instructions for building financial models in Excel, making it a valuable resource for anyone who wants to develop their financial modeling skills.
Save
This comprehensive guide to investment banking provides a detailed overview of the industry and the key financial modeling and valuation techniques used by investment bankers. It covers a wide range of topics, from mergers and acquisitions to leveraged buyouts.
This comprehensive guide to venture capital provides a detailed overview of the industry and the key investment strategies and techniques used by venture capitalists. It covers a wide range of topics, from fundraising to exits.
This comprehensive guide to Python for data analysis provides a detailed overview of the most common techniques and tools used by data analysts. It covers a wide range of topics, from data cleaning and preparation to data visualization and modeling.
Save
This comprehensive guide to R for data science provides a detailed overview of the most common techniques and tools used by data scientists. It covers a wide range of topics, from data cleaning and preparation to data visualization and modeling.
Provides a comprehensive guide to using Excel for financial analysis and modeling. It covers a wide range of topics, from basic functions and formulas to advanced techniques such as Monte Carlo simulation and data analysis.
This practical guide to Excel for data analysis and business modeling provides a detailed overview of the most common techniques and tools used by data analysts and business modelers. It covers a wide range of topics, from data cleaning and preparation to data visualization and modeling.
This concise guide to machine learning provides a clear and practical explanation of the most common machine learning algorithms and techniques. It covers a wide range of topics, from supervised learning to unsupervised learning.
This concise guide to the time value of money provides a clear and practical explanation of the concepts and calculations involved in investment decision-making. It covers a wide range of topics, from basic concepts to advanced applications.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/bhg3zu/valuation
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Rating
4.3
Effort
Approx. 8 hours
Level
Introductory
Via
Coursera
Institution
Yonsei University
Instructor
Hyun Han Shin
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
Bahasa Indonesia
ไทย
қазақша
tiếng Việt
This course belongs to a
collection
called
Valuation and Financial Analysis For Startups. It's comprised of five courses:
- Valuation for Startups Using Discounted Cash Flows Approach (viewing)
- Financial Analysis for Startups
- Valuation and Financial Analysis For Startups Capstone
- Valuation for Startups Using Multiple Approach
- Applying Investment Decision Rules for Startups
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser