Financial Modelling and Valuation Analyst (Batch-06)

Pre-Requisites Topic – Financial Accounting: Introduction

Why Study Accounting

04:19
Meet Your Instructor and Introduction to Course

05:12

Pre-Requisites Topic – Financial Accounting: Financial Accounts – Intro

Pre-Requisites Topic – Financial Accounting: Accounting Cycle (01)

Practice Problem 1

02:23
Practice Problem 2

01:59
Practice Problem 3

02:06
Practice Problem 4

02:16
Practice Problem 5

00:41
Trial Balance What and Why Income Statement Statement of Retained Earnings

27:45
Posting to the General Ledger

14:44
Debits & Credits Journal Entry Examples

01:39:06
Assets Valuation

22:08

Pre-Requisites Topic – Financial Accounting: Accounting Cycle (02)

Practice Problem 1

03:22
Practice Problem 2

02:42
Practice Problem 3

01:23
Practice Problem 4

02:36
Practice Problem 5

01:09
Account Analysis Examples

13:20
Closing entries Real vs. Nominal Accounts Closing Entry Example

48:52
Adjusting Entries Prepaid Expense Examples Unrecorded Expenses and Revenues

50:35
Accrual Basis Accounting Revenue Recognition Principle Accrual vs Cash Basis

21:15
Common Ending Account Balances

16:45

Pre-Requisites Topic – Financial Accounting: General Financial Statement

Practice Problem 1

00:35
Practice Problem 2

07:24
Practice Problem 3

01:11
Practice Problem 4

03:24
Practice Problem 5

03:31
Practice Problem 6

03:02
Practice Problem 7

02:51
Practice Problem 8

04:52
Practice Problem 9

04:47
Relationship of Statements Financial Statement Formats

54:36
Expanded Equation

40:00
The Income Statement Revenues Defined Expenses Defined

30:38
Introduction to the Financial Statements Balance Sheet Stephen’s Sweet Shop

01:04:38

Pre-Requisites Topic – Financial Accounting: Financial Statement Analysis

Practice Problem 1

02:24
Practice Problem 2

01:51
Practice Problem 3

01:26
Practice Problem 4

01:59
Practice Problem 5

01:59
Practice Problem 6

02:44
Practice Problem 7

01:37
Practice Problem 8

02:22
Practice Problem 9

02:50
Practice Problem 10

01:19
Practice Problem 11

03:00
Practice Problem 12

00:58
Problem Vertical Analysis

20:45
Problem Stock Valuation Ratios

12:55
Problem Turnover Ratios

16:31
Problem Liquidity & Leverage Ratios

24:22
Vertical Analysis

23:48
Forecasting Future Earnings

11:29
Measures of Stock Value

38:48
Measure of Profitability

05:38
Measures of Management

41:45
Calculating Percentage Increases Financing Asset Growth

09:23
Measures of Leverage

14:06
Ratio Analysis

23:41
Measures of Liquidity

13:01

Pre-Requisites Topic – Financial Accounting: Debt and Equity Financing

Practice Problem 1

03:53
Practice Problem 2

05:10
Practice Problem 3

03:22
Practice Problem 4

03:47
Practice Problem 5

04:32
Practice Problem 6

02:28
Dividends Payments

36:32
Preferred Stock

20:24
Common Stock

18:42
Bonds Payable

34:53
Mortgage Notes Payable

48:48
Notes Payable

27:26

Pre-Requisites Topic – Financial Accounting: Long Term Operating Assets

Practice Problem 1

02:15
Practice Problem 2

03:09
Practice Problem 3

03:19
Practice Problem 4

05:55
Practice Problem 5

04:03
Practice Problem 6

03:00
Practice Problem 7

01:54
Practice Problem 8

05:39
Natural Resources and Practice Questions

09:01
Goodwill

17:02
Intangible Assets

21:06
Practice Problems Long-Term Assets

18:32
Repairs, Maintenance and Improvements of Assets

06:16
Sale or Disposal of Asset

17:01
Allocation of the Cost of an Asset (expense over useful life)

37:21
Acquisition of an Asset

04:49
Introduction to Long-Term Assets

17:15

Pre-Requisites Topic – Financial Accounting: Operating Expenses

Pre-Requisites Topic – Financial Accounting: Inventory

Practice Problem 1

01:42
Practice Problem 2

02:58
Practice Problem 3

02:33
Practice Problem 4

02:42
Practice Problem 5

02:29
Practice Problem 6

04:51
Practice Problem 7

02:27
Physical Inventory Count and Recap

06:30
Application of FIFO, LIFO, MWA

37:43
Effects of Inflation and Deflation

24:43
Inventory Cosh Flows new

41:57
Purchase Discounts and Returns of Inventory

25:24
Introduction to Accounting for Inventory

17:34

Pre-Requisites Topic – Financial Accounting: Sales Revenues

Practice Problem 1

04:03
Practice Problem 2

05:34
Practice Problem 3

05:59
Practice Problem 4

16:04
Practice Problem 5

15:14
Practice Problem 6

05:26
Practice Problem 7

02:07
Practice Problem 8

04:11
Credit Card Sales

12:55
Uncollectible Accounts Receivable Bad Debt Expense

36:53
Sales Returns Gross Margin Markup Defined

37:22
Revenues Reviewed

15:46

Pre-Requisites Topic – Financial Accounting: Financial Practice Set

Introductory Class

Pre-Requisites Class – Excel Basics | Shortcuts | Fill Handle | Flash Fill | Sorting & Filtering | Grouping | Referencing (Relative, Absolute, Mixed) | Basic Functions | 3D Referencing

Class 01 –

Class 02 –

Class 03 –

Class 04 –

Class 05 –

Class 06 –

Class 07 – Financial Model Template | Excel Shortcuts | Market Conventions

Class 08 – Financial Modelling – Forecasting Methodologies (Revenue | Cost of Sales | Gross Margin | Administrative Expenses)

Class 09 – Financial Modelling – Forecasting Methodologies (Working Capital – Receivables, Payables, Inventory | Capital Expenditure (PP&E) | Interest Expense (Finance Cost) | Depreciation Expenses | Non-Current Liabilities

Class 10 – Capital Assets & Financing Forecast | Completing Financial Statements | Cash Flow Forecasting | Model Accuracy Checks | Case Study 01: Financial Model (Recommendation Project)

Course Content

Pre-Requisites Topic – Financial Accounting: Introduction

Why Study Accounting

Meet Your Instructor and Introduction to Course

Pre-Requisites Topic – Financial Accounting: Financial Accounts – Intro

Lesson Notes Message from Norm

What is a Business Keys to a Successful Business

Debt vs. Equity Financing Financial vs. Managerial Accounting

General Financial Statements Comparable Information The Role of GAAP

Legal Forms of Business Ownership Corporate Governance Business is Good

Pre-Requisites Topic – Financial Accounting: Accounting Cycle (01)

Practice Problem 1

Practice Problem 2

Practice Problem 3

Practice Problem 4

Practice Problem 5

Trial Balance What and Why Income Statement Statement of Retained Earnings

Posting to the General Ledger

Debits & Credits Journal Entry Examples

Assets Valuation

Pre-Requisites Topic – Financial Accounting: Accounting Cycle (02)

Practice Problem 1

Practice Problem 2

Practice Problem 3

Practice Problem 4

Practice Problem 5

Account Analysis Examples

Closing entries Real vs. Nominal Accounts Closing Entry Example

Adjusting Entries Prepaid Expense Examples Unrecorded Expenses and Revenues

Accrual Basis Accounting Revenue Recognition Principle Accrual vs Cash Basis

Common Ending Account Balances

Pre-Requisites Topic – Financial Accounting: General Financial Statement

Practice Problem 1

Practice Problem 2

Practice Problem 3

Practice Problem 4

Practice Problem 5

Practice Problem 6

Practice Problem 7

Practice Problem 8

Practice Problem 9

Relationship of Statements Financial Statement Formats

Expanded Equation

The Income Statement Revenues Defined Expenses Defined

Introduction to the Financial Statements Balance Sheet Stephen’s Sweet Shop

Pre-Requisites Topic – Financial Accounting: Financial Statement Analysis

Practice Problem 1

Practice Problem 2

Practice Problem 3

Practice Problem 4

Practice Problem 5

Practice Problem 6

Practice Problem 7

Practice Problem 8

Practice Problem 9

Practice Problem 10

Practice Problem 11

Practice Problem 12

Problem Vertical Analysis

Problem Stock Valuation Ratios

Problem Turnover Ratios

Problem Liquidity & Leverage Ratios

Vertical Analysis

Forecasting Future Earnings

Measures of Stock Value

Measure of Profitability

Measures of Management

Calculating Percentage Increases Financing Asset Growth

Measures of Leverage

Ratio Analysis

Measures of Liquidity

Pre-Requisites Topic – Financial Accounting: Debt and Equity Financing

Practice Problem 1

Practice Problem 2

Practice Problem 3

Practice Problem 4

Practice Problem 5

Practice Problem 6

Dividends Payments

Preferred Stock