Learn Financial Modelling – Step by Step – Session 2

Financial modelling is a crucial skill for professionals in finance, business, and accounting. It involves building a mathematical representation of a financial decision-making situation, in order to forecast the consequences of different courses of action.

In this course, you will learn how to build financial models from scratch, using Microsoft Excel. We will start with the basics, such as setting up a balance sheet and income statement and then move on to more advanced topics, such as discounted cash flow analysis and sensitivity analysis.

Throughout the course, you will work on real-world examples and case studies, so you can apply the concepts you learn to your own financial modelling projects.

By the end of this course, you will have a strong foundation in financial modelling and be able to confidently create financial models to support decision-making in your professional life.

Start your journey towards becoming a financial modelling expert now!

📥 Download the Exercise Files –

📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp Channel (TVS Mentoring) –

📌SUBSCRIBE NEWSLETTER –
————————–

👉JOIN:

🔥REGISTRATION LINKEDIN COHORT :

🔥REGISTRATION EQUITY RESEARCH COHORT Latest Batch:

📛 Please refer to this video for all the Details of the Cohort:

✅ For queries, please reach to us on our Instagram handle: or DM us on WhatsApp – +91 9302017656

👉Register here for our latest Advanced Valuations and Financial Modelling Cohort
🔥 AVFM LIVE –
🔥 AVFM RECORDED –

————————–

✅ You can Connect with Parth Sir on Linkedin –

✅Follow The Valuation School page on Linkedin –

✅Join our Instagram handle –

00:04 Understanding Excel settings and functions for Financial Modeling
02:17 Learn how to optimize Excel for financial modeling
07:07 Learn about financial modeling in Excel and how to optimize your calculations and save time
09:33 Automate data table updates and use automatic calculation for efficient financial modeling.
14:44 Learn how to use the analysis tool pack in Excel for regression analysis.
18:03 Learn how to set up the analysis tool pack in Excel.
22:30 Learn how to format cells and columns in Excel
25:32 Learn Financial Modelling step-by-step
30:23 Formatting numbers in Financial Modelling
32:25 Understanding the conventions of color coding in financial modeling.
37:56 Learn how to audit and format cells in a financial model
39:55 Learn to avoid hardcoding numbers in financial modelling
45:51 Learn to group and organize data in financial modelling
48:44 Highlight the gross profit and add a border
52:33 Understanding the process of changing and checking formulas in financial modelling.
54:58 Understanding and implementing partial anchoring in revenue calculation.
1:01:29 Understanding and implementing financial modelling techniques
1:04:03 Immediate results from 5% with 100% impact.
1:09:48 Learn about custom formatting and applying it to numbers.
1:12:55 Hard coding and absolute anchoring are important in financial modelling.
1:17:40 The start date for this year is 15th August.
1:20:25 Learn about casting analysis and how to link cells in financial modelling
1:25:57 Min function is used to find the smallest number in a sequence
1:28:48 Learn how to express the condition ‘if less than’ in financial modeling
1:35:36 Learn Financial Modelling – Step by Step – Session 2

source