support@w4writers.com +44 7743 307695
Jul 04, 2023

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.

Recent Post

Order this Assignment now

Total: GBP120

fables template