3 Stmt Financial Model
Hello,
Hope everyone is well.
I was curious if someone would be able to assist me in a modelling work I have been working on.
Its a model for an ASX company Coles Group Limited, ASX:COL.
Details:
So far I have input last 2 years of historical data, but I am not sure if I have spread them correctly. I have used their FY 25 [June 24- July 25] financials. Attached are the actual financials & my model.
Confusions with my spreading:
Profit & Loss:
- Cost of Sales has Depreciation, I have separated Depn from COS. Is this correct?
- Administration Exp has Impairment Exp, which I have separated now. Is this correct?
Balance Sheet:
- I have separated all the fixed assets into different categories, including the intangible assets(?)
- RoU assets and Lease liabilities were very confusing, I just read about the online, and it seems we can either model Lease Lability as debt [Australian Accounting standard] or treat it as operating expense. Coles have treated it as a debt as per AASB (?)
- Provisions in liability section, I am not sure how to model these as most of the provisions are for employee leave & benefits (?)
Next Steps I am thinking:
- Model revenue based on foot traffic and online traffic as Coles sells items in store & online. Online sales growing strongly. So, I will use a growth, may be historical rate for online growth and for on-site may be an economic growth rate for Australia?
- I think I can easily model the operating working capital, but with fixed assets including intangibles, do I model& treat them similar to CAPEX, with maintenance CPAEX & growth CAPEX? [Land, Buildings, Plant & Equipment, Leasehold Improvs, ROU Assets, Goodwill & Licenses, Software (?)
- With interest bearing liabilities, I found that they have bonds and external debts, so I will model them (?)
Appreciate the help!
u/Maximin11 — 6 days ago