Home Creators Posts Import Register Favorites Logout
haven't archived this post yet. have a subscription? use the importer!

Downloads

  • Patreon Asset Allocation Calculator.xlsx

Missing 1 file, as this post has not yet been imported.

Content

How to use this: https://youtu.be/fTOUJCVJwUU


Comments

imak

the excel sheet is excellent!!! ❤️❤️❤️

Chan

Thanks Ah Chu. May I ask a question, if etf (i.e. VOO and GLD) count as "Stock" please?

Sylvia

Does a property count as an asset or debit?

Andrew Nei

How about cash flow?

Yuzu

Very useful excel

CC

MPF should count as assets?

Elmer

Thank you very much Ah Ju. This spreadsheet is enlightening !

Cheryl

阿豬,想請問房地產你會唔會都考慮係你個投資組合入邊?個Excel入邊只係得REIT

Jade

Very useful! Thanks Ah Ju!

Tony Ho

Inspiring concept demo! While seems column M saving % and column Q spending per month got logic issue, resulting in a lower spending amount during working-age period (thus faster than reality to reach retirement). On the rows that Salary Increment is 0%, this behavior becomes visible because spending drops. Would be great if Ar Ju can see see if that is expected, thanks!

Tony Ho

Thanks a lot! One more clarification: why would spending PV keep dropping before retirement (Q11 - Q37)?

CMK

Thank you Ah Ju! Unfortunately, Canadian tax will eat up portion of the investment gain. I conservatively reduced the expected return %s by half to approximate the tax effect. It's still interesting to simulate the different scenarios.

keith lam

Thanks a lot! Ar JU!

chang

Hello Ah JU! I'm a big fan of yours. I'd like to know how to obtain the expected returns for the S&P 500 from 1990 to 2022 using Bloomberg. I would greatly appreciate it if you could share this information with me.

chang

Yes, I have a bloomberg terminal. And can generate data using excel linked with bloomberg

chang

But I do not know the way to obtain the expected returns for the S&P 500 from 1990 to 2022 using Bloomberg

Barry Chan

Thanks a lot Ah Ju!!

KITTATA LAI

阿豬,個excel 表係咪無咗,我新加入嘅,唔該🙏🏼

Agnes Chan

Hi Ah Ju, i just joined this and i cant download this file as well. It appeared garbled when i opened it.

Minnie112heart

Hi 阿豬,我想download 個excel 表呀!謝謝🙏

Mandy

同問