Open to opportunities

Gaurav Rewari

@gauravrewari

Financial Analyst specializing in investment modeling, DCF valuation, and credit analysis for risk-aware lending decisions.

India

Message

What I'm looking for

I’m looking for a role where I can build DCF/valuation models, support credit underwriting with rigorous financial analysis, and apply forecasting, sensitivity, and risk assessment to drive sound investment and lending decisions.

I’m a finance postgraduate with hands-on experience in investment modeling and valuation, applying discounting techniques (NPV, DCF) and building Excel-based financial models to evaluate cash flow patterns and investment viability. I calculate WACC and perform relative valuation using multiples like P/E and EV/EBITDA to support enterprise valuation and decision-making.

In credit analysis, I assess borrower financial profiles using detailed evaluation of income, financial statements, and repayment capacity—supported by CIBIL analysis and key ratio work (IIR, LTV, NTH). I also run sensitivity and scenario analysis, structure valuation reports with risk-return dynamics, and ensure accuracy through financial statement analysis, forecasting, and regulatory-compliant loan processing.

Experience

Work history, roles, and key accomplishments

Credit Analysis Officer

Can Fin Homes Ltd.

Jun 2025 - Dec 2025 (6 months)

Built Excel-based DCF and valuation models (NPV, IRR) and assessed borrower financials to support credit underwriting decisions. Performed CIBIL and ratio-based risk evaluation, incorporated revenue and cash-flow projections, and ran sensitivity analyses to inform loan sizing and repayment capacity.

NPV IRR Analysis Financial Statement Analysis Credit Underwriting & CIBIL Checks Ratio Analysis (IIR LTV NTH)Sensitivity Analyses

Education

Degrees, certifications, and relevant coursework

Apeejay School of Management

Post Graduate Diploma in Management (PGDM), Finance & Marketing

2023 - 2025

Activities and societies: Discounted cash flow (DCF), NPV/IRR, WACC/cost of capital, financial statement analysis, scenario & sensitivity analysis, forecasting, ratio/performance evaluation, time value of money.

Completed a PGDM (Finance & Marketing) with coursework focused on financial analysis, time value of money, and valuation using DCF and related metrics. Built forecasting, scenario/sensitivity, and ratio/performance analysis models using Excel-based approaches.

Guru Gobind Singh Indraprastha University

Bachelor of Arts (Honours), Economics

2020 - 2023

Activities and societies: Financial statement analysis, ratio analysis and performance evaluation, time value of money (present/future value), WACC, forecasting, scenario & sensitivity analysis, investment and risk analysis, modeling in structured formats.

Earned a B.A. (Hons.) in Economics with applied training in financial statement analysis and investment/valuation fundamentals. Developed models for present and future value analysis, cost of capital (WACC), and scenario/sensitivity-based financial forecasting.

The Valuation School

Financial Modeling

Activities and societies: Advanced MS Excel (financial modeling, data structuring), data cleaning & transformation (raw to structured), Power BI (visualization), valuation/DCF modeling and integration of assumptions and outputs.

Learned financial modeling and valuation-related techniques, including building and structuring modeling outputs. Practiced data cleaning/transformation and visualization to support reporting and model inputs.