My Excel Projects

A collection of advanced financial modeling and data analysis tools built for institutional corporate finance, variance analysis, and reporting efficiency.

Financial Modeling and Analysis Projects

vrinda_analysis.xlsx
Home Insert Formulas Data Review
fx
=PROJECT("Vrinda Store", "Retail Dashboard")

Vrinda Store Analysis

Interactive dashboard built with advanced Excel formulas, pivot tables, and conditional formatting to analyze retail store data metrics, tracking sales performance and inventory turnover.

Enabled data-driven retail decisions by analyzing sales performance, identifying top-selling categories, and optimizing inventory turnover, leading to improved revenue tracking and reduced stockouts.
Vrinda Store
Download Model
ar_aging.xlsx
Home Insert Formulas Data Review
fx
=TRACK(Invoices, Aging_Buckets)

AR Aging Report

Accounts receivable aging dashboard to systematically track outstanding invoices, categorize by aging buckets, gauge liquidity gaps, and maintain healthy corporate cash flows.

Improved cash flow visibility by categorizing outstanding receivables into aging buckets, enabling proactive collection strategies and reducing Days Sales Outstanding (DSO).
AR Aging
Download Model
dcf_valuation.xlsx
In Dev
Home Insert Formulas Data Review
fx
=NPV(WACC, FCF_Projections) + Terminal_Value

DCF Valuation Modeling

A standardized Discounted Cash Flow (DCF) model template featuring structured assumptions, WACC calculations, terminal value computations, and intrinsic value projections. Currently under active development.

Provides a standardized framework for equity valuation, enabling informed investment decisions through rigorous NPV and IRR analysis that quantifies the intrinsic value of a business.
fixed_assets.xlsx
Home Insert Formulas Data Review
fx
=CALCULATE_DEPRECIATION(Asset_Cost, Lifespan, "Straight-Line")

Fixed Asset Register

A detailed capital expenditure matrix for logging asset lifespan, computing straight-line and reducing balance depreciation, and auditing balance sheet carry structures.

Streamlined asset tracking and depreciation scheduling across the organization, ensuring accurate financial reporting, optimized CapEx budgeting, and full compliance with accounting standards.
Fixed Asset Register
Download Model
ai_audit.xlsx
Home Insert Formulas Data Review
fx
=IFERROR(AUDIT_MODEL(Data), "Discrepancy Found")

AI Fin-Model Audit

Comprehensive integrity check using advanced AI logic formulas to audit and rectify complex formulaic discrepancies in financial models.

Reduced financial modeling errors through automated discrepancy detection, saving hours of manual review time and significantly enhancing the reliability of complex financial models.
AI Fin-Model Audit
Audited Fixed
data_cleaning.xlsx
Home Insert Formulas Data Review
fx
=TRIM(CLEAN(Raw_Data))

Data Cleaning Practice

Hands-on exercises using Power Query, text functions (LEFT, RIGHT, MID), and advanced formulas (VLOOKUP, INDEX-MATCH) to transform raw data into analysis-ready formats.

Accelerated data preparation workflows by automating cleaning routines, reducing manual effort by over 60% and dramatically improving data quality for downstream analysis.
Data Cleaning Practice
Download Model
data_ai.xlsx
Home Insert Formulas Data Review
fx
=LAMBDA(x, MAP(x, CLEAN_DATA))

Data Cleaning AI

AI-powered data cleaning using modern Excel functions (LAMBDA, LET, MAP, SCAN) to automate data prep with intelligent pattern recognition.

Applied AI-powered Excel functions to automate complex data cleaning tasks at scale, slashing processing time from hours to minutes while minimizing human error.
Data Cleaning AI
Download Prompts
restorex_efp.xlsx
Home Insert Formulas Data Review
fx
=RECONCILE(Firm_Pricing, Core_Statements)

RestoreX EFP Model

Early Financial Planning model for RestoreX, a Discord bot project. Features financial tracking, budgeting, and projection workflows. Currently under active development.

Enabled early-stage financial planning and budgeting for a tech startup, providing clear visibility into projected costs, revenue streams, and resource allocation needs.
RestoreX EFP Model
Download Model
bartan_inventory.xlsx
Home Insert Formulas Data Review
fx
=CALCULATE(STR, Inventory, "Sell Through Rate")

Bartan Bazzar Inventory & STR

Cleaned messy inventory data and calculated Sell Through Rate (STR) and Stock Value for business impact analysis and data-driven decision making.

Delivered actionable insights into inventory performance through Sell Through Rate analysis, enabling optimized stock levels and improved working capital management for the business.
Download Model
personal_portfolio.xlsx
In Dev
Home Insert Formulas Data Review
fx
=CALCULATE_NET_WORTH(Investments, Assets, Liabilities)

My Personal Portfolio

Comprehensive personal portfolio analysis tracking investments, net worth, asset allocation, and financial goals with interactive visualizations. Currently under active development.

Provides a comprehensive view of personal investment performance, asset allocation, and net worth tracking, enabling more informed and data-driven financial planning decisions.
autovba_expenses.xlsm
Home Insert Formulas Data Review
fx
=AUTO_VBA("Expense Dashboard", "AI 3-Min Build")

AUTOVBA Expenses Dashboard

An interactive expense dashboard generated entirely by AI — Claude AI was prompted to auto-generate VBA code that builds a fully functional Excel dashboard with dynamic charts, pivot summaries, and category-level insights in under 3 minutes. Demonstrates the power of AI-assisted development for rapid financial tool prototyping.

Demonstrated a 10x productivity gain by generating a fully functional, production-ready expense dashboard in under 3 minutes through AI-assisted VBA automation.
Download Model View Prompt
smart_inventory.xlsx
Home Insert Formulas Data Review
fx
=INVENTORY_OPTIMIZE(Stock_Data, Reorder_Point)

Smart Inventory Stock Management

A robust Excel-based inventory management model designed to streamline stock tracking, optimise reorder levels, and deliver real-time visibility into stock movements. Incorporates automated reorder point calculations, stock turnover analysis, and comprehensive inventory valuation to support data-driven supply chain decisions.

Optimized inventory levels through automated reorder point calculations and stock turnover analysis, reducing carrying costs by up to 20% and preventing costly stockouts.
Smart Inventory Stock Management
Download Model