1.1 Accounting Refresher & Financial Statement Understanding

• Interpret balance sheets, income statements, and cash flow statements
• Reconstruct financial statements using raw accounting data
• Identify red flags and accounting manipulations

1.2 Corporate Finance Basics

• Explain time value of money, NPV, IRR, payback
• Evaluate capital budgeting decisions using DCF techniques
• Assess cost of capital, WACC, and hurdle rate selection

1.3 Excel for Finance – Core to Advanced

• Automate financial tasks with formulas, pivot tables, and lookups
• Build dynamic models using named ranges and data validation
• Apply advanced tools like Power Query, solver, and what-if analysis

2.1 3-Statement Model (Beginner to Pro)

• Link P&L, balance sheet, and cash flow into a dynamic model
• Integrate circularity and debt schedules accurately
• Perform historical analysis and future projections

2.2 Working Capital & Forecasting Techniques

• Forecast drivers like DSO, DPO, inventory turnover
• Apply top-down and bottom-up forecasting approaches
• Integrate operational and financial assumptions into models

2.3 13-Week Cash Flow Model

• Structure short-term liquidity planning for stressed scenarios
• Model weekly inflows/outflows, beginning and ending cash balances
• Apply for internal treasury, VC-backed startups, and distressed assets

3.1 DCF Valuation

• Forecast free cash flows and terminal value
• Calculate WACC and discount cash flows to present value
• Interpret output using valuation bridges and sensitivities

3.2 Comparable Company & Transaction Analysis

• Identify peers and normalize multiples (EV/EBITDA, P/E)
• Build comps table using public filings and market data
• Analyze transaction premiums and synergies from M&A deals

3.3 Football Field & Sensitivity/Scenario Modeling

• Visualize multiple valuation techniques using a football field
• Stress test models using sensitivity and scenario tables
• Present valuation output for executive decisions

4.1 LBO Model

• Build transaction structure with equity, debt, and fees
• Model debt schedules, interest, and exit scenarios
• Calculate IRR, cash-on-cash returns, and sensitivity analysis

4.2 Private Equity Returns Model

• Analyze deal flow, entry/exit multiple, and fees
• Compute net IRR, DPI, TVPI and cash waterfalls
• Apply to portfolio tracking and fund-level modeling

4.3 VC & Cap Table Modeling

• Model pre/post-money valuation and dilution impact
• Build multi-round financing cap table with liquidation preferences
• Evaluate convertible notes and SAFE instruments

5.1 M&A Accretion/Dilution Model

• Evaluate pro forma EPS and synergy impact
• Model financing structure – cash, stock, debt mix
• Analyze buyer/seller value creation and sensitivity

5.2 IPO Valuation Model

• Prepare offering valuation based on comps and DCF
• Estimate proceeds, dilution, and pricing strategy
• Model post-IPO cap table and ownership structure

5.3 Returns Analysis & Holding Period IRR

• Evaluate exit multiples and public vs private exits
• Compute holding period IRR, MOIC, and scenario impact
• Present investor-level returns through data visuals

6.1 SaaS Model

• Forecast MRR, churn, CAC, and lifetime value
• Model cohorts, unit economics, and retention
• Link growth drivers with COGS and burn

6.2 Real Estate & Waterfall IRR Model

• Build schedule of construction, lease-up, and exit
• Calculate IRR using tiered waterfall with hurdles
• Model equity splits and refinancing impact

6.3 Project Finance & Oil & Gas Models

• Model multi-phase infrastructure projects with DSCR covenants
• Build oilfield revenue model using reserve and production metrics
• Structure SPV financing, debt sculpting, and cash waterfalls

6.4 Banking & Insurance Models

• Model loan books with NPAs, provisions, and NIM
• Evaluate capital adequacy, Basel norms, and ROE
• Forecast claims, reserves, and underwriting ratios

6.5 F&O and Feasibility Study Models

• Simulate payoff of options and build Black-Scholes pricing
• Create feasibility models with break-even and IRR
• Use sensitivities to assess decision under uncertainty

7.1 Power BI and Tableau for Finance

• Build dynamic financial dashboards with drill-downs
• Connect and clean data using Power Query/Dataflows
• Create KPI visuals and reports for management

7.2 Executive Dashboards in Excel

• Use charts, slicers, and pivot tables to create CxO-ready views
• Build dynamic scorecards and operational summaries
• Embed dashboards into models with macros or navigation menus

7.3 Investor Decks and Management Presentations

• Convert models into storylines for decks and pitches
• Use visual hierarchy and slide structuring principles
• Customize outputs for PE, IB, VC, and board meetings

8.1 ChatGPT & AI Tools for Modeling

• Generate model skeletons and sensitivity outputs using prompts
• Automate valuation write-ups and financial summaries
• Use AI to audit or review models with context

8.2 Automation Using Excel + Python

• Automate reporting workflows via Python scripting
• Connect APIs, scrape financial data, and create live models
• Auto-generate charts, tables, and PowerPoint slides

8.3 Integrations and Model-Driven Apps

• Connect Excel models to Power BI and Google Sheets
• Use Zapier/Power Automate for finance-related workflows
• Create interactive web models using Streamlit

9.1 Python Basics for Finance

• Master NumPy, pandas, and financial functions
• Import, clean, and manipulate time-series financial data
• Build dashboards using matplotlib and seaborn

9.2 Advanced Finance Modeling in Python

• Create DCF, LBO, and portfolio return models
• Apply Black-Scholes, Monte Carlo, and regression models
• Backtest strategies using Python notebooks

9.3 Machine Learning in Finance

• Build classification models for credit scoring
• Forecast cash flows using time series (ARIMA/LSTM)
• Use clustering for customer or asset segmentation