تخطي إلى المحتوى الرئيسي
Ca Karma Kapadia

Ca Karma Kapadia

Chartered Accountant (CA) | FP&A & Financial Modelling | Asset Management | Audit & Financial Reporting

كفاءة
Dubaiعضو منذ ١٤ أكتوبر ٢٠٢٦
Advanced ExcelVBAPower BICoStarYardiArgusSAPIFRSUAE Corporate TaxVATBEPS Pillar 2
·

وظّف هذا الشخص

أرسل عرض عمل مباشرة لهذا المرشح

Advanced ExcelVBAPower BICoStarYardi

نبذة

Chartered Accountant (CA) with 5.5 years of experience (including 3 years of audit articleship) across FP&A, financial modelling, asset management and statutory audit, with current experience supporting a real estate investment portfolio at Gallagher & Mohan and multi-entity clients at Qualitas. Builds financial models, variance and budget analysis, and lender/investor reporting;

skills built on a statutory audit and IFRS consolidation foundation from 3 years at G.K. Choksi & Co. Strong in Excel, VBA, Power BI and AI-driven process automation; CFA Level 1 candidate.

الخبرة

Asset Management Analyst | Senior Financial Analyst at Montford Private Equity Group (formerly TMGOC Ventures), deployed by Gallagher & Mohan (2025-12 – Present)

Asset Management, Financial Modelling & FP&A support for a real estate investment portfolio | Tools: Yardi, Argus, Power BI, CoStar, Advanced Excel

  • Provide end-to-end asset management and FP&A support for a 3,180-key portfolio: monthly variance reporting and analysis for each property and at portfolio level, portfolio performance management, monthly and quarterly rolling forecasts, and scenario, refinance and hold/sell analysis models as required.
  • Built a multi-scenario refinance model (7 lender options) for a 3-property, $75M portfolio (TTM NOI $6M) supporting a $50M refinance; used it to compare pros and cons across lenders and select the best-fit option, improving terms from SOFR+4.4% to SOFR+3% and tightening the debt yield covenant from 11-12% to 10%.
  • Prepared monthly and quarterly lender reporting packages for 14 assets (actual vs budget, TTM, pace, DSCR and debt yield), ensuring covenant compliance and on-time submission to lenders and servicers.
  • Prepare monthly investor reports and MBR (Monthly Business Review) packages for joint venture (JV) and fund partners across 5 assets (month, YTD, forecast, TTM, balance sheet, capex, STR tabs); present quarterly QBRs (Quarterly Business Reviews) on portfolio performance and variance drivers, partnering monthly with the Construction team on capex forecasting.
  • Built and maintained loan covenant trackers across a $40M TTM NOI portfolio spanning 15 properties, monitoring DSCR, debt yield compliance and cash-trap triggers, avoiding 1 covenant breach and flagging 3 others for early remediation.
  • Built LP/GP equity distribution waterfall models for 9 assets using Argus-sourced data, running scenario and sensitivity analysis for investor return projections - supported a $45M acquisition decision and drove quarterly investor reporting across the remaining portfolio.
  • Underwrote potential property acquisitions using pro-forma cash flow builds, cap rate and IRR analysis and multi-scenario sensitivity testing to support go/no-go acquisition decisions.
  • Built an LBO model testing IRR and MOIC under base and conservative scenarios for the $45M acquisition, confirming target returns were met even under conservative assumptions and supporting a GO decision; the deal was pursued and closed. Also built a three statement model (income statement, balance sheet, cash flow) for an existing hospitality asset to support hold/sell analysis, which signaled a HOLD.
  • Co-developed asset business plans for 4 properties with the VP of Asset Management, building the underlying financial models (revenue/expense projections, capex plans, hold/sell analysis); following capex execution and tightened expense/marketing tracking, 2 of the 4 properties rose from last place (6th of 6) to 2nd and 3rd among their competitive set.
  • Automated portfolio data workflows using AI (Claude), reducing manual reporting effort by 40% and improving data accuracy across the portfolio; reverse-engineered a third-party reporting platform's source data and template logic to replicate it in-house, saving an estimated $350K in licensing costs.

Financial Executive at Qualitas Accountants LLP (2023-12 – 2025-07)

Financial Planning, Analysis, Reporting & Financial Modelling | Tools: Yardi, Advanced Excel

  • Engineered a comprehensive DCF model for a client's Cultivation Division by forecasting sales from historical data and a projected 5% industry growth, enabling the client to secure US$1 million above the initial quoted price from the acquirer.
  • Compiled monthly Consolidated Financial Statements (CFS) under IFRS, integrating data from multiple entities and performing reconciliations, leading a team of 4.
  • Prepared Statement of Cash Flows (IAS 7) for cash flow forecasting and liquidity analysis, and performed lease accounting analysis (IFRS 16) with workings from both lessor and lessee perspectives.
  • Developed working knowledge of SAP, navigating financial data and bulk income/expense datasets to support reporting and trend analysis, continued building proficiency in current role.
  • Restructured the management reporting framework, including the unpaid bills report, achieving a direct 4-hour reduction in reporting time and giving management timely, actionable financial data.
  • Performed detailed sales-to-cash analyses and bank reconciliations, identifying an attempted US$10,000 fraudulent transaction (embezzlement) by a key employee of the client and safeguarding client capital.
  • Built Power BI KPI dashboards from scratch for 3 clients, tracking monthly and YTD revenue and KPIs against budget; helped identify unproductive costs and drove a $75K/month cost saving that supported organic revenue growth.

Articled Associate at G.K. Choksi & Co. (2020-02 – 2023-03)

Statutory Audit, Financial Reporting & Compliance

  • Executed advanced substantive analytical procedures in compliance with SA 520 across a diversified conglomerate (Logistics, Manpower, Real Estate, Infrastructure), enabling early detection of unusual trends and red-flag reporting of financial anomalies, strengthening the overall risk assessment framework.
  • Drafted statutory audit reports compliant with SA 700 series (705, 706, 701) and supplementing the main opinion with CARO 2020 reporting where applicable.
  • Prepared Consolidated Financial Statements in accordance with IFRS 10 for a private limited company including the elimination of intra-group profits and borrowings, and determining non-controlling interests (NCI).
  • Prepared Quarterly India RERA Returns (Form-3), ensuring regulatory compliance and supporting real estate transaction diligence. Filed GST monthly returns, carried out Tax Audits.

التعليم

Chartered Accountant (CA) – ICAI (2025)

CFA Level 1 – CFA Institute (2027-02)

Bachelor of Commerce – Somlalit College of Commerce, Ahmedabad (2018 – 2021)

المهارات

Chartered Accountant (CA)FP&A & Financial ModellingAsset ManagementAudit & Financial Reporting

التقييمات