EK Asset Category (2023-2024)
EK Asset Category (2023-2024)(Excel)
DEC23-DEC24 Analysis by Asset Category
AU Equities: Mortgage Interest Rate is at 6.79%, so we’ve offset 100K to PPM. Out of 84K, only 26K is invested in Income Funds. The remaining 58K is in the ING Offset Account as EFI-Holding. Total AU Equities Allocation is at 7%. Our Target is 10%, so we’ll need to true-up AU Equities through JUN25.
AU Super: Balance is 318.5K. KSuper is at 202.5K; ESuper is at 116K. Kathy’s still missing DEC24 SG and won’t be paid until the end of the month, but for this purpose, we’ll exclude it as we’re reporting actuals, and non-accrued basis. I also haven’t contributed to ESuper for 2024 as Spousal Contribution, but will be done prior to JUN25 to get the rebate. I’ll include this in the JUN25 Notes. For Periods JAN24-NOV24, we have 14.8K in SG, 5.8K in Bonus SG, and 15K in Bonus SS. Total SG+SS is 14.8K+5.8K=20.6K+15K=35.6K. For ESuper, total contribution is 5K in JAN24. Total for EKSuper Contributions are 35.6K+5K=40.6K. Increase in Equity is 60.4K, so that makes 60.4K-40.6K=20K in Growth. DEC23 Bal is 258K, so 20K/258K=7.75% in Growth.
US Equities: We’ve liquidated our US Inv of 60K after DEC23 and offset to PPM. For 2025, we’ll be excluding this Category in EK Portfolio. We haven’t decided yet if we wanted to invest in US ETFs due to PFICs tax implications.
Currencies: Currently at 12K. 10K is due to LtF (Loan-to-Family). Bosco and Kaho purchased their property, but somehow miscalculated the stamp duty, so Bosco contacted me directly for support, so of course. We’ve set the loan terms and conditions of 1.25K/monthly payments effective JAN25-AUG25 total 10K loan. Around JUL25, they have the option of borrowing another 5K, and payments will continue in SEP25-DEC25 of 1.25K/monthly payments, another 5K loan. Total loan upto 15K, but the 5K will be with Kaho directly as 10K will be our limit per person. Once we start receiving payments, I’ll offset 5K with ING Offset to LtF, and the remaining 5K will be EFI. We’re currently at 84K in EFI, so 84K+10K=94K. This should get us closer to our Target of 10%.
ING Offset/PPM: DEC24 is 411.65K. PPM is 300K. PPE is 50K. KD/KMA is 61.65K. Based on our drawdown schedule, we’ve allocated 10K/quarter from PPE. We have a remaining balance of 9K by DEC24, so the next drawdown of 10K will be around MAR25/JUN25 respectively. We have until end of 2025 to fully reallocate KD/KMA and KFI-BInvT out of the ING Offset Account. KD/KMA will be complete by JUN25. KFI-BInvT we’ll start allocating 3K/month effective JAN25. Hard to say if we can fully reallocate KFI-BInvT by DEC25 so we’ll reassess by JUN25 after KBonus.
Property: DEC24 is 306.5K. We’re assessing our property value to be at 800K. Our remaining mortgage is 493.5K. In DEC23, property value is 785K with a remaining mortgage of 514.5K. Net Equity is +15K in property value, and decreased our remaining mortgage by 21K. Property is currently allocated at 27%. Target is at 25%. JUN25 assessment will be much higher as we’re no longer paying mortgage interest, so that would push our % allocation higher. We’ll need to offset this with EKSuper. Most likely we’ll offset about 5K and contribute to ESuper as Spousal Contribution.
Additional Notes:
KD/KMA+KFI-BInvT: We’ve now allocated KD/KMA to CBA/Macq Savings account at 5% interest. KFI-BInvT will start on JAN25. Total KD/KMA+KFI-BInvT=61.65Kx2=123K. Most likely this will be a Down Payment for our Investment Property. What we haven’t decided yet is the allocation offsets for Property2. We’re also considering 20%-to-25% down payment with 5% in the new Offset Account with Redraw feature. KFI-BInvT can stay in EK Portfolio until DEC25.
ING Offset/PPM: As KD/KMA will be fully allocated by JUN25, we’ll need to exclude KD/KMA from our EK Portfolio and EK Portfolio Analysis by DEC24 before the year ends. No impact on EK Portfolio, but EK Portfolio Analysis would lower the ING Offset/PPM by 61.65K. This would bring Offset/PPM to 350K, which matches our PPM. If we were to update KD/KMA using this method, this would impact our below the line reporting as it’s no longer an exclusion. Best way is to remove KD/KMA completely from EK Portfolio Analysis, remove KD/KMA Category from EK Portfolio, and report it as a separate line item outside of our consolidation (using comments only) and update financials monthly.
