Financial analysis and reporting – LO 1Apply suitable decision-making techniques to assist in the… 1 answer below »

150 150 admin

Financial analysis and reporting
LO 1Apply suitable decision making techniques to assist in the preparation of a business plan.
LO 2Demonstrate competence via a multipage linked spreadsheet for the preparation of a business plan.
Task: Established business analysis
You are being assessed on your ability to demonstrate the use of EXCEL to solve business and financial problems and create a suitable business plan. You should include your financial analysis within your business plan.
Charles Street Fabrications Limited is an established family business which has been
trading for 50 years. The financial year runs from January to December. The business
owns its premises and machinery outright. The property is worth £200,000 and
machinery £39,569. They deal exclusively with corporate clients, designing and
producing steel products to their client’s specifications.
Additional information at end of current year
Debtors:£104,035; Stock:£52,035 (£135,088 last year); Wages:£131,537; Insurances and Administration costs:£23,000; Utilities :£101,577; Cost of sales:£225,800; Fixtures & Fittings:£14,608;Value of vehicle:£12,500; Vehicle Depreciation rate:20% (straight line);Bank overdraft:£10,000; Suppliers (Creditors):£226,413; Accruals:£6,392; Loan Repayment:£15,000; Loan Value:£221,806. Payment terms for Debtors:2 months and Creditors, 1 month. All other expenses assume settlement immediately. The owner has a £239,669 equity share in the business. Mr Street is the owner and sole director of the business and he draws a salary of £50,000 per annum.

 
PLACE THIS ORDER OR A SIMILAR ORDER WITH COLLEGE NURSING PAPERS AND GET AN AMAZING DISCOUNT!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp