Financial Analysis

Excerpts of financial data for Polar Enterprises as follows:
Statement of comprehensive income 20.10 (R) 20.9 (R)
Sales (10% credit) 32 011 500 19 373 000
Cost of sales (10% credit purchases) 26 180 100 15 993 700
Operating Profit 1931 200 1327 800
Tax (25%) 457 850 306 600
Profit after Tax 1 373 550 919 820

Statement of financial position 20.10 20.9
Non-Current Assets 5 200 000 4 700 000
Current Assets 2 866 530 4 974 530
Inventories 1 482 200 2 038 860
Accounts receivable 261 290 155 200
Marketable securities 326 950 2 306 440
Cash 796 090 474 030
Current Liability 1 088 860 588 310
Account payable 190 660 192 040
Other current liability 898 200 396 270
Required :
1.1 Calculate the current ratio and acid test ratio at the end of each year. (8 marks)
1.2 Calculate the cash conversion cycle (CCC) (17 marks

1 answer

To calculate the current ratio, acid test ratio, and cash conversion cycle (CCC) for Polar Enterprises for the years ending 20.10 and 20.9, we will follow the definitions and formulas for these financial metrics.

1.1 Current Ratio and Acid Test Ratio

Current Ratio: The current ratio is calculated by dividing current assets by current liabilities.

\[ \text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}} \]

Acid Test Ratio: The acid test ratio (or quick ratio) is calculated by taking current assets minus inventories, then dividing by current liabilities.

\[ \text{Acid Test Ratio} = \frac{\text{Current Assets} - \text{Inventories}}{\text{Current Liabilities}} \]

Calculations:

  1. Year 20.10:

    • Current Assets: 2,866,530
    • Current Liabilities: 1,088,860
    • Inventories: 1,482,200

    Current Ratio for 20.10: \[ \text{Current Ratio} = \frac{2,866,530}{1,088,860} \approx 2.64 \]

    Acid Test Ratio for 20.10: \[ \text{Acid Test Ratio} = \frac{2,866,530 - 1,482,200}{1,088,860} \approx \frac{1,384,330}{1,088,860} \approx 1.27 \]

  2. Year 20.9:

    • Current Assets: 4,974,530
    • Current Liabilities: 588,310
    • Inventories: 2,038,860

    Current Ratio for 20.9: \[ \text{Current Ratio} = \frac{4,974,530}{588,310} \approx 8.45 \]

    Acid Test Ratio for 20.9: \[ \text{Acid Test Ratio} = \frac{4,974,530 - 2,038,860}{588,310} \approx \frac{2,935,670}{588,310} \approx 4.98 \]

Summary of Ratios:

  • Current Ratio for 20.10: 2.64
  • Acid Test Ratio for 20.10: 1.27
  • Current Ratio for 20.9: 8.45
  • Acid Test Ratio for 20.9: 4.98

1.2 Cash Conversion Cycle (CCC)

The cash conversion cycle is calculated using the following formula:

\[ \text{CCC} = \text{Days Inventory Outstanding (DIO)} + \text{Days Sales Outstanding (DSO)} - \text{Days Payable Outstanding (DPO)} \]

To compute this, we need to find:

  • Days Inventory Outstanding (DIO): \[ \text{DIO} = \left( \frac{\text{Average Inventory}}{\text{Cost of Sales}} \right) \times 365 \]

  • Days Sales Outstanding (DSO): \[ \text{DSO} = \left( \frac{\text{Average Accounts Receivable}}{\text{Sales}} \right) \times 365 \]

  • Days Payable Outstanding (DPO): \[ \text{DPO} = \left( \frac{\text{Average Accounts Payable}}{\text{Cost of Sales}} \right) \times 365 \]

Step 1: Calculate Average Values

  1. Inventories:

    • Average Inventory = (1,482,200 + 2,038,860) / 2 = 1,760,530
  2. Accounts Receivable:

    • Average Accounts Receivable = (261,290 + 155,200) / 2 = 208,245
  3. Accounts Payable:

    • Average Accounts Payable = (190,660 + 192,040) / 2 = 191,350

Step 2: Calculate DIO, DSO, DPO

  1. Cost of Sales for each year:

    • Cost of Sales 20.10 = 26,180,100
    • Cost of Sales 20.9 = 15,993,700
  2. Sales for each year:

    • Sales 20.10 = 32,011,500
    • Sales 20.9 = 19,373,000

Calculations for 20.10:

  1. Days Inventory Outstanding (DIO) for 20.10: \[ \text{DIO} = \left( \frac{1,760,530}{26,180,100} \right) \times 365 \approx 24.6 \text{ days} \]

  2. Days Sales Outstanding (DSO) for 20.10: \[ \text{DSO} = \left( \frac{208,245}{32,011,500} \right) \times 365 \approx 2.36 \text{ days} \]

  3. Days Payable Outstanding (DPO) for 20.10: \[ \text{DPO} = \left( \frac{191,350}{26,180,100} \right) \times 365 \approx 2.66 \text{ days} \]

CCC for 20.10: \[ \text{CCC} = 24.6 + 2.36 - 2.66 \approx 24.3 \text{ days} \]

Calculations for 20.9:

  1. Days Inventory Outstanding (DIO) for 20.9: \[ \text{DIO} = \left( \frac{2,038,860}{15,993,700} \right) \times 365 \approx 46.7 \text{ days} \]

  2. Days Sales Outstanding (DSO) for 20.9: \[ \text{DSO} = \left( \frac{155,200}{19,373,000} \right) \times 365 \approx 2.93 \text{ days} \]

  3. Days Payable Outstanding (DPO) for 20.9: \[ \text{DPO} = \left( \frac{192,040}{15,993,700} \right) \times 365 \approx 4.41 \text{ days} \]

CCC for 20.9: \[ \text{CCC} = 46.7 + 2.93 - 4.41 \approx 45.22 \text{ days} \]

Summary of Cash Conversion Cycle:

  • CCC for 20.10: 24.3 days
  • CCC for 20.9: 45.22 days

Overall Summary:

  • Current Ratio: 20.10: 2.64; 20.9: 8.45
  • Acid Test Ratio: 20.10: 1.27; 20.9: 4.98
  • Cash Conversion Cycle: 20.10: 24.3 days; 20.9: 45.22 days