Finance Portfolio

Shweta Thapa

Finance Intern · Finance Trainee · Equity Analyst Intern

B.Com graduate with 2 years of recruitment experience, now moving into finance. Completed a financial modelling course with DCF valuation and project finance projects in Excel. Looking for a Finance Intern, Finance Trainee or Equity Analyst Intern role where I can learn on real projects.

Dehradun, Uttarakhand, 248001swessthp2000@gmail.comLinkedIn

Finance Projects

Models built from the ground up

Two Excel models completed during my financial modelling course — a DCF valuation and a three-statement project finance model.

Discounted Cash Flow

DCF Valuation of Titan Company Ltd

Built a DCF model in Excel from annual reports, forecasting free cash flows and estimating value per share using WACC & Terminal Value.

Method

  • Annual reports
  • Forecast FCF
  • Discount at WACC
  • Terminal Value
  • Value per share

Project Finance

Project Finance Model: Travel Agency

Built a project finance model in Excel covering Three Financial Statements, IRR and NPV.

Method

  • Income Statement
  • Balance Sheet
  • Cash Flow
  • IRR & NPV

Capabilities

Skills & toolkit

Financial Modelling

Course projects, built in Excel

  • DCF valuation
  • Project finance model

Financial Statements

Core financial statements

  • Balance Sheet
  • Income Statement

MS Excel

Lookup and aggregation functions

  • XLOOKUP
  • INDEX-MATCH
  • SUMIFS

Reporting & Records

Accurate, detail-focused, well organised

  • Data entry
  • Reporting
  • Record-keeping

Professional Experience

Two years of analytical groundwork

Recruitment taught me to work accurately with people, data and trackers — the habits I now bring to finance.

  1. Talent Acquisition — People North Adcon

    11/2024 – 07/2026
    • Screened and shortlisted candidates, and maintained hiring trackers and reports in Excel.
  2. IT HR Recruiter Intern — TechHost Services

    07/2024 – 10/2024
    • Sourced and screened IT candidates and tracked follow-ups.
  3. HR Intern — Collegetips.in

    05/2024 – 06/2024
    • Supported HR operations with data entry and record-keeping.

Background

Education & certification

Education

  • Bachelor of Commerce (B.Com)
    DAV PG College, Dehradun
    2021  ·  64%
  • Intermediate
    KVS Birpur, Dehradun
    2018  ·  67%
  • Matriculation
    KVS Birpur, Dehradun
    2016  ·  68%

Certification and additional information

Certification

Financial Modelling

Mentors Me Careers · October 2026

Languages

  • English
  • Hindi
  • Nepali

Interests

  • Nature photography
  • Sports

Get in touch

Open to finance internships and trainee roles

I’m looking for a Finance Intern, Finance Trainee or Equity Analyst Intern role where I can keep learning on real projects. The quickest way to reach me is email.