Eid Greetings!

May the Blessing of ALLAH Fill your life with happiness and open all doors of success now and always.

~ EID MUBARAK ~

FIN254 Project Update!

An excel template (Template.xlsx) has been made available in the project folder. You will be using this template for each of the stocks you are assigned for individual project work. Following are some steps you would follow for each stock.

1. After downloading the file, open the file using Microsoft Excel and then rename (using save as function) it using your id, name, and DSE trading code of the stock. For example, if your id is "101-1010-030", name is "Salman Khan", and company is "Grameen Phone Limited", then you should rename the template as "1011010030_SalmanKhan_GP.xlsx".

2. There are three worksheets in this template. First worksheet is "DSE Company Profile". You would copy and paste the company profile from Dhaka Stock Exchange website (http://www.dse.com.bd/displayCompany.php?name=?) [replace "?" by your stock's DSE trading code].

3. Second worksheet is "Data Entry and Analysis". You are required to fill up the yellow colored cells only. Start with the period 2011, and then proceed to earlier periods gradually. Most of the necessary data would be found in the periodic financial statements. Some data may be found in the annual reports, or in the company profile page of DSE. Two additional excel files have been provided for your assistance. One is "MONTHLY PRICE DATA BETWEEN 1999 TO 2012.xls" to record share price at the end of each period. Another is "DIV. ARCHIVE.xls" to help you record dividend related data.

4. Third worksheet is "Remarks". Here you discuss about problems you faced in data entry and ratio analysis for the stock.

If you have any issue regarding data entry, please don't hesitate to contact me. If data entry is done, you email me (to both of my email addresses with appropriate subject) softcopy of the excel file and submit printed copy of the "Data Entry and Analysis" worksheet by 20th November, 2012 to get your 3 points for the project.

There will be a penalty for late submission. Each day of delay will cost you 5% (i.e., 0.15) of data entry points. Of course, you may submit it earlier. There will be bonus points for early submission. You will receive 10% (i.e., 0.30) of data entry points for each day. However, total bonus points will not exceed 2 points. Incomplete submission would not qualify for bonus points.

Career Seminar by Airtel!

The Department of Career & Professional Development Services (CPDS) cordially invites you to attend a career seminar by Airtel Bangladesh Limited.

Date: 17 October 2012, Wednesday
Time: 10:30 am to 1:00 pm
Venue: OAT 801

Your participation will be highly appreciated.

Career in Accountancy!

The Department of Career & Professional Development Services (CPDS) of North South University (NSU) cordially invites you to join a seminar on “Career in Accountancy”. The seminar will be conducted by ACCA Bangladesh.

Date: 16 October 2012
Day: Tuesday
Time: 10 am –1:00 pm
Venue: OAT - 801

Your participation will be highly appreciated.

Presentation on Dhanmondi Lake!

Renowned environmentalist & architect Iqbal Habib, principal of Vitti Sthapati Brindo, will be making a presentation on the design and vision of the Dhanmondi Lake and Begunbari Khal - two very important urban development projects of recent times and lifelines of Dhaka city. His presentation will touch on issues like environment, physical planning and urban design.

Architect Habib and his firm Vitti have won several local and international design awards and their significant projects include the design of the Bangabandhu Mausoleum at Tungi Para, Bangabandhu Musueum and Dhanmondi Lake Development Project, Shahid Dr. Milon Memorial at the TSC Circle, Begunbari Khal Development and several others.

Architect Habib is going to present for the first time at NSU. You are cordially invited.

Meet the Leaders!

Junior Chamber International (JCI) Bangladesh is going to conduct a seminar session on “Meet the Leaders” at North South University (NSU). JCI World President will be attending as speaker. CPDS cordially invites you to attend this seminar.

Date: 10th October 2012; Wednesday
Time: 3:00 pm
Venue: OAT 801

Your participation will be highly appreciated.

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!

US Election and Democracy!

USAID is going to conduct a seminar session on “US Election and Democracy” at North South University. CPDS cordially invites you to attend this seminar.

Speaker: Mr. Paul  Sabatine (US embassy )
Date: 10th October, 2012; Wednesday
Time: 10:00 am to 12 pm
Venue: OAT 801

Your participation will be highly appreciated.