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
  • Tags

Most Popular Posts Today

How to Buy Crypto with the Help of AI [Video]
►
Categories
Resources for Accountants

How to Buy Crypto with the Help of AI [Video]

Cryptocurrency investing has grown exponentially in the last decade, and artificial intelligence (AI) is making it more accessible and smarter than ever. Whether you're a beginner or a seasoned trader, AI can help you make more informed decisions, manage risks, and automate processes. In this guide, we’ll walk you step by step through how to buy cryptocurrency using AI tools and platforms.

Key Steps and Strategies for Starting a Business [Video]
►
Categories
Resources for Accountants

Key Steps and Strategies for Starting a Business [Video]

Starting a business is an exciting and challenging endeavor that requires careful planning and strategic execution. Whether you are launching a small startup or a large enterprise, understanding the key steps and strategies involved is essential for turning your vision into a successful venture. This video outlines the crucial stages and tactics to help you navigate the complexities of starting a business and increase your chances of long-term success.

Most Popular This Week

How to Account for Early Retirement of Bonds [Video]
►
Categories
Resources for Accountants

How to Account for Early Retirement of Bonds [Video]

This video explains how to account for the early retirement of bonds (aka early extinguishment of debt or early redemption of bonds).When a company retires (redeems) its bonds prior to the maturity date, the company must do several things:-Reduce the cash account by the amount used to repurchase the bonds (if cash is used to retire the bonds)-Remove the bonds payable-Zero out the unamortized discount or unamortized premium-Record a gain or loss IF the repurchase price is different from the carrying value (aka book value) of the bonds on the date the bonds are retiredThere are two ways to calculate the gain or loss on the early retirement of the bonds:(1) record the journal entry; if a debit is required to make the journal entry balance, then debit a loss on early retirement (or loss on bond redemption, loss on early extinguishment of debt, etc.). If a credit is instead required to make the journal entry balance, the credit a gain on early retirement (or gain on bond redemption, gain on early extinguishment of debt, etc.)(2) calculate the difference between the repurchase price (the amount paid to retire the bonds) and carrying value (aka book value) of the bonds at the time they are retired. If the repurchase price is less than the carrying value, there is a gain. If the repurchase price is greater than the carrying value, there is a loss.0:00 Introduction0:39 4 things to do when retiring bonds1:20 Example3:59 T-account for discount on bonds payable4:18 Journal entry to record gain on retirement of bonds5:53 Alternative situation (loss on retirement of bonds)— 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

  • Tags
Taking the Pipeline Pledge [Video]
►
Categories
Resources for Accountants

Taking the Pipeline Pledge [Video]

Mark Koziel, CEO of the AICPA, encourages accountants to take the Pipeline Pledge, an initiative of the National Pipeline Advisory Group. Its goal is to spur CPAs to volunteer and take action to increase awareness of accounting among K-12 and college students, and to support those considering a career in the profession. Visit https://www.accountingpipeline.org/participate/