Categories
Resources for Accountants

Ratio Analysis (Step by Step Financial Ratios Tutorial) – Part 1 of 33 [Video]

Ratio Analysis (Step by Step Financial Ratios Tutorial) – Part 1 of 33

In this tutorial, we will learn what is Ratio Analysis along with step by step instructions to calculate financial ratios.

This is the 1st Part of our most comprehensive Ratio Analysis video series comprising of 33 videos. We have attempted to go beyond the conventional jargons in this extensive guide and instead focused on practical financial statement analysis used by Investment Bankers and Equity Research Analysts. In addition, using the Colgate Case Study, we have calculated Ratios in Excel from scratch (financials from 2016 to 2020).

—————————————
What is Ratio Analysis?
—————————————
Ratio analysis is a type of financial statement analysis that involves quantitative interpretation of a company’s financial performance in different areas. It gives insightful information on the company’s profitability, solvency, operational efficiency, and liquidity positions, as reflected by financial statements.

———————————-
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 Ratio Analysis in Finance, you can go to this link:
https://www.wallstreetmojo.com/ratio-analysis/

Connect with us!
Youtube ► https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1
LinkedIn ► https://www.linkedin.com/company/wallstreetmojo/mycompany/
Facebook ► https://www.facebook.com/wallstreetmojo
Instagram ► https://www.instagram.com/wallstreetmojoofficial/
Twitter ► https://twitter.com/wallstreetmojo

Watch/Read More
  • Tags

Most Popular Posts Today

Most Popular This Week

How to Transition from Startup to Established Company [Video]
►
Categories
Resources for Accountants

How to Transition from Startup to Established Company [Video]

The journey from a fledgling startup to an established company is akin to scaling a mountain—fraught with challenges, but also promising breathtaking vistas of growth and success. This transition marks a pivotal moment in the entrepreneurial odyssey, where the agility and creativity that characterized the startup phase must harmonize with the stability and maturity necessary for long-term sustainability. It's a delicate balance, requiring strategic foresight, operational finesse, and unwavering commitment. In this guide, we'll delve into the multifaceted process of transitioning from a startup to an established company, exploring key strategies and best practices to navigate this transformative journey.

30-Day Roadmap for New Controller or CFO (My Blueprint) [Video]
►
Categories
Resources for Accountants

30-Day Roadmap for New Controller or CFO (My Blueprint) [Video]

Join 10,000+ professionals who enrolled in the Controller Academy 🚀 https://controller-academy.com/courses/controller-academy Get your copy of the 30-day roadmap: https://thefincontroller.com/p/30dayroadmap I am a CPA in the United States and I summarize in the video what new Controllers and CFOs need to focus on during their first 30 days in the role. Videos mentioned during this tutorial: Balance Sheet Reconciliation: https://youtu.be/rXavkEg4Ht0 How to create month-close checklist https://youtu.be/m_SfIf8PKpg Time Stamps: 00:00 Intro 00:36 Agenda 01:15 1. Financial Statement Review 02:46 2. Budget 04:50 3. Internal Controls 08:45 4. Systems 12:41 5. Month-end 14:31 6. People 17:15 7. Compliance 20:15 8. Create 90 day roadmap ----------------------------------- Hang Out with me on social media: 📸 https://www.instagram.com/the_financial_controller/ 📱https://www.tiktok.com/@thefinancialcontroller https://www.linkedin.com/in/bill-hanna-cpa-7653a851/ DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week! All views expressed on my channel are mine alone. Not intended as financial or professional advice