Qualification |
Unit number and title |
|||
Level 5 Diploma Business |
Unit 2 Managing Financial Resources |
|||
QFC Level |
Credit value |
|||
Level 5 |
|
|||
Unit Code |
Unit By |
Submitted on |
||
|
Locus Assignment Help |
|
||
Assignment title |
Finance as a resources , Making financial decisions & Analysing financial performance |
The purpose of this assignment is to give the learners a broad understanding of the sources and availability of managing financial for a business organisation. Learners will learn how to evaluate these different sources and compare how they are used. They will learn how financial information is recorded and how to use this information to make decisions for example in planning and budgeting.
Decisions relating to pricing and investment appraisal are also considered within the unit. Finally, learners will learn and apply techniques used to evaluate financial performance
Since embarking upon your Business you have been looking for a new job in finance or accountancy. You have had a number of years of experience working in industry and you would be particularly interested in a role which involved working with and advising local businesses. Eventually you secure a post with a large firm of accountants as a Finance and Business Advisor. This is a new departure for the company who have, traditionally, concentrated upon accountancy and auditing services.
As a starting point, the senior partner in the company suggests that you put together:
You are given the following information from the company’s financial statement.
|
£000 |
£000 |
From the balance sheet as at |
31 March 2003 |
31 March 2002 |
Stocks |
12482 |
11862 |
Trade Debtors |
32287 |
28410 |
Trade Creditors |
17048 |
13585 |
Total Asset less current liabilities |
47505 |
34912 |
Creditors Due after more than one year |
13388 |
6870 |
Share Capital ( 25p share) |
6782 |
4282 |
From the profit and loss account for the year ended |
31 March 2003 |
31 March 2002 |
Turnover |
205157 |
182530 |
Cost f goods sold |
172065 |
153730 |
Expenses |
27342 |
22285 |
Interest Payable |
1925 |
1220 |
Calculate the following ratios and comment on the performance of the business over the two years;
Cash Flow Forecast for a new business - Northfield Components Ltd: Jan 2008 - Dec 2008 |
||||||||||||
|
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEP |
OCT |
NOV |
DEC |
|
£000 's |
£000 's |
£000 's |
£000 's |
£000 's |
£000 's |
£00 0's |
£000 's |
£000 's |
£000 's |
£00 0's |
£000 's |
Brought Fwd. |
40 |
|
|
|
|
|
|
|
|
|
|
|
Sales |
200 |
300 |
300 |
300 |
250 |
260 |
300 |
260 |
300 |
325 |
265 |
265 |
Total Income |
240 |
300 |
300 |
300 |
250 |
260 |
300 |
260 |
300 |
325 |
265 |
265 |
Purchases |
150 |
140 |
135 |
135 |
140 |
130 |
135 |
145 |
140 |
140 |
145 |
145 |
Wages |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
Rent & Rates |
56 |
|
|
56 |
|
|
56 |
|
|
56 |
|
|
Light & Heat |
|
|
55 |
|
|
55 |
|
|
55 |
|
|
55 |
Advertising |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
Insurance |
55 |
|
|
|
52 |
|
|
|
|
|
|
|
Equipment |
50 |
10 |
|
10 |
|
10 |
|
|
|
|
|
|
Vehicles |
20 |
|
|
|
|
|
|
|
|
|
|
|
Directors Salaries |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
Motor Expenses |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
Sundry Expenses |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
Total Expenditure |
432 |
251 |
291 |
302 |
293 |
296 |
292 |
246 |
296 |
297 |
246 |
301 |
Monthly |
-192 |
49 |
9 |
-2 |
-43 |
-36 |
8 |
14 |
4 |
28 |
19 |
-36 |
Deficit/Surplus |
|
|
|
|
|
|
|
|
|
|
|
|
Accumulative Deficit/Surplus |
-192 |
-143 |
-134 |
-136 |
-179 |
-215 |
-207 |
-193 |
-189 |
-161 |
-142 |
-178 |
Gross profit margin
Stock Turnover
Debtors Collection period ( Debtors Days)
Creditors payment period ( creditors days
(This provides evidence for outcome 2 – assessment criteria 2.1, 2.2 , 2.3 and 2.4 for outcome 4 – assessment criteria 4.1,4.2 and 4.3)
The Financial Accountant of Northfield Components has recently resigned and left his post with immediate effect. The Directors decide to advertise for a replacement but realize that the recruitment process may take up to three months. In the short term they decide to bring in a financial consultant to tide them over until a permanent appointment is made. You are asked by your line manager to take on this role – initially for three months
On your first morning in early January 2008 the Directors present you with the cash budgets prepared by the departed financial accountant. You are given the budgetfor the twelve months from January 2008. The directors are concerned about the likely cash deficits shown in the cash budget.
Cash Flow Forecast for a new business - Northfield Components Ltd: Jan 2008 - Dec 2008 |
||||||||||||
|
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEP |
OCT |
NOV |
DEC |
|
£000 's |
£000 's |
£000 's |
£000 's |
£000 's |
£000 's |
£00 0's |
£000 's |
£000 's |
£000 's |
£00 0's |
£000 's |
Brought Fwd. |
40 |
|
|
|
|
|
|
|
|
|
|
|
Sales |
200 |
300 |
300 |
300 |
250 |
260 |
300 |
260 |
300 |
325 |
265 |
265 |
Total Income |
240 |
300 |
300 |
300 |
250 |
260 |
300 |
260 |
300 |
325 |
265 |
265 |
Purchases |
150 |
140 |
135 |
135 |
140 |
130 |
135 |
145 |
140 |
140 |
145 |
145 |
Wages |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
Rent & Rates |
56 |
|
|
56 |
|
|
56 |
|
|
56 |
|
|
Light & Heat |
|
|
55 |
|
|
55 |
|
|
55 |
|
|
55 |
Advertising |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
Insurance |
55 |
|
|
|
52 |
|
|
|
|
|
|
|
Equipment |
50 |
10 |
|
10 |
|
10 |
|
|
|
|
|
|
Vehicles |
20 |
|
|
|
|
|
|
|
|
|
|
|
Directors Salaries |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
22 |
Motor Expenses |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
Sundry Expenses |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
11 |
Total Expenditure |
432 |
251 |
291 |
302 |
293 |
296 |
292 |
246 |
296 |
297 |
246 |
301 |
Monthly |
-192 |
49 |
9 |
-2 |
-43 |
-36 |
8 |
14 |
4 |
28 |
19 |
-36 |
Deficit/Surplus |
|
|
|
|
|
|
|
|
|
|
|
|
Accumulative Deficit/Surplus |
-192 |
-143 |
-134 |
-136 |
-179 |
-215 |
-207 |
-193 |
-189 |
-161 |
-142 |
-178 |
You are required to present your findings and recommendations in a formal written report to the Directors of Northfield Components Ltd.(This provides evidence for outcome 3 – assessment criteria 3.1)
The Directors of North Seaton Engineering Company are considering two alternative business projects each of which involve an initial investment of ? 450,000. In your role as financial consultant you are asked to advise the Directors which of the two projects would be the more financially viable.
Project ‘A’ involves the introduction of modern, hi-tech machinery into the company’s main production unit. This will result in significant increases in output and substantial savings in production and maintenance costs. This in turn will result in a net increase in turnover to the company of:
Year 1 - ? 180,000
Year 2 - ? 230,000
Year 3 - ? 280,000
Year 4 - ? 120,000
Project ‘B’ involves an increase in the company’s marketing activities. The Directors would employ one of the region’s most prestigious marketing companies to manage a massive national campaign. They feel that business could be increased without, necessarily, updating production processes. In is anticipated that the net effect of their campaign would bring in additional annual turnovers of:
Year 1 - ? 60,000
Year 2 - ? 120,000
Year 3 - ? 250,000
Year 4 - ? 250,000
As financial consultant, you are asked to carry out a full investment appraisal of the two projects. In order to fully assess the pros and cons of the two alternatives you decide to employ a number of appraisal techniques:
Net present value.
For calculation purposes, you assume that the cost of capital will remain fairly static at around 6% per annum over the four year period.
Your appraisal should be presented in the form of a written report to the Directors and include all financial computations and a summary of the conclusions which can be drawn from the results of the appraisal – including recommendations as to which project should be taken on board.
A company producing puppets produce the following cost information:
Per Puppet |
|
|
£ |
Direct Materials |
3.00 |
Direct Labour |
1.10 |
Variable Overheads |
0.70 |
Fixed costs ( for year)- production |
£65000 |
- Selling |
£28000 |
If the company produces 40000 puppets calculate the cost per puppet using full costing method. If the company adds up 15% on cost as the cost plus mark-up, calculate the price at which the puppets will be sold for.
1.1 Identify thesources of finance available to a business
1.2 Assess the implications of the different sources
1.3 Evaluate appropriate sources of finance for a business project
2.1 Analyse the costs of different sources of finance
2.2 Explain the importance of financial planning
2.3 Assess the information needs of different decision makers
2.4 Explain the impact of finance on the financial statements
3.1 Analyse budgets and make appropriate decisions
3.2 Explain the calculation of unit costs and make pricing decisions using relevant information
3.3 Assess the viability of a project using investment appraisal techniques
4.1 Discuss the main financial statements
4.2 Compare appropriate formats of financial statements for different types of business
4.3 Interpret financial statements using appropriate ratios and comparisons, both internal and external.
Details
Other Assignments
Related Solutions