Categories
Resources for Accountants

Horizontal Analysis (Step by Step Financial Ratio Analysis Tutorial) – Part 3 of 33 [Video]

Horizontal Analysis (Step by Step Financial Ratio Analysis Tutorial) – Part 3 of 33

In this tutorial, we’ll go over the finer details of Horizontal Analysis, including its formulas and step-by-step calculations. Following that, we will conduct a horizontal analysis of the Colgate Case Study and interpret the findings.

Download the Colgate Excel Model Ratio Analysis Template – We will use template for the analysis. You can download the ratio analysis template from this link – https://www.wallstreetmojo.com/ratio-analysis-template/

What is Horizontal Analysis?
——————————————–
Horizontal analysis, also known as trend analysis, refers to the percentage change in the same line item of a financial statement in the next accounting period compared to the value of the baseline accounting period. Horizontal analysis can be performed on any of the item in the income statement, balance sheet and statement of cash flows.

Formula
——————————————–
Horizontal Analysis formula = [(Amount in comparison year – Amount in the base year)/ Amount in a base year] x 100

Advantages of Performing Horizontal Analysis
——————————————–
• Horizontal analysis helps evaluate trends year over year (YoY) or quarter over quarter (QoQ), for example, how much has the revenue increased over the years.
• It enables investors to view and compare actual data for consecutive years.
• Horizontal analysis is simple to interpret. It does not require any special financial skill to understand the difference between the previous year’s data and the current data.

Links to Step by Step Financial Ratios Tutorials
——————————————–
• Part 1 – Ratio Analysis:
https://www.youtube.com/watch?v=yPUb6PsVvLA&list=PLazLoBfxFADN9Qq8j8hghG9nvVBXl1V0y

• Part 2 – Vertical Analysis:
https://www.youtube.com/watch?v=7CX4F2Adubs

What you need to do?
——————————————–
– Step 1: Download the Colgate Excel Model Ratio Analysis Template. This template will be used for the analysis. You can download the ratio analysis template from this link – https://www.wallstreetmojo.com/ratio-analysis-template/
– Step 2: Please note that we are providing you with downloadable and preformatted Excel spreadsheets to assist you in understanding and applying the concepts. You will receive two templates: 1) Unsolved Colgate Model 2) Completed Colgate Model
– Step 3: Start by using the “Unsolved Colgate Model Template” for analysis by following the instructions step by step.
– Step 4: Good Luck! 🙂
——————————————–

To know more about Horizontal Analysis in Finance, you can go to this link:
https://www.wallstreetmojo.com/horizontal-analysis/

Connect with us!
LinkedIn ► https://www.linkedin.com/company/wallstreetmojo/mycompany/
Facebook ► https://www.facebook.com/wallstreetmojo
Instagram ► https://www.instagram.com/wallstreetmojoofficial/?utm_medium=copy_link
Twitter ► https://twitter.com/wallstreetmojo
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe – https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw

Watch/Read More
Categories
Resources for Accountants

Master Advanced DAX in Power BI: Elevate Your Data Analysis Skills! [Video]

🚀 Looking to master complex data analysis in Power BI? Whether you're a data analyst, business intelligence professional, or someone aiming to enhance your DAX skills, this course is your gateway to advanced data modeling and analytics!​ 🎓 Introducing WallStreetMojo’s Advanced DAX in Power BI Training Course – Your comprehensive guide to mastering Data Analysis Expressions (DAX) for sophisticated data insights and reporting.​ ✅ 7+ hours of self-paced, expert-led video tutorials ✅ One-year unlimited access – Learn at your convenience! ✅ Hands-on Excel-based learning with downloadable templates ✅ Master advanced DAX functions, including CALCULATE, SUMMARIZE, and RANKX ✅ Learn to build complex data models and perform intricate calculations ✅ Earn a globally recognized certification upon course completion ✅ Rated 4.8⭐ by thousands of satisfied learners!​ 🔹 What You'll Learn: 📌 Deep dive into advanced DAX functions and their applications 📌 Create dynamic and interactive Power BI reports 📌 Implement complex business logic using DAX 📌 Optimize data models for performance and scalability 📌 Apply real-world scenarios to reinforce learning​ 📜 Upon completion, you'll receive a professional certificate to enhance your resume and open doors to opportunities in data analysis, business intelligence, and more.​ 💡 Join over 100,000 learners who have transformed their careers with WallStreetMojo. It's your turn to gain a competitive edge in the data analytics industry!​ 🎯 Start your journey to mastering advanced DAX in Power BI today – Click below to enroll now! 👇​ 🔗 https://www.wallstreetmojo.com/power-bi/advanced-dax-in-power-bi-course/ 📢 Subscribe for more practical data analytics training and career tips! 🔔 Turn on notifications to stay updated on the latest in Power BI education!

Categories
Resources for Accountants

Complete Guide to Options, Futures & Swaps! [Video]

🚀 Looking to master the world of derivatives and elevate your finance career? Whether you're a student, analyst, or professional aiming to deepen your understanding of financial instruments, this course is your gateway to becoming a derivatives expert!​ 🎓 Introducing WallStreetMojo’s Basic & Advanced Derivatives Bundle Course – Your comprehensive guide to understanding and applying derivatives in real-world scenarios, from foundational concepts to advanced strategies.​ ✅ 6+ hours of self-paced, expert-led video tutorials ✅ One-year unlimited access – Learn at your convenience! ✅ Hands-on Excel-based learning with downloadable templates ✅ Master forwards, futures, options, swaps, and risk management techniques ✅ Learn to evaluate derivative pricing using stochastic models ✅ Earn two globally recognized certifications upon course completion ✅ Rated 4.8⭐ by thousands of satisfied learners!​ 🔹 What You'll Learn: 📌 Differentiate between various derivative instruments 📌 Apply knowledge to real-world financial scenarios 📌 Implement hedging strategies to protect value 📌 Speculate and bet on future prices effectively 📌 Develop an analytical thought process for trading​ 📜 Upon completion, you'll receive two professional certificates to enhance your resume and open doors to opportunities in trading, risk management, portfolio management, and more.​ 💡 Join over 100,000 learners who have transformed their careers with WallStreetMojo. It's your turn to gain a competitive edge in the finance industry!​ 🎯 Start your journey to mastering derivatives today – Click below to enroll now! 👇​ 🔗 https://www.wallstreetmojo.com/derivatives/advanced-derivatives-certification-course-bundle/ 📢 Subscribe for more practical finance training and career tips! 🔔 Turn on notifications to stay updated on the latest in finance education!

Categories
Resources for Accountants

How to Account for Share Based Compensation [Video]

When a company grants share-based compensation that has a performance condition (which means a certain sales, profit, or other performance condition must be met in order for the share-based compensation to vest), the company must assess at the end of each period whether it is probable that the performance condition will be met. If it is not probable that the performance condition will be met, the company must reverse any compensation expense previously recorded for this share-based compensation (if no compensation expense was previously recorded, the company wouldn't make a journal entry). If it is probable that the performance condition will be met, the company should record compensation expense. Note that for share-based compensation with a MARKET condition (based on the stock price) instead of a performance condition, the company should record compensation expense whether or not it is probable that the market condition will be met. — Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world. — SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS: • A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING • A 44-PAGE GUIDE TO U.S. TAXATION • A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS • MANY MORE FREE PDF GUIDES AND SPREADSHEETS * http://eepurl.com/dIaa5z — SUPPORT EDSPIRA ON PATREON *https://www.patreon.com/prof_mclaughlin — GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT * https://edspira.thinkific.com — LISTEN TO THE SCHEME PODCAST * Apple Podcasts: https://podcasts.apple.com/us/podcast/scheme/id1522352725 * Spotify: https://open.spotify.com/show/4WaNTqVFxISHlgcSWNT1kc * Website: https://www.edspira.com/podcast-2/ — GET TAX TIPS ON TIKTOK * https://www.tiktok.com/@prof_mclaughlin — ACCESS INDEX OF VIDEOS * https://www.edspira.com/index — CONNECT WITH EDSPIRA * Facebook: https://www.facebook.com/Edspira * Instagram: https://www.instagram.com/edspiradotcom * LinkedIn: https://www.linkedin.com/company/edspira — CONNECT WITH MICHAEL * Twitter: https://www.twitter.com/Prof_McLaughlin * LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin — ABOUT EDSPIRA AND ITS CREATOR * https://www.edspira.com/about/ * https://michaelmclaughlin.com

Categories
Resources for Accountants

Financial Planning & Analysis Course Your guide to budgeting, forecasting, & financial analysis! [Video]

🚀 Aiming to excel in financial planning and analysis? Whether you're an aspiring FP&A analyst, finance professional, or business owner, mastering budgeting, forecasting, and financial modeling is your key to strategic decision-making!​ 🎓 Introducing WallStreetMojo’s Financial Planning & Analysis Course – Your comprehensive guide to budgeting, forecasting, and financial analysis with real-world applications!​ ✅ 11+ hours of self-paced, expert-led video tutorials ✅ One-year unlimited access – Learn at your convenience! ✅ Hands-on Excel-based learning with downloadable templates ✅ Master budgeting, forecasting, cost analysis, and dynamic financial modeling ✅ Understand FP&A's role in mergers, acquisitions, and investment strategies ✅ Earn a recognized certification upon course completion ✅ Rated 4.8⭐ by thousands of satisfied learners!​ 🔹 What You'll Learn: 📌 Build effective budgets and control costs for strategic financial planning 📌 Create robust financial models used by top investment banks and Fortune 500 firms 📌 Leverage Excel and automation tools to streamline financial planning and analysis 📌 Understand the role of FP&A in mergers, acquisitions, and investment strategies 📌 Analyze financial statements and drive data-driven decision-making​ WallStreetMojo 📜 Upon completion, you'll receive a professional certificate to enhance your resume and open doors to opportunities in financial planning, analysis, and corporate finance.​ 💡 Join over 100,000 learners who have transformed their careers with WallStreetMojo. It's your turn to gain a competitive edge in the finance industry!​ 🎯 Start your journey to mastering financial planning and analysis today – Click below to enroll now! 👇​ 🔗 https://www.wallstreetmojo.com/budgeting/financial-planning-analysis-course/ 📢 Subscribe for more practical finance training and career tips! 🔔 Turn on notifications to stay updated on the latest in finance education!