Dear Readers,
I am writing to share my disappointment and the broader lessons learned after the maturity of an endowment plan, I purchased from Great Eastern in 1999. The plan, which was intended to secure my financial future, has fallen far short of reasonable expectations, especially when compared to alternative savings methods and the inherent limitations of long-term commitments like this. I was told that I would receive maturity amount of 41,000.00 after 25 years based on the illustrations benefit and by the Financial Advisor.
In my earlier analysis, I initially estimated the annualised return of my Great Eastern endowment at around 1.31% p.a. That figure was incorrect.
The mistake came from treating my total premiums of SGD23,675 as though the entire amount had been invested upfront for 25 years.
The formula used was the standard CAGR formula:
CAGR = (Final Value ÷ Initial Value)^(1 ÷ Number of Years) − 1
Using my figures:
CAGR = (33,234.09 ÷ 23,675)^(1 ÷ 25) − 1
= approximately 1.37% p.a.
So even under that method, the correct mathematical result is about 1.37%, not 1.31%.
More importantly, however, CAGR is not the appropriate method for my endowment policy.
CAGR assumes the entire starting amount was invested at the beginning and remained invested throughout the full period. That did not happen in my case.
I paid only SGD947 on 22 December 1999, followed by another SGD947 every year, with my final premium paid on 22 December 2023. Therefore, each annual premium was invested for a different length of time.
The first SGD947 was committed for almost 25 years, whereas the last SGD947 was committed for less than one year before maturity.
The more appropriate calculation: XIRR
Because my premiums were paid on different dates, the correct way to measure my actual annualised return is XIRR — Extended Internal Rate of Return.
XIRR finds the annual return r that makes the present value of all my cash flows equal to zero:
0 = Σ [CFᵢ ÷ (1+r)^((Dateᵢ−Date₀)/365)]
where:
CFᵢ = each cash flow
Dateᵢ = the actual date of each cash flow
Date₀ = the date of the first payment
r = the annualised return
My actual cash flows were:
22 Dec 1999: −SGD947
22 Dec 2000: −SGD947
22 Dec 2001: −SGD947
…
22 Dec 2022: −SGD947
22 Dec 2023: −SGD947
12 Dec 2024: +SGD33,234.09
Using these exact dates and cash flows, the XIRR is:
2.5198% p.a., rounded to 2.52% p.a.
In Excel, this can be reproduced using: =XIRR(B2:B27,A2:A27)
where Column A contains the dates and Column B contains the corresponding negative premium payments and positive maturity payout.
Therefore, the more appropriate measure of my policy's actual annualised return is 2.52% XIRR, not 1.31% or 1.37% CAGR.
Although my Great Eastern endowment achieved an XIRR of approximately 2.52% p.a., I personally do not consider this an attractive return for committing to a 25-year policy.
The important distinction is that I am not claiming Great Eastern guaranteed me a 3%, 4% or 5% annual investment return. My original 1999 Benefit Illustration contained guaranteed and non-guaranteed components, and it used assumptions—including a 5% p.a. rate for accumulating certain cash benefits—that were not guaranteed.
Nevertheless, the illustration matters when evaluating the expectations I had when purchasing the policy. The illustrated total benefit was $41,341.84, whereas my actual maturity proceeds were $33,234.09, a difference of $8,107.75, or approximately 19.61%.
Based on my actual cash flows—25 annual premiums of $947 from December 1999 to December 2023 and maturity proceeds received in December 2024—the policy generated approximately 2.52% XIRR per annum.
To me, that return is modest for a commitment lasting a quarter of a century. It may have beaten ordinary bank fixed deposits over much of the low-interest-rate environment, and it appears to have remained ahead of long-term inflation. But those facts do not automatically make 2.52% an attractive return.
A particularly useful benchmark is CPF Ordinary Account, whose basic interest rate has a 2.5% floor. My endowment's 2.52% XIRR exceeded that floor by only 0.02 percentage point, or two basis points. The products are not directly interchangeable—CPF and an insurance endowment have very different restrictions and benefits—but the comparison provides useful perspective on the return I received.
My conclusion therefore is not that the endowment was a financial disaster. Nor would it be accurate to claim that a bank fixed deposit would definitely have performed better. Rather, I believe a 2.52% annualised return was disappointing relative to the length of the commitment and the expectations created by the original benefit illustration.
Had the policy actually delivered an annualised return closer to 3–5%, the compounding effect over 25 years would have been considerably more meaningful. This experience taught me to distinguish between illustrated returns, guaranteed benefits and the actual XIRR ultimately earned.

Thanks for the well written post. You'd made pertinent points that consumers will need to look at. I'm sure it will be useful for many who are considering buying an endowment plan.
ReplyDeleteMany Thanks David for your kind words, hope my experience benefits everyone, financial planning need to start at the young age in the teens.
ReplyDelete