Reference no: EM133305879
Learning Outcome 1: Critically discuss the functions and aims of financial management and the nature of financial decision-making within organisations.
Learning Outcome 2: Evaluate the financial performance and position of a business using appropriate performance measures.
Learning Outcome 3: Integrate financial data and management information in assessing business performance.
Learning Outcome 4: Critically apply contemporary management accounting techniques to aid decision making in changing environments.
Learning Outcome 5: Appraise the criteria for investments and/or capital projects and evaluate their sources of finance.
Assignment Detail:
CASE STUDY: Robot Limited
Robot Limited is a UK subsidiary of the Pullover Group inc. The company has been operating in the UK for the past 15 years. Robot provides financial services to a number of organisations which include SME's, property developers and investment property funds in the UK and US. For the past 14 years, Robot has been a profit-making firm as it has retained its previous clients, in addition to capturing an increasing share of the market. However, the finance director of Robot has recently got in touch with your professional consulting firm and has engaged your firm with the mandate to provide them with an explanation of the cash flow problem that Robot Limited had been facing. The company is also dependent on the parent based in the US for funds, as and when required.
In the past month there has been a number of meetings in London and New York where it has been agreed that Robot Limited should do their best to expand the business and raise the required capital in the UK, or perhaps abroad, so as not to
depend so much on cash coming from the parent company all the time. Consequently, the management of Robot is considering the following projects:
The current product that Robot Limited has to offer mostly to specialist developers and investment funds companies is outdated. The company is looking to invest in a new product and there are two proposals on offer. The details of these two proposals are outlined below.
Flexible Suite
Draft figures
Year
New Software cost
|
0 1
9,400
|
2
|
3
|
4
|
5
|
Sales Revenue
|
3,000
|
5,200
|
7,500
|
8,800
|
9,200
|
Less:
|
|
|
|
|
|
Freeze Module
|
(540)
|
(720)
|
(880)
|
(980)
|
(1,200)
|
Overheads
|
(300)
|
(320)
|
(440)
|
(560)
|
(680)
|
The table above shows the estimated outgoings and inflows for the project. All of the above estimates have been prepared in terms of present-day cost and prices. Assume that cash flows arise at the end of each period. In addition:
Revenues are expected to rise by 5% in price terms per year from year 1 (start of year 1).
Overheads are expected to rise by 5% per year from year 1 (start of year 1) The cost of Freeze Module is expected to rise in line with inflation of 5% per year from the beginning of year 1.
The costs of Technical Adviser, who has come from the US have not been taken into consideration in the forecast and are as follows:
Technical Adviser (TA): Will be paid £120 per hour and expected number of hours for TA is 1,400hrs. The rate paid is expected to rise in line with inflation at 5% per year from year 2 and the number of hours is expected to reduce by 4% per year, every year from year 2 onwards. If Robot Limited invests in Flexible Suite, then the discount rate that would be required to assess the NPV would be 10%.
Solid State Suite is the second of two proposals, the expected life of this software will also be 5 years and the cost of the new software, expected revenue, Freeze Module costs and overheads are as follows:
Solid State Suite
|
Draft figures
£'000
|
|
|
Year 0
|
1
|
2
|
3
|
4
|
5
|
New Software cost 12,400
|
|
|
|
|
|
Sales Revenue
|
5,600
|
6,900
|
9,000
|
11,200
|
11,600
|
Less: Freeze Module
|
(820)
|
(1,050)
|
(1,250)
|
(1,480)
|
(1,860)
|
Overheads
|
(540)
|
(640)
|
(770)
|
(900)
|
(980)
|
All of the above estimates have been prepared in terms of present-day costs and prices. Assume that cash flows arise at the end of each period. In addition, you need to consider the cost of Technical Adviser, inflation and the rise in the revenue, and overheads consideration, which are the same for the Flexible Suite. If Robot Limited invests in Solid State Suite, then the discount rate that would be required to assess the NPV would be the same 10%.
New Customer Centre
The manager in charge of sales has just informed your company that they plan to open a centre in the Midland region of UK, and it is hoped that this centre will be opened for business on 1 November 2022. You have also been informed that to start with, the company will only sell 2 software packages, that of Basic Package (BP) and the Tailored Package (TP). This will be done to test the market and see if the business will break-even in the same period. These two popular packages will be offered at £400 for BP and £520 for TP.
The company has provided you with the following information regarding the costs and estimated sales for the three-month period, starting from 1 November.
Robot Limited plan to put in £6,000 as start-up capital and plan to sell a total of 1,800 (combined) of BP and TP for the same period. They are not sure which of the two products will produce the most profits for Robot.
Total budgeted sales for each month are as follows: November 600, December 600 and January 600, of which 40% of each month will be for TP. You will be required to assess the best product combination of sales for the period.
To help with the setup of the store, the company has just concluded a deal to get a bank loan of £28,000 on the 1 November. The interest on this loan will be paid every month. The company will be required to make 12 equal payments to repay the loan starting end of December.
Financial information
As mentioned above the company plans to sell a total of 1.800 product packages during these three months. The fixed costs for the period are as below:
Rent
|
£16,400
|
Telephone
|
£2,600
|
Loan Interest
|
£1,008
|
Insurance
|
£5,800
|
Electricity and Gas
|
£4,000
|
Business Rates
|
£4,200
|
Other cost
|
|
Marketing
|
£46,000
|
Administration
|
£14,800
|
Staff Salary
|
£32,000
|
From their costs estimates, the variable costs of the services are £190 for the BP and £260 for the TP. The fixed costs are for the whole period, so they are not affected by the level of service. However, the variable costs will increase with services output (i.e., sales output multiplied with variable cost per product).
Professional Skills:
Executive Summary
A one page maximum document which summarises the whole financial business plan. An executive summary should follow the order of the financial business plan and outline: the purpose of the financial business plan; the key analyses; the main conclusions; recommendations.
Knowledge and Understanding:
Introduction
A section clearly introduces the purpose of the financial business plan and gives a brief relevant background. It also sets out the structure of the financial business plan.
Knowledge and Understanding: A literature review to critically discuss requirements for NPV and other investment appraisal tools, breakeven analysis and budgeting tools. Their advantages and disadvantages. The main sources of financing through debt or equity.
An overview of previous research in the area you are writing about. A literature review summarises prior publications in the field and should also include your own evaluation/analysis of the research.