Task:
You are the Managing Director of ATC Ltd, a small but successful manufacturer of re-circulating chillers for the thermal management of high technology instrumentation and industrial process equipment. The financial year ends on 31st December and a stock take has been carried out in the first week of January 2011 before trading begins in 2012. The companys Bank has requested a set of accounts prior to a meeting to discuss the budget for 2012. You are given a set of financial data and you must now put together the report for the Bank for 2011.
The financial data provided to the Managing Director on 20th January 2012 prior to his meeting with the Bank Manager is as follows:
£
sales
994,207
20 year mortgage
284,155
accumulated depreciation to 31.12.10
116,670
Share capital
62,754
P &L reserve – prior years
58,015
creditors
143,299
Other direct production costs
22,276
Depreciation charge for period
7,172
Cash at bank
56,497
Closing stock
111,249
Overheads for the year
97,674
Direct Labour
155,283
Management salaries
156,526
Debtors
179,733
Cost of sales (materials)
423,108
Building and Machinery
449,582
First decide if each item is a balance sheet or a Profit & Loss (P&L) item. Provide detail which will enable you to construct the P&L and balance sheet (for example, allocate to each item Fixed asset, current liability, Cost of sales etc
.)
Construct the Profit and Loss account
Construct the balance sheet for 31st December 2011.
Once you have the set of accounts, you decide to carry out an analysis so you are prepared for the meeting with the bank manager.
You decide to calculate:
The gross margin (in percentage terms) including only cost of materials.
The gross margin also including direct labour and other production costs (as a percentage).
The return on sales (as a percentage).
The written down value of the building and machinery at 31st December 2011.
The break even for the company. What level of sales were required in 2011 for the year for the company to break even (this will be a useful starting point for the 2012 budget).
The approximate stock turn (in days).
Average creditors (in days).
Return on capital employed as a percentage. For capital, use two calculations one using only the initial share capital investment and one including also the P&L reserve (exclude the bank mortgage).
Provide a brief comment on each of these to help the bank manager review the accounts.