Master Cash Flow Valuation - Financial Literacy in Excel

Grab the language of Finance - The time value fundamentals - The financial literacy with real life applications 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
Requirements
No specific requirements
A little familiarity with Microsoft Excel interface would be helpful
Description
> 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?

Interest rate:

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.
Entrepreneurs
Business managers with a non-finance background
Anyone interested



More Info