Regression Analysis
• Dependent Variable: Quarterly revenue
• Independent Variables:
• CPI (Inflation)
• Unemployment Rate
• S&P 500 Index
• LVMH stock price (luxury market proxy)
1. 📈 Trend Analysis with Conditional Formatting
• Track TRR’s revenue, GMV, and EBITDA across several quarters or years.
• Use line charts and conditional formatting to visually highlight:
• Negative quarters (in red)
• Profit improvements (in green)
• Helps illustrate volatility over economic cycles.
5. 🔄 Sensitivity Analysis
Use Excel’s =DATA TABLE or manual adjustments to test:
• How sensitive TRR’s profit is to small % changes in:
• GMV
• Commission rate
• Return rate
• Helps highlight critical business levers.
i need you to sourse specific data regarding my project analysis component of my Finance Pathway Capstone (FIN603), focusing on The Impact of Macroeconomic Conditions on The RealReal’s Business Model. It outlines the step-by-step process for conducting both descriptive and inferential data analysis using real financial and macroeconomic data. The Excel workbook will include key financial metrics such as revenue growth, EBITDA margin, profit margin, and GMV trends, all based on The RealReal’s 2022–2023 SEC filings. It also explains how to build a multiple regression model using macroeconomic indicators (CPI, unemployment rate, S&P 500 index, and LVMH stock price) to quantify their impact on TRR’s quarterly revenue. Additionally, a consumer behaviour model is incorporated using Statista and Trustpilot data to explore how sustainability preferences and sentiment affect GMV. A comparative competitor analysis (including Vestiaire Collective and Depop) further supports the strategic discussion. This Excel file will serve as direct evidence for Chapter 3: Findings & Discussion of my capstone report and will be submitted as a supplementary document, aligning with the assignment brief’s requirement for a strong, evidence-based financial evaluation using real-world data.