Now, cheaptech's turn...
Okay... Brod! Murag lahi ta ug paagi sa pag-compute... hehe
As for me, I see it this way... Let me share to you the proper way to compute this...
Considering the supplied table:
i.e. Year 3: 3-----99,490.00---0---------------232,000.00----------------0---------232,002.00
Total payment = P99,490 x 3 = P298,470
Guaranteed Basic Cash Value = P232,000
Based on this, using the same method of computing for the ROI:
P232,000 / P298,470 = 0.77729755 or 77.73%
If you're going to look at it as is, then of course, lugi jud ka.
i.e. Year 8: 8-----99,490.00---80,000.00-------530,000.00----------282,151.00------812,160.00
Total Payment = P99,490 x 8 = P795,920
Guaranteed Basic Cash Value = P530,000
Total Guaranteed Pay-out Received = P80,000 x 3 = P240,000
Total Guaranteed Living Benefits at end of Year 8 = P530,000 + P240,000 = P770,000
P770,000 / P795,920 = 0.96743391 or 96.74%
If you're going to look at it as is, you can say nga alkansi ka during this time, but you also have to consider that wala pa na-consider ang interest earned ani. And if atong i-consider ang dividends, then I am confident to say, that you can break-even your investment at this point or a little bit more... But again, let's not compute for it kay dili guaranteed ang interest rates...
Now, let's revisit year 10:
10----99,490.00---80,000.00-------697,000.00----------409,101.00----1,106,114.00
Total Payment = P994,900
Total Guaranteed Pay-out = P80,000 x 4 = P320,000
Guaranteed Basic Cash Value = P697,000
Total Guaranteed Living Benefits at end of Year 10 = P320,000 + P697,000 = P1,017,000
P1,017,000 / P994,900 = 1.02221329 or 102.2%
P1,017,000 - P994,900 = P22,100 ==> As for this earning, you can't spread this one out over 10 years kay wala pa man ka naka-full sa imong invesment. You can only spread this earning over a 10 year time table if you invested the full payment sa first year pa lang nimo... If mao na ang situation, then agree ko nimo nga lugi jud ka...
But this is not the case. If ang investor ganahan mag-bulto ug bayad sa iyang investment, like the 2nd-10th year investment, he can do so. How? He can put it in a facility with Insular Life called a Premium Deposit Fund (PDF), which acts as a savings account wherein future investments will be taken out of. While waiting for the future investments to be taken out of the PDF, it's also growing, which is good news for the investor!

By how much? Well, right now, it's at 8% but again, it's not guaranteed. What we can guarantee thou, is that it will not go down below 6%/annum. And what does this mean for the investors? Additional earnings for him! More work for his money!!! Yipee!!!
Now, to give you a picture of this...
Projection of Deposit (P99,490 x 9) @ current 8%/annum
Deposit----------Withdrawals---------Interest Earned---------Year-End Values
895,410.00-----------0------------------71,632.80-----------967,042.80
-----------------99,490.00--------------69,404.22-----------936,957.02
-----------------99,490.00--------------66,997.36-----------904,464.39
-----------------99,490.00--------------64,397.95-----------869,372.34
-----------------99,490.00--------------61,590.59-----------831,472.92
-----------------99,490.00--------------58,558.63-----------790,541.56
-----------------99,490.00--------------55,284.12-----------746,335.68
-----------------99,490.00--------------51,747.65-----------698,593.34
-----------------99,490.00--------------47,928.27-----------647,031.60
-----------------99,490.00--------------43,803.33-----------591,344.93
Now, what does the table above mean? The deposit represents the total amount needed to pay-off the 2nd-10th year sa imong investment. Why 2nd-10th year lang? Kay assumed man nga human na ug bayad ang 1st year. The withdrawals represent the amount needed on a yearly basis. So, even though nahuman na ug bayad ang imong investment dues, there's still money left from your deposit amounting to P591,344.93 (gamay ra noh?!

)
So, let's revisit year 10 using the additional info:
Total Deposit: P99,490 + P895,410 = P994,900
Total Deposit - Earnings from Deposit = P895,410 - P591,344.93 = P304,065.07
With this in mind, mga P304,065.07 ra ang imong gi-cash out sa imong investment... Kay bisag nag-deposit ka ug P800k+ in the beginning, gi-ulian ra man pud ka ug P591k+.
Total Guaranteed Living Benefits at end of Year 10 = P320,000 + P697,000 = P1,017,000
P1,017,000 + P591,344.93 = 1,608,344.93
P1,608,344.93 / P994,900 = 161.66%
161.66% / 10years giving you 16.17% per annum... Not bad, right? And again, considering the fact nga wala pa ang interest sa plan itself... Thus, giving you a higher return.
Now, if you're still not comfortable with this figure, then I will leave you at peace... This particular passive investment is not for you... Not my loss...

But I hope you learned something. When doing calculations, make sure you're computations are correct so that you're assessment are based on the right info. But I do appreciate your calculations. Without your calculations, dili ko mapugos ug himo ug computation diri to show to others that this is indeed a good investment...
Hahay! At last nahuman na jud akong computation! Any other queries?