Master Cash Flow Valuation - Financial Literacy in Excel
What you'll learn
- Explain why timing can affect the value of money
- Draw a cash flow timeline for visualizing cash flow(s)
- Differentiate compound interest from simple interest
- Calculate the future value and present value of a single cash flow
- Calculate the future value and present value of multiple cash flows
- Differentiate between an annuity and a perpetuity
- Differentiate between an ordinary annuity and an annuity due
- Calculate the future value and present value of an ordinary annuity, an annuity due, and a perpetuity
- No specific requirements
- A little familiarity with Microsoft Excel interface would be helpful
> Are you going to explore the world of finance?
> Do you have issues in understanding the concept of time value of money and cash flow valuation?
> Are you a (personal/business) financial decision maker who needs a foundation in the area of finance?
> Do you solve finance exercises/problems STEP BY STEP but do not really know why the STEPS are like that?
> Are you planning for a professional qualification like CFA in the area of Finance?
> Do you want to start using spreadsheet software like Excel for financial analysis, modelling, and valuation?
If your answer is 'YES' to any one of the above questions, THIS COURSE IS THE PERFECT ONE FOR YOU TO START WITH...
Time value of money:
Why is the timing of cash flow important?
What is the interest?
How are the simple interest and compound interest different?
Future value and present value:
How to calculate the future value of a single cash flow?
How to calculate the future value of multiple cash flows?
How to calculate the present value of a single cash flow?
How to calculate the present value of multiple cash flows?
If you are looking for the answers to these questions, you have chosen the right course.
Almost everyone has to make financial decisions. Even if one is not a business manager or portfolio manager, s/he must make financial decisions appropriately for his/her personal financial well-being, which necessitates achieving financial literacy. The instructor recognizes the importance of financial literacy for all. This course is also suitable for absolute beginners who have never attended a finance course before, wants to start achieving the financial literacy at a basic level, and may continue learning finance at advanced level in future.
Most of the personal and business level financial decision making involve the valuation of present and future cash flows. This course covers the essential concepts for understanding such valuation.
This course consists of several video lectures that will be updated over time and based on students' requests, quizzes at the end of every section for testing your level of understanding, and additional resources. The lectures contain explanations of necessary concepts along with examples and illustrations. Some of the lectures will be prepared for demonstrating the MS Excel applications of the concepts covered in this course.
The instructor welcomes his students for continuous discussion with him. Any sort of input for improving the course is also appreciated. He also expects your positive and genuine review and rating of the course.
Who this course is for:
- This course is for those who want to start the journey of developing their financial literacy. No prior formal education in finance is needed to understand the content.
- As a supplementary course for students attending or going to attend the first course in finance.
- Business managers with a non-finance background
- Anyone interested
Dr. Md Mohan Uddin is currently a Professor of Finance at United International University. Before that, he held various senior faculty member positions at universities in Bangladesh and Malaysia. He also taught online Masters students of University of Roehampton and supervised online graduate dissertation students of University of Liverpool. During his academic career, he has been teaching undergraduate/graduate level business and finance courses since 2003. The courses he taught include: Corporate Finance, International Finance, Financial Management, Principles of Finance, Investment Analysis, Bank Management, Banking & Insurance, Project Management, Strategic Management, and Computer Applications in Business. He has got his PhD in Finance from Universiti Utara Malaysia, and MBA and BBA degrees majoring in Finance and Banking from University of Dhaka, Bangladesh. He enjoys making learning and instruction videos and is very much excited to be engaged with online platforms like Udemy and skillshare, where he can utilize those technologies for the purpose of reaching a large number of learners worldwide. In addition to presenting research papers in international conferences he has also been active in publishing research articles in different local and international journals in the area of finance. His area of interest includes corporate finance, capital market and its regulation, international finance, financial criminology, Islamic finance and small business finance.