Ammar Mahmood | Elance
Last Sign-in: Nov 18, 2015

Ammar Mahmood

Finance & Excel Expert / Statistics Analyst
  |   Lahore, Punjab
  |  10:16 pm Local Time


Working on Elance since March 2012. Pursuing CFA Charter and a MBA in Finance in addition to my BSc in Accounting and Finance. I have work experience of 3 years at Pakistan's leading bank (MCB Bank) as a Corporate Risk Analyst in Risk Management Group. Capable of performing a variety of jobs including the following:

1) Financial Management and Valuations including forecasts, proforma statements
2) Financial Statements Analysis
3) Business Plans
4) Managerial Accounting and Control Systems
5) Marketing Research, Strategy formation and Analysis
6) Peachtree and Quickbooks Pro 2010 Accounting Software
7) Proficient in MS Word/Excel/Project/Access/Powerpoint
8) Statistical Tools including Stattools, @Risk, Stata and SPSS
9) Econometrics models based in Excel
10) Business Mathematics
Service Description
1) Financial Management and Valuations

Capital Budgeting Decisions, Cost of Capital Decisions (WACC, CAPM), Optimal Capital Structure Decision, Loan / Bond Valuation, Business/Project Valuations, Forecasts, Proforma Financial Statements, long/hold/short a stock, stock valuation, Dividend Discount Model, NPV Analysis, Time Value of Money, IRR, MIRR, Payback Period

2) Financial Statements Analysis

Ratio Analysis, Cash Flow Analysis, FCFF, Liquidity, Profitability, Leverage, Solvency, Efficiency Ratios, Horizontal and Vertical Analysis, Commonsize financial statements, Financial Statements IFRS / GAAP Compliant, Bookkeeping

3) Business Plans

Write up, Loan Applications, Valuations, Set ups, Venture Capital Valuation, Premoney and Postmoney valuations.

4) Operations Management

Assembly Line, Takt Time, Batch Process, Job shop, Inventory Management, EOQ, Process Engineering, Cycle Time, Throughput Time / Rate

5) Managerial Accounting and Control Systems

ABC vs Job Costing, Managerial Control Systems, Profit/Cost/Investment centres, Break Even Analysis, Marginal Costing, Relevant Costing, Residual Income, Economic Value Added

6) Marketing Research, Strategy formation and Analysis

Data Collection, Questionnaires, Surveys, Report Writing, Segmentation, Promotion, Pricing Strategy

7) MS Excel

Business Model development, Solver, @Risk, Statstools, Whatif, Lookup, Index, Match, Correlation, Regression, Sensitivity Analysis, Tornado Charts

8) MS Access

Database, Proposals, Invoicing, Quotes
Lahore University of Management Sciences
Masters in Business Administration
2011 -
Lahore University of Management Sciences
Bachelor of Science with Honors
2004 - 2008
Marketing Specialist
2013 - Present
MCB Bank Limited
Manager - Corporate Credit Review
2008 - 2011
Payment Terms
None specified
Ammar Mahmood | Elance

Ammar Mahmood