Posted: December 29th, 2014

ACCT222 Information Technology Project;

ACCT222 Information Technology Project;

You are assigned the following company for the project:
National Leasing
Please refer to the following details about the project below.
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 processing
3.    Reporting information
Data gathering:
You will be assigned a company listed on the Qatar Exchange. National Leasing. 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 June 30, 2010 until September 30, 2014 (total of 18 reports):
http://www.qe.com.qa/pps/qe/qe%20english%20portal/Pages/Home/
–    To find quarterly financial statements, go to the “listed Securities” tab in the Qatar Exchange website. 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 June 30, 2010, then September 30, 2010 and so forth. The two ratios that you will need are P/E ratio (defined as stock price divided by the earnings per share) and P/B ratio(defined as stock price divided by the book value per share).

Data processing:
–    Input and organize the data into an excel spreadsheet. You need to have separate columns for the date and each variable (i.e. net income, shareholders’ equity, P/E ratio and P/B ratio).
–    Compute your company’s return on equity (ROE) ratio using the formula functions.
–    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 the link below:

–    Conduct correlation analysis on ROE, P/E and P/B ratios. For more information on doing correlations via Excel, please follow the video in the link below:

–    Conduct regression analysis where ROE is the dependent variable and P/E and P/B ratios are the independent variables. For more information on doing regression via Excel, please follow the video in the link below:

Reporting information:
Write a brief report (two pages maximum) about the results of the correlation and regression analyses. Please make sure that you hand in the project in PDF form.
For more details about the project, please follow the captured lecture from December 14, 2014 (minute 30 to the end).
http://echo360.qu.edu.qa:8080/ess/echo/presentation/dfc335f0-2d8f-4e84-8d7f-69942f0a8b8f

Please submit the Excel spreadsheet

In case you have missing data for some periods, please find the average for the available periods and then use that value to replace the missing data.

Also, please keep in mind that you need four reports for each year:

Quarter 1             Semi Annual       Quarter 3             Annual

You need net income and equity information from each of the periods above.

The periods that are needed are from the period June 30, 2010 until September 30, 2014 (total of 18 reports).

So for example for 2010, you will need the semi Annual reports (June 30), the Quarter 3 reports (September 30) and the Annual reports (December 31).

For 2011, you will need the Quarter 1 reports (March 31), semi Annual reports (June 30), the Quarter 3 reports (September 30) and the Annual reports (December 31).

So on and so forth.

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat+1-631-333-0101EmailWhatsApp