Cash receipts and payments and other data

Reference no: EM13930294

Below are account balances, cash receipts and payments and other data for X Limited, a company that distributes chemical supplies, for the financial year that ended 30 June 2012 and 30 June 2013.

2012 2013

$ $

Accounts payable 22 000 10500

Accounts receivable 11 000 15000

Accumulated depreciation (buildings) 119 000 125000

Accumulated depreciation (equipment) 45 000 60000

Buildings 412 000 450000

Cash 16 000 20000

Contributed capital 300 000 300000

Cost of goods sold 146 000 150000

Dividends (declared and paid) 17 000 12000

Equipment 245 000 250000

General and administrative expenses 96 000 90000

Income tax expense 14 000 20000

Income tax payable 6 000 5000

Interest expense 25 000 30000

Interest payable 14 000 10000

Land 35 000 40000

Long-term investments 35 000 50000

Merchandise inventory 62 000 70000

Loans, current portion 10 000 15000

Loans, non-current 278 000 290000

Prepaid insurance 7 000 5000

Retained earnings, beginning balance 25 000 37000

Sales revenue 357 000 400000

Selling expenses 47 000 35000

Supplies 13 000 15000

Trademarks 13 000 15000

Wages payable 18 000 14500

You are required to:

a) Prepare a classified statement of financial performance for 2012 and 2013

b) Prepare a classified statement of financial position for 2012 and 2013

c) From the company's financial statements, calculate the following ratios for the two years:

i) Return on Assets ratio

ii) Return on Equity ratio

iii) Net Margin

iv) Quick ratio

v) Current ratio

vi) Asset turnover ratio

vii) Average settlement period for debtors

viii) Average settlement period for creditors

d) Provide a report to management of X Limited Company giving advice based on your results from the ratios above.

Reference no: EM13930294

Questions Cloud

Recommendation on investing in the company : Your client is a strong believer in supporting Australian made products and Socially Responsible Investing. The latter would mean adopting an investment strategy which seeks to consider both financial return and social good. Your client is also a ..

Unemployment and inflation over the period 1981 to 2014 : 1. For Finland obtain data on unemployment and inflation over the period 1981 to 2014 from the European Economy European Commission Web address 2. For Finland graph the unemployment and inflation data and comment on the relationship.

Identifying the cubic pattern of the given data : Which type of moving average seems most appropriate to you in identifying the cubic pattern of the data?

Based on profitability alone : Which company is more likely to be able to pay its current liabilities?

Cash receipts and payments and other data : Below are account balances, cash receipts and payments and other data for X Limited, a company that distributes chemical supplies, for the financial year that ended 30 June 2012 and 30 June 2013.

Effective explanation of the competitiveness of countries : Examine on the basis of existing theories and experiences of the developing countries why the extent to which factor availability is no longer an effective explanation of the competitiveness of countries.

Explain the choice of the smoother lengths : Explain the choice of the smoother lengths in about two sentences. Write the whole smoothing operation as a single weighted moving average by finding the appropriate weights.

List all movie ids and titles that have never been rented : List names of the tables that you have created whose name starts with MM. (Hint: use data dictionary view USER_TABLES).

Estimate the trend using a centered moving average : Estimate the trend using a centered moving average. Using an classical additive decomposition, calculate the seasonal component. Explain how you handled the end points.

User Account

All Pages