Apologies, my calculations were out of whack, as you'd applied 3/4 ($2.625m) of the repayments to Q2 instead of 2/4 ($1.75m) and I followed that through. The net quarterly income from Q2 was then incorrectly applied to Q3, as your logic implied a 50/50 split of repayments, but the numbers in fact show 3/4 to 1/4. This has the effect of short changing Q3 by $1.75m (by understating net income by $0.75 in Q2 and flowing through to Q3). The end effect is that the increase in Q3 to Q4 balance is correct, but the starting point is too low. So, my perpetuity comment was incorrect.
Q2 closing balance is under by 1/4 of the repayments ($0.875m) as you've applied 3/4 of the repayments to the June quarter instead of 2. Closing balance should be circa $1.7m.Disregarding the repayments, quarterly net income should be circa $3.65m.
In Q3 1/4 of $3.5m should be applied, seeing this net figure reduce to $2.8m. This leaves the end of Q3 balance at $4.5m.
Q4 sees net income of $3.65m leaving end of Q4 balance at circa $8.2m. Happy to be corrected if I've put a foot wrong there - hard without the spreadsheet.
- Forums
- ASX - By Stock
- Ann: Debt Refinancing and Drilling Program Update
Apologies, my calculations were out of whack, as you'd applied...
-
- There are more pages in this discussion • 62 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Add BYE (ASX) to my watchlist
(20min delay)
|
|||||
Last
5.4¢ |
Change
0.004(8.00%) |
Mkt cap ! $53.93M |
Open | High | Low | Value | Volume |
5.1¢ | 5.4¢ | 5.1¢ | $12.54K | 236.3K |
Buyers (Bids)
No. | Vol. | Price($) |
---|---|---|
2 | 210876 | 5.3¢ |
Sellers (Offers)
Price($) | Vol. | No. |
---|---|---|
5.9¢ | 17174 | 1 |
View Market Depth
No. | Vol. | Price($) |
---|---|---|
1 | 5688 | 0.053 |
2 | 217656 | 0.051 |
1 | 20000 | 0.048 |
1 | 455587 | 0.047 |
2 | 402460 | 0.046 |
Price($) | Vol. | No. |
---|---|---|
0.059 | 17174 | 1 |
0.060 | 296241 | 4 |
0.063 | 65000 | 1 |
0.065 | 100000 | 1 |
0.070 | 120000 | 2 |
Last trade - 10.19am 06/06/2024 (20 minute delay) ? |
|
|||||
Last
5.3¢ |
  |
Change
0.004 ( 6.00 %) |
|||
Open | High | Low | Volume | ||
5.2¢ | 5.3¢ | 5.2¢ | 31012 | ||
Last updated 10.15am 06/06/2024 ? |
Featured News
BYE (ASX) Chart |
The Watchlist
CCO
THE CALMER CO INTERNATIONAL LIMITED
Anthony Noble, CEO
Anthony Noble
CEO
Previous Video
Next Video
SPONSORED BY The Market Online