Канал: Plain Vanilla Counseling PVC

Calculating Standard Deviation and Variance in Excel

Calculating Standard Deviation and Variance in Excel

Calculate MODE in Excel

Calculate MODE in Excel

Using Rank Formula in Excel

Using Rank Formula in Excel

Calculating COVARIANCE in Excel

Calculating COVARIANCE in Excel

Using FIND Formula in Excel

Using FIND Formula in Excel

How to Use DATE Formulas in Excel

How to Use DATE Formulas in Excel

Learning SUMIF Formula in Excel

Learning SUMIF Formula in Excel

Using COUNTIF Formulas in Excel

Using COUNTIF Formulas in Excel

Using Count Formulas in Excel

Using Count Formulas in Excel

Using Index Formula in Excel

Using Index Formula in Excel

Using CHOOSE Formula in Excel

Using CHOOSE Formula in Excel

Using IF Formula in Excel

Using IF Formula in Excel

How to Trace Dependent Cells in Excel

How to Trace Dependent Cells in Excel

Using SUM Formula in Excel

Using SUM Formula in Excel

FM9: Price to Earnings (PE) Multiple Valuation

FM9: Price to Earnings (PE) Multiple Valuation

FM8: Making FCFF Valuation Financial Model

FM8: Making FCFF Valuation Financial Model

FM7: Using Gordon Growth Model in Excel

FM7: Using Gordon Growth Model in Excel

FM6: DDM in Financial Modeling

FM6: DDM in Financial Modeling

FM5: Dividend Discount Model

FM5: Dividend Discount Model

FM4: Valuation with Multiplier Models

FM4: Valuation with Multiplier Models

FM3: How to do Equity Valuation

FM3: How to do Equity Valuation

FM2: Defining Value vs Price

FM2: Defining Value vs Price

FM1 Introduction: Financial Modeling for Valuation Course

FM1 Introduction: Financial Modeling for Valuation Course

CFA L1 Reading 59B (Backup): GIPS

CFA L1 Reading 59B (Backup): GIPS

CFA L1 Reading 58B: Guidance for Standards

CFA L1 Reading 58B: Guidance for Standards

CFA L1 Readings 56-57: Ethics and Trust, Code of Ethics, and Standards of Professional Conduct

CFA L1 Readings 56-57: Ethics and Trust, Code of Ethics, and Standards of Professional Conduct

CFA L1 Reading 50: Portfolio Risk and Return Part 2

CFA L1 Reading 50: Portfolio Risk and Return Part 2

CFA L1 Reading 23: Income Taxes

CFA L1 Reading 23: Income Taxes

CFA L1 Reading 22: Long Lived Assets

CFA L1 Reading 22: Long Lived Assets

CFA L1 Reading 21B: Inventories

CFA L1 Reading 21B: Inventories

CFA L1 Reading 19: Understanding Cash Flow Statements

CFA L1 Reading 19: Understanding Cash Flow Statements

CFA L1 Reading 16B: Financial Reporting Standards

CFA L1 Reading 16B: Financial Reporting Standards

CFA L1 Reading 16A (Backup): Financial Reporting Standards

CFA L1 Reading 16A (Backup): Financial Reporting Standards

CFA L1 Reading 14: Currency Exchange Rates

CFA L1 Reading 14: Currency Exchange Rates

CFA L1 Reading 12B: Monetary and Fiscal Policy

CFA L1 Reading 12B: Monetary and Fiscal Policy

CFA Level 1 Reading 11C: Understanding Business Cycles

CFA Level 1 Reading 11C: Understanding Business Cycles

CFA L1 Reading 11B: Understanding Business Cycles

CFA L1 Reading 11B: Understanding Business Cycles

CFA L1 Reading 11A: Understanding Business Cycles

CFA L1 Reading 11A: Understanding Business Cycles

CFA L1 Reading 9: The Firm and Market Structures

CFA L1 Reading 9: The Firm and Market Structures

CFA L1 Reading 6: Hypothesis Testing

CFA L1 Reading 6: Hypothesis Testing

CFA L1 Reading 5: Sampling and Estimation

CFA L1 Reading 5: Sampling and Estimation

CFA L1 Reading 51: Basics of Portfolio Planning and Construction

CFA L1 Reading 51: Basics of Portfolio Planning and Construction

CFA L1 Reading 46: Basics of Derivative Pricing and Valuation

CFA L1 Reading 46: Basics of Derivative Pricing and Valuation

CFA L1 Reading 24A: Non current Long Term Liabilities

CFA L1 Reading 24A: Non current Long Term Liabilities

CFA L1 Reading 20: Financial Analysis Techniques

CFA L1 Reading 20: Financial Analysis Techniques

CFA L1 Reading 17: Understanding Income Statements

CFA L1 Reading 17: Understanding Income Statements

CFA L1 Reading 13: International Trade and Capital Flows

CFA L1 Reading 13: International Trade and Capital Flows

CFA L1 Reading 10: Aggregate Output, Prices, and Economic Growth

CFA L1 Reading 10: Aggregate Output, Prices, and Economic Growth

CFA L1 Reading 8A: Topics in Demand and Supply Analysis

CFA L1 Reading 8A: Topics in Demand and Supply Analysis

CFA L1 Reading 4: Common Probability Distributions

CFA L1 Reading 4: Common Probability Distributions

CFA L1 Reading 2B Backup: Statistical Concepts and Market Returns

CFA L1 Reading 2B Backup: Statistical Concepts and Market Returns

CFA L1 Reading 1B (Backup): DCF

CFA L1 Reading 1B (Backup): DCF

CFA L1 Reading 24B: Non current Long Term Liabilities

CFA L1 Reading 24B: Non current Long Term Liabilities

CFA L1 Reading 24C: Non current Long Term Liabilities

CFA L1 Reading 24C: Non current Long Term Liabilities

CFA L1 Reading 25B: Financial Reporting Quality

CFA L1 Reading 25B: Financial Reporting Quality

CFA L1 Reading 25A: Financial Reporting Quality

CFA L1 Reading 25A: Financial Reporting Quality

CFA L1 Reading 26B: Applications of Financial Statement Analysis

CFA L1 Reading 26B: Applications of Financial Statement Analysis

CFA L1 Reading 26A: Applications of Financial Statement Analysis

CFA L1 Reading 26A: Applications of Financial Statement Analysis

CFA L1 Reading 27A: Introduction to Corporate Governance and Other ESG Considerations

CFA L1 Reading 27A: Introduction to Corporate Governance and Other ESG Considerations

CFA L1 Reading 27B: Introduction to Corporate Governance and Other ESG Considerations

CFA L1 Reading 27B: Introduction to Corporate Governance and Other ESG Considerations

CFA L1 Reading 28A: Uses of Capital

CFA L1 Reading 28A: Uses of Capital

CFA L1 Reading 30: Cost of Capital-Foundational Topics

CFA L1 Reading 30: Cost of Capital-Foundational Topics

CFA L1 Reading 29: Sources of Capital

CFA L1 Reading 29: Sources of Capital

CFA L1 Reading 33A: Market Organization and Structure

CFA L1 Reading 33A: Market Organization and Structure

CFA L1 Reading 33B: Market Organization and Structure

CFA L1 Reading 33B: Market Organization and Structure

CFA L1 Reading 34: Security Market Indices

CFA L1 Reading 34: Security Market Indices

CFA L1 Reading 35: Market Efficiency

CFA L1 Reading 35: Market Efficiency

CFA L1 Reading 37A: Introduction to Industry and Company Analysis

CFA L1 Reading 37A: Introduction to Industry and Company Analysis

CFA L1 Reading 38: Equity Valuation Concepts and Basic Tools

CFA L1 Reading 38: Equity Valuation Concepts and Basic Tools

CFA L1 Reading 39: Fixed Income Securities Defining Elements

CFA L1 Reading 39: Fixed Income Securities Defining Elements

CFA L1 Reading 40: Fixed Income Markets Issuance, Trading, and Funding

CFA L1 Reading 40: Fixed Income Markets Issuance, Trading, and Funding

CFA L1 Reading 42: An Introduction to Asset Backed Securities

CFA L1 Reading 42: An Introduction to Asset Backed Securities

CFA L1 Reading 43: Understanding Fixed Income Risk and Return

CFA L1 Reading 43: Understanding Fixed Income Risk and Return

CFA L1 Reading 44: Fundamentals of Credit Analysis

CFA L1 Reading 44: Fundamentals of Credit Analysis

CFA L1 Reading 45A: Derivative Markets and Instruments

CFA L1 Reading 45A: Derivative Markets and Instruments

CFA L1 Reading 45B: Derivative Markets and Instruments

CFA L1 Reading 45B: Derivative Markets and Instruments

CFA L1 Reading 47: Introduction to Alternative Investments

CFA L1 Reading 47: Introduction to Alternative Investments

CFA L1 Reading 49: Portfolio Risk and Return Part 1

CFA L1 Reading 49: Portfolio Risk and Return Part 1

CFA L1 Reading 54: Technical Analysis

CFA L1 Reading 54: Technical Analysis

CFA L1 Reading 58A: Guidance for Standards

CFA L1 Reading 58A: Guidance for Standards

CFA L1 Reading 28B: Uses of Capital

CFA L1 Reading 28B: Uses of Capital

CFA L1 Reading 32: Measures of Leverage

CFA L1 Reading 32: Measures of Leverage

CFA L1 Reading 33C: Market Organization and Structure

CFA L1 Reading 33C: Market Organization and Structure

CFA L1 Reading 36: Overview of Equity Securities

CFA L1 Reading 36: Overview of Equity Securities

CFA L1 Reading 37B: Introduction to Industry and Company Analysis

CFA L1 Reading 37B: Introduction to Industry and Company Analysis

CFA L1 Reading 41: Introduction to Fixed Income Valuation

CFA L1 Reading 41: Introduction to Fixed Income Valuation

CFA L1 Reading 48: Portfolio Management An Overview

CFA L1 Reading 48: Portfolio Management An Overview

CFA L1 Reading 53: Introduction to Risk Management

CFA L1 Reading 53: Introduction to Risk Management

CFA L1 Reading 55: Fintech in Investment Management

CFA L1 Reading 55: Fintech in Investment Management

CFA L1 Reading 59A: Introduction to the Global Investment Performance Standards (GIPS)

CFA L1 Reading 59A: Introduction to the Global Investment Performance Standards (GIPS)

CFA L1 Reading 21A: Inventories

CFA L1 Reading 21A: Inventories

CFA L1 Reading 18: Understanding Balance Sheets

CFA L1 Reading 18: Understanding Balance Sheets

CFA L1 Reading 15: Introduction to Financial Statement Analysis

CFA L1 Reading 15: Introduction to Financial Statement Analysis

CFA L1 Reading 12A: Monetary and Fiscal Policy

CFA L1 Reading 12A: Monetary and Fiscal Policy

CFA L1 Reading 8B: Topics in Demand and Supply Analysis

CFA L1 Reading 8B: Topics in Demand and Supply Analysis

CFA L1 Reading 3: Probability Concepts

CFA L1 Reading 3: Probability Concepts

CFA L1 Reading 1A: Time Value of Money

CFA L1 Reading 1A: Time Value of Money

Corporate Governance Explained

Corporate Governance Explained

Hypothesis Testing

Hypothesis Testing

Financial Calculator Tutorial for Future Value Calculation

Financial Calculator Tutorial for Future Value Calculation

CFA Level 1 Exam Pattern & Syllabus

CFA Level 1 Exam Pattern & Syllabus

Hedge Funds Explained

Hedge Funds Explained

Alternative Investments Explained

Alternative Investments Explained

Debt Financing Explained

Debt Financing Explained

Match Formula in Excel

Match Formula in Excel

How to Use HLOOKUP in Excel

How to Use HLOOKUP in Excel

Using Vlookup in Excel

Using Vlookup in Excel

Calculating Internal Rate of Return (IRR) in Excel

Calculating Internal Rate of Return (IRR) in Excel

Calculating NPV in Excel

Calculating NPV in Excel

NPV Calculation Explained

NPV Calculation Explained

Analyst Interview Questions

Analyst Interview Questions

5 Tips for Job Interview Preparation

5 Tips for Job Interview Preparation

CFA vs CA: Which one to Pursue?

CFA vs CA: Which one to Pursue?

AFS (79): Sensitivty Analysis vs Scenario Analysis

AFS (79): Sensitivty Analysis vs Scenario Analysis

AFS (78): How to Value an Asset for Investment

AFS (78): How to Value an Asset for Investment

AFS (77): Balance Sheet Forecast in Financial Model

AFS (77): Balance Sheet Forecast in Financial Model

AFS (76): How to build Financial Model

AFS (76): How to build Financial Model

AFS (75): Asset Valuation using Multiples and GGM

AFS (75): Asset Valuation using Multiples and GGM

AFS (74): Dividend Ratios Calculation and Analysis

AFS (74): Dividend Ratios Calculation and Analysis

AFS (73): Forward PE vs Trailing PE Multiple

AFS (73): Forward PE vs Trailing PE Multiple

AFS (72): PEG Ratio Calculation and Analysis

AFS (72): PEG Ratio Calculation and Analysis

AFS (71): How to Calculate and Analyze Price to Earnings (PE) Ratio?

AFS (71): How to Calculate and Analyze Price to Earnings (PE) Ratio?

AFS (70): DuPont Analysis of ROE

AFS (70): DuPont Analysis of ROE

AFS (69): Return on Investment Ratios

AFS (69): Return on Investment Ratios

AFS (68): Interest Coverage Ratios

AFS (68): Interest Coverage Ratios

AFS (67): Defensive Interval and Operating Cycle Analysis

AFS (67): Defensive Interval and Operating Cycle Analysis

AFS (66): Cash Conversion Cycle

AFS (66): Cash Conversion Cycle

AFS (65): Defensive Interval Ratio

AFS (65): Defensive Interval Ratio

AFS (64): Activity Ratios Case Study

AFS (64): Activity Ratios Case Study

AFS (63): Activity Ratios Analysis

AFS (63): Activity Ratios Analysis

AFS (62): Categories of Financial Ratios

AFS (62): Categories of Financial Ratios

AFS (61): Ratios for Insurance Companies

AFS (61): Ratios for Insurance Companies

AFS (60): Ratio Analysis of Cash Flows

AFS (60): Ratio Analysis of Cash Flows

AFS (59): Example of Free Cash Flow Calculation

AFS (59): Example of Free Cash Flow Calculation

AFS (58): Free Cash Flow to Equity (FCFE)

AFS (58): Free Cash Flow to Equity (FCFE)

AFS (57): Free Cash Flow to Firm (FCFF)

AFS (57): Free Cash Flow to Firm (FCFF)

AFS (56): Free Cash Flow (FCF) Calculation

AFS (56): Free Cash Flow (FCF) Calculation

AFS (55): Cash Flow Analysis Dell Case Study

AFS (55): Cash Flow Analysis Dell Case Study

AFS (54): Commonsized Cash Flow Percentage of Sales Analysis

AFS (54): Commonsized Cash Flow Percentage of Sales Analysis

AFS (53): Commonsized Cash Flow Percentage of Inflows Analysis

AFS (53): Commonsized Cash Flow Percentage of Inflows Analysis

AFS (52): Operating and Financing Cash Flows Detailed Analysis

AFS (52): Operating and Financing Cash Flows Detailed Analysis

AFS (51): Evaluating Cash Flows Sustainability

AFS (51): Evaluating Cash Flows Sustainability

AFS (50): Cash Flow Statement Analysis

AFS (50): Cash Flow Statement Analysis

AFS (49): Cash Flow Direct vs Indirect Method

AFS (49): Cash Flow Direct vs Indirect Method

AFS (48): Calculating Cash Paid for Dividends

AFS (48): Calculating Cash Paid for Dividends

AFS (47): Calculating Cash from Sale of Assets in Direct Method of Cash Flow Statement

AFS (47): Calculating Cash from Sale of Assets in Direct Method of Cash Flow Statement

AFS (46): Calculating Cash Expenses in Direct Method of Cash Flow Statement

AFS (46): Calculating Cash Expenses in Direct Method of Cash Flow Statement

AFS (45): Calculating Cash Paid to Suppliers in Direct Method of Cash Flow Statement

AFS (45): Calculating Cash Paid to Suppliers in Direct Method of Cash Flow Statement

AFS (44): Calculating Cash Received from Customers in Direct Method of Cash Flow Statement

AFS (44): Calculating Cash Received from Customers in Direct Method of Cash Flow Statement

AFS (43): Cash Flow IFRS and US GAAP Differences

AFS (43): Cash Flow IFRS and US GAAP Differences

AFS (42): Cash Flow Statement Direct and Indirect Methods

AFS (42): Cash Flow Statement Direct and Indirect Methods

AFS (41): Components of Cash Flow Statement

AFS (41): Components of Cash Flow Statement

AFS (40): Asset Turnover ROA and Debt to EBITDA Ratio Analysis

AFS (40): Asset Turnover ROA and Debt to EBITDA Ratio Analysis

AFS (39): Debt Service Coverage Ratio DSCR

AFS (39): Debt Service Coverage Ratio DSCR

AFS (38): Solvency Ratio Analysis of Balance Sheet

AFS (38): Solvency Ratio Analysis of Balance Sheet

AFS (37): Solvency Analysis using Common Size Balance Sheet

AFS (37): Solvency Analysis using Common Size Balance Sheet

AFS (36): Liquidity Ratio Analysis of Balance Sheet

AFS (36): Liquidity Ratio Analysis of Balance Sheet

AFS (35): Common Size Liquidity Analysis of Balance Sheet

AFS (35): Common Size Liquidity Analysis of Balance Sheet

AFS (34): Equity Components in Balance Sheet

AFS (34): Equity Components in Balance Sheet

AFS (33): Deferred Tax Liabilities and Assets

AFS (33): Deferred Tax Liabilities and Assets

AFS (32): Financial Assets IFRS 9

AFS (32): Financial Assets IFRS 9

AFS (31): Goodwill Recognition and Analysis

AFS (31): Goodwill Recognition and Analysis

AFS (30): Intangible Assets Recognition and Amortisation

AFS (30): Intangible Assets Recognition and Amortisation

AFS (29): Impairment Impact on Net Margin and ROA Ratios

AFS (29): Impairment Impact on Net Margin and ROA Ratios

AFS (28): Impairment of Fixed Assets in IFRS

AFS (28): Impairment of Fixed Assets in IFRS

AFS (27): Types of Non Current Assets

AFS (27): Types of Non Current Assets

CFA Level 1 Fixed Income Securities Bond Valuation

CFA Level 1 Fixed Income Securities Bond Valuation

CFA Level 1 Corporate Finance WACC

CFA Level 1 Corporate Finance WACC

AFS (26): Current Liabilities

AFS (26): Current Liabilities

AFS (25): Inventory Valuation and Analysis

AFS (25): Inventory Valuation and Analysis

AFS (24): Trade Receivables Analysis

AFS (24): Trade Receivables Analysis

AFS (23): Classified and Liquidity based Balance Sheets

AFS (23): Classified and Liquidity based Balance Sheets

AFS (22): Comprehensive Income (OCI)

AFS (22): Comprehensive Income (OCI)

AFS (21): Ratio Analysis of Income Statement

AFS (21): Ratio Analysis of Income Statement

AFS (20): Earnings Analysis of a Company

AFS (20): Earnings Analysis of a Company

AFS (19): Profitability Analysis of a Company

AFS (19): Profitability Analysis of a Company

AFS (18): Growth Analysis of a Company

AFS (18): Growth Analysis of a Company

AFS (16): Basic EPS and Diluted EPS

AFS (16): Basic EPS and Diluted EPS

AFS (17): Diluted EPS with Antidilutive Securities

AFS (17): Diluted EPS with Antidilutive Securities

AFS (15): Expense Recognition and Analysis

AFS (15): Expense Recognition and Analysis

AFS (14): Gross vs Net Reporting of Revenues

AFS (14): Gross vs Net Reporting of Revenues

AFS (13): Installment and Cost Recovery Revenue Recognition Methods

AFS (13): Installment and Cost Recovery Revenue Recognition Methods

AFS (12): Completed Contract Revenue Recognition Method

AFS (12): Completed Contract Revenue Recognition Method

AFS (11): Percentage of Completion Revenue Recognition Method

AFS (11): Percentage of Completion Revenue Recognition Method

AFS (10): Revenue Recognition Criteria and Analysis

AFS (10): Revenue Recognition Criteria and Analysis

AFS (09): Income Statement Analysis

AFS (09): Income Statement Analysis

AFS (08): IFRS vs US GAAP

AFS (08): IFRS vs US GAAP

AFS (07): Financial Reporting Standards and Framework

AFS (07): Financial Reporting Standards and Framework

AFS (06): Accounting Process and Analysis

AFS (06): Accounting Process and Analysis

AFS (05): Accounting Equation

AFS (05): Accounting Equation

AFS (04): Financial Reporting Process

AFS (04): Financial Reporting Process

AFS (03): Financial Analysis Framework

AFS (03): Financial Analysis Framework

AFS (02): Sources and Analysis of Financial Information

AFS (02): Sources and Analysis of Financial Information

AFS (01): Financial Statement Analysis

AFS (01): Financial Statement Analysis

Portfolio (Part 35) - Multiplier Models and Relative Valuation

Portfolio (Part 35) - Multiplier Models and Relative Valuation

Portfolio (Part 34) - FCFF and FCFE Valuation

Portfolio (Part 34) - FCFF and FCFE Valuation

Portfolio (Part 36) - Fintech in Investment Management

Portfolio (Part 36) - Fintech in Investment Management

Portfolio (Part 33) - DDM Valuation

Portfolio (Part 33) - DDM Valuation

Portfolio (Part 32) - Valuation

Portfolio (Part 32) - Valuation

Portfolio (Part 31) - Information Ratio

Portfolio (Part 31) - Information Ratio