Hello, so for the assignment I will share a word document it includes everything you need to know please go over it step by step and include everything. I have already chosen my company from Qatar stock exchange and the company is QNB and for my competitive comoany is Doha bank I have downloaded the financial analysis for that the income statement, balance sheet, cash flow and 2 ratios. For the assignment you need to do the 4 types of ratios to calculate which are: 1)profitability ratios 2) liquidity ratios 3) solvency ratios 4) investment ratios You will need to upload a word document report worth 2000 words and an excel sheet where the calculations are and graphs then you can upload the graphs on to word but I need both word and excel documents. Please avoid plagiarism Add table of content please and reference page (this is not included with the word count) As you can see on the word document there’s 5 steps include all please and don’t forget the ratios. The information on the assigment is under the document “AF4037- ASSESSMENT REPORT”
I have uploaded 2 examples of students work last year under the name “exemplary report 1 and 2” please look at it so you have kind of an idea how it should be.
I have also uploaded ooredoo excel sheet and Doha bank excel sheet, in these documents i got the financial statements from bloomberg please for the graphs and ratios do it all on the excel and then submit the excel sheets and word documents but for the graphs posts them on the word document and when theres a comparsion between both companies paste the graphs next to each other to show the comparsion
//one of my friends the tutor gave her a feedback for introduction she said:
Introduction:
Consider providing more information on the company profile (Workshop week -1), such as: location, year established, year listed, size, its market/audience, management, etc… [see Instruction (1) on “Assessment Brief”]
Suggest you add a short paragraph after introducing the company, on what is the purpose of the report. Also, you could mention who you will compare with.
Analysis:
In your ratio analysis, the 10 year analysis doesn’t clearly come across, other than on the graph. Furthermore, the possible reason or cause for any changes/differences in the results, need to be mentioned, as it is part of the analysis. See the Example Reports on blackboard, they may guide you on this.
Just a note, in your analysis, bear in mind the size of the companies. Your selected company is much larger than its peer company. And in cases where size could have an effect on the reason for certain performance, you could mention the possibility that the difference in size could have on it.//
