ACC9700 Financial Analysis and Decision Making Report for BGC Ltd

University University of Lincoln (UL)
Subject ACC9700 Financial Analysis Appraisal and Decision Making

Main Report & Presentation

This presentation and report account for a total of 70% of the module. The remaining 30% of the module marks relates to the reflective writing submission.

Your submission will consist of the following:

  • Presentation: A ten-minute video presentation (+/- 1 minute), which should be of a professional format suitable for a management meeting. Visual aids e.g., PowerPoint should be used, and the students may choose to be visible or not in the presentation. The presentation should not only make appropriate recommendations but provide a clear justification for the recommendations.
  • Report: A 1,500-word report which is in a professional format, including an Executive Summary. The report is based around the same scenario as the presentation and should contain details and calculations which support the recommendations made in the presentation. The report should include:
    • An executive summary, clearly detailing your recommendations with a brief justification.
    • A short introduction detailing the issues facing the company.
    • Discussion of Parts A, B, and C.
    • Workings may be included in the body of the report or may be included in an Appendix.
    • Fully justified recommendations and a brief conclusion.

Remember the report is a supporting document to your presentation; the two should be consistent.

Do You Need Assignment of This Question

Parts A, B, and C

The scenario below is divided into sections to provide guidance on the contents of the presentation. You should read the scenario thoroughly and ensure that you consider the guidance and include all required elements in a single report and a single presentation.

Scenario

BGC Ltd is a rapidly growing company which provides cleaning services to retail companies and offices. Most of their work is in High Street shops, out-of-town shopping malls, and offices. The company also produces its own cleaning products which are organic and have a low carbon footprint. These cleaning products are used exclusively by the company on its own cleaning contracts.

The company was set up by three friends from college, Bev, Gio, and Cam several years ago. The company began to experience rapid growth five years ago, but the COVID-19 pandemic which began in 2020 caused the growth of the company to falter.

Part A (40% weighting of report mark)

Profit and Loss

for year ending 30 June2021202020192018
£000£000£000£000
Turnover9,21614,52316,28913,777
Cost of Sales-8,853-13,534-15,010-12,570
Gross Profit3639891,2791,207
Admin exp-257-478-463-473
Other Operating Expenses-49-564523
Profit Before Interest and tax57455861757
Interest Payable and similar charges-28-20-1-16
Profit Before Taxation29435860741
Tax on profit-108-157-166-147
Profit for the financial year-79278694594

Buy Answer of This Assessment & Raise Your Grades

Statement of Financial Position

At 30 June 20212021202020192018
£000£000£000£000
Non-Current Assets
Goodwill31313134
Tangible Assets2,4652,0901,4941,446
Total Non-Current Assets2,4962,1211,5251,480
Current Assets
Inventory298564542760
Trade Receivables9321,5321,7551,274
Cash at bank and in hand1932286262
Total Current Assets1,2492,1282,5832,296
Current Liabilities
Trade payables1,296952721881
Net Current Assets-471,1761,8621,415
Total Assets less Current Liabilities2,4493,2973,3872,895
Creditors falling due after one year5574005261
Net Assets1,8922,8973,3352,834
Capital and Reserves
Called up Share Capital1111
Profit and Loss Account1,8912,8963,5342,833
Total Capital and Reserves1,8922,8973,5352,834

Report Requirement

Prepare a report for the directors of BGC Ltd discussing the performance, liquidity, and solvency of the company over a minimum of the last two years of the financial information provided. Your report should include, but is not limited to, reference to your calculations of the following ratios:

  • Gross Profit Margin
  • Net Profit Margin
  • Return on Capital Employed
  • Current Ratio
  • Working Capital Cycle
  • Gearing
  • Interest cover

Your workings should be included in the Appendix to the report. In the body of your report, you should include the ratios you have calculated along with an appraisal of the company’s performance in the last two years of the financial information provided.

Presentation Requirement

Provide a brief analysis of the current performance, liquidity, and solvency of BGC Ltd based on your ratio analysis, highlighting any areas of opportunity or concern. You are not required to include workings of ratios in your PowerPoint.

Are You Looking for Answer of This Assignment or Essay

Part B (30% weighting of report mark)

Cash Budget

JulyAugustSeptemberOctober
£000£000£000£000
Income
Receipts from customers9601,0401,1001,205
Other income4546
Total Cash Inflow9641,0451,1041,211
Payments
Purchases187194267102
Wages578620765894
Tax97
Office refurbishment250
Dividends400
Total Payments7651,2141,379996
Net Cash Inflow (Outflow)199-169-275215
Opening Cash Balance1921849-226
Closing Cash Balance21849-226-11

Report Requirements

Provide an analysis of the cash budget making recommendations for the directors to consider. Your recommendations should be fully justified. Your recommendations could relate to any opportunities or threats you have identified from your analysis of the cash budget and should include:

  • An analysis of the opportunity/threat
  • Implications for the company
  • Alternative options for the organisation

Presentation Requirements

Within your presentation, you should provide a critical discussion of the cash budget and justified recommendations for the directors to consider and the implications for the company.

Part C (30% weighting of report mark)

BGC Ltd is looking to the future and is keen to move the company forward. However, there is some disagreement within the directors of the company. An extract of the minutes from a meeting highlights some of the conversation which took place:

  • Gio: We need to recruit more cleaning staff and salespeople. Then we can take on more contracts and drive the business to be the market leader.
  • Bev: But our competitors are undercutting us. In order to compete, we have to continually reduce our prices. I think we should be leaving the retail sector – the High Street is really suffering, and out-of-town malls are not as successful as they were. We should really consider moving into the domestic market. People hate cleaning and love coming home to a clean house. We could use our award-winning cleaning products in domestic settings and keep the office contracts as well.
  • Cam: We need to do some analysis to find out which areas of our business are more profitable.
  • Gio: If we moved to domestic cleaning, we could continue to use the vans and cleaning equipment we already have, and our customers would pay us there and them.
  • Cam: We need to do some analysis to find out which areas of our business we want to focus on.Following this meeting the following information has been made available. This consists of an analysis of the sales and gross profit for the years 2018 to 2021 showing the sales and gross profit split between the retail sector and the office sector.

Do You Need Assignment of This Question

Analysis of Current Market

Sector2021 (£000)2020 (£000)2019 (£000)2018 (£000)
Retail Sales2765798896118955
Office Sales6451653566784822
Total Sales9,21614,52316,28913,777
Retail Gross Profit89357504489
Office Gross Profit274632775718
Total Gross Profit3639891,2791,207

Some analysis of the future markets for cleaning in the retail, office and domestic sector revealed the following:

Predicted Markets in 2022

Cash InflowBoom (£000)Static (£000)Recession (£000)
Office800375250
Retail50050-150
Domestic1100400-200

Chances of Market Conditions

  • Boom: 25%
  • Static: 35%
  • Recession: 40%

Report Requirements

Using calculations to support your reasoning, critically discuss the company’s plans for the future.

Provide recommendations based on whether BGC Ltd should:

  1. Carry on in the retail and office sectors.
  2. Shut down the retail element and move into the domestic market.

Your recommendations should be fully justified.

Presentation Requirements

Within your presentation, you should provide a critical discussion of the company’s plans, making justified recommendations for the directors.

Other Submission Information

You must support your submission with full calculations. You may include all detailed calculations in an Appendix to the report. The key figures or supporting information can be used in the main body of your report.

Note: Any information presented in figures, charts, graphs, or tables throughout the main body of the report is excluded from the word count.

Buy Answer of This Assessment & Raise Your Grades

Answer
img-blur-answers
WhatsApp Icon