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

Overview of ASC 805 [Video]

Accounting for business combinations under ASC 805 can be quite complex! Do you know the difference between a business combination and an asset acquisition under U.S. GAAP? The answer to this question is important because the accounting is totally different! No worries. We have you covered in this CPE-eligible, eLearning course (1.5 CPE)! In this online course we begin with the definition of a business and whether a transaction falls within the scope of ASC 805. We then provide you with an overview of the 4-step acquisition method set out in ASC 805, including whether assets and liabilities acquired should be recognized apart from goodwill and, if so, how they should be measured. If you’re new to the accounting for business combinations under U.S. GAAP, this course is a great place to start! Take the course: https://www.gaapdynamics.com/product/business-combinations-overview-of-asc-805/ Buy all three courses and save! https://www.gaapdynamics.com/product/asc-805-business-combinations/ Learn more about GAAP Dynamics: https://www.gaapdynamics.com/ Check out our other online courses on the GAAP Dynamics Learning Library: https://www.gaapdynamics.com/individual-learning/ Subscribe to GAAP Dynamics to see more videos like these!

Categories
Resources for Accountants

How to Improve Your Verbal Communication Skills | Top 10 Verbal Communication Tips for Managers [Video]

Discover how to Improve Your Verbal Communication Skills. Effective verbal communication is an essential skill for managers, as it can greatly influence the success of their teams and organizations. By mastering the art of clear and concise verbal communication, managers can foster better relationships, boost productivity, and inspire their employees. To help you enhance your verbal communication skills as a manager, here are ten valuable tips, along with examples, to guide you in your journey.

Categories
Resources for Accountants

Application of ASC 805 [Video]

This is the introductory video for the third course of the three-part Business Combinations eLearning series. Now that you are familiar with the basic accounting rules and certain ASC 805 advanced issues, this course will apply that knowledge by walking through an example acquisition and requiring you to identify the proper accounting treatment. Take the course: https://www.gaapdynamics.com/product/business-combinations-application-of-asc-805/ Buy all three courses and save! https://www.gaapdynamics.com/product/asc-805-business-combinations/ Learn more about GAAP Dynamics: https://www.gaapdynamics.com/ Check out our other online courses on the GAAP Dynamics Learning Library: https://www.gaapdynamics.com/individual-learning/ Subscribe to GAAP Dynamics to see more videos like these!

Categories
Resources for Accountants

Advanced Issues and Disclosures [Video]

This is the introductory video to our self-study eLearning course "Business Combinations: Advanced Issues and Disclosures." Check it out here: https://www.gaapdynamics.com/product/business-combinations-advanced-issues-and-disclosures/ This is the second course of the three-part Business Combinations eLearning series. Now that you are familiar with the basic accounting rules, this course dives deeper into more advanced business combination issues such as exceptions to general guidelines, noncontrolling interests, and measurement period adjustments. Learn more about GAAP Dynamics: https://www.gaapdynamics.com/ Check out our other online courses on the GAAP Dynamics Learning Library: https://www.gaapdynamics.com/individual-learning/ Subscribe to GAAP Dynamics to see more videos like these!