Master Cash Flow Valuation Financial Literacy in Excel

Master Cash Flow Valuation – Financial Literacy in Excel, available at $44.99, has an average rating of 4.7, with 22 lectures, 6 quizzes, based on 62 reviews, and has 4762 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. or As a supplementary course for students attending or going to attend the first course in finance. or Entrepreneurs or Business managers with a non-finance background or Anyone interested It is particularly useful 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. or As a supplementary course for students attending or going to attend the first course in finance. or Entrepreneurs or Business managers with a non-finance background or Anyone interested.

Enroll now: Master Cash Flow Valuation – Financial Literacy in Excel

Summary

Title: Master Cash Flow Valuation – Financial Literacy in Excel

Price: $44.99

Average Rating: 4.7

Number of Lectures: 22

Number of Quizzes: 6

Number of Published Lectures: 22

Number of Published Quizzes: 6

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: About the course

Lecture 2: How to participate in this course

Lecture 3: Timing of cash flow: Why does it matter?

Chapter 2: Cash Flow Time Line

Lecture 1: Visualizing cash flow(s) using a time line

Chapter 3: The Interest: Simple and Compound

Lecture 1: Future value at a simple interest

Lecture 2: The compound interest

Chapter 4: Future Value and Present Value of a Single Cash Flow

Lecture 1: Future value of a single cash flow

Lecture 2: Present value of a single cash flow

Lecture 3: Excel Financial Model: Calculating the future value of a single cash flow

Chapter 5: Future Value and Present Value of Multiple Cash Flows

Lecture 1: Future value of multiple unequal cash flows

Lecture 2: Present value of multiple unequal cash flows

Lecture 3: Annuity

Lecture 4: Ordinary annuity and annuity due

Lecture 5: Future value of an ordinary annuity

Lecture 6: Future value of an annuity due

Lecture 7: Present value of an ordinary annuity

Lecture 8: Present value of an annuity due

Lecture 9: Perpetuity

Lecture 10: Present value of a perpetuity

Chapter 6: Application via Excel Models

Lecture 1: Modelling loan amortization schedule in Excel spreadsheet

Lecture 2: Preparing a business project valuation model in Excel

Chapter 7: Summary

Lecture 1: Summary of the Course

Instructors

Md Mohan Uddin
Professor of Finance

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 10 votes

4 stars: 22 votes

5 stars: 28 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!