Wednesday, November 26, 2008

FIN254: Project

Following link will take you to the project folder. You may download all necessary files (daily price quotation, month-end price quotation, dividend information from January 2001 to Jun 2008 of all shares listed with Dhaka Stock Exchange (DSE), excel data analysis template, word report template etc.) from there. Please use the Template.xls for individual stock evaluation. Rename the excel file using stock ticker followed by your id number. You would have to create five such excel files for 5 stocks assigned to you and a word file (maximum length: two pages) where you would talk about your findings. Please rename the word file to your id number. You may submit your project by sending the softcopies (five excel files and a word file).

Project Folder

After renaming the template.xls file, insert necessary data in the yellow shaded cells. Fill out the first table using close price files. For the shares that were enlisted with DSE after Jan 2001, use data from the time of enlistment and leave the prior cells empty. Use Div_DSE.xls file to fill out the second table. If you fill out all yellow shaded cells, Cumulative Return and Average Periodic Return would automatically be calculated. Use them in the word template file to write about your findings.

Use both of my email addresses: imran.edu@gmail.com and imran@northsouth.edu to send the softcopies. The subject of your email should be like this... FIN254 Project: your name, id, & section. I will send you an acknowledgement email after receiving your files. If you don't get the confirmation, then try again. Project submission due date is 14th of December, 2008 (Sunday). You may of course send your files earlier. Further details would be discussed in class. If you have any question then you may see me at my office or send an email.

Please READ the above instructions carefully before sending your project as email attachments. Check your work carefully before sending it to me. I would not be able to accept a modified version second time.  Thanks.

2 comments:

Anonymous said...

Sir
I have a query regarding FIN254 project. I am not sure of the term 1B:5 of B/R column. Will you plese explain it sir.
Thank you.

Anonymous said...

Sir, will you be available in Office for FIN254 project problems?