Monthly Income and Expense Dashboard

Overview: The workbook tracks monthly income, expenses, and provides a 15-year income projection (2026-2040) with built-in inflation (3%) and tax rate (25%) adjustments. It's set up for USD/INR/EURO based on your region.

Key Features:

• Dashboard Sheet: Displays key metrics including monthly net income , budgeted vs. actual expenses, surplus/deficit analysis, and financial health indicators. 
  
• Monthly Income Sheet: Tracks gross and net income for each month, factoring in taxes and inflation adjustments.
  
• Expense Sheet: Details 14 expense categories (rent, EMIs, utilities, insurance, travel, etc.) with budget allocations as percentages of income versus actual spending.
  
• Annual Income Sheet: Projects income growth over 25 years with a annual increase assumption.
  
• Dropdown Sheet: Contains reference data for dropdowns (currencies, years, months, yes/no options).
  
• 
  

Financial Insights: The dashboard shows a debt-to-income ratio, financial health score , and suggests investment options for surplus funds based on your jurisdiction (basis the currency you select). e.g. If you choose your currency as USD, the dashboard will provide investment options in USA. Similarly for EURO and INR.

Recommended Uses

• Monthly Reviews: Update actuals each month to track trends
• Goal Setting: Use projections to plan major purchases, retirement, or debt payoff
• "What-If" Scenarios: Adjust inflation, tax rates, or income growth to model different futures
• Accountability: The visual status indicators (✓ OK, ⬆ OVER) make budget adherence clear at a glance