- This topic has 261 replies, 81 voices, and was last updated 7 years ago by
.
- Posts
i have tried all sorts but adobe can not let me copy and paste.
What i am going to do is print the statements and then scan them as PDFs for both company and Comparator. If say i did them in pdf format how can i go about with formulas in excel in ratio calculation?Just a clarification please, my company year end is 31 march, so am i correct to start with FY 11/12 statements?
With the the SLS, do i need to repeat the 4 questions in my upload as this will count towards the word count?
@lamech311. You will have to do prints and scans as you suggest. Unless you have access to a program that will convert pdf to Excel you will probably end up having to type in your figures on the Excel spreadsheet but you can use some of the ratios that the company has already calculated if appropriate as long as you acknowledge the sources.
Yes your reference year starts with year end 31 Mar 2012.
You do not have to repeat the whole of the Questions (or do a contents page) for the SLS. You could shorten- e.g. Q2 How I met RAP Objectives, Q3 Interpersonal and Communication skills
Thanks guys for this discussion, the company I am assesing on my RAP have financial statements from different sources eg from their website, London Stock Exchange, and other search sites. However there is a slight difference between them and some of them have extra bits which is missing in the company’s statements, I know that this is what I should mention in my limitations section, but I dont know which ones to rely on and whether to use the extra bits as well. At the moment I am using all the financial statements by just selecting what I think is important for my use.
Any ideas on how I should go about it? Thanks- Topics: 0
- Replies: 3
- ☆
@trephena Thank you very much trephena, i just on business trip and back this week. I have read through your advise and really appreciate your guidance.
I decide to amend my RAP and make the financial statement from 2011-2013 as latest in my 2014 November submission.
The company i work for is a UK registered bank’s subsidiary in China. Since all the foreign banks are subsidiaridise in China, the financial information and market information will be available on internet, to avoid overwhelming information, i will use only HSBC China and my compnies data. Will this be ok? thank you again.- Topics: 0
- Replies: 1
- ☆
Hi @trephena, I am doing topic 8, can I know which figure to use (group or company) from financial statement? Normally there are two types of figure available.
@jeyasree. To a certain extent you can choose whether you want to use a company that is in a group or look at the group as a whole provided that you do the same for the comparator and are consistent and don’t swap between the two. So the choice is yours.
@gbscool Apologies for the delay in responding. Yes you need to compare like with like so it would be meaningless to compare a local bank with the global operations of something like HSBC.
Remember with a bank you need to tailor the ratios to the industry (CAMELS model perhaps?) but as you work in the industry that shouldn’t be a problem. Mention the work of the Basel Committee and anything else that is bank specific and relevant to the analysis of a bank.
BTW did you contact the Learning Luminarium about mentoring?
Hi,
I have chosen to work with on a company that has a year end in March . Since March 14 , a quarter statement has been released and by the RAP submission date( mid November) another quarter would have passed ending in September. Am I expected to base my RAP on these statements too or can I prepare my RAP on the last three years upto march 14? Please advise .
@sadsingh You are not expected to use the quarterly statements. If the latest full year ended in March 2014 then that is your reference year.
Note: We have covered the subject of dates of financial statements in quite a bit of detail on the Forum ‘Quick clarification: Financial year Results’ so you may wish also to read the queries and replies there
@trephena I apologise for not having checked there prior to posting my query. Thank you for your reply. Appreciate it.
hello ,
I need your advice about f/s. company i have selected is LUCKY Cement in Pakistan, and Its competitors are Fauji Cement Company ltd and Bestway cement ltd both in Pakistan. The problem is the Lucky Cement hasn’t issued their annual report yet but only unaudited quarterly statements, same is the case with Bestway cement but Fauji Cement company ltd annual report 2014 is available.
Now my question is can i use 2013,12 and 11 reports or i must use 2014??sorry didn’t know that for f/s dates discussion there is separate thread. i have posted there as well.
hello
the company i choose for topic 8 has more than 20 subsidiaries should that be a problem? or i just need to analyse the parent company i choose and compare it with competitors which do not have so many subsidiariesHello
Could you please advise how many slots available on the OBU website that can take uploads?
what i mean is whats the maximum number of files that can be uploaded on the OBU website please for example If you have files like; RAP, SLS, PRESENTATION SLIDES, EXCEL and 2 PDFs(being financial statements for the two companies). Can all those be uploaded?@lamech311 – yep you should be fine on the number of files (I think it will take up to about 10- but they expect the ref list to be loaded as a separate file). However there is a limit on file sizes -so see the latest P29/P30 Info PacK for details as files that exceed the individual size limit will be rejected automatically by the system.
The annual reports of the company that I am focusing on Is providing a consolidated and a non consolidated form of financial statements. So is the comparator company’s annual report. I am not sure which to base my analysis on. Please advice.
@trephena
Thank you for answering my query. I have another one to ask you.
The annual reports of the company that I am focusing on Is providing a consolidated and a non consolidated form of financial statements. So is the comparator company’s annual report. I am not sure which to base my analysis on. Please advice.@sadsingh – you need to compare like with like to be able to make meaningful comparisons so either both single company or both consolidated (my gut feeling is that the consolidated offer broader scope). As the choice is yours why not read the CEO/ Directors reports and get a real feel for things before you start doing your serious research? – as I have indicated in my article on Evaluation on our home pages it can be very enlightening to discover company strategies and really improve the quality of the E & A section
@ trephena
Hi,
1). Is it necessary to draft the financial statements in excel then convert to PDF( as an evidence of using spreadsheet) or can I save the PDF pages directly from the annual reports that show the financial statements?
2). On the annual reports there are several pages of notes following the financial statements. Are they suppose to be included along?
3). Is it ok to save the ratio analysis page in the annual report along with the corresponding statements or should that be saved separately?
Please advice,
Thank you.1. you need to include some evidence of use of spreadsheets with your work to fulfil the IT criteria so bear this in mind. Maybe show some raw figures and how you did the graphs from these. It doesn’t have to be pretty, pretty – just evidence that you know how to do it and you load it as one of your appendices
2. I don’t think the markers want or have the time to read all of the annual report so only include the financial statements unless there is anything that is particularly relevant in any notes. Remember your explanations have to go beyond the annual report as just citing the notes to the accounts will not get you a pass as it does not really explain the all important underlying causes. Also remember there is a limit on pdf file sizes so see the Info pack for these
3. Not sure exactly what you mean – yes you can have them in the same file if you want or different files. You can load up to about 10 files provided none of them exceeds the individual file size limit
Hi people! is there any limitation to the number of pages for the appendices, I am thinking of pasting my financial statements for the three years which means three pages and also another 3 pages for my comparator company and then my ratios among other appendices?
@denmaster – file size limits, so see the Info pack for these
Hi Trephena, I am writing thesis on topic 8 and for analysis I have selected Marks & Spencer as main company and Next Plc as its competitor.
Problem that I am facing is that both companies year-end is different. Year-end of M&S is on first Friday of the month of March and Next Plc is having year-end in January.
Can I select these companies for analysis???
- You must be logged in to reply to this topic.