01 Excel – Padel Club Business Plan & Modeling
Background
As part of a simulated project assigned by my school, I participated in a challenge to develop a Padel club business plan for a virtual entrepreneur.
Padel is a rapidly growing racket sport, and the project assumed the entrepreneur needed to establish a new Padel club in the Paris Île-de-France region of France. The objective was to submit a 5-year business plan to a bank to secure funding.
Our task was to build a Excel tool for financial data analysis, project performance forecasting, and strategic recommendations.
My Core Contributions
I collaborated closely with my team to develop a powerful and user-friendly Excel tool to support the business plan’s creation.
1.Excel Modeling
- Built a financial model with over 20 dynamic formulas, enabling real-time linkage between input parameters (rent, customer traffic, pricing, etc.) and output metrics (cash flow, ROI, break-even point).
- Designed three scenario switching functions (pessimistic/baseline/optimistic) to demonstrate risk resistance through sensitivity analysis.
2. Strategic Decision Support
- Timeline Control System: Allowed for comparison of operational data from 2023-2025.
- Scenario Simulation Module: Included three preset parameter groups: Base Case, Best Case, and Worst Case.
- Decision-Making Tool: The Check module allowed testing the impact of different operational strategy combinations and provided business recommendations.
Technical Highlights
| Feature | Description |
|---|---|
| Dynamic Data Validation | Implemented OFFSET and COUNTA functions for automatically expanding dropdown menus. |
| Financial Engine | Utilized NPV and IRR functions to evaluate investment project profitability. |
| Automated Calculation | Employed VBA macros for global parameter application and automated formulas. |
| Error Trapping | Developed a custom Error prompt system to prevent invalid inputs. |
Data Disclaimer
All data is based on a simulated business scenario. Financial metrics and market parameters are theoretical models designed for educational demonstration purposes only. These constructs do not reflect actual business operations or real-world financial performance.