Fundamentals Of Financial Analysis By Leila Gharani – Free Download Course TeachAB – Xelplus
This Course Is Literally Designed To Help You Analyze Financial Statements Like a Pro · Develop X-Ray vision into your company’s finances, allowing you to see what you should see!
✅ About This Course:
✅ Course Author: Leila Gharani
✅ Official Course Price: $55
✅ Free For Our VIP Members? : Yes
✅ Download Links : Mega & Google Drive
✅ Course Size : 3.05 GB
✅ Updatable? : Yes, all future updates included.
✅ Sales Page : You can check at the bottom of this page.
🏆 Here’s What You Get & Learn With This Course:
How to reconcile the flow of financial transactions from journal entries to a trial balance
How to create and read the main financial statements and how they link
How to calculate metrics and ratios to judge financial performance
How to improve cash flow by managing your working capital
How to prepare Excel so you spend less time doing setup and more time gathering insights
How to apply theoretical time value of money concepts to real world projects so you make better decisions
Proven techniques for preparing sound forecasts and budgets
Course Cuirriculum:
Section 1: Introduction
Welcome to Financial Analysis Course
Download Course Material
Section 2: Financial Analysis Overview
What is Financial Analysis
Skills Needed for a Financial Analyst
Career Trajectory of a Financial Analyst
Section 3: Accounting – The Core Principles
What is Accounting and Why Do You Need it
Challenge: Debits and Credits
T-Accounts
Journal Entries
Trial Balance
Types of Financial Statements
Quiz: Accounting Basics
Key Takeaways: Core Principles
Section 4: Accounting Case Study – Accounting for a Beach Business
Accounting for a Beach Business – Getting Started
Accounting for a Beach Business – Journal Entries
Accounting for a Beach Business – Trial Balance
Accounting for a Beach Business – Financial Statements
Accounting for a Beach Business – What Happens Next Year
Section 5: Accounting – Essential Concepts
Cash VS Accrual Accounting
Depreciation – Basics
Depreciation – Example
Inventory and COGS
Inventory Cost Flow Assumptions
Quiz: Accounting Essentials
Key Takeaways: Essentials
Section 6: Financial Statements – Income Statement
Main Purpose and Components
Format of Income Statements
How to Read an Income Statement: Case Study – Microsoft
Constructing an Income Statement
Quiz: Income Statement
Section 7: Financial Statements – Balance Sheet
Assets – Definition
Assets – Types
Types of Liabilities
Equity
How to Read a Balance Sheet: Case Study – Microsoft
Constructing a Balance Sheet
Quiz: Balance Sheet
Section 8: Financial Statements – Cash Flow Statement
How to Read a Cash Flow Statement: Case Study – Microsoft
Cash Flow Operating: Direct VS Indirect Method
Constructing a Cash Flow Statement
Quiz: Cash Flow Statement
Section 9: Financial Statement Analysis
Important Ratios to Analyze Financial Statements
Calculating Growth
Horizontal vs. Vertical Analysis
Compound Annual Growth Rate (CAGR) Vs. AAGR
Quiz: Financial Statement Analysis
Section 10: Time to Test Your Knowledge
Congratulations – What You’ve Achieved so Far
Quiz: Test Your Knowledge
Challenge: Financial Statements
Section 11: Necessary Excel Functions for Financial Analysts
Most Common Excel Functions for Financial Analysis
TRIM Function
Median VS Mean Calculation
Common Date Functions
Calculating Working Days & Future Dates
Combine Text & Numbers
Excel SUMPRODUCT Function (Skip extra Calculations)
Challenge: Excel Functions
Key Takeaways: Necessary Excel Functions
Section 12: Important Excel Features for Financial Analysts
Goal Seek
Showing Numbers in Millions / Thousands
Tips for Proper Datasets (Good Functionality, Good Looks)
Advantages of Excel Tables
Conditional Formatting – Top / Bottom Analysis
Challenge: Excel Features
Key Takeaways – Important Excel Features
Section 13: Master Pivot Tables for Financial Analysis
Pivot Tables for Quick Data Analysis
Calculate Percentages & Change Aggregation in Pivot Tables
GetPivotData Function in Excel
Slicers in Pivot Tables to Create Dashboards
Working with Dates in Pivot Tables
Challenge: Pivot Tables
Create a Pivot Table from Multiple Sheets
Key Takeaways: Pivot Tables
Section 14: Common Charts & Graphs for Financial Analysis
Line Chart in Excel
Column Chart & Stacked Column Chart
Plotting Multiple Series (Line & Column Chart in One)
Charts in Cells – Sparklines in Excel
Waterfall / Bridge Chart in Excel
Pie Chart & Doughnut Chart in Excel
Pareto Chart
Challenge: Excel Charts
Section 15: Working Capital Management
Overview
Receivables
Inventory
Payables
Challenge: Working Capital
Quiz: Working Capital
Key Takeaways: Working Capital
Section 16: The Time Value of Money
The Time Value of Money Explained
Understanding Discounted Cash Flows (DCF)
Net Present Value (NPV)
Internal Rate of Return (IRR)
Calculating Payback Period with Varying Cash Flows
Weighted Average Cost of Capital (WACC)
Quiz: Time Value of Money
Key Takeaways: Time Value of Money
Section 17: Financial Leverage
Why Companies Take on Debt
Annuities (PMT)
Calculating Periods to Payback (NPER)
Calculating a Complete Loan Schedule
Calculate Interest Rate for a Loan
Challenge: Debt
Quiz: Financial Leverage
Section 18: Financial Forecasting
Simple Moving Average
Weighted Moving Average
Exponential Triple Smoothing
Allocating Yearly Values to Months
Variance and Standard Deviation
Regression Equation & Relationship between Variables
Regression Analysis
Quiz: Forecasting
Next Steps
Wrapping up & What You’ve Achieved
BONUS: Mini Course – Power Query for Financial Analysts
Will I Need Power Query?
Properly Structure Data in Seconds
Merge Pivot Table Report with Other Tables
Case Study: Import Messy SAP Data Extract into Excel
Pivot Table from Messy Data
Combine Data from Multiple Sheets into ONE Pivot Table
Import Data from PDF (Office 365)
The Power of Power Query
✅ Great X Courses Guarantee : At Great X Courses, we insist in providing high quality courses, with direct download links (no paid links or torrents). What you see is exactly what you get, no bad surprises or traps. We update our content as much as possible, to stay up to date with the latest courses updates.
For more info about this course, check out the sales page.
