DCF Analysis of Party City
Budget: $250 – $750 USD
Project Proposal: Discounted Cash Flow (DCF) Analysis for Party City During Bankruptcy
Project Overview
Party City, a leading retailer of party supplies, entered bankruptcy in January 2023, highlighting financial distress driven by macroeconomic factors, operational inefficiencies, and a significant debt burden. To assess the company’s financial health and restructuring prospects, this project requires a comprehensive Discounted Cash Flow (DCF) analysis with a focus on monthly Free Cash Flow (FCF) projections and EBITDA adjustments (add-backs).
The objective is to determine Party City's valuation, understand its debt obligations, and evaluate whether financial restructuring strategies could have improved its sustainability.
Scope of Work
Financial Data Collection and Review
Gather financial statements (income statement, balance sheet, and cash flow statement) from SEC filings, bankruptcy court documents, and investor reports.
Identify key revenue drivers, cost structures, and capital expenditures.
Discounted Cash Flow (DCF) Valuation
Forecast Party City’s Free Cash Flow (FCF) on a monthly basis to reflect short-term liquidity constraints.
Identify appropriate discount rate (WACC) considering market conditions and bankruptcy risk.
Conduct a terminal value assessment using multiple valuation methods (perpetuity growth method, exit multiple method).
EBITDA Adjustments (Add-Backs) Analysis
Identify one-time, non-recurring expenses added back to EBITDA for an adjusted financial picture.
Examples of add-backs:
Restructuring and reorganization costs
Legal and advisory fees related to bankruptcy
Write-offs and impairments
Rent and lease obligations if restructured
Debt Burden and Capital Allocation Analysis
Break down Party City’s capital structure, highlighting secured vs. unsecured debt.
Evaluate how debt obligations restricted the company’s ability to invest in growth areas (e.g., digital transformation, store expansions, or product innovation).
Compare debt service costs vs. reinvestment opportunities.
Scenario Analysis and Stress Testing
Model best-case, base-case, and worst-case scenarios for FCF and enterprise value (EV).
Analyze potential impact of different restructuring strategies (debt-to-equity swaps, asset sales, refinancing options).
Deliverables
Detailed DCF model in Excel with monthly projections.
Comprehensive report (PowerPoint or Word) summarizing findings, methodology, and restructuring implications.
Executive summary outlining key valuation insights and recommendations.
Ideal Candidate Requirements
Extensive financial modeling experience, specifically DCF valuations.
Strong understanding of EBITDA adjustments and add-backs in distressed scenarios.
Expertise in corporate debt structuring and bankruptcy proceedings.
Ability to project Free Cash Flow on a monthly basis with stress-testing scenarios.
Experience with Capital IQ, Bloomberg, or Debtwire for financial data extraction.
Budget and Timeline
Budget: Competitive compensation based on experience and deliverables.
Timeline: 2 days
Interested candidates should submit:
Portfolio or past financial analysis work (preferably distressed companies).
Proposed approach to DCF valuation and Party City's debt analysis.
Fee structure and estimated timeline for completion.
This project is essential for evaluating Party City’s financial standing and could support restructuring insights. We seek an analyst with expertise in financial distress modeling to provide a data-driven valuation and restructuring outlook.
Project Overview
Party City, a leading retailer of party supplies, entered bankruptcy in January 2023, highlighting financial distress driven by macroeconomic factors, operational inefficiencies, and a significant debt burden. To assess the company’s financial health and restructuring prospects, this project requires a comprehensive Discounted Cash Flow (DCF) analysis with a focus on monthly Free Cash Flow (FCF) projections and EBITDA adjustments (add-backs).
The objective is to determine Party City's valuation, understand its debt obligations, and evaluate whether financial restructuring strategies could have improved its sustainability.
Scope of Work
Financial Data Collection and Review
Gather financial statements (income statement, balance sheet, and cash flow statement) from SEC filings, bankruptcy court documents, and investor reports.
Identify key revenue drivers, cost structures, and capital expenditures.
Discounted Cash Flow (DCF) Valuation
Forecast Party City’s Free Cash Flow (FCF) on a monthly basis to reflect short-term liquidity constraints.
Identify appropriate discount rate (WACC) considering market conditions and bankruptcy risk.
Conduct a terminal value assessment using multiple valuation methods (perpetuity growth method, exit multiple method).
EBITDA Adjustments (Add-Backs) Analysis
Identify one-time, non-recurring expenses added back to EBITDA for an adjusted financial picture.
Examples of add-backs:
Restructuring and reorganization costs
Legal and advisory fees related to bankruptcy
Write-offs and impairments
Rent and lease obligations if restructured
Debt Burden and Capital Allocation Analysis
Break down Party City’s capital structure, highlighting secured vs. unsecured debt.
Evaluate how debt obligations restricted the company’s ability to invest in growth areas (e.g., digital transformation, store expansions, or product innovation).
Compare debt service costs vs. reinvestment opportunities.
Scenario Analysis and Stress Testing
Model best-case, base-case, and worst-case scenarios for FCF and enterprise value (EV).
Analyze potential impact of different restructuring strategies (debt-to-equity swaps, asset sales, refinancing options).
Deliverables
Detailed DCF model in Excel with monthly projections.
Comprehensive report (PowerPoint or Word) summarizing findings, methodology, and restructuring implications.
Executive summary outlining key valuation insights and recommendations.
Ideal Candidate Requirements
Extensive financial modeling experience, specifically DCF valuations.
Strong understanding of EBITDA adjustments and add-backs in distressed scenarios.
Expertise in corporate debt structuring and bankruptcy proceedings.
Ability to project Free Cash Flow on a monthly basis with stress-testing scenarios.
Experience with Capital IQ, Bloomberg, or Debtwire for financial data extraction.
Budget and Timeline
Budget: Competitive compensation based on experience and deliverables.
Timeline: 2 days
Interested candidates should submit:
Portfolio or past financial analysis work (preferably distressed companies).
Proposed approach to DCF valuation and Party City's debt analysis.
Fee structure and estimated timeline for completion.
This project is essential for evaluating Party City’s financial standing and could support restructuring insights. We seek an analyst with expertise in financial distress modeling to provide a data-driven valuation and restructuring outlook.