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

How to Start and Fund Your Own Business [Video]

Embarking on the journey of starting and funding your own business is akin to setting sail on uncharted waters. It's a thrilling yet daunting endeavor that demands a blend of creativity, strategy, and financial acumen. In today's dynamic business landscape, where innovation and disruption reign supreme, the allure of entrepreneurship beckons individuals eager to carve their own path and leave a mark on the world. However, navigating the complexities of business ownership requires careful planning, unwavering commitment, and access to adequate funding. This guide aims to illuminate the path ahead, offering a roadmap for aspiring entrepreneurs to transform their vision into a tangible business reality.

Categories
Resources for Accountants

What are the different types of Hedge Accounting models? [Video]

Bob will help you "close the GAAP" on what the different types of hedge accounting models are and when to use them. Check out his quick video explanation here! If you are interested in learning more, explore our eLearning courses on our GAAP Dynamics Learning Library: ASC 815: Hedge Accounting (Course Collection): https://www.gaapdynamics.com/product/asc-815-hedge-accounting/ Financial Instruments: Hedge Accounting Under IFRS 9: https://www.gaapdynamics.com/product/financial-instruments-hedge-accounting-under-ifrs-9/#collection-cards

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

Cheap Car Insurance Renewal Cost ★ 2022 [Video]

Discover cheaper car insurance renewal cost. Here’s the free service we use to get cheaper car insurance (toll free): 1-855-981-7528. It’s a free by phone service that specializes in locating the cheapest car insurance rates. They perform the tedious task of shopping around, and present you with the cheapest auto insurance provider for your location. We call this service every year before our auto insurance expires. It allows us to discover whether there is a cheaper rate than ours, and has saved us lots of money over the years. Here are some of the topics covered in this video: How to get cheaper auto insurance rates online, get discounts and lower your policy cost, ways to lower vehicle insurance premium cost, which are the best car insurance companies and why Geico, National, Progressive, Allstate, Root, State farm, General, or farmers are not always the best bet. Why Dave Ramsey is not always right. Ways to get affordable drivers insurance quotes, how to locate the best cheap automobile insurer for a specific location. For more ways to save on your car insurance rates, see here: https://www.bizmove.com/auto-car-insurance/