ACC7032 Analyse financial data, conduct cost-benefit analysis and financial planning for effective business decisions using spreadsheet software package.

Managerial Finance

Learning outcome 1: Evaluate the different competing financial objectives of the firm and the agency problem between shareholders and managers in publicly listed companies.

Learning outcome 2: Analyse financial data, conduct cost-benefit analysis and financial planning for effective business decisions using spreadsheet software package.

Learning outcome 3: Critically evaluate investment projects using appropriate investment appraisal techniques to assess suitability and viability of the projects consistent with the overall strategy and business model(s) of the firm.

Learning outcome 4: Critically appraise the major issues of capital management, relative advantages and disadvantages from the various perspectives of the stakeholders of the firm.

Question 1

The scenario

SeikoHoldingsPlc is based in Birmingham, United Kingdomserving UK and Europe.Seiko Holdings Plcis headed by Clara Chou a seasoned Psychologist who has a strong love for great living spaces believing this improves mental health and longevity. It operates from a rented Head Office premises in central Birmingham with a Shared Services Centre serving the group. Seiko Holdings Plchas investments and interests in Healthcare Industry (Adult Care) and Hospitality Industry(offering packaged holiday services).

The Health& Social Care business operating under the name Seiko Care Solutions (SCS) rents properties which SCS tailor to cater for the needs of the service users and maintains per Care Quality Commission (CQC) standards and personal care plans. SCS lost two paralysed service user contracts following a complaint for a delayed completion of disabled toilets renovation project. Under Sheila Roberts as Managing Director (a qualified Mental Health Nurse), SCS had enjoyed year-on-year growth, however profitability has (since January 2020) been heavily impacted by various macro factors in the UK affecting such costs as food costs, energy costs and property costs etc.

Seiko Holdings Plc operates in the hospitality sector under the name Seiko Spaces (SS) where it owns and operate a Bed and Breakfast (B&B) chain with strategic business relationships with a prominent UK and Regional Europe passenger aeroplane business based in London. SS owns the B&Bs it runs and plans to expand its chain. SS is run by Parndeep Singh (Managing Director) a travel enthusiast with a knack for spotting profitable destinations and routes. Under Parndeep Singh`s eight year leadership, SS has maintained strong year-on-year growth and profitability until 2020 when profitability and growth declined despite the demise of Thomas Cook in September 2019 and due to COVID-19, Brexit and many other macro factors in the UK. On reviewing the unpleasant profitability position, Clara Chou demanded for the position to improve citing Thomas Cook`s demise in September 2019 as an opportunity for growth and improved profitability for SS.

Following deliberations, Seiko Holdings Plc Strategic Business Committee recommended that Seiko Group should acquire a good fit for strategic synergistical benefits to Seiko Holdings Plc for improved growth and profitability. Theidentified two possible acquisition targets and would want you to perform some ratio analysis, evaluate the findingsand advise the committee on which one they should acquire and why. The target companies are below:

PureCare Solutions Ltd: A prominent profitable Health and Social Care business offering Supported Living services to past offenders on path roto community rehabilitation and mental health patients. PureCare Solutions Ltd has a strong network of support teams and has maintained an Outstanding Rating from Care Quality Commission for the past 7 years under the leadership of the current Managing Director who has been in charge for the past 10 years.

Kindra Properties Ltd: Led by founder Kindra Peters a seasoned Property Developer and Architecture, Kindra Properties Ltd has delivered various property development projects, renovations and has a successful Buy, Revamp, Rent, Refinance and Repeat (BRRRR) portfolio and strategy. Three of its BRRR properties are leased to Supported Living Services and have state of the art tailored bathrooms and play areas. The other properties are leased to a company operating them as Bed and Breakfast properties.

Requirements

1.1 You are required to calculate ratios for Kindra Properties.

1.2 Prepare a business report (using a proper report format), maximum 2 pages long (+/- 10%), to Seiko Holdings Plc Strategic Business Committee based on ratio analysis and relevant qualitative issues to be considered. Your 800-word report must evaluate the financial statements and ratio analysis and make a convincing argument for investment in one of the two target companies. Your analysis, conclusions and recommendations should be supported by credible academic references (in Harvard Referencing format per Birmingham City University policy) using proper academic/ business English. (800 words)

1.3 Critically evaluate the working capital management (WCM) of both companies including some qualitative aspects and draw conclusions on which is stronger. (200 words)

1.4 Prepare a table with possible sources of finance Seiko Holdings Plc should consider to finance the investment in either PureCare Solutions Ltd or Kindra Properties Ltd.Critically evaluate the options you have identified and make a well-reasoned, and well-referenced, conclusion and recommendation(s). (350 words)

Question 2a

Overview

You are employed by Mobility Global (MG) as a Senior Management Accountant. Like other businesses, MG has been exposed to challenges facing the UK including Brexit, COVID-19, The Russo-Ukranian War, UK Political Dynamic, Interest Rates and Inflation to name but a few.MG produces and sells three types of special personal mobility equipment directly to National Health Service (NHS) and Care Homes across the United Kingdom.

MG`s profitability has been on a decline over the past years. Below is MG`s overall performance for the month of December 2022. In view of the huge capital investment made, MG`s directors are considering ways to improve this mediocre performance.

Upon considering the data below in the Executive Committee Meeting, Clara Zoul the Operations Director and five other directors share the same understanding and view that production of Hoists and Mobile Beds must be stopped if profitability is to improve in 2023.

Fixed overheads were apportioned based on the floor area occupied. You spot that marginal costing would show the results differently and may affect the directors` decision.

Task 1

Parndeep Kaur, the Finance Director is busy on some strategic forecasts and has requested you to prepare a report to MG`s directors concerning the proposal to cease Hoists and Mobile Beds production.

Using your knowledge of Management Accounting and Marginal Costing, clearly showing calculations and using appropriate, credible references, critically analyse Mobility Global`s product viability and the proposal to cease the production of Hoists and Mobile Beds. You are to:

i. Prepare a Marginal Costing Statement for each product and total for the month of December 2021.

ii. Based on the contribution you calculated in part (a) above, advise if MG should stop the production of Hoists. Prepare a Marginal Costing Statement showing the results if MG stops making Hoists.

iii. Based on the contribution you calculated in part (a) above, advise if MG should stop the production of Mobile Beds. Prepare a Marginal Costing Statement showing the results if MG stops making Mobile Beds.

iv. In addition to the calculations and your recommendations above (whether to cease production of Hoists and Mobile Beds), critically discuss the qualitative issues to be considered by Mobility Global`s board in making the decision.

v. Discuss how and why marginal costing calculates contribution to pay overheads and why this is useful in evaluating product value to a firm comparing it to Absorption Costing technique.

Question 2b

As a Neptune Holdings Plc junior management accountant, the Finance Director wants your calculations and recommendation regarding an expansion plan the Board is considering, which includes a chain of factory outlet stores.

Below are the figures for the first one that is planned for a central Manchester location next year.

Company policy dictates that any decision should be based on the results of calculating Net Present Value (NPV) of 3 years of cash flows using a cost of capital of 12%, Payback Period (PBP) must be less than 3 years, and the Internal Rate of Return (IRR) of the project should provide a 5% cushion in case of increases in inflation or interest rates.

The initial investmentinvestment consists of £100,000 for the land, building costs of £158,000, and £36,600 for fittings and equipment.

The cash flows in year 1 are expected to be: total sales revenue £600,600; the cost of Alpha products sold £165,900; Beta stock sold £118,860; staff costs £24,780; light & heat £35,196; other overheads £134,904. The cash flows for years 2 and 3 are the same as those in the first year, howeverexpected increase by 2% inflation each year.

Requirements for Question 2 part (b)

Using the information above and in accord with the above stated company policy you are required to calculate:

i. Net Present Value (NPV)

ii. Payback period (PBP) and Discounted Payback Period (DPBP)

iii. Internal Rate of Return

iv. Based on your calculations do you recommend the investment is made and the new outlet store is built?

v. Critically discuss the limitations of the above project appraisal techniques used and any other recommendations on issues the board that must be considered before making final investment decision.

Question 3

Euro Engineering Ltd manufactures three types of ceramic coffee percolator; the Metal, pink and the Zinc models. The maximum market demand and resource requirements of each of these products are shown below.

The percolators are made from an advanced heat-resistant material that gives the firm a competitive advantage. An email from the purchasing manager has informed you that, because of a problem with the supplier, it should be assumed that the half year`s supply of this special material is limited to 80,000kg.

Euro Engineering Ltd operates on a just-in-time production (JIT) method so that opening and closing inventory levels are zero.

The sales director has already accepted an order for 5,000 Metal percolators that, if not fulfilled, would incur a financial penalty of £12,000. This order is included in the Gold`s maximum market demand figure.

Continental`s directors need to know whether they should go ahead and satisfy the contract and then prioritise production in the normal way or whether it should consider breaching the contract and incurring the penalty.

The selling prices, raw material costs, labour costs and other variable overheads rates per unit for 2023 financial year will be the same as those in 2022.

Required:
Use management accounting techniques for example High-Low Method where applicable.

3.1 Applying marginal costing techniques, rank the products

3.2 Prepare a budgeted production schedule and a marginal cost income statement (analysed by product including the total) for the year ending 31 August 2023 assuming that the Metal contract honoured

3.3 Prepare a budgeted production schedule and a marginal cost income statement (analysed by product including the total) for the year ending 31 August 2023 assuming that the Metal contract IS NOT honoured

3.4 Considering calculations above and other qualitative issues, advise Euro Engineering Ltd directors whether to honour or dishonour the Metal Percolator Contract

3.5 Budgeting serves various purposes including planning, control, motivation and communication. You have been requested by Clara Ores the Finance Director to explain to Euro Engineering Ltd directors the importance of budgeting in light of the purposes above.