11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon | Excel Modeling Job openings in Delhi, NCR and Gurgaon
Apply to 11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon on CutShort.io. Explore the latest Excel Modeling Job opportunities across top companies like Google, Amazon & Adobe.
What you will do:
- Creating and updating proprietary models/spreadsheets for the prospective investments
- Analysing financial information and conducting analytic and strategic research.
- Inputting data into proprietary financial models and ensuring the accuracy of data and output based on the data.
- Creating Automations using VBA and other tools wherever needed.
- Compiling historical data in respect of stocks and companies from publicly available sources.
- Updating and maintaining databases to track relevant financial, economic or other indicators which may be relevant to the sector and/or region under coverage
- Assisting with other company and industry related analysis as may be required by the Fund Manager
- Monitoring relevant market news and information
- Assisting with the preparation and development of research reports, industry primers and marketing presentations.
- Financial Modelling Experience is a must and a person should be excellent at this. This is the main part of the job along with research on the Financial Numbers
- Excellent understanding of Financial Statements and Accounting Standards.
- Qualified CA
- Financial Statements Audit experience preferred
- The ability to work independently and proactively
- Person should be passionate for Equities
- Strong proficiency in Advanced Excel, VBA.
- Proficiency in data science tools and languages (SQL and Python) will be considered as a great positive but not a necessary requirement
About Company
One of the India's leading Renewable Energy Consultants, working with large commercial and Industrial clients and helping them choose right Renewable Energy solution for them.
Roles & responsibilities:
• Research and Analysis in the Renewable Energy Sector of the regulations,policies, market competitors, key developers
• Creating and maintaining Financial Models and Financial Calculators as per the Customer’s and Company’s requirements
• Supporting in the Transaction Execution and in signing the PPA documents with the customers
• Preparation of Financial Modeling, corporate presentations, and information memorandum, RFS
Requirements:
MBA in Finance or comparable qualification with 8 -16 months of experience and excellent knowledge of Microsoft Excel
• You must have excellent knowledge and hands on for Ms Excel.
• You must have strong analytical (quantitative as well as qualitative) skills including building financial models
• You should have a strong financial statement analysis foundation
• You should have great research capabilities and understanding of the power and utility sector with a focus on solar, wind, and new upcoming technologies
• You should have excellent communication, writing skills, report-writing, and presentation skills
Customers can choose from a variety of food kits that allows them to pick ingredients of their choice. With the belief that good food never fails in bringing people together, the startup has made the whole experience of eating a common meal interactive by applying the DIY concept.
What you will do:
- Preparing accounts and tax returns of the company
- Reconciling accounts receivable and accounts payable
- Issuing invoices for all the payments which are due to the company, tracking the cash inflow and also reporting any late transactions
- Settling the payment transactions due to be paid to third-parties, managing the same and thus issuing stop-payment instructions accordingly
- Preparing and maintaining financial records and statements of the company including, but not limited to, P&L, book-keeping and general entries
- Posting and managing all journal entries to ensure all business transactions are recorded
- Ensuring timely closure of monthly, quarterly and annual accounts
- Ensuring timely compliance of GST of various transactions
- Generation of various financial statements concerning the liabilities and assets of the business, using Tally
- Auditing financial performance and accordingly advising on how to reduce costs and increase profits
- Forecasting the financial status of the company and also analyzing the risk factors involved
Desired Candidate Profile
What you need to have:
- Relevant work experience as an Accountant
- Graduation is a must. Female candidates preferred
- Excellent communication skills
- Willingness to work 6 days a week
- Good knowledge and work experience in Tally
- Excellent in time management and critical thinking
- Candidate who can multitask and with an eye for detail
Our Client is the world's largest FMCG brand manufacturer and exporter with a legacy spanning over 120 years.They are India's first integrated company with a comprehensive product chain. Our client is a billion dollar top line company holding 45% market share in India and 50% share in export market.
- Presenting the monthly and quarterly financial reports of various oversees distributors
- Checking International Trade Marketing expenses inline of approval provided
- Preparing and checking Quarterly TME approval to be provided to distributors
- Creating Analysis report on budgeted expenditure and actual expenditure of TME
- Maintaining dialogues and working relationship with overseas distributors
- Managing receipts & vendor payments for exports receivables (AR)
- Implementing a Business Intelligence tool and dashboard reports
- Supporting management team and the Heads of Department with data-driven analysis
- Supporting legal team from commercial side on international commercial disputes.
- Evaluating and advicing on the Letters of credit
- Ensuring Timely and Accurate MIS, AR/ AP, variance analysis and various other periodical reports to Management and overseas distributors.
What you need to have:
- CA;ICWA(CMA);MBA / PGDM
- Preferably from FMCG Export and Manufacturing companies
- Experience of Financial Control Mechanisms
- Significant analytical skillset, including the utilization of BI and reporting tools
- Strong Quantative abilities, advanced excel skills, including writing macros in Excel and other
- Experience with Global Financial Planning & Analysis and Audit
- Adaptive, willing and able to work with different time zones to get the work completed
They are currently providing 800 beds in 13 locations, and plan to add another 1600 in the next few months, with the aim to add at least a lac bed in the near future. The spaces offered by them are highly rated by their customers and are preferred over other competitors for the location and services offered within a decent budget. Invested by some very well known names across Asia, it provides their team with a work culture that thrives on modern yet social and explorative values.
What you will do:
- Leading in finance initiatives like ERP transition
- Leading financial close review with controllership team including month-end close call, finalization of P&L accounts, balance sheet and trial balance
- Responsible for reviewing the balance sheet and P&L schedules for the controllership review
- Highlighting and driving the necessary action points
- Leading the team to prepare and understand the month end flux analysis for all P&L and balance sheet accounts with the in depth analysis
- Understanding and influencing the design of financial systems
- Ensuring appropriate financial policies, procedures and internal controls are in place, documented and driving process improvements
- Interacting and working closely with the internal and external auditors on audit related queries and ensuring timely completion of the audits
Desired Candidate Profile
What you need to have:- CA with more than 8 years of experience in Finance, Accounts, Tax, Budgeting, Liaising, Purchase, Data Analysis and Fund Management
- Demonstrative excellence in conceptualizing and implementing effective management systems to improve financial controls and financial discipline in the organisation
- Expert in analyzing existing systems and procedures, designing internal control systems, facilitating and influencing effective decision-making based on intensive financial analysis of facts and figures
- Excellent in managing the business continuity and disaster recovery plans
- Track record in managing the equity transactions, guiding and advising management on operations, business structuring, financial planning, etc
- Expertise at streamlining processes, identifying unprofitable functions, evaluating control procedures thereby facilitating effective and disciplined performance
- Excellent relationship building and interpersonal skills
- Ability to connect, inspire, influence, confront and challenge people in order to improve process, systems and eventually achieve operational efficiency
- Exceptional interpersonal skills and analytical bent of mind thus being able to comprehend and explain complex financial data easily with a track record of high achievement
Expense Recording
Bank Reconciliation
Debtor Reconcilation
Vendor Payments
Vendor Reconciliation
GST & TDS Returns
experience- 1-5 years of experience in CA firm
knowledge - filing GST and TDS returns, bookkeeping, exposure in audits.
Almost a decade old, it is a venture committed to bring together a varied range of traditional crafts and techniques of dyeing, weaving, printing and hand embroidery. The founders have dedicated their life to promote Indian Block Prints and provide employment and Hand-Embroidery training to women so that numerous underprivileged women can be empowered.
As a Finance Executive, you will be responsible for handling accounts and finance of the company.
What you will do:
- Accounting Entries/Book Keeping
- Reconciliating Credit Card
- Utility Payment and its accounting
- Invoicing
- Reconciliating Bank/Loan
- Preparing Debit Note and credit note
- Confirming with Vendor
- Coordinating with inter departments
- Branch Accounting
What you must have:
- Commerce Graduate having 6-7 Plus years of Experience
- Good in Excel
- Candidate with good working knowledge and TDS Knowledge
- Candidate from manufacturing background preferred
Perform daily reconciliation of accounts between Geneva and Custodian/Prime Broker.
Monthly investigation on Reconciliation discrepancies and verify all the transactions (Independently
complete cash, portfolio and capital reconciliations and investigate and resolve any discrepancy).
Prepare monthly financial reporting package for Hedge Funds, including the determination of "Net
Asset Value" and
prepare the Statement of Asset and Liabilities and Profit and Loss Statement
Ensure Fund income and expenses, including management and performance fees, are accrued for and
are in accordance with relevant accounting standards (Calculation of Incentive Fee and Management
Fee).
Accurate and timely processing of all capital activities including subscriptions, redemptions,
transfers, rollups, capital commitments and calls.
Derive pricing for portfolio investments. Updating status reports.
Cash Management-managing the daily cash flow of trades and monitoring fund cash-flows.
Process incoming and outgoing cash movements related to capital activity.
Creation and maintenance of investor information including payment models and contacts.
Preparation of Investor and Client reports including Audit confirmations, Trade confirmations etc.
Communicate the transactions associated with the fund(s) and work closely with internal and external
clients to provide accurate and thorough accounting packages.
Correspond with external investment managers regarding day-to-day fund inquiries including entering
security trades, fee, payments, cash position breaks, and reconciliations. Client engagement and a
dedication to quality service is a must for success.
Requirements for this role include:
University degree or equivalent that required 3+ years of formal studies of Finance/Accounting
principles
2+ year(s) of accounting experience for financial instruments (equities, fixed income, and derivatives),
operation of capital
markets, and life cycle of trades. Well versed with all financial instruments
Complete procedural knowledge of fund accounting is a must. Trade Booking, Cash reporting,
Exception analysing, reconciliation of assets and cash, Post pricing issues etc.
2+ year(s) of data entry experience that required a focus on quality including attention to detail,
accuracy, and
accountability for your work product.
2+ year(s) of experience using MS-Excel that required you to use Formulas, Tables & Formatting,
Conditional Formatting,
Charting, Pivot tables & Pivot Reporting.
2+ year(s) of experience in a service-oriented role where you had to correspond in writing or over the
phone with external
customers.
Ability to work regularly scheduled shifts from Monday-Friday.
Desired qualities:
A drive to broaden one’s knowledge of the financial services industry by learning new concepts and
systems and taking the
initiative to apply it to daily work assignments.
Attention-to-detail to ensure that all deliverables consistently meet the highest standard of quality
and accuracy.
Positivity and collegial approach in assisting both colleagues and clients and the ability to work in
team environment.
Curiosity, critical thinking and attention to detail: Whether it’s to identify a solution to a problem or
possibly help
implement a more efficient process or procedure, your skills have a place in our business.
You will act as an intermediary between the funds and their investment managers and serve as the official record keeper
for the funds.
Prepare monthly financial reporting package for the Hedge Funds, including the determination of "Net Asset Value" and
prepare the Statement of Asset and Liabilities and Profit and Loss Statement
Ensuring fund income and expenses, including management and performance fees, are accrued for and are in accordance
with relevant accounting standards.
Accurate and timely processing of all capital activities including subscriptions, redemptions, transfers, rollups, capital
commitments and calls.
Derive pricing for portfolio investments. Updating status reports.
Cash Management-managing the daily cash flow of trades and monitoring fund cash-flows. Process incoming and outgoing
cash movements related to capital activity
Reporting-preparing bespoke reports to address client requests.
Independently complete cash, portfolio and capital reconciliations and investigate and resolve any discrepancies
Creation and maintenance of investor information including payment models and contacts.
Preparation of Investor and Client reports including Audit confirmations, Trade confirmations etc
Requirements for this role include:
1+ year(s) of accounting experience for financial instruments (equities, fixed income, and derivatives), operation of capital
markets, and life cycle of trades. Knowledge of Capital Market
Ability to work regularly scheduled shifts from Monday-Friday 17:30pm to 3:30am IST.
University degree or equivalent that required 3+ years of formal studies of Finance/Accounting principles
1+ year(s) of data entry experience that required a focus on quality including attention to detail, accuracy, and
accountability for your work product.
1+ year(s) of experience using MS-Excel that required you to use Formulas, Tables & Formatting, Conditional Formatting,
Charting, Pivot tables & Pivot Reporting.
1+ year(s) of experience in a service-oriented role where you had to correspond in writing or over the phone with external
customers.
Desired qualities:
A drive to broaden one’s knowledge of the financial services industry by learning new concepts and systems and taking the
initiative to apply it to daily work assignments.
Attention-to-detail to ensure that all deliverables consistently meet the highest standard of quality and accuracy.
Positivity and collegial approach in assisting both colleagues and clients and the ability to work in team environment.
Curiosity, critical thinking and attention to detail: Whether it’s to identify a solution to a problem or possibly help
implement a more efficient process or procedure, your skills have a place in our business.
2) Develop AI generated quant trading strategies for new markets.
3) Work closely with Infra team and contribute towards developing/improving the underlying research infra.
4) Manage a team of junior AI scientists and be responsible for their growth.
5) Report and document all the research findings and ideas.