This reveals a candidate's judgment under uncertainty, which analysts face when client or market data is incomplete. Employers want to see logical fallback methods and honest communication about limitations.
Acknowledge the problem, then propose a structured workaround: define what is missing, find proxy data or benchmarks, use ranges or sensitivity analysis, and document assumptions. Avoid claiming you can always find the exact number.
Start by acknowledging that incomplete financial data is the rule, not the exception, especially in a market like ours where some listed companies and private firms still report on a lag or with uneven disclosure. The real challenge is not the missing numbers themselves, it is the risk of letting a gap quietly corrupt your analysis, so your first move is to name what is missing and why it matters. Say plainly that you would separate the data you have from the data you need, then rank the gaps by their impact on the decision at hand. For the critical gaps, explain that you would look for reasonable proxies, such as industry benchmarks from the Philippine Stock Exchange disclosures, comparable regional peers, or historical trends from the same company, and that you would always label these as assumptions. Then show that you would test the outcome with sensitivity analysis, presenting a base case and a stressed case so the client or your managing director sees the range, not a false precision. Finally, emphasize that you would document every assumption in a clear memo and flag the uncertainty in your report, so nothing is silently buried. That honesty, paired with a structured method, is what turns incomplete data into a manageable risk rather than a dead end.
A common mistake is to say 'Wala po kaming data kaya estimate lang po' without explaining the estimation method. Instead, show that you can still move forward by using benchmarks, scenarios, and clearly labeled assumptions.
Situation
In a school project where I acted as a junior analyst for a mock investment pitch, we only had quarterly revenue data for a private company and no detailed expense breakdown. The brief asked us to estimate the company's operating margin for a potential buyer.
Task
I had to decide how to handle the missing expense details without making up numbers, and then present a defensible margin estimate to the class panel.
Action
I first identified what we needed and what was missing, then looked for comparable public companies with similar business models to understand typical cost structures. I used a range of assumptions, clearly labeled as estimates, and built three scenarios: conservative, base, and optimistic. I also flagged the risk that the actual margin could be outside the range if the company had unusual expenses. In the presentation, I explained the limitation and how the estimate could be refined with more data.
Result
The panel appreciated that I did not fabricate a precise number but instead gave a range with clear assumptions. My team received a high grade for transparency and analytical rigor.
When data is missing, use transparent assumptions and scenario ranges rather than pretending to have exact answers.
Write your own answer, then get instant AI feedback graded against:
Get AI feedback on your answer — free.
3 free AI-graded answers + 1 free mock interview, no card needed.
Sign Up FreeAlready have an account? Log in
Sign in to join the conversation.
No answers shared yet — be the first to show how you'd approach this.