Financial analyst

MOHAMMED ARBAAZ KHAN

MBA (Finance)

636-***-**** **************@*****.*** RT Nagar, Bengaluru - 560032

LinkedIn: www.linkedin.com/in/mohammed-arbaaz-khan

Profile summary

MBA Finance graduate with strong knowledge in financial analysis, valuation, financial modelling, and

business analytics. Skilled in Advanced Excel, Power BI, ratio analysis, and dashboard reporting with hands-

on experience through internships and finance projects. Experienced in analyzing financial statements,

conducting Cost-Volume-Profit (CVP) analysis, and preparing data-driven financial reports for decision-

making. Seeking an entry-level Financial Analyst or FP&A Analyst role in a growth-oriented organization.

Skills

Financial Analysis & Corporate Finance

? Financial Statement Analysis

? Financial Reporting

? Financial Modelling & Valuation

? DCF Valuation

? Ratio Analysis & Trend Analysis

? Budgeting & Forecasting

? Cost-Volume-Profit (CVP) Analysis

? Break-Even Analysis

? Capital Budgeting (NPV, IRR)

? Enterprise Value & Equity Value Analysis

? Profitability & Cost Analysis

Data Analytics & Visualization

? Advanced Microsoft Excel

? Financial Dashboard Creation

? Power BI Dashboard & Reporting

? Data Visualization

? Pivot Tables & Pivot Charts

? VLOOKUP, XLOOKUP, INDEX-MATCH

? Power Query

Professional Skills

? Time Management & Task Prioritization

? Analytical Thinking & Problem Solving

? Business Communication

? Team Collaboration & Coordination

? Attention to Detail

? Report Preparation & Documentation

Education

? MBA (Finance) 2023-2025

VTU University, Bangalore Institute of Technology - Bengaluru

Specialization ? Finance

? Bachelor of Business administration 2019-2022

VSKUB University - Ballari, SMT. Sharadamma Kothbal College of Business MGT., Koppal

Certifications

1. Financial Modelling, Valuation & Investment Banking Certification ? edZeb

2. Data Analytics Job Simulation by Deloitte

Experience

1.Finance Intern

At Kalyani Steel Limited, Ginigera

? Analyzed financial statements and operational reports to identify profitability and cost trends.

? Assisted in preparing Excel-based financial reports and business performance summaries.

? Performed ratio analysis and CVP analysis to evaluate operational efficiency.

? Worked with financial data to support management reporting and business decision-making.

? Gained practical exposure to manufacturing finance, reporting standards, and cost analysis.

Academic & Personal Projects

1. Financial Ratio Analysis ? ConocoPhillips

? Conducted detailed analysis of financial statements to evaluate company performance

? Calculated key ratios such as liquidity, profitability, and solvency ratios

2. Internship - Organizational Review & Financial Analysis

Kalyani Steels Ltd., Ginigera - 1 Month

? Analysed organizational structure and business operations of the company

? Performed financial ratio analysis to assess performance and efficiency

? Gained knowledge of financial reporting standards and compliance practices

3. Final Year Project ? CVP & Trend Analysis

Kalyani Steels Ltd., Ginigera - 2 Months

? Conducted Cost-Volume-Profit (CVP) analysis across product lines to evaluate profitability.

? Calculated Break-Even Point, Margin of Safety, Contribution Margin, and Profitability trends.

? Performed trend analysis using financial data across multiple quarters.

? Used Excel for data analysis, financial calculations, and visualization.

? Interpreted cost behavior and operational efficiency for business decision-making.

4. Data Analytics Projects (Excel & Power BI)

? Developed employee performance and sales analytics dashboard using Excel

? Created interactive sales dashboard using Power BI for data visualization

5. PepsiCo Valuation & Financial Modelling Project

? Conducted company valuation analysis of PepsiCo using Discounted Cash Flow (DCF) and

Comparable Company Analysis methods.

? Analyzed PepsiCo financial statements including income statement, balance sheet, and cash flow

statement.

? Forecasted revenue growth, operating margins, and free cash flows using Excel-based financial

models.

? Calculated Enterprise Value, Equity Value, WACC, and terminal value for valuation assessment.

? Evaluated key financial ratios such as profitability, liquidity, leverage, and efficiency ratios.

Key Concepts Used:

? DCF Valuation

? WACC Calculation

? Enterprise Value & Equity Value

? Financial Forecasting

? Ratio Analysis

Language

English, Kannada, Hindi

Interest

Sports like volleyball, Chess, Carrom and cricket

Contact this candidate