Solved by verified expert :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
company’s 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.
