Forums › OBU Forums › Topic 8 Financial Statements
- This topic has 261 replies, 81 voices, and was last updated 7 years ago by wajih16.
- AuthorPosts
- November 5, 2014 at 12:52 pm #207808
Hi @Trephena
Thank you again.
I’m so sorry I keep coming back with my doubts but please bear with me these few days. You’re a knowledgeable source and at the moment I don’t have peers to turn to plus my mentor is not experienced so I come here. Trust me, where I live, acca people are a rare breed.
I’d appreciate if you can offer your suggestions for this:
1. I did a segment analysis for my target company as it has operations in different countries. I analysed on the basis of its revenue/trading profit margins and compared performance in all the regions over the years. Now my question is am I expected to do some sort of segment analysis for the comparator too?
The comparator company however does not have international businesses like the target company. They only compete in the home market. So analysis of their segment gets difficult. However, I had the idea of analyzing their profits at the same home market but target company provides only trading profit figure for market each regional market segment (op profit, profit for year are at group level) while comparator does not provide a figure for trading profit and segmented its markets based on its various services provided. Therefore I am not able to find like-to-like info on the two in their reports, notes or website.
So can I just analyse segment profit change over the ears of the target company and leave out the comparator in this case? Or is the comparator bit a must? π
2. About interest coverage: Interesting point you make about the finance cost. Yes I looked through the notes already. But If the income (PBIT in this case) I am taking in the numerator excludes finance income; then taking the net interest expense (finance cost-finance income) makes sense doesn’t it? Please correct me if I’m wrong.
November 5, 2014 at 2:41 pm #207837@avian will
1. No don’t bother with the comparator for the segmental analysis (a) it is only required for the actual financial analysis and (b) sounds like you wouldn’t really be comparing like with like anyway
2. Oh go for it! Bung the formula and calculation you use on your Excel sheet -I doubt the marker will seriously question the treatment as long as you are consistent
Now for goodness sake chill – there is a life after the RAP and you need to go out and live it a bit… π
November 7, 2014 at 10:37 pm #208325@awais21 – If you are already comparing your main company with its competitor then I do not think you would “need” industry average. Basically, the whole purpose of this comparison is to determine the ‘strategic position’ of your main company. And to give meaning to your analysis. For example; if a company has 55% GP margin, you cant tell if its good or bad until you compare it with a similar company. In my opinion, your analysis will be much better if the competitor are similar in terms of market, operations, products etc. For instance, Apple and Microsoft are generally seen as competitors but if you were to do your analysis on these two companies, you will notice that the differences in their products make them very different. Microsoft has a big portion of revenue coming in from their licensing fees and thats how they generate “recurring” revenue. Its more focused on software compared to Apple, which believes in integrating both. This is just to give you an example that if you ever doubt your analysis, just step back and look at the bigger picture and “why” are you doing something.
I also want to add that if you are using the above mentioned format in your RAP analysis then in my opinion, you are wasting valuable words. For example, you can combine step 1, 2 and 5 in one single graph. In excel you need to choose the format of the graph that shows your figures at the bottom and prepare the graph for both the main company and the competitor.
November 8, 2014 at 4:50 am #208338Thanks @isookvi
Regarding step1,2,5 combination I will try to use the wise words as much as possible.
I am doing rap on cement company say Γ and its competitors Comp Y and Z , i did the comparison of Γ with Y and Z
E.G say gp was low Bcoz Fuel chargΓ©s moved up by 38% causing the oil and gas prices to go up hence fuel chargΓ©s shooted up , similar for power consumption and to give it Γ taste i did add y in my country fuel and power charges went up with rΓ©f etc.
Comp y and Z performed better Bcoz of augmentΓ©d profits and gavΓ© the reason for it
Now tell me that above approach was right or not
Do i still need industry AVG stuff or comparison with two companies in same industry, similar products ,same country operations is enough??
And thnx for Excel sheet charts i did the same like you suggested.
Thanks
Plz answer this too.
Why Trephena’s reply hasnt come yet π
No hard feelings isookvi you were also vert much of Γ help thanks
RegardsNovember 8, 2014 at 5:40 am #208345@awais21 – I was going to reply to i@sookvi to thank him (? or her) for their excellent advice and was going to say there was nothing further I could add! – So thank you isookvi for the clear and really good post π
Back to you awais21 – I think it sounds a good idea now you have explained it in better detail but be careful that you do not over-complicate things. I would still be inclined to go for one main comparator Comp Y and only bring in Comp Z to back up the situation where there is a significant difference between A & Y. Your mission is to do a good financial & business analysis of company A in 7,500 words and not financial & business analyses of companies A, Z & Y – So some use of Z to support your Findings could strengthen your analysis if used wisely but otherwise using it for every ratio may not add much and start to be a disadvantage in terms of word count.
In respect of graphs as isookvi suggests bring in the comparator(s) at graph step 2. There is no need to keep repeating things so let the graphs ‘do the talking’ and use your words for those all important explanations as those are what will make the difference between passing and failing.
(Please everyone – I give of my time voluntarily and am not an OT employee: although I try to answer promptly, I do have my own life outside of these forums so I am delighted when our former students who have passed, return to make good contributions based on their own experience π ).
November 8, 2014 at 11:16 pm #208497@awais21 – No worries. My knowledge is pretty limited to topic 8 based on my own research and I always hope that @trephena would correct me if I am off somewhere.
@trephena – No need to thank me as I try to jump in every now and then to see if any questions were left unanswered (though I rarely find any lol). OT is lucky to have you as their moderator as you put a lot of effort in these forums. OT helped me a lot when I was studying ACCA and working on my project. I recently got my full membership of ACCA and feel the need to jump on here, whenever I can, to see if I can be of some assistance.November 9, 2014 at 1:24 pm #208588@isookvi
THANKS ALOT for your help and time, your suggestion was good it looks pretty good now,my RAP.
@trephena
thanx for your help , i know its difficult to be present all the time, but thanks for your time.so i have done some changes in graphs
the ratios are evident through table and graphs as foolowingtable
Graph
graph content in bars: my company ratio, compet-1 ratio, compet-2 ratio, Industry average
is is good to show like that?
looking forward
RegardsNovember 9, 2014 at 1:25 pm #208589pardon the spellings π
November 10, 2014 at 8:11 pm #208904Hi,
It dawned on me that I did not put any tables in my RAP showing the absolute numbers for gross profit, net profit… I have graphs showing the profit margins is % and have not used the absolute numbers to do any explaining. So is it recommended to still show tables with those figures? or the graphs with the margin percentages is enough?
Thanks!
November 10, 2014 at 8:41 pm #208908@avian will -absolutely no problem. The reason you use ratios is that it takes care of any differences in size and makes the trends more comparable
November 12, 2014 at 7:52 am #209253In light of what you just said about comparators…
When I am explaining the differences between target and competitor company, is it enough to just explain the main reasons behind why target company’s results are so and so and just use the competitor’s figures to show how much worse/better target is doing? I mean do I have to go into deep reasons on why competitor’s results are what they are?
E.g. say I’m talking about their gearing levels and explained why target company’s gearing is increasing and then say it is geared at a higher level than competitor making it more exposed to risk. Now do I have to explain why the competitor’s gearing increased over the years too?
Thanks!
November 12, 2014 at 4:09 pm #209390@avian will – depends if you want a higher grade or are happy if you get a C. The better the evaluation the higher the grade usually, provided everything else is fine.
April 8, 2015 at 1:28 pm #240513Hi Trephena
I am having really big problems choosing a company to base topic 8 on. I decided on Pak Suzuki and Honda as a comparison because the financial statements are on their websites. The problem I am having is finding sources of information outside of the information one their websites. For this reason I have decided that it maybe best to chose a different company. Please can you guide me on reliable places to find out business information like your example of Laura Ashley? I am hoping this may guide me in choosing the right company.
So far I am thinking possible one of the following: lloyds, hsbc, aldi, marks and Spencer’s, next, John Lewis, Ryan air, Apple. This is based on looking at the business section of the telegraph.
Many thanks
JennyApril 8, 2015 at 2:58 pm #240521Please help ????
I really want to base me project on a UK company as I find I am getting confused if the company is global because they are effected by lots of different factors depending on the countries they are in and I think i will find it difficult to do a SWOT and PEST analyses. Also I think I would need to understand the impact of each country on the business. ????
I am going round in circles and feel very stressed. I need to make a decision so I can get started. But it’s a very important decision to make as it will impact everything I do in the project.
I was thinking Aldi would be a good company as it’s been in the news a lot recently and maybe bench mark against Waitrose as this is who is being used in the news. Aldi’s approach is low prices and simple layouts, Waitrose is at the expensive so I am not sure they are comparable. Maybe Tescos but I don’t think their financail statements are correct.
The financail statements are not on Aldi website and I think only group accounts are on companies house.
If anyone can help me decide I would be eternally greatful, please
April 9, 2015 at 4:32 am #240595I’m not sure how the appendices work.
1. I just cut the Financial Statements pages out of Annual Reports. They’re about 5 pages long for each company. Should I include the Notes pages as well, which are about 50 pages long for each company?
2. Can I use separate financial statement appendices for the two companies? eg. Appendix 1 for CompanyA and Appendix 2 for CompanyB.
3. And I will use Appendix 3 as formulas and calculations in an Excel spreadsheet. I wonder how many separate appendices can I upload? Or I just have to combine them as one.
Thanks.
April 9, 2015 at 7:30 am #240607I have just come back from leave and need to catch up with everything. Time is currently in short supply so please note the following:
@moioi – We have a forum called Appendix Queries so please look there first for an answer. If you question has not been dealt with and answered previously please re-post it there as we need to group similar queries together under a topic heading.@jenny17 – please use the search facility for RAP models or look at the last few pages of our OBU forums where models were raised and have been dealt with.
As a general rule everyone – please do NOT keep opening new topics – LOOK first as it wastes everyone’s time having to repeat information (please see HELP KEEP OUR FORUMS TIDY!!!!!) and consider which is the most appropriate place to post your query if you cannot find any previous answers that deal with it. Thanks.
Trephena
April 12, 2015 at 10:22 am #240995hello @trephena i am doing topic 8 and the comparator company i have chosen is of different currency..which exchange rate sud i use to convert the currency?i used the exchange rates of 31st december 2013, 2012 and 2011 for the respective financial statements as the financial period ended in 31st december..or do i need to use an average rate??pls suggest thankyou..
April 12, 2015 at 5:09 pm #241032@Jenny77 – if you are in Pakistan then you should be able to use articles from Business Recorder and Dawn as independent sources of information for your report. Of course if you want to choose a UK company that won’t be a problem and the independent sources available to students are the BBC news (business pages), Daily Telegraph, uk.reuters.com/business. I particularly suggest you follow Kamal Ahmed, the BBC Business Editor as he produces some very good understandable articles.
Aldi (or Lidl) may be a problem as it is a German not UK company, having said that it is now a major force in UK food retailing. While its target market is very different from Waitrose – Aldi targets socio economic groups C & D whereas Waitrose is B &C could could work round this. The main problem I would see is being able to separate out UK market figures for Aldi as it would NOT be appropriate to compare its whole European sales with Waitrose as the latter operates predominantly only in the UK so comparisons would be meaningless.
Usually you focus on the main sphere(s) of operation for the SWOT and PESTLE
April 12, 2015 at 7:03 pm #241047@saananaani – Your ratio analysis should use per centages mostly so the forex rates are not really relevant. You should be comparing the GP % ratios of the companies and their EPS’s etc so actual currency amounts are not being compared.
Remember although you are not required to used the unaudited interim accounts as your financial statements will be nearly a year and a half old by P30 Submission you need to consider any potentiall more recent material developments that might have had a significant impact on the company e.g. sudden major drop in share price when looking at the investor ratios or restructuring announcements.
April 16, 2015 at 4:40 pm #241536Hi Trephena,
I’m having a problem with the financial statements. As I failed last time, I need to update the financial statements to last year which is 2014. In 2014 financial statement, there are some reclassifications in the income statement of the year 2013 so that revenue and selling expenses were different. So I want to ask if I still keep the figures in 2013 or change them according to the new financial statement? If I change them so that they are comparable to 2014 figures, they are not likely to be comparable to 2012 figures any more.
Can you please help me on this problem? Thanks a lot.
April 17, 2015 at 7:15 am #241573Ha – you go with the latest years as these are the more reliable figures. Any extraordinary circumstances surrounding your information gathering need to be stated in the Limitations section so explain there about the restatement. It may be appropriate to mention it again when discussing the revenue and selling expenses
April 17, 2015 at 3:59 pm #241624AnonymousInactive- Topics: 0
- Replies: 4
- β
Dear @trephena
I failed last time on topic 8 and am now confused on which financial statements to be used to update my RAP. Last time when I submitted in November 2014 I used the financial statements of year ended 31 December 2011, 2012, 2013. Now, I intend to submit next month in May 2015. The financial statements for year ended 31 December 2014 has not yet been published. According to official announcements, it is going to be published at the end of this month (April 2015). So, it is expected to be available at the start of the submission period 30. In the information pack there are two conflicting requirements stipulated:1. The programme requirement is that you use the last 3 financial reports that are available, or will be available, at the start of the submission period
2. The Programme Director has advised that any Company results that are published (in any form) less than 90 days before the start of submission do not have to be used.
So in my case according to the requirement 1, the FS of 2014 should be used and according to requirement 2 it should not be used.
What is the correct way?
April 17, 2015 at 4:39 pm #241627@rs504 – It is the way you are reading it. For clarity:
1. You must use the lastest FS available for every submission
2. However if the latest published FS were only made available “(in any form) less than 90 days before the start of submission [they] do not have to be used”.
3. The submission period starts on 1 May and 90 days before that would be about 1 February
4. Your company’s 31 Dec 2014 FS will be published shortly i.e. end of April so this would be less than 90 daysIs that clear now to you that you go with 2013? Make sure you explain why in your Limitations section. I would say in bold something along the lines that one of the limitations of the data is that it is now fairly old as the 2014 FS were only released on XX date.
However as I have pointed out many times before if anything material or spectacular has happened to the company since Dec 2013 you would be expected to acknowledge this to show that you have researched well (this would include any scandal, takeover of the company, chairman stepping down, profit warnings or serious lowering of their credit risk score by Moody or Dun & Bradstreet etc.
April 17, 2015 at 6:30 pm #241636AnonymousInactive- Topics: 0
- Replies: 4
- β
Yes, its clear to me now..Many thanks @trephena for your invaluable support.. π
May 1, 2015 at 5:12 am #243456I failed on topic 8 at my first attempt and am now confused on whether the financial statements I used should be updated. According to p39 of the information pack, the results that are published less than 90 days before the start of submission do not have to be used.
Last time I used the financial statements of year ended 31 December 2011, 2012, 2013. According to the re-submission guide, it said that “for re-submission this can mean reworking all your figures”. However, the updated annual report of the company (annual report 2014) was released on 9 April 2015 which showed on its website.
I reviewed the contents of the annual report 2014, there is no information on its publication date except the signing date by the audited company (18 March 2015). So I wonder how the marker knows the exact publication date. Should I make an explanation about its publication date?
- AuthorPosts
- You must be logged in to reply to this topic.