FIN254 Project!

The purpose of this project is to analyze some DSE stocks using Ratio Analysis. Each student is assigned with 2 stocks to analyze (please refer to “Assigned Stocks” file to know about yours). You will have to analyze 10 years of data. Necessary files have been uploaded in the “Project” folder. There are three important deadlines to meet for the project as mentioned below.

Important Tasks	Weeks	Deadline	Points
Data Collection	2-wks	22-OCT	3
Data Entry	4-wks	20-NOV	3
Ratio Analysis	2-wks	04-DEC	4
Total Project Points			10

What is Data Collection?

Here data collection means to collect audited financial statements (Balance Sheet or Statement of Financial Position, Income Statement or Statement of Comprehensive Income, Statement of Cash Flows, and Statement of Changes in Equity) with relevant Notes/Disclosures found in the Annual Reports for the stocks you are assigned with.

Where can we find the Data?

Primary source for the Annual Reports of the companies is the Dhaka Stock Exchange (DSE) Library. If the relevant annual reports are available in digital format, you may order a data cd. Please keep your NSU Id with you to get student discount. If digital version is not available, you may photocopy relevant pages of the Annual Reports. You may also look for the annual reports in the footpaths/sidewalks in front of the DSE building which might be cheaper than photocopying. For recent years of data, you may visit company website and download them.

Once data is collected you show me the data to get your 3 marks for the project.

What is Data Entry?

Once you have the data, means, the annual reports, you are ready to input relevant data in an excel template that I would provide you. There would be designated cells where you make the data entry as instructed.

Show me the excel file once data entry is complete to get another 3 marks for the project.

What to do for Ratio Analysis?

I will give some ratio to calculate. You would be using the excel file where you made the data entry to calculate the ratio I would give you. Once you are done calculating the ratio, you submit your excel file along with a short report to me to get your last 4 marks for the project by the deadline.

You may visit the DSE link (http://dse.com.bd/company%20listing.php) to visit your assigned stocks to get some idea about them. If you have any questions or issues, please don’t hesitate to contact me as soon as possible!