1.This project aims at improving student’s skills that are related to understanding, preparing and analyzing financial statements.
2.The project is free case. This means the student will be free to select published financial statements (annual report) of any company from newspapers, websites or any other sources. According to this project, the student will be liable to copy the income statement and the balance sheet (for two years, the current and the last) from the annual report into an Excel sheet.
3.Student will act as a credit manager in a bank and has to decide whether to grant the selected company a loan or not based on the evaluation of the financial statements of the selected company using ratio analysis (debt ratio and current ratio only) for the current and last year.
4.This project is based on the philosophy of e-tables (Excel), so students have to use formulas (addition, subtraction, multiplication and division) to build each financial statement and to link the cells to each other when necessary. Submission without using formulas and linking cells in the Excel sheet will lose some marks.
5.This is an individual assignment and every student should choose a different company and to register the chosen company in his name with his tutor. Company could be a local, foreign or international, Qatari or non-Qatari company. Please don’t choose BANKS or FINANCIAL INSTITUTIONS (e.g. insurance companies). You can get the annual report from the company’s website, Stock exchange website, or any other website but you must cite the source of your information (reference).
6.The total marks assigned for this project is 15 marks. Project marks will distributed as follows:
Income statement – 4marks
Balance sheet – 4marks
Financial ratios and the credit decision-making – 3marks
Using formulas and linking cells in the Excel sheet – 4marks
7.The submission of this project (only one Excel sheet) should be done via the Bb through the safe-assign link and similarity test will run after your submission.