GIC Interview Questions 2027: How to Calculate IRR & How to Answer

Explain IRR as the discount rate that sets NPV to zero, describe calculation methods (iterative solving in practice via Excel's IRR/XIRR; interpolation by hand for simple cases), then discuss interpretation and limitations: reinvestment assumption, multiple IRRs, scale blindness. This GIC analyst interview question is commonly reported by candidates in technical rounds.

GIC Analyst Interview Questions: What This Question Assesses

The interviewer checks foundational fluency with the return metric used across private markets and project investing. They expect the definition instantly — but the real test is whether you understand IRR's limitations, since professionals who use it daily know exactly where it misleads.

GIC Analyst Interview Questions: Define, Calculate, Critique

• Define it: "The internal rate of return is the discount rate at which the NPV of all cash flows equals zero — the implied compound annual return of the investment."
• How it's calculated:
• In practice: By iteration — Excel's IRR or XIRR solves numerically; there's no closed-form solution for most cash flow patterns. XIRR handles irregularly dated cash flows; IRR assumes regular periods.
• By hand (simple cases): One-period: (ending value ÷ beginning value) − 1. Multi-period: interpolate — compute NPV at two rates bracketing zero and estimate the crossing point.
• Interpretation: Compare against a hurdle rate reflecting risk. In private markets, quote IRR alongside MOIC (multiple on invested capital), because IRR alone hides scale and timing.
• Limitations — the crucial part:
• Reinvestment assumption: IRR assumes interim cash flows reinvest at the IRR itself — unrealistic for high IRRs.
• Multiple IRRs: Cash flows changing sign more than once can produce multiple solutions.
• Scale blindness: A 50% IRR on a tiny investment creates less value than 15% on a huge one — pair IRR with NPV or MOIC.

Sample line: "IRR is the discount rate that zeroes NPV — solved iteratively via XIRR for real dated cash flows. I'd use it alongside MOIC and absolute value measures, because IRR's reinvestment assumption and scale blindness make it dangerous alone."

Common Mistakes

• Only the textbook definition: The critique — reinvestment, multiple IRRs, scale — is what separates candidates.
• Confusing IRR with MOIC: Know both: IRR is time-sensitive, MOIC is not. They complement each other.
• Forgetting XIRR: Real cash flows aren't neatly periodic. Mentioning XIRR shows practical awareness.

IRR fluency is assumed across gic analyst interview questions — hesitate here and everything after gets harder.

Keep Reading

• accenture final year project question
• GIC Technical Interview Questions: What They Ask
• GIC vs Temasek Interview: Which Is Harder?

FAQ

What is the difference between IRR and XIRR? IRR assumes regular intervals; XIRR handles actual calendar dates — the realistic case for irregular drawdowns and distributions.

What is MOIC? Multiple on Invested Capital — total value returned divided by capital invested. Shows scale of return without time sensitivity.

Can IRR be negative? Yes — when the investment loses money, the zero-NPV discount rate is negative, reflecting value destruction.

Preparing for GIC's interview? Our 2027 GIC Learning Indicator PI Cognitive Assessment Exact Questions & Answers has practice questions and answers — $79 one-time, instant download.