This project examines equity-related issues such dividends, stock splits and foreign ownership for a Qatari company. This information should be obtained by using information technology and web based resources. One of the learning outcomes assigned to Intermediate Accounting II (ACCT222), is the ability to utilize information technology in making business decisions. To assess this outcome, you will be expected to participate in the following activities: 1. Data gathering 2. Data entry 3. Data processing 4. Reporting information This project is designed to be conducted individually. Therefore, it is not permitted for any student to seek help from others in any stage of this project. Background: Assume that you are a representative of an international consultancy company and you are asked to analyze the shareholders' equity section of a specific company located in Qatar. The information of this Qatari company is available in different websites through the internet. The requirement is to obtain this information and then utilize the advanced features in Excel (i.e., correlation and regression analyses) to make several business decisions that are related to the components of equity section and some other variables of this Qatari company. Data gathering: Each student will be assigned a company listed on the Qatar Stock Exchange. You will need to obtain the following information about your company for every quarter from June 30, 2015 until June 30, 2020. 1. Total assets, total current assets, total liabilities, total current liabilities, total equities net income and net operating cash flows. To find quarterly financial statements, click on the following link: http://www.qe.com.qa/pps/qe/qe%20english%20portal/Pages/Home/ then go to the "Disclosures" tab, then click on "Financial Reports", then click on "Financial Statements", then choose the "Year", then choose the company and click on the required report. Information Technology Project Intermediate Accounting II - ACCT222 Individual Project - Fall 2020 2 2. You will also need to obtain quarterly information about your company's dividend yield. To obtain this information, click on the following link: https://finance.yahoo.com/ a) Stock price: Search for your company's code (example Qatar Cement: QNCD). Click on "Historical Data" then click on "Historical Prices", then click on "Frequency", and then click on "Daily". Also go to "Time period" then choose your specified period. b) Dividends: Search for your company's code (example Qatar Cement: QNCD). Click on "Historical Data" then click on "Dividends Only". Also go to "Time period" then choose your specified period. c) Dividend yield: It is calculated by the following equation (dividends distributed in cash per share divided by the share price) You will need to obtain quarterly data from June 30, 2015 until June 30, 2020. Select the date, starting with June 30, 2015; September 30, 2015; December 31, 2015; March 31, 2016 and so forth. Until you arrive to June 30, 2020. 3. You will need to provide the following information for your company: Actual Qatari ownership, GCC individual ownership, actual foreign ownership. To find this information click on the following link: http://www.qe.com.qa/pps/qe/qe%20english%20portal/Pages/Home/ then go Click to "Market Statistics" and then "Statistical Reports", then go to "Actual ownership level". 4. You will need to state if your company has had a stock split during its life. To find this information, click on the following link: https://finance.yahoo.com/ then search for your company's code (example Qatar Cement: QNCD). Click on "Historical Data" then click on "Historical Prices", select "Stock Split". Also go to "Time period" then chose" "MAX". Take a screen shot of the result. Data entry: - Enter and organize the data collected into an excel spreadsheet. You need to have separate columns for each variable (dividend yield, total assets, total current assets, total liabilities, total current liabilities, total equity, net income and net operating cash flows) in order to correctly perform the required analyses, involving formulas and statistical functions, in the following steps below. - Using the data of the variables entered in columns, compute the following ratios for your company using the formula functions in Excel: a) Return on equity ratio (net income divided by total equity). b) Debt-to-asset ratio (total liabilities divided by total assets). c) Current ratio (total current assets divide by total current liabilities). 3 d) Cash flow ratio (net operating cash flow divided by total assets). e) Company size (natural logarithm of total assets). (Note: the values of each ratio should be entered in separate columns) Data processing: - Conduct descriptive analysis via excel for the following ratios computed in the previous step: Dividend yield return on equity ratio, debt-to-asset ratio, current ratio, cash flow ratio, company size. For more information on conducting descriptive analysis via excel, please follow the video in the link below: https://www.youtube.com/watch?v=YLK8zxojdh0 (Note: make sure that your Microsoft Excel has "data analysis" in the "Data" tab. If it does not, then please follow the instructions shown in the video through this link: http://www.youtube.com/watch?v=_yNxLFagKgw ) - Conduct correlation analysis on the different ratios. For more information on doing correlations via Excel, please follow the video in the link below: http://www.youtube.com/watch?v=zEXK6M93lb8 - Conduct regression analysis where Dividend yield is the dependent variable and the five ratios (return on equity ratio, debt-to-asset ratio, current ratio, cash flow ratio, company size) are the independent variables. For more information on doing regression via Excel, please follow the video in the link below: http://www.youtube.com/watch?v=TkiB1xBnjn4 http://www.youtube.com/watch?v=ExfknNCvBYg Reporting information: Write a brief report (two pages maximum) about the results of the descriptive statistics (mean, median, standard deviation, minimum and maximum), correlation and regression analyses. Please insert graphs to explain your results. Finally, please make sure that you hand in the project in PDF form