personal-budget-analysis-mom

📊 Personal Budget Analysis with Month-over-Month (MoM) Trends

🎯 Problem Statement

Analyze monthly personal expenses to identify spending trends, category-wise behavior, and opportunities for better financial planning.

📁 Dataset

• Simulated personal expense dataset
• Covers 5 months (Feb–Jun 2026)
• Includes categories like Rent, Groceries, Utilities, etc.
• Designed for trend and category analysis

⚙️ Approach

• Structured raw data for analysis

• Created Pivot Tables for aggregation

• Calculated MoM percentage changes

• Built charts to visualize trends and category behavior

• 📊 Key Metrics

• Total Monthly Spend

• Month-over-Month (MoM) Change %

• Category-wise Expense Distribution

🛠 Tools Used

• Excel (Pivot Tables, MoM Calculations, Charts)

📊 Dashboard Preview

📈 Key Insights

• Groceries exhibit the highest volatility, with a 40% drop in March followed by a 33% increase in April
• Overall spending declined in March (-7.17%) and gradually stabilized in subsequent months
• Fixed expenses such as rent and insurance remain consistent, while discretionary categories fluctuate

💡 Recommendations

• Monitor high-variability categories to improve budget consistency
• Set spending limits for discretionary categories to reduce fluctuations
• Maintain fixed expense stability while optimizing variable expenses