Basic Financial Analysis Using Excel (Profit)

Описание: 📊 Basic Financial Analysis in Excel | Profit Modeling for Bulu Limited

In this video, we demonstrate how to build a profit analysis model in Microsoft Excel using a real-world case from Bulu Limited—a company managing t-shirt orders during a major tournament.

🧾 Case Overview:
Bulu Limited faces key business decisions around fixed and variable costs, demand uncertainty, and pricing strategy. With an order of 1,450 t-shirts and an expected demand of 1,500, understanding how costs and pricing affect profit is crucial.

💡 What You’ll Learn:
Difference between fixed costs (₹750 per order) and variable costs (₹8 per shirt)

Revenue projections based on fluctuating demand

Full-price sales: ₹18 per shirt during the tournament

Discounted sales: ₹6 per shirt post-tournament

Excel formulas for:

Total cost and total revenue calculations

Conditional revenue modeling using =MIN, =MAX, and =IF functions

Profit margin analysis under different order and demand scenarios

The impact of adjusting order quantity on overall profitability

This Excel-based financial model provides a clear view of how order planning, pricing strategy, and demand forecasting work together to influence business success.

📈 Great for students, entrepreneurs, and business analysts looking to apply financial analysis in Excel.