The public company "GQ ball pen industries ltd" Term paper.

Part 1: Each group will be assigned one company by the course instructor to work with. Groups will test the financial performance of the assigned company for the most recent 3 years (using the published annual reports). For example, if a group is assigned Beximco Pharmaceuticals Ltd, they must do ratio analysis for Beximco for the most recent 3 years.

Ratio Analysis should be made based on the following ratios- I. Profitability Ratio Gross Profit Margin, Net Profit Margin, Return on Asset and

Return on Equity II. Asset Management Ratio Average Age of Inventory, Average Collection Period, Average Payment Period and Total Asset Turnover III. Liquidity Ratio Current Ratio and Quick Ratio. IV. Debt Management Ratio Debt-Equity Ratio and Interest Coverage Ratio V. Market Ratio P/E Ratio and EPS VI. DuPont analysis Decomposition of Return on Equity (ROE) *** Calculation must be supported by relevant interpretation. Students have to show and interpret each type of ratio containing the last 3 years performance of the company. Without a logical and rich interpretation of the ratios, your assignment will have no value. *** Ratio Analysis must be done and submitted in PDF file. A detailed breakdown of the calculation must be shown. Ex.- Inventory + Trade Debtors + Advances Deposits and Payments + Short term Loan (Unsecured) + Cash Equivalents

Trade Creditors + Liabilities for Expenses + Liabilities for other Finance 3730808243 + 2204014900 + 1450936735 + 21386290 + 15768683854

843937277 + 27576542 + 1489930233

Part 2: Students will have to show a one year trend analysis of the stock price for their assigned company. The selected year (for the trend analysis) should be the latest year based on which the financial ratios for the company were calculated. Furthermore they must follow the accounting period (ex- Jul-Jun) of their assigned company. Students need to do a thorough interpretation of the trend analysis of the stock price movement. Stock price fluctuation must be graphically displayed through line-chart. Interpretation of the fluctuation should be based on news archive, economic factors. Trend Analysis should be performed using Excel.

Part 3: As a reference to the work, each group must provide screenshots of pages from where the amount/figures were derived and provide them in the appendix. Also an excel file containing daily stock price for the entire year with trend analysis should be included in the appendix. In addition to that, a reference page should also be included.

A separate findings section in the paper should take the reader in detail through the companies performance over the same time period based on financial ratio and stock price. Charts and graphs (explaining the financial performance) incorporated is a must. This report will carry 10% Marks. Use the online consultation hours of your respective faculty member if you need any clarification.

V. Term Paper Structure: Cover Page Table of Content Executive Summary Background of the assigned company (Maximum half page) Ratio Analysis: Calculation of financial ratios for the assigned company. It should be submitted in a PDF file Trend Analysis of Stock Price: Daily stock price of the assigned company with line charts to show fluctuation. It should be submitted in Microsoft excel. Analysis and findings: This section should have a detailed interpretation of companys financial position based on the all the ratios calculated in the previous section. Major factors impacting the stock price fluctuation with citation (provided in reference). Conclusion References Appendix