Project Description
I have a set of company figures already pulled together in Excel and I need a fresh pair of expert eyes to make sure every link and assumption holds up. Your task is to analyse and review the full trio of statements—income statement, balance sheet and cash-flow statement—then walk me through how those numbers flow into the valuation work.
The valuation model is built around a Discounted Cash Flow approach. I’m specifically looking for help in two areas:
• calculating and sanity-checking free cash flow;
• determining an appropriate discount rate, including a well-supported WACC.
Once you have worked through the file, I’d like clear comments inside the spreadsheet plus a brief write-up (bullet points are fine) summarising any corrections, red flags or alternative assumptions you suggest. If something doesn’t reconcile, flag it and show the fix so I can follow the logic step by step.
Acceptable deliverables
1. The updated Excel model with your edits and cell-level notes.
2. A short explanatory memo (PDF or Word) highlighting key findings and the rationale behind your discount-rate build-up.
That’s it—no need to forecast additional years; my immediate concern is validating the current numbers and ensuring the discount rate truly reflects the firm’s risk profile. If you are comfortable with corporate finance theory and Excel modelling, this should be a straightforward engagement.