Financial analysis
Learning Outcome 1: Demonstrate an understanding of different markets and sources of finance; and the role of budgeting in an organisation.
Learning Outcome 2: Be able to assess budgets based financial data to support organisational objectives (CMI Los 2).
Learning Outcome 3: Analyse the information contained in a company`s annual report; and appraise finance and investment decision.
Learning Outcome 4: Demonstrate an understanding of the context within which accounting operates, and the various local and international standards that need to be complied with.
Learning Outcome 5. Effectively apply budgets and investment appraisal techniques.
Learning Outcome 6. Effectively apply key ratios appropriate for analysing the financial performance of the organisation.
Learning Outcome 7. Understand how to evaluate financial proposals for expenditure submitted by others (CMI Los 3).
Your Task:
The London Delight is a company that prepares meals for commuters in its kitchen located next to the busiest train station. Company seen a growth in its sales post Covid19. The current trend that resulted increase in revenue is takeaways, using third party app orders (online). The company`s planning and actual budgets for January shown below:
The London Delight
Planning and actual budgets for the month ended January 31st, 2023
|
PLANNING |
ACTUAL |
|
Regular meals quantity |
(q) |
50 000 |
40 000 |
Online meals quantity |
(q) |
30 000 |
35 000 |
Revenues (£6.00q) |
|
£480 000 |
£450 000 |
Expenses: |
|
|
|
Raw material (£3.50q) |
280 000 |
258 500 |
|
Chef Salary (£10 000+£0.25q) |
30 000 |
29 000 |
|
Wages and salaries (£35 500+£0.50q) |
75 500 |
73 500 |
|
Utilities (£1 500 + £0.15q) |
13 500 |
13 900 |
|
Facility rent |
6 000 |
6 000 |
|
Insurance |
3 800 |
3 800 |
|
Fuel |
18 500 |
17 800 |
|
Delivery charges (£6 500 + £1.50qm) |
19 250 |
18 950 |
|
Business rates and taxes |
8 000 |
8 000 |
|
Repairs and maintenance |
5 000 |
4 500 |
|
Net Operating Income |
£20 450 |
£16 050 |
qm= quantity in miles (8500 budgeted 8300 Actual miles in January)
Required:
a) i) Prepare a report showing London Delight revenue and spending variance for January 2023?
ii) Outline the objectives of budgeting and explain how London Delight benefits from engaging in robust budgetary processes? (25 marks)
b) London Delight`s income statement for the period ending 31 December 20x2 is as follows:
Sales (35000q) |
175,000 |
Direct Material |
70,000 |
Direct Wages |
35,000 |
Variable overheads |
21,875 |
Fixed overheads |
8,750 |
Admin Overheads |
26,250 |
Selling & distributing overheads |
15,300 |
|
177,175 |
Profit/Loss |
(2,175) |
Calculate and comment:
• The contribution per unit and break-even sales
• Profitability ratios
• Evaluate viability of proposal when increase in selling price and wages by 10% will generate profits for upcoming period.
• Explain results and show benefits of Cost volume profit analysis (20 marks)
c) Management of London Delight carried out marketing research and found using modern machinery will improve efficiency and reduce energy consumption. There are two proposals under consideration:
|
Proposal 1 |
Proposal 2 |
Equipment cost |
£700,000 |
£900,000 |
Useful life |
5 years |
5 years |
Cash flow year 1 |
£100,000 |
£50,000 |
Year 2 |
£150,000 |
£80,000 |
Year 3 |
£225,000 |
£200,000 |
Year 4 |
£300,000 |
£400,000 |
Year 5 |
£300,000 |
£550,000 |
NB: cost of capital 10% Based on above details:
• Assess and effectively apply investment appraisal techniques (Payback, NPV, ARR, IRR etc) to advise management on above proposals outlining merits of each technique. (25 marks)
d) Explain the terms profitability and sustainability. Suggest management potential sources of finance to fund proposals in part c. Your report should advise the London Delight on the measures they should adopt to ensure the attainment of sustainability. (20 marks)
The word count for this assignment is 2,000 words +/- 10% and will not include the title page, executive summary, contents page or bibliography.
It is important that you show knowledge of key debates within the wider literature. Also, it is strongly advised that you are critical in your writing and ensure a good level of integration and coherence in applying theories. Please work on, and ensure an excellent level of criticality, coherence, and flow of your report. This will require effective discussion and clarity.
Level 6 NUR6065 : An exploration of the care and management of a patient with complex health needs- Nursing care:
Read MorePearson BTEC Level 3 Unit 9: Work Experience in the Engineering Sector :
Read More6N1957: This assignment requires the learner to carry out research on the current provision:
Read MoreYou are hired to support the Finnish Data Protection authority:
Read MoreDescribe the research paradigms and their appropriateness to nursing and midwifery practice.
Read MoreDemonstrate an understanding of and apply key (fundamental) concepts and principles in network application and mobile security:
Read More5N0690: Collection of Work – Communication, Assignment, Discussion of the uses of CT to include rationale for choice of technology used in different situations.
Read More5N0609 : You are required to write an assignment on a healthcare related topic – Communications ,
Read MoreIdentify and explain 3 of the so-called underpinning principles of the Children (Northern Ireland) Order 1995 :
Read MoreHome Questions Assignment Describe and discuss historical, ethical, and wider issues within psychology: Psychology Assignment,UK Describe and discuss historical, ethical, and wider issues within psychology:
Read More