Finance Internship

Module 1: Fundamentals of Accounting & Finance

Core accounting and finance principles to build a strong foundation for all finance tasks.

• Introduction to Finance and Financial System
• Basic Accounting Concepts & Principles
• Types of Accounts – Personal, Real, Nominal
• Journal Entries & Ledger Posting
• Trial Balance
• Cash Book, Bank Reconciliation Statement
• Financial Statements:
  • Trading Account
  • Profit & Loss Account
  • Balance Sheet

Practical

• Prepare journal entries for sample transactions
• Create basic financial statements for a small business

Module 2: GST (Goods & Services Tax)

Understand GST structure, registration, invoicing, returns and input tax credit mechanics.

• Introduction to GST
• Types of GST:
  • CGST
  • SGST
  • IGST
  • UTGST
• Registration under GST
• GST Rates and Classification of Goods & Services
• Reverse Charge Mechanism (RCM) – Basics
• Input Tax Credit (ITC)
• Blocked Credits under GST
• GST Invoicing & Returns

Module 3: Financial Statement Analysis & Time Value of Money

Analyze financial statements and learn time value of money concepts for valuation and decision making.

• Financial Statement Analysis:
  • Common Size Statements
  • Comparative Statements
• Ratio Analysis (Liquidity, Profitability, Leverage, Efficiency)
• Cash Flow & Fund Flow Statements
• Introduction to Time Value of Money (TVM)
• Future Value & Present Value concepts
• Compounding & Discounting Techniques
• Annuities and Perpetuities

Practical

• Ratio analysis for a listed company
• Cash flow statement preparation in Excel
• PV/FV calculations using formulas & Excel functions

Module 4: Corporate Finance & Cost of Capital

Key corporate finance topics including sources of finance, capital budgeting and cost of capital analysis.

• Introduction to Corporate Finance
• Sources of Finance: Equity, Debt, Preference Shares
• Capital Structure & Leverage
• Cost of Capital:
  • Cost of Debt
  • Cost of Equity
• WACC (Weighted Average Cost of Capital)
• Capital Budgeting Decisions:
  • Payback Period
  • NPV (Net Present Value)
  • IRR (Internal Rate of Return)
  • Profitability Index

Practical

• Calculate WACC for a company
• Capital budgeting problem-solving in Excel

Module 5: Investment & Risk–Return Concepts

Learn investment types, stock market basics and risk-return measurement for portfolio decisions.

• Investment vs Speculation vs Gambling
• Types of Investments:
  • Equity
  • Bonds
  • Mutual Funds
  • Real Estate etc.
• Stock Market Basics:
  • Primary vs Secondary Market
  • IPO process
  • Stock Exchanges
• Risk and Return Concepts:
  • Types of Risk
  • Expected Return
  • Standard Deviation
  • Beta
  • CAPM (Capital Asset Pricing Model)
• Portfolio Management Basics

Practical

• Analyze real stock data (price movements, returns)
• Calculate expected return & risk using Excel
• Introduction to financial data sources (NSE/BSE websites, Moneycontrol, Yahoo Finance)

Module 6: Financial Modelling & Excel for Finance

Master Excel tools and financial modelling techniques to build forecasting models and dashboards.

• Excel Basics for Finance:
  • Formulas
  • Functions (NPV, IRR, PMT, XIRR)
  • Pivot Tables
  • Charts
• Introduction to Financial Modelling
• Model Structure & Best Practices
• Building a Simple 3-Statement Model:
  • Income Statement
  • Balance Sheet
  • Cash Flow Statement
  • Linking Statements & Forecasting

Practical

• Build a 3-statement model for a small business case
• Create dashboards/charts for financial analysis

Module 7: Tally ERP 9

Hands-on Tally ERP 9 training covering accounting, inventory, payroll and GST entries with reporting.

• Tally ERP 9:
  • Inventory
  • Payroll
  • Cost Centers
• GST Entries & Returns
• Generating Reports
• Financial Reporting & Compliance Basics
• Financial statement preparation + Tally accounting

Practical

• Enter full-year transactions in Tally & generate reports
• Present financial analysis/project in Excel