Master Cash Flow Valuation - Financial Literacy in Excel

Focused View

Md Mohan Uddin

2:37:55

49 View

1. Introduction

1. About the course.mp4

02:09

1. Introduction.zip

2. How to participate in this course.pdf

3. Timing of cash flow Why does it matter.mp4

05:19

2. Cash Flow Time Line

1.1 Cash Flow Time Line.html

1.2 What is Cash Flow Timeline definition and meaning.html

1. Visualizing cash flow(s) using a time line.mp4

09:13

2. End-of-section quiz.html

3. The Interest Simple and Compound

1.1 How Simple Interest Works with Your Money.html

1.2 Introduction to Interest.html

1.3 Simple Interest Calculator - WebMath.html

1.4 Simple Interest Definition Investopedia.html

1. Future value at a simple interest.mp4

12:17

2.1 Calculating Simple and Compound Interest - Series 7 Investopedia.html

2.2 Compound Interest Definition Investopedia.html

2.3 Introduction to Interest.html

2.4 Simple interest and compound interest explained.html

2. The compound interest.mp4

07:55

3. End-of-section quiz.html

4. Future Value and Present Value of a Single Cash Flow

1.1 Compound Interest.html

1.2 Compound Interest Calculator - WebMath.html

1.3 Compound Interest Calculator Investor.gov.html

1. Future value of a single cash flow.mp4

14:41

2. Present value of a single cash flow.mp4

05:30

3. Excel Financial Model Calculating the future value of a single cash flow.mp4

07:51

4. End-of-section quiz.html

5. Future Value and Present Value of Multiple Cash Flows

1. Future value of multiple unequal cash flows.mp4

11:41

2. Present value of multiple unequal cash flows.mp4

05:03

3. Multiple unequal cash flows.html

4. Annuity.mp4

02:29

5. Ordinary annuity and annuity due.mp4

03:49

6. Future value of an ordinary annuity.mp4

10:14

7. Future value of an annuity due.mp4

08:04

8. Present value of an ordinary annuity.mp4

07:44

9. Present value of an annuity due.mp4

10:27

10. Perpetuity.mp4

03:20

11. Present value of a perpetuity.mp4

05:29

6. Application via Excel Models

1. Modelling loan amortization schedule in Excel spreadsheet.mp4

13:11

2. Preparing a business project valuation model in Excel.mp4

11:29

3. Spreadsheet Assignment 1 - Loan Amortization Schedule.html

7. Summary

1. Summary of the Course.pdf

Description

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

Who is this 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

What You Need to Know?

No specific requirements

A little familiarity with Microsoft Excel interface would be helpful

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.