DCF Business Valuation Model

Project Title

Correct FCFF & FCFE Calculations in Existing Excel DCF Model

Project Description

I have an existing Excel DCF valuation model that is nearly complete. However, the Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity (FCFE) calculations have been flagged as incorrect during a financial modelling assessment.

I'm looking for an experienced financial modelling professional to:

Review the existing workbook.
Trace every precedent and dependent related to the FCFF and FCFE schedules.
Verify all upstream calculations (EBIT, taxes, depreciation, CapEx, working capital, debt movements, etc.).
Identify any formula, sign convention, or methodology errors.
Correct the FCFF and FCFE calculations according to standard valuation practices.
Ensure all formulas remain fully linked (no hard-coded values).
Explain every correction made.
Deliverables
Corrected Excel workbook.
Summary of all changes made.
Explanation of why the previous calculations were incorrect.
Confirmation that the FCFF and FCFE schedules follow accepted DCF methodology.
Requirements

Applicants should have experience with:

Investment Banking financial modelling
DCF Valuation
FCFF & FCFE
Three-statement financial models
Working Capital schedules
WACC and Enterprise Value calculations

Please mention your experience with correcting valuation models or financial modelling test assignments.