# 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

> Are you going to explore the world of finance?

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.

Course Content

• Introduction –> 3 lectures • 7min.
• Cash Flow Time Line –> 1 lecture • 9min.
• The Interest: Simple and Compound –> 2 lectures • 20min.
• Future Value and Present Value of a Single Cash Flow –> 3 lectures • 28min.
• Future Value and Present Value of Multiple Cash Flows –> 10 lectures • 1hr 8min.
• Application via Excel Models –> 2 lectures • 25min.
• Summary –> 1 lecture • 0min.

Requirements

> 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.

Get Tutorial