FIN254 Project Related Questions

Q1: I am not sure of the term 1B:5 of B/R column. Will you please explain it sir?

Ans: 1B:5 means 1 bonus share against 5 shares which is equivalent to 20% bonus share. Similarly 1B:2 would mean 50% bonus share.

Q2: I have a problem with interim dividends. Please tell me how to handle that information.

Ans: You probably noticed some MNCs offering interim dividends. In those cases, you just use the final dividend amount and declaration date, ignore the rest interim dividends for that period.

Q3: Where do we get face value of a stock?

Ans: Get a recent copy of daily newspaper and just turn to Stock columns of Business/Finance section (But make sure previous day was a trading day!). You may also go to DSE website at this link (http://www.dsebd.org/company%20listing.php). Clicking on the link for your stock will take you to a window where you will find not only the face value of the stock, but also, a lot more other information regarding that stock. Alternatively, you may choose to buy a DSE monthly review where face value of all the stocks listed with DSE is available.

Q4: Sir, if 1B:5 is 20% bonus issue.Then how do we calculate the bonus % for 1B:7 and 1B:14?The percentages are in decimals; however when the value is filled in the dividend cell it is automatically converted to a whole number, for e.g it changes from 14.28% to14%. Is this correct?

Ans: You are correct. 1B:7 and 1B:14 are equivalent to 14.29% and 7.14%. Don't bother about the auto-rounding. Formula will take decimals into consideration.

Q5: I have problem in BIFC which has no dividends. In analysis it shows invalid & has no first issue price. Where do I put the begining value? 

Ans: Please look at the dividend file carefully. BIFC announced following dividends
Cash Dividend of 15% on 15-04-07 and
Cash 10% & Stock 10%B on 09.04.2008.

Moreover, BIFC was listed with DSE in November 2006. So, you will not get any trading information before that. In the first table you will have no values from 2001 to 2005. Replace "End of Dec, 2005" by "15-Nov-08" (as it is the first trading day for BIFC) and put closing price of that date which is 189.75 (you can get it from CP_2006.xls file). Then put the three closing price values under that accordingly.

For the Analysis worksheet: As this stock started trading from 2006, you need to put the initial investment amount of 1,00,000 in 2006 (Cell No. B9), not earlier. Hope you will be able to get this right. And please remember to calculate the investment period accordingly (in this case from Nov-06 to Jun-08, there are 20 months, so the investment period would be =20/12).

Q5: Sir, if the 3rd month from the dividend declared is after June 2008, then should I record this whole dividend or I assign zero to the closing price of 3RDM.

Ans: You may leave it blank. Please DO NOT assign zero, because it would be a wrong information.

Q6: Sir, I am having some problem with the project.  For Desh Garments last CP given is of 14-12-02. Should I take it as the end CP of DEC 2002?

Ans: Yes, you are correct. End of Dec closing price of a script in any year does not neccessarily mean trading on the last day of December of that year. Your project requires you to pick the last closing price in a particular year. If a particular script was last traded on the 14th of Dec in 2002, then let it be. Use that to be the Year-end closing price. You may even find a script which was not at all traded in the month of December. In that case, the Year-end closing price might be the closing price of last trading day, even if it was in Nov or earlier. Just replace "End of Dec, 2002" by "End of 2002".

Q7: Sir, if any company's beginning price for jan 1, 2001 is not given and the beginning price is on jan 10 or jan 12 then what is the investment period? will I calculate by month or day?

Ans: If you want to be precise, you may consider the fractional monthly period (for example, taking 2/3 of the month if trading date is on the 11th). Otherwise, you may include that whole month if the date is in the first half of the month or you may exclude that month if the date is around the end of the month.

Q8: Sir, Do I include D.A.D(9/17/2001), Cash (0), 3RDM(Dec)? Face value is the face value of a single share or a lot?

Ans: For a zero/nil cash dividend, you don't need to put close price of the 3rd month. Face value is the par/stated value of any single instrument.

Q9: Sir, I have seen the company listing information of UCBL on the DSE Website and it shows that they have declared a 30% Bonus issue for 2001 but I cannot find the declare date any where for it. So, I could not include the 30% bonus issue in the excel file for UCBL without that date.

Ans: The declaration date is right there in the dividend file! It's 30%B (2001) announcment date 05.08.2007. I don't know why/how you missed it! Announcement date is not important in case of stock dividend for our project. However, it's important for cash dividend.

Q10: Are we just required to comment on the cumm. and average return for the various companies in the word file? Do I mail you both the excel and the word file (softcopies) only?

Ans: Exactly! You are required to discuss the findings and compare stock performances in the word file. You should email me six files: five excel files (one for each stock) and one word file with the discussion.

Q11: For Islamibank (the one that you sent as sample), you have given 1000 as facevalue, but the website of DSE is showing facevalue of 100 and market lot of 10. so, should we multiply the facevalue with market lot and get the final facevalue?

Ans: This is because of a very recent stock split. It used to have a face value of Tk. 1000 per share and 1 share per market lot. The split ratio was 1:10 (old:new) and market lot of 10 shares. The record date for the split was 27th November, 2008! Thus, the new face value of Islami Bank is in fact Tk. 100.

Q12: What do "1B:4,1R:2", "5%(1B:20)" and "35%B,1R:2" mean? I know what individually 1B:4 means and what 30%B means, but i don't know what the "R" term means and how to interpert them toghether.

Ans: They mean the same thing together. For example, "1B:4,1R:2" means 1 bonus share against 4 shares (or 25% bonus share) and 1 right share for 2 shares (or 50% right share). When the companies announce this type of declation, they also announce different record dates for bonus and right shares to be effective. To learn more you may browse through the news section of DSE website.

Q13: What do you think about my stock .........? I am having this type of problem with it? What to do with it?

Ans: Please don't use the blog to ask me specific share related problem. In that case, email me directly. It's not practical to post solutions to hundreds of such individual stock related problems here. Hope you would understand. Thank you.