60 days1 hour a day, liveCapstone project reportPlacement assistance

Financial Analysis & Modelling Internship

A 60-day practical financial analysis and modelling programme taught live by HireCraft360 faculty: 45 days of core financial modelling (3-statement models, DCF valuation, FP&A and capital budgeting) and 15 days of soft skills, with career support and a capstone equity research report.

I'm interested

About the programme

Format
One live, instructor-led hour every day for 60 days: 45 days of core financial modelling training and 15 days of soft skills training, plus a live 3-statement and valuation model and a capstone project report.
Who it is for
B.Com, BBA and MBA (Finance) students, CA, CMA and CFA aspirants, fresh graduates and anyone aiming at investment banking, equity research or FP&A roles.
What you leave with
Excel financial models built from scratch, a company valuation portfolio, an equity research report, an ATS-friendly finance resume and an updated LinkedIn profile, and an internship completion certificate.
Duration
60 days: 45 days core + 15 days soft skills.
Programme fee
₹20,000, paid once.
Batch dates
To be announced. Leave your contact in the form on this page and we will tell you first.

What you get

60 hours of live teaching

A one-hour hands-on modelling session every day with HireCraft360 faculty: 45 days of core financial modelling and 15 days of soft skills. Nothing is pre-recorded.

Built from a blank spreadsheet

No templates: you construct dynamic 3-statement, DCF and FP&A models in Excel yourself, formula by formula.

Project report

An equity and valuation project report of 25 to 35 pages, structured for college submission, with a dynamic Excel model workbook to show in interviews.

Certificate on completion

A certificate after you complete the classes, submit the project report and clear the final evaluation. Details come with the batch announcement.

What you will learn

  • Master advanced Excel shortcuts, formatting standards and logical functions.
  • Build fully integrated 5-year 3-statement financial models from scratch.
  • Perform intrinsic (DCF) and relative valuations (trading and transaction comps).
  • Carry out financial planning and analysis (FP&A) variance and capital budgeting tasks.
  • Compile and present an equity research report of 25 to 35 pages.

Curriculum: 12 modules

Taught over 60 days (45 days core + 15 days soft skills), one live class a day. Open a module to see its topics.

Module 01 Advanced Financial Excel & Corporate Finance
  • The corporate finance ecosystem and career paths (investment banking, FP&A, credit).
  • Formatting standards (colour coding inputs and formulas) and error auditing.
  • Financial lookup functions: XLOOKUP, INDEX-MATCH, SUMIFS, dynamic arrays.
Module 02 Financial Statement & Ratio Analysis
  • Reading annual reports and 10-Ks, and parsing footnotes.
  • Statement normalisation: non-recurring items and EBITDA adjustments.
  • Profitability, liquidity and solvency ratios (ROE, ROA, CCC, debt-to-equity).
  • DuPont analysis and common-size statements.
Module 03 3-Statement Financial Modelling Basics
  • Financial modelling architecture: the assumptions tab and granular schedules.
  • Historical data extraction and cleaning from Screener and SEC filings.
  • Revenue and cost forecasting: top-down vs. bottom-up drivers.
Module 04 Advanced Modelling & Schedules
  • Working capital schedule: DSO, DIO, DPO.
  • Fixed assets, debt and shareholder equity schedules.
  • Linking the three statements and handling circularity.
  • Scenario and sensitivity modelling: bull, base and bear case toggles.
Module 05 Corporate Valuation Fundamentals
  • Enterprise value (EV) vs. equity value, diluted shares, the net debt bridge.
  • Free cash flow calculation: FCFF vs. FCFE.
  • Cost of capital (WACC): CAPM, beta, risk-free rate.
Module 06 Discounted Cash Flow (DCF) Modelling
  • Forecasting explicit-period cash flows and mid-year discounting.
  • Terminal value estimation: Gordon growth vs. exit multiple method.
  • DCF sensitivity analysis: two-way data tables and football field charts.
Module 07 Relative Valuation & M&A Overviews
  • Trading comps: selecting peers, EV/EBITDA and P/E multiples.
  • Precedent transaction analysis: control premiums.
  • Introduction to M&A accretion and dilution, and LBO mechanics.
Module 08 FP&A, Budgeting & Unit Economics
  • Financial planning: annual operating plan (AOP), rolling forecasts, zero-based budgeting.
  • Budget vs. actuals variance analysis (price, volume, mix).
  • Startup unit economics: CAC, LTV, burn rate, runway.
Module 09 Capital Budgeting & Project Finance
  • Capital budgeting decisions: NPV, IRR, XIRR, payback period.
  • Project finance: operating and financial leverage, DSCR.
  • Detecting financial red flags and signs of earnings manipulation.
Module 10 LinkedIn Optimisation & Personal Branding
  • Optimising your profile for investment banking and corporate finance searches.
  • Networking strategies for breaking into finance roles.
Module 11 ATS Resume Building & Placement Preparation
  • Finance resume building (quantifying deal and model achievements).
  • Mock interviews on technical accounting and valuation concepts.
  • Placement assistance workflows and introductions to hiring partners.
Module 12 Capstone Equity Research & Valuation Project
  • Company or sector selection, and data gathering from NSE and BSE filings.
  • Drafting the company overview, industry analysis and valuation summary.
  • Deliverable: final project report, Excel workbook and equity pitch presentation.

Career support included

LinkedIn optimisation

Strengthen your professional profile so that finance recruiters and banks can find you.

ATS-friendly personalised AI resume builder

Use AI-assisted tools to build a customised analyst resume with quantified deal and model bullet points, structured for applicant tracking systems (ATS).

Placement assistance

Interview preparation, mock interviews (technical finance questions) and, once you complete the programme, introductions to HireCraft360's hiring partners.

Assessment and deliverables

Assessment Weight What it checks
Advanced Excel & Formatting 10% Speed, use of shortcuts and adherence to standard model formatting.
Financial Statement Analysis 15% Accuracy in DuPont analysis and in normalising statements.
3-Statement Model Build 25% A balance sheet that balances, schedule linkages and scenario toggles.
DCF & Relative Valuation 20% Correct WACC calculations, terminal values and peer group selection.
Capstone Equity Report & Pitch 30% Overall investment thesis, report structuring and presentation skills.

In your portfolio by the end

  • An automated financial ratio and DuPont analysis dashboard.
  • A fully integrated 5-year 3-statement Excel model.
  • An intrinsic valuation and sensitivity matrix (DCF) model.
  • An ATS-friendly finance resume and an optimised LinkedIn profile.
  • A bound or PDF equity and valuation capstone report (25 to 35 pages).

Capstone project report

Every intern completes a financial analysis and valuation project report of 25 to 35 pages, with a dynamic Excel model workbook behind it. It is structured for college submission, useful in a finance job portfolio, and required for certification.

Project tracks (choose one)

  1. Public equities: a comprehensive 3-statement model and intrinsic valuation (DCF and comps) of an NSE-listed company
  2. Credit and sector health: comparative financial ratio and DuPont analysis of the top five players in an Indian sector
  3. Venture and startups: startup unit economics, 5-year projections and an investor pitch valuation model
  4. Project finance: a capital budgeting and feasibility study (NPV, IRR and DSCR) for an infrastructure expansion

Report structure

  1. Title page, internship completion certificate and acknowledgment
  2. Executive summary and investment or financial recommendation
  3. Company profile, business model and industry analysis (Porter's five forces)
  4. Historical financial statement and ratio analysis (5-year trend)
  5. Key forecasting assumptions and 3-statement model projections
  6. Intrinsic (DCF) and relative valuation summary with sensitivity analysis
  7. Key risks, mitigants and strategic recommendations
  8. Annexure (income statement, balance sheet, cash flow, WACC and DCF model schedules)

Questions

When does the next batch start, and at what time are the classes?

Batch dates and the daily class time will be announced. Leave your contact in the form on this page and we will tell you as soon as they are fixed.

What is the fee?

The programme fee is ₹20,000, paid once by the student. How and when to pay will be shared with the batch dates. Filling in the form costs nothing and does not commit you to anything.

How are the classes held?

Live, one hour a day with HireCraft360 faculty for 60 days: 45 days of core training and 15 days of soft skills training. These are not recorded video lessons. How you join the class will be confirmed with the batch dates.

Will I get a job at the end?

We cannot promise a job, and no honest programme can. What you get is placement assistance: an ATS-friendly resume, LinkedIn optimisation, interview preparation, mock interviews and, once you complete the programme, introductions to HireCraft360's hiring partners. An offer depends on the employer and on your interview.

Will my college accept the project report?

The report follows a standard internship report structure so it can be submitted to a college. Acceptance rules differ between colleges and universities, so check the requirement with yours before you enrol.

What do I get at the end?

A certificate of completion, once you complete the classes, submit the project report and clear the final evaluation, plus the portfolio you built along the way. Who issues the certificate and what it covers will be announced with the batch.