Rahul Kamat

Senior Analyst Fp & a @John Lewis Partnership

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.

Savitribai Phule Pune University

Bachelor of Commerce - BCom, Accounting

Association of Chartered Certified Accountants (ACCA)

ACCA, Accounting

Lancaster University

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