Share
Explore BrainMass

Corporate Finance - Net Present Value

Net Present Value - See the attached file.

Sleep-Easily Ltd manufactures high quality, branded orthopaedic furniture in Manchester. The products are made in limited numbers and for limited production periods of usually no more than six years. All products are sold on the Web, supported by speciality magazine advertising. A significant part of the overhead is concerned with the costs of promotion and is shared between up to 70 product items at any one time.
The directors are currently reviewing a number of new product proposals:
A) Recliner chair
B) Footstool
C) Armchair
D) Small armchair (special lumbar support)
E) Three-seater sofa
The following information concerning costs and prices for each unit of production in £s:

Product
A
Recliner
B
Footstool
C
Armchair
D
Small armchair
E
3 seater sofa

Labour cost
61
14
40
33
110

Materials cost
145
20
107
60
255

Overheads1
100
10
70
55
165

Sales Price
400
80
355
205
555

1 Overheads are allocated on the basis of machine hours. Overheads include an average of £40 per item for packaging and delivery.

The marketing department's estimate of annual sales in units for each product are:

ProductYear
1
2
3
4
5
6

A
120
130
140
145
220
80

B
100
130
160
145
220
80

C
140
185
220
205
270
110

D
180
240
280
265
220
140

E
108
138
160
145
220
75

The 'recliner chair' production (product A) requires the purchase and installation of new equipment costing a total of £38,500. This equipment will have a value in use to the firm of about £13,500 at the end of the six-year product run. The two armchairs (products C & D) and the sofa (product E) will be manufactured using equipment which has many years of life left and which is being underutilised at present. The footstools (product E) can be manufactured using a machine that was otherwise intended for sale immediately for £3,500. However, this equipment has just three years of life left and it is anticipated that it will be replaced at the end of three years at a cost of £14,000 (the equipment will have an estimated value of £6,000 when trolley production ceases six years from now).
The recliner (product A) will also use up most of a stock of springs and hinges that are otherwise redundant. Four springs and four hinges are needed on each recliner. The springs each have a cost of £1.05 and the hinges each cost £0.90, both are already included in the estimate of material cost for the recliner.
Ignore taxation and inflation. The company has a required rate of return of 18% on all of its projects.
Required
You should be able to identify the relevant cash flows and apply basic capital budgeting methods to guide your decision making.
1. Calculate the net present value for each of the five products.
2. With the exception of product D, the small armchair, all of the products will be replacing existing items in the company's current catalogue. How, if at all, should this influence the decision to manufacture? (Note that the company sees the products as not necessarily selling as stand alone units because customers often combine items to make a suite when placing an order).
3. An opportunity has arisen to sell to a leading department store chain extra thirty recliners for each of the next six years during which production is being considered. Leaving aside distribution and marketing issues associated with moving from Web-only based sales, do you recommend that the company pursue this business and if yes, what is the minimum 'factory gate' price per unit that it should request?

Attachments

Solution Preview

Hi,
<br>
<br>I have done the problems on excel. Don't get confused looking at the numbers.
<br>
<br>For each of the expense category, the expense is calculated as ...

$2.19