Reference no: EM132278553

Case Study Assignment -

One of the learning outcomes assigned to Intermediate Accounting, is demonstrate the ability to critically analyze accounting issue and to apply accounting knowledge to solve business problems. To assess this outcome, you will be expected to participate in the following activities:

1. Data gathering

2. Data processing

3. Reporting information

Data gathering -

This is individual performed case study. You will be assigned a company listed on the Qatar Stock Exchange. You will need to go on to the following website in order to download in information about your company's quarterly financial statements and financial ratios for the period 2011 until 2019 (total of 20 reports).

• To find quarterly financial statements, go to the "listed Securities" tab in the Qatar Exchange website, and then click financial statements. From the reports, you will need to collect information about the company's net profit and total shareholders' equity.
• To obtain financial ratios, go to "Market Statistics" and then "Financial Indicators". Select the date, starting with 2011, until 2019. The three ratios that you will need are return on shareholders' equity (defined as net income divided by the average shareholders' equity), and Earnings per share (defined as earnings per share divided by the number of outstanding share), and earnings / price ratio (defined as earnings per share divided by the market price per share).

Data processing -

Input and organize the data into three separate tables.

Table No. 1: consists of the following columns: date, net income, average of shareholders' equity, and returns on shareholders' equity.

Table No.2: consists of the following columns: date, net income, number of shares, and earnings per share.

Table No. 3: consists of the following columns: date, earnings per share, average of share price, and earnings / price ratio.

Reporting information -

Write a brief report (two pages maximum) about the results of the comparison between the book value of shareholders equity and market value of shareholders equity, and how such change in these two ratios affect decision-making and performance of the company, especially in view of:

• Change in net income
• Change in shareholders' equity
• Performance rules and policies
• Other factors

Attachment:- Assignment File.rar