Rahul Kamat

About Rahul Kamat

Finance professional (CA, & MBA) with experience in FP & A, financial reporting, compliance…

Experience

1. Senior Analyst Fp & a

   John Lewis Partnership

   Jan 2024 — Present · London, GB

   Delivered a £1.8bn IFRS16 Lease Debt and £4.5bn Fixed Assets forecast with <95% accuracy in under 2 months, within 2 months of joining in a fast-paced environment; role scope was so extensive that it was split between two successors after my departureBuilt a bottom-up property-wise lease debt forecast model for the business plan for 480 properties, showcasing thought leadership, enhancing accuracy by 5%, and receiving appreciation from senior property team stakeholdersIntroduced a discount rate matrix based on property age and lease type, increasing forecast accuracy by 3%.Advised Commercial Finance Director of Waitrose to increase lease debt headroom by £15m by restructuring 7 regear deals, showcasing analytical skills and innovative mindset.Addressed new lease accounting treatment by partnering with accounting and commercial finance teams, improving forecast accuracy by 2%. Built a finance narrative around lease debt by producing 50+ commentaries for variances in actuals vs budgets, last year and the latest forecast, showcasing strong financial analysis and communication skills.Developed a comprehensive monthly lease debt risks and opportunities report, enabling real-time accuracy for Debt coverage ratio calculations and enhancing analytical thinking.Automated a 3-year depreciation forecast model covering 15 business units and fixed asset lines, creating a new forecasting framework IF conditions in Excel.Developed scenario analysis for 40 regears, providing real-time insights on debt service coverage ratio and delivering all results within 1 day using IF & CHOOSE functions in Excel.Automated quarterly capital paid forecasting using scenario modelling in Excel, increasing the accuracy of the Lease Debt forecast by 3%.Secured a 9-month contract extension due to positive feedback received from Commercial Finance stakeholders due to actionable recommendations and advice provided in the area of lease debt.

Education

• Savitribai Phule Pune University

  Bachelor of Commerce - BCom, Accounting

  2002 — 2004

• Association of Chartered Certified Accountants (ACCA)

  ACCA, Accounting

• Lancaster University

  Master of Business Administration - MBA, Business Administration and Management, General

Skills

• Mergers & Acquisitions
• Business Analysis
• Equity Research
• Capital Markets
• Team Management
• Business Valuation
• Corporate Finance
• Investment Banking
• Financial Analysis
• Valuation
• Investments
• Business Strategy
• Analysis
• Acquisitions
• Accounting
• Equity Valuation
• Financial Modeling
• Private Equity