Time Series Analysis of Bata
Essay Preview: Time Series Analysis of Bata
Report this essay
`[pic 1]North South UniversityRatio Analysis: Time series analysis of “Bata”[pic 2]Submitted To:FJ MohaimenLecturer,Department of Accounting and Finance School of Business and EconomicsNorth South UniversitySubmitted By:Serial No.NameID1.Nafis Yamin15200500312.Quazi Ridita Samina15105130303.Ishrat Jahan14309216304.Moslema Mahmud15110580305.Shaan Farabee1310251630Course Name: Introduction to Financial ManagementCourse Code: FIN 254Section: 01Executive Summary Bata Shoe is regarded as one of the best footwear companies in Bangladesh. This multinational company started their operations in Bangladesh in 1962 by opening their branch office and launched as fully fledged company in 1972.  Recently we have analyzed the financial statements of year 2013, 2014 and 2015 of Bata Company. We have collected the data which are available in their company’s website. Then we have computed the ratios such as Liquidity ratio, Activity ratio, Debt Ratio, profitability ratio, Market Ratio. After computing these ratios we have performed time series analysis on these ratios.  From this analysis we have observed whether the company is in an improving position or not for last 3 years and have given our opinion elaborately in recommendation part. Liquidity Ratios:  Liquidity ratios measure a companys ability to pay debt liabilities and its margin of safety through the calculation of metrics including the current ratio, quick ratio. It is used to measure a companys ability to pay its short-term debts.Ratios201320142015Current Ratio1.621.791.95Quick Acid Ratio0.630.68.866Current Ratio:[pic 3]Current ratio shows the extent to which current liabilities are covered by current assets. From the graph it can be seen that the current ratio increased from 2013-2015Current ratio was stable in 2013-2015. It means that the company was able to pay its current liabilities. After 2013 current assets increased steadily which means the company is capable enough to pay of its current liabilities. But the ratio of the value is too low.
Quick ratio:The quick ratio shows the firm’s ability to meet current liabilities. It follows the same trend as current ratio and increased over the following years. Just like the current ratio; the company had a stable quick ratio in 2013 to 2015 and that’s why quick ration increased to a stable position. Activity Ratios: Activity ratios measure a firms capacity to convert different accounts within its balance sheets into cash or sales. It helps us in determining whether a companys management is doing a good job of generating revenues and cash from its resources or not.Ratios201320142015Average Collection Period20.1820.5838.84Inventory Turnover2.392.292.30Average Age of Inventory152.72159.39158.69Total Asset Turnover1.711.731.63Average payment Period32.0164.4263.01[pic 4][pic 5][pic 6][pic 7][pic 8]Avg. Collection Period:Average collection period in the approximate amount of time that it takes for a business to receive payments owed, in terms of receivables, from its customers and clients. We can see from the charts Avg. collection period is slightly increasing over the year 2013 to 2014 and has increased immensely at the year 2015.Inventory Turnover:Inventory turnover is how many times inventory is sold and replaced. From 2013-2014 it has slightly decreased and increased a bit in 2015.Avg. Age of Inventory:The average number of days it takes for a firm to sell to consumers a product it is currently holding as inventory. From the charts we can see that it has been increasing from 2013 to 2014 and then slightly decreased again in 2015.Total Asset Turnover:It measures how efficiently a company uses its assets to generate sales. It has risen to 2013-2014. But in 2015 it has dropped from 1.73 to 1.63.Avg. Payment Period:Average payment period means the average period taken by the company in making payments to its creditors. It was 32.01 in 2013and increased rapidly in 2014 which was 64.42 but it has been decreased slightly to 63.01 in 2015.