Calculate the firm's 2003 financial rations and then fill the preceding table.

Authors Avatar

ACC501 Assignment 2

Nelson Pilay

Question 1 a:

Calculate the firm’s 2003 financial rations and then fill the preceding table.

Answer:

Current ratio                                =        $1,531,181 ÷ $616,000

                                        =        2.5 

Quick ratio                                =        (1,513,181 - $700,625) ÷ $616,000

                                        =        1.3 

Inventory turnover (times)                =        $3,704,000 ÷ $700,625

                                        =        5.3

Average collection period                =        ($805,556 ÷ $5,075,000) x 360

                                        =        57 days

Total asset turnover (times)                =        $5,075,000 ÷ $3,125,000

                                        =        1.6

Debt ratio                                =        ($1,781,250 ÷ $3,125,000) x 100

                                        =        57%

Times interest earned ratio                =        $153,000 ÷ $93,000

                                        =        1.6

Gross profit margin                        =        ($1,371,000 ÷ $5,075,000) x 100

                                        =        27%

Net profit margin                        =        ($36,000 ÷ $5,075,000) x 100

                                        =        0.71%

Return on total assets (ROA)                =        ($36,000 ÷ $3,125,000) x 100

                                        =        1.2%

Return on common equity (ROE)        =        ($36,000 ÷ $1,343,750) x 100

                                        =        2.7%

Price/earning (P/E) ratio                =        $11.38 ÷ $0.33

                                        =        34.48

Market/book (M/B) ratio                =        $1,343,750 - $50,000

                                                        100,000

                                        =        $12.94

                                        =        $11.38 ÷ $12.94

                                        =        0.88

Question 1 b:

Analyse the firm’s current financial position from both a cross-sectional and a time-series viewpoint.  Break your analysis into evaluation of the firm’s liquidity, activity, debt and profitability and market.

Answer:

Analysis of the company’s financial statement is sectionalised into liquidity, activity, debt and profitability and market and the details are as follows:

Join now!

Liquidity: The current and quick ratios have improved over the years and are higher than the industry average.  In comparison between the current ratio and quick ratio it indicates that almost 50% of the company’s current assets value in 2003 is made up of inventory.  Nevertheless, the quick ratio for 2003 suggest that the company has no short term liquidity problems and should have no difficulty in paying its debts as they become due.

Activity: The inventory turnover pace is constant for the last 3 years (2001 to 2003) but much slower against the industry average.  The slower ...

This is a preview of the whole essay