🚀 Medial Secures Investment on Shark Tank India - Fueling the Future of Professional Social Networking. 🔥
Login

Back

Siddharth Shahu

FMVA • 7h

I recently worked on a variance analysis case study in Excel to understand how real business factors impact profitability. Case Overview For a soft drink company, the comparison was: • Budgeted Profit: ₹2,00,000 • Actual Profit: ₹1,78,000 ➡ Profit declined by ₹22,000 Breaking Down the Variance Using a waterfall analysis, I identified the following drivers: Negative Impact • Sales Volume Decline: -₹80,000 → Sales dropped from 50,000 to 46,000 units, significantly impacting revenue. Positive Impact • Price Increase: +₹46,000 → Selling price increased from ₹20 to ₹21. Key Insight The most important takeaway from this analysis: Even though the company increased prices and controlled costs, the decline in sales volume had the largest negative impact on profitability. I’m currently building my skills in Financial Analysis, Credit Risk, and working on such case studies to strengthen my practical understanding. Happy to connect with professionals in finance, banking, and analytics.

Reply
1

More like this

Recommendations from Medial

Image Description

Dhandho Marwadi

Welcome to the possi... • 11m

📊 HDFC Securities FY25 Performance Analysis A) Strong Growth Across Core Metrics Operating Revenue jumped 23% YoY to ₹3,264 Cr (vs ₹2,660 Cr in FY24), reflecting a robust uptick in broking, distribution, and retail activity. Operating Profit rose

See More
1 Reply
5
Image Description
Image Description

SHIV DIXIT

CHAIRMAN - BITEX IND... • 1y

📖 DAILY BOOK SUMMARIES 📖 🔗 DIRECT FREE E-BOOK DOWNLOAD LINK AVAILABLE — https://drive.google.com/file/d/18xYnImrwK8k4kYlK4TmUjcTsYckwaK_Z/view?usp=drivesdk 🔥 The Art Of Profitability 🔥 🚀 20 Lessons 👉 ✨ By Adrian Slywotzky ✨ 1. Profita

See More
2 Replies
13
11

Yogesh Jamdade

..... • 1y

Data analysis for business: Data analysis is a powerful tool that businesses can leverage to gain a competitive advantage. Here are some of the key ways it's useful: Understanding Customers:Businesses can analyze data on sales, demographics, and cu

See More
Reply
2
6
Image Description

PRATHAM

Experimenting On lea... • 2y

Pw profit has declined 90% in fy23 . People say this is because they don't want to pay taxes and I think it's weird. I mean on that note every business should show less profit nah. Yea they may show less profit then actual figure but they showed 90

See More
1 Reply
1
4

Pradeep Kumar Hans

Vardhan Group - Ecom... • 1y

Flipkart Seller Account Management Here we provide you support for flipkart seller account growth and increased sales. support will be 1 Cataloging ( Unlimited listing ) 2 Price Analysis 3 Competitive Price 4 Promtion Offer Participation 5 Adve

See More
Reply
5

Account Deleted

Hey I am on Medial • 1y

TATA CONSULTANCY SERVICES LTD - A One-Minute Fundamental Analysis As part of the Tata Group, Tata Consultancy Services (TCS) is a global IT services leader. Known for innovation, excellence, and sustainability, TCS serves over 600,000 professionals

See More
Reply
Image Description

Capital Wire

Breaking Down Billio... • 25d

Bacca Bucci continued its growth in FY25 with strong demand for its footwear. Nearly all revenue came from product sales, but rising costs pressured margins. Expenses increased as inventory and employee costs rose, despite lower marketing spend. The

See More
1 Reply
3
Image Description
Image Description

Vinayak Shivanagutti

🚀7M+ Post Impressio... • 1y

Case Study: PhonePe – India's UPI Leader Founded in 2015, PhonePe dominates India's digital payments landscape. Stats: Users: 350M+ registered Market Share: 40%+ of UPI transactions Business Model: Transactions, financial services, advertising. R

See More
16 Replies
10
47
Image Description

Vivek Kethavath

Finance | Start-up • 1y

Q3 Dec Results Analysis!🚨🚨🚨 As of today, 599 companies have declared the results. Out of 599: 🟢338 have reported positive results. 🔴241 have reported negative results. 🟠30 have given neutral results. °•° Cumulative Revenue Growth has been ju

See More
1 Reply
2
Image Description

Shreya Sinha Roy

 • 

Capgemini • 1y

I am trying to grab a job as a data analyst and I have added the following projects in my GitHub portfolio.. 1. Restaurant Order Analysis ( MySQL) 2. Blinkit Data Analysis (Excel) 3. Fuel Market Price Analysis (Power BI) 4. Danny's Diner Case Study

See More
1 Reply
2
6

Download the medial app to read full posts, comements and news.