PRS_Returns.zip ( 13.83k )
Number of downloads: 331Note: If the XIRR Excel function is not working, please refer for the fix --> click here
This will help you assess if PRS return is your cup of tea.
Example:
If you are 35 years old in 2012, tax rate is 26%, and would like to contribute RM3000 for 10 years only (take advantage of tax relief), then at the age of 55, assuming PRS return is 0% annualized, your annualized return will be 1.95%
CODE
Age Year Fund Contribution Fund Fund Value Income Tax Income Tax Total Return
Amount Return (Year-End) Rate Relief Amount Rate (Ann.)
Rate (Ann.)
35 2012 $3,000 0.0% $3,000.00 26.0% $780 35.02%
36 2013 $3,000 0.0% $6,000.00 26.0% $780 21.81%
37 2014 $3,000 0.0% $9,000.00 26.0% $780 15.82%
38 2015 $3,000 0.0% $12,000.00 26.0% $780 12.41%
39 2016 $3,000 0.0% $15,000.00 26.0% $780 10.20%
40 2017 $3,000 0.0% $18,000.00 26.0% $780 8.66%
41 2018 $3,000 0.0% $21,000.00 26.0% $780 7.53%
42 2019 $3,000 0.0% $24,000.00 26.0% $780 6.66%
43 2020 $3,000 0.0% $27,000.00 26.0% $780 5.96%
44 2021 $3,000 0.0% $30,000.00 26.0% $780 5.40%
45 2022 $- 0.0% $30,000.00 0.0% $- 4.60%
46 2023 $- 0.0% $30,000.00 0.0% $- 4.01%
47 2024 $- 0.0% $30,000.00 0.0% $- 3.54%
48 2025 $- 0.0% $30,000.00 0.0% $- 3.17%
49 2026 $- 0.0% $30,000.00 0.0% $- 2.87%
50 2027 $- 0.0% $30,000.00 0.0% $- 2.63%
51 2028 $- 0.0% $30,000.00 0.0% $- 2.42%
52 2029 $- 0.0% $30,000.00 0.0% $- 2.24%
53 2030 $- 0.0% $30,000.00 0.0% $- 2.08%
54 2031 $- 0.0% $30,000.00 0.0% $- 1.95% <--- Result
55 2032
Amount Return (Year-End) Rate Relief Amount Rate (Ann.)
Rate (Ann.)
35 2012 $3,000 0.0% $3,000.00 26.0% $780 35.02%
36 2013 $3,000 0.0% $6,000.00 26.0% $780 21.81%
37 2014 $3,000 0.0% $9,000.00 26.0% $780 15.82%
38 2015 $3,000 0.0% $12,000.00 26.0% $780 12.41%
39 2016 $3,000 0.0% $15,000.00 26.0% $780 10.20%
40 2017 $3,000 0.0% $18,000.00 26.0% $780 8.66%
41 2018 $3,000 0.0% $21,000.00 26.0% $780 7.53%
42 2019 $3,000 0.0% $24,000.00 26.0% $780 6.66%
43 2020 $3,000 0.0% $27,000.00 26.0% $780 5.96%
44 2021 $3,000 0.0% $30,000.00 26.0% $780 5.40%
45 2022 $- 0.0% $30,000.00 0.0% $- 4.60%
46 2023 $- 0.0% $30,000.00 0.0% $- 4.01%
47 2024 $- 0.0% $30,000.00 0.0% $- 3.54%
48 2025 $- 0.0% $30,000.00 0.0% $- 3.17%
49 2026 $- 0.0% $30,000.00 0.0% $- 2.87%
50 2027 $- 0.0% $30,000.00 0.0% $- 2.63%
51 2028 $- 0.0% $30,000.00 0.0% $- 2.42%
52 2029 $- 0.0% $30,000.00 0.0% $- 2.24%
53 2030 $- 0.0% $30,000.00 0.0% $- 2.08%
54 2031 $- 0.0% $30,000.00 0.0% $- 1.95% <--- Result
55 2032
In my opinion, this personal annualized return of 1.95% is enough to cover the Annual Fund Management Fee and Sales Load. This is good enough for many people.
Conclusion: Buying PRS is like buying Unit Trust with free management fee and sales load.
Special thanks to wongmunkeong, this PRS spreadsheet is a modified version of his SSPN return spreadsheet he prepared and shared in the SSPN Topic.
This post has been edited by creativ: Nov 29 2012, 11:01 AM
Nov 28 2012, 12:57 AM
Quote
0.0220sec
0.60
6 queries
GZIP Disabled