Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Accounting Expert

Question One, Sydney Limited:

Sydney Cycles Ltd is a small company that was originally started in late 2000 following the Sydney Olympics by a group of cycling enthusiasts who were unable to obtain the parts needed to repair or modify their bikes. From its early days Sydney Cycles Ltd's business model has been very locally-focused with its services and product offerings tailored to meet the needs of cyclists from around the inner-city metropolitan areas of Sydney. While the firm imports a small range of specialist racing componentry from suppliers throughout Europe and the United States it primarily manufactures its own frames and, using some imported parts, assembles race and touring bikes within a small factory-unit/retail outlet it leases on a ‘month-to-month' basis. The firm's management has traditionally competed with larger European and American-based brands, such as ‘Cannondale' or ‘Colnago', based upon its ability to offer individual customer service (set-ups and bespoke frames) and expert advice based on their knowledge of the local riding conditions.

The management of Sydney Cycles Ltd has increasingly witnessed changes in their market with many of their former clients now purchasing cycling products via the internet rather than directly from the firm's factory-unit/retail outlet. Sydney Cycles Ltd's management are willing to embrace this changing marketplace but some members of the executive team are concerned about the firm's recent financial performance. Others within the company's management group have a conflicting view, believing Sydney Cycles Ltd is performing comparatively well.

In a management meeting during December, two directors (both major shareholders) of the firm expressed their concerns about the performance of Sydney Cycles Ltd. These two directors have made loans to the company of $1,400,000 in the recent past and were also therefore its major creditors. The loan was provided to Sydney Ltd free of any interest charge and now the two directors wish that the firm would begin to repay them their loan capital in the coming months.

Both shareholder/directors have recently suggested that they also required more timely financial data from the company. One of these directors also suggested that the firm needed to benchmark its performance against similar organisations. Others within the firm's management group have cautioned against this and suggested that this may be problematic given that the firm was not large and therefore truly comparable data may be difficult to obtain. As a result of their demands, from the beginning of the 2016 calendar year, the firm will now produce monthly financial statements.

The management of Sydney Cycles Ltd have scheduled a finance committee meeting in early February 2016 to discuss the business's performance. Sydney Cycles Ltd's external accountant had prepared the following balance sheet as at the end of December, 2015 and a list of summarised transactions that had occurred during January 2016. The firm's general manager has obtained the following ratios from a commercial supplier of financial data. These ratios were based on the full-year ended 31st December, 2015.

Sydney Cycles Ltd
Balance Sheet
as at 31st of December, 2015


$

$

$

Assets




Current assets




Cash at Bank 


580,000


Accounts Receivable

1,700,000



Less: Allowance for Doubtful Debts   

190,000

1,510,000






Inventory 


2,220,000


Prepaid Insurance


70,000


Prepaid Lease (premises)


240,000


Total current assets



4,620,000





Non-current assets




Equipment

4,400,000



Motor Vehicles

1,000,000



Less: Total Accumulated Depreciation

1,340,000



Total non-current assets


4,060,000

4,060,000

Total assets



8,680,000





Liabilities




Current liabilities




Accounts Payable      


2,700,000


Accrued Salaries and Wages


440,000


Advertising Payable


580,000


Total current liabilities



3,720,000





Non-current liabilities




Director's Loan


1,400,000


Total non-current liabilities



1,400,000

Total liabilities



5,120,000





Owners' equity




Share Capital


2,740,000


Retained Earnings


820,000


Total owners' equity



3,560,000

 Total liabilities and owners' equity



8,680,000

• ROE: 25 per cent
• ROA: 17 per cent
• Leverage: 1.50 times
• Profit margin: 4 per cent
• Gross margin: 40 per cent
• Asset turnover: 5 times
• Inventory turnover: 17 times
• Debtor turnover: 33 times
• Current ratio: 0.50 times

During January 2016, the following events occurred:

a. Sydney Cycles Ltd paid $1,700,000 cash to its creditors;

b. The firm also paid all salaries and wages outstanding at the end of December;

c. Sydney Cycles Ltd purchased $800,000 worth of cycle parts to hold in inventory on credit from its US and European suppliers;

d. The firm made internet sales on credit of $2,265,680 during January;

e. The firm made direct ‘store-based' sales and service fees from its unit/outlet in cash totalling $450,000;

f. Management conducted a ‘stock-take' at the end of January and determined that Cost of Goods Sold [CoGS] for the month was $1,570,000;

g. The firm's existing insurance coverage expires at the end of January. As a result Sydney Cycles Ltd paid cash for its annual composite insurance premium of $840,000 (12 month policy commencing 1st of February, 2016, covers building / equipment fire and theft, motor vehicles; person liability, workers compensation etc);

h. The firm received in cash the sum of $2,800,000 from its debtors;

i. Paid $150,000 as an initial repayment of the monies owing on the ‘Director's loan';

j. During a television interview recorded at the ‘Santos Tour Down Under' (an annual cycling event held in Adelaide during January) both Cadel Evans (Tour De France winner) and Olympian, Anna Meares, offered positive endorsements for Sydney Cycles Ltd's products. The international media exposure provided by the interviews immediately lead to an increase in activity on the firm's website. The firm's management are delighted and believe that, although the pair's endorsements was unsolicited, it was the equivalent of the firm spending $800,000 on a publicity and marketing;

k. Unfortunately the management of Sydney Cycles Ltd had already embarked upon an advertising campaign using a variety of media in late 2015 (and thus were unable to capitalise on the recent favourable press). All advertisements went to air in December 2015. The contract called for Sydney Cycles Ltd to pay the firm's advertising liability in two equal instalments. During January the firm paid the first of these two instalments on its advertising liability;

l. Paid lease on factory unit for February of $240,000. (The lease is payable monthly in advance, at $240,000 per month);

m. The firm paid utility-related expenses (lighting, power, Government charges, incurred during January, of $210,000;

n. The management of Sydney Cycles Ltd has received notification that Newcastle Cycling Ltd has gone bankrupt - this is a debtor with an outstanding balance of $130,000;

o. After writing-off Newcastle Cycling Ltd's debt, management requires the Allowance for Doubtful Debts to have a balance of $180,000;
p. The management of Sydney Cycles Ltd depreciates equipment at a rate of 20 per cent per annum based on its historic cost (straight-line);

q. The management of Sydney Cycles Ltd depreciates motor vehicles at a rate of 15 per cent per annum based on its historic cost (straight-line);

r. The management of Sydney Cycles Ltd has noted that the current book value of their plant and equipment is slightly below its current market price. As a consequence the firm's management is unsure as the whether they should revalue the plant and equipment upward by an additional $10,000;

s. The firm incurred (but did not pay) salaries and wages expense of $310,000 for January;

t. The firm has hired a new part-time staff member with specific expertise in the promotion of internet sales. She is expected to increase internet sales by $50,000 per month. She will commence employment with Sydney Cycles Ltd on the 1st of March 2016 and will receive $10,000 per month;

u. Sales commissions for each month are determined on the last day of that month. For January commissions were $22,000. They will be paid next month;

v. As a result of the publicity generated during the ‘Santos Tour Down Under' by late January Sydney Cycles Ltd received an order from Bathurst Bikes Ltd to sell $210,000 worth of custom designed frames to be delivered in late March, 2016;

Required: Making and discussing any assumptions necessary

1. For the month ending 31st of January, 2016 [ignoring taxation]:

- Prepare journal entries (including adjusting entries);
- Post to ledger accounts;
- Prepare a ‘post-adjustments' trial balance;
- Prepare closing entries;
- Prepare a ‘post-closing' trial balance;
- Prepare an Income Statement for the month of January, 2016;
- Prepare a Balance Sheet as at the 31st of January, 2016;

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91913092
  • Price:- $45

Priced at Now at $45, Verified Solution

Have any Question?


Related Questions in Financial Accounting

Finance final exam -answer the following questions based on

FINANCE Final Exam - Answer the following questions based on the course presentation, text, and any outside relevant sources. Use citations and show your work where applicable. 1. Strategic and Financial Planning a. Defi ...

Company a is a calendar year company that depreciates all

Company A is a calendar year company that depreciates all its machinery on a straight-line basis. On January 1, 2016, the company purchased machinery costing $100,000, with an estimated useful life of 10 years and a zero ...

Accounting financial assignment -question - in recent years

Accounting Financial Assignment - Question - In recent years a number of companies have gone into liquidation (been 'wound up') because they have not been able to meet their liabilities when they fell due. In Australia, ...

What has been strides position on dividend payouts in the

What has been Strides' position on dividend payouts in the past (pattern, relationship with earnings, etc.)? What factors affected its dividend policy?

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

In its first year of operations cullumber company

In its first year of operations, Cullumber Company recognized $31,800 in service revenue, $6,600 of which was on account and still outstanding at year-end. The remaining $25,200 was received in cash from customers. The c ...

On december 1 of the current year the following accounts

On December 1 of the current year, the following accounts and their balances appear in the ledger of Latte Corp., a coffee processor: Preferred 2% Stock, $50 par (240,000 shares authorized, 86,000 shares issued)$4,300,00 ...

Need slides need a one page executive summarybelow is the

Need slides. Need a one page executive summary. Below is the scenario: "Hi again. I've got news about our client. "ExxonMobil is looking to increase revenue by 10 percent and possibly reduce costs. Need an executive summ ...

Part adbm financial solutionsyou are a financial consultant

Part A DBM Financial Solutions You are a financial consultant working with DBM Financial Solutions and have a portfolio of clients you work with in achieving financial management solutions. Client 1- Manhattan Limited Yo ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As