Department: Finance & Accounts
Location: Delhi
Experience: 2-5 Years
Qualification: B.Com / M.Com / MBA (Finance)
About the Role
Key Responsibilities
- Calculate loan interest, EMI schedules, repayment plans, and finance costs accurately.
- Compare loan proposals and interest rates from different banks to recommend the most cost-effective financing option.
- Monitor and manage working capital loans, term loans, overdraft (OD), cash credit (CC), and other banking facilities.
- Prepare and maintain loan schedules, repayment trackers, and banking MIS reports.
- Verify bank interest calculations, processing charges, and other banking-related costs.
- Manage company insurance policies, including policy renewals, endorsements, premium payments, and claim processing.
- Coordinate with insurance companies for employee and asset insurance.
- Perform bank reconciliations and maintain accurate financial records.
- Prepare MIS reports, financial analysis, and management reports using Microsoft Excel.
- Support budgeting, cash flow planning, and financial reporting.
- Ensure proper documentation and compliance for banking and insurance activities.
Required SkillsBanking & Finance
- Strong knowledge of loan management and banking operations.
- Sound understanding of:
- Interest Rate Calculations
- EMI Calculations
- Simple & Compound Interest
- Working Capital Finance
Microsoft Excel (mandatory)
- Advanced Excel proficiency, including:
- VLOOKUP & XLOOKUP
- INDEX-MATCH
- Pivot Tables & Pivot Charts
- IF, IFS
- SUMIF, SUMIFS
- COUNTIF, COUNTIFS
- IFERROR
- Conditional Formatting
- Data Validation
- Lookup and Financial Functions
- MIS Reporting and Data Analysis
Insurance Management
- Experience in handling corporate insurance policies.
- Policy renewals and endorsements.
- Insurance claim coordination.
- Premium reconciliation and documentation.
- Excellent analytical and numerical skills.
- Solid financial calculation and logical reasoning ability.
- High level of accuracy