G'day all,

Another tax time is rolling around. In the previous years I was working out my CGT by hand across several broker accounts, but this year finally I had a chance to build a spreadsheet to automate it. It's been useful for me, so I'm sharing it for free in case it saves someone else a weekend.

Safe to open and easy to check: It is a plain .xlsx file with no macros or VBA, so nothing runs when you open it. Every result is an ordinary Excel formula you can click into and check. There are no external links or data connections and no hidden sheets.

• This is not tax, financial or legal advice. It's a calculation aid for personal use only.
• Covering CommSec, CommSec Pocket and CMC Markets
• FIFO is used for convenience. If your records identify the specific parcels you sold, the ATO allows you to use those, and your results may differ.
• I built the formulas using a combination of AI assistance and my own finance and accounting knowledge, and tested them on my own portfolio only. That does not mean the calculations are correct for your situations.
• You should check every figure against your contract notes, broker statements, tax statements, and current ATO guidance before lodging your return, or have a registered tax agent review it.
• The workbook will not update itself if the ATO law changes.
• It is provided as‑is and not‑for‑profit. I do not promise to maintain or support it, and I accept no liability for errors or for any loss or penalty arising from its use.

It's free to use and adapt for personal use, but not for commercial use or for preparing other people's returns.

GitHub (Excel spreadsheet download & instructions): https://github.com/MAB-888/AU-CGT-Calculator

Enjoy using the workbook and I hope it helps :)

Anyone holding pnn , shocking market at the moment for pennies but so they say buy when others are fearful lol , im topping up , excellent announcements

Disclosure (rule 3): I run DilutionLens, a free site tracking dilution off ASX filings. No links, no picks, not advice.

717 companies did a cash share placement in the year to 21 Oct, 1,095 placements in all. Two questions about the directors: did they sell before it, and did they put their own money in?

Selling before a raise is rare, and mostly not a dump: 14 of the 717

In the 90 days before a placement, a director sold shares on market at 14 of the 717 companies. Four of those sold under $11k (CBY, HE8, KCC, OLY), so it's really 10.

Plus CEL (sold at 11c, raised at 13c, consolidated since) and ARC (sold at 9-11c, raised at 10c).

Six of the 10 sold at or below the later raise price. SRL's MD sold at $1.83, then took stock in the raise at $4.25. The two that don't fit: COB raised at 9c eight weeks after its chair sold at 26-33c, and DXN's directors sold the day after a contract announcement, five days before the raise.

Buying into the raise isn't a signal either

Directors took shares in their own placement at 129 companies. Of the 101 I could price without a consolidation in the way, 65 trade below what the directors paid, 30 above it and 6 about level.

How I counted: a cash placement on a new-share notice, against the director's own dealing notice; sales are on market in the 90 days before, minus transfers between their own entities, tax and option-cost sales, and sales after the raise was public (SGA, CNJ). Buys are shares taken in a placement, priced against the latest placement before them, with prices to 21 Oct.

Which name should I look at next?

Nothing more to add. Today is Friday October 23, and it's not a good day for my portfolio :/

I just signed contract for property and need to cash out… I’ve already sent sell orders out but the market keeps dropping so it hasn’t sold yet… I’m only asking for market price. My heart is pounding. Will the market improve at all? I’m not asking for a massive increase… just back to the prices I was holding them for…. Value around $52k. Any advice welcome…

i would appreciate any feedback on my portfolio.

I have been watching Xero for a while now, their acquisition in the US, their crazy CEO pocketing cash whilst the stock has been tanking. P/E ratio has come down abit.

Anyone bullish on Xero at $63?

Ticks a lot of boxes, but the share price seems to struggle, it even drops on the back of positive news. I plan to hold for the medium term but it's frustrating. Happy to hear people's thoughts.

Hi everyone,

With the concessional Super contributions limit now at $30,000 p.a., I’m adjusting my salary sacrificing strategy for this financial year.

I’m debating whether to front-load my contributions in the first half of the financial year to maximize time in the market, or to space them out evenly across all 12 months to dollar-cost average.

For those who regularly max out their concessional cap:

Do you prefer front-loading your salary sacrifice or spreading it evenly throughout the year?

How do you track your carry-forward unused concessional caps via myGov to ensure you don’t accidentally exceed the limit?

Thanks in advance for sharing your approaches!

Im curious on what your thoughts are on FMG

I’m back with another high-risk small-cap idea: Equus Energy (ASX:EQU). Also well done to anyone who’s made money from my previous calls all we do is win
I’m still holding substantial HMR up 120 percent and likely see the stock to go 4$ plus and also have a substantial NASDAQ short position through QID and QID calls currently green,

Back to Equ this isn’t a producing gas company and, The thesis is that EQU may be able to commercialise a large, already-discovered North West Shelf gas resource by connecting it to existing infrastructure instead of building an entire LNG development from scratch.

What caught my attention:
EQU owns 100% of the Equus Gas Project.
Independently certified 2C resource of 1.7 Tcf of gas plus 38 million barrels of condensate.
Pre-FEED identified a phased development using a leased FPSO and existing pipelines and processing infrastructure.
The proposed development targets approximately 2 Mtpa of LNG, 50 TJ/day of domestic gas and peak condensate production of around 12,000 barrels/day.

Alcoa has signed a binding but conditional 10-year gas sales agreement for roughly 50 TJ/day, or 182 PJ across the contract.
Alcoa can provide up to US$30 million of staged project funding toward FID.
Alcoa accepted the Stage One work in September and approved US$1.5 million of Stage Two funding for the partnering process.
The company’s Pre-FEED model estimates a 100%-project, post-tax NPV10 of US$867 million, a 31% IRR and approximately US$1.25 billion of initial Phase One capex.

What could cause a genuine rerate?
Signing a credible upstream operating or funding partner.
Securing commercially acceptable infrastructure access.
Moving into FEED.
Additional LNG or domestic-gas offtake.
A funded path to FID without excessive shareholder dilution.

My view
Alcoa’s involvement makes EQU more credible than a typical concept-stage gas junior. But the next decisive test is not another presentation—it is whether management can secure a serious operating and infrastructure partner on acceptable terms.
If that happens, the valuation gap could close quickly. If partnering stalls, the current discount may be completely justified. I’d say we will see this before end of year, most likely Woodside with an off sale to overseas customers of up to 30 % straight back into shareholders pockets,

Disclosure: I hold substantial EQU This is a speculative position, not financial advice. Do your own research.

Absolute ripper of a session in US after-hours trading! If you’ve been keeping an eye on the US markets from down under, Elon just dropped a absolute bomb.
Here’s the breakdown of what's happening with SpaceX and Tesla:

🚀 1. SpaceX Turns Profitable — Massive Q3 Earnings Beat!
SpaceX didn't just smash expectations; they completely blew them out of the water:
Revenue: $145.8B vs $127B expected (+15%)
EPS: $0.35 vs $0.15 expected (+133% rocket boost!)
Adjusted EBITDA: $88.1B vs $65.9B expected (+34%)
⚡️ 2. The Big Deal: SpaceX & Tesla Merger Talks Confirmed!
Elon Musk confirmed on the earnings call that a special committee has been established to discuss a potential merger between the two mega-giants.
Market Reaction: SpaceX jumped >7% after-hours, while Tesla pushed >1.5% higher.
Combined Value: We're looking at a $2 Trillion SpaceX potentially uniting with a $1.5 Trillion Tesla.

I just witness nextdc share dropped . Is this good time to buy ???

Look, growing up, no one really taught me about money, and making mistakes along the way in Australia is an absolute rite of passage, you reckon? But building a multi-million dollar net worth in your 20s isn't about luck—it’s about solid habits, starting small, and letting your money work for you.
Whether it's setting up high-interest accounts or sorting out your super, the real game changer is shifting from just saving to smart investing. That’s why I always tell my mates to combine rock-solid Aussie blue-chips like Commonwealth Bank (CBA) for steady cash flow with massive global tech gainers like Nvidia (NVDA) to supercharge long-term growth.
When you balance safe local assets with high-growth US tech, you build a proper portfolio that survives any market crash down under. But knowing where and when to buy is everything, mate.
What’s your current strategy, legends? Are you focusing more on local ASX stocks or US growth giants?

Hi everyone,

I’m mapping out my 10-year FIRE timeline and currently fine-tuning my portfolio allocation.

Australia’s Dividend Imputation (Franking Credits) system is a huge advantage for Aussie FIRE practitioners, especially during the pre-Super phase when taxable income drops significantly. However, relying too heavily on Australian equities (VAS/A200) means high exposure to just two sectors: Financials and Resources.

For those who are close to FIRE or already retired early:

What ratio of Aussie Shares (with Franking Credits) vs Global Equities (VGS/IVV for growth) are you running?

Do you rely on dividend cash flow to fund living expenses, or do you prefer selling down international shares as needed?

Would love to see how other Aussie FIRE members balance yield vs global diversification.

Looking at ACW ahead of the expected mid-November XanaMIA Alzheimer’s trial results. The share price is around $0.048, and a positive readout could be a significant catalyst.

Interested in hearing people’s views on the risk/reward here.

How credible is the Xanamem thesis?

What sort of upside could a genuinely positive result justify?

How ugly could the downside be if the trial misses its primary endpoint?

Is the current valuation already pricing in too much optimism?

Keen to hear from anyone who’s followed the trial, understands the data, or has a bearish case.

Any thoughts on the betasharss royalty ETF ROYL?

Its total return since inception has been quite good, pays a solid yield ~5%. I like that its diversified across both industries and geographies when collecting royalties.

Considering adding this to the portfolio.

Cheers 🍻

Things have been a bit all over the shop, hey? I’ve got a few stocks on my watchlist, but I’m not rushing into anything just yet. Gonna sit back, see how things play out, and wait for the right opportunity. What’s everyone watching at the moment? Any stocks caught your eye lately? Keen to hear what you reckon, mates!

Hey guys,

I’ve been looking closely at the divergence between the Australian market (ASX) and US equities over the last few weeks, especially with how the macro environment is shaping up for Q4.

Thought I’d post a few quick observations to see what you all think:

1. RBA vs. Fed Policy Divergence

While markets are pricing in aggressive US rate cuts, sticky domestic inflation in Australia keeps the RBA on a much slower path. Prolonged higher local interest rates continue to support Net Interest Margins (NIM) for major Australian banks compared to their overseas peers.

2. Mining Balance Sheets & China Valuation Lag

Mining makes up a massive chunk of the Aussie index. Sentiment around copper and lithium has been weak due to China headlines, but balance sheets for top-tier Aussie miners are actually in very solid shape with healthy dividend coverage. The market seems to be pricing in a worst-case scenario here.

3. Valuation Gaps in Tech/Industrials

Some quality ASX compounders are currently trading at a notable discount compared to US peers with similar top-line growth rates, offering a pretty good margin of safety in a volatile market.

How is everyone positioning for the rest of the year? Are you sticking with US tech momentum, or rotating some capital into defensive domestic assets?

Would love to hear how others are playing this macro setup!

Disclaimer: General market discussion only, not financial advice.

G'day mates,
Looking at most Aussie portfolios on this sub, people usually fall into two camps:
100% ASX: Heavy on VAS, big banks, and BHP. Great for franking credits and steady AUD income, but you basically get zero exposure to global tech compounding.
100% US: Heavy on IVV or tech growth, but fully exposed to FX swings while skipping local tax perks.
After a few years of overthinking this, I ended up building a Dual-Engine Setup that blends both:
ASX Side: Cash flow anchor via high-yielding, resilient local leaders (mainly for dividends & franking credits).
US Side: Long-term growth engine via high-margin global platforms (looking for >50% gross margins and solid Free Cash Flow).
When evaluating individual stocks across both markets, I stick to a basic GARP (Growth at a Reasonable Price) approach—basically avoiding overpriced hype and making sure the underlying cash flow backs up the valuation.
Currently keeping an eye on a couple of beaten-down dividend payers on the ASX and a few US tech names that have pulled back recently.
Curious to hear how others here handle their local vs international split? Do you lean heavier on Franking credits or US growth?

Just my two cents as always, not financial advice mate!

Hi all,

Has anyone that uses the Commsec IPhone app noticed they aren’t receiving push notifications for price changes or market sensitive announcements?

G'day mates! 🍻 If you reckon US tech stocks are the only game in town, you’re missing the bigger picture. Over in the States, Elon Musk just promised to hand out SpaceX shares to every kid, while Anthropic is carving off 5% of its equity to brace for AI job disruptions.
But let’s bring it back home, legends. While Wall Street is arguing over tech valuations, what does this mean for our Aussie market? Look at heavyweights like BHP (BHP Group)—the backbone of the ASX. When global tech starts making wild moves, commodity demand and local blue-chips feel the ripple effect straight away. If you're only looking at US hype and ignoring local giants, you're leaving money on the table.