Question

Njenge is a special purpose vehicle set up by the Football Association of Zambia (FAZ) and the National Sports Council of Zambia (NSCZ) to undertake a project to manufacture an innovative muscle toning device (Muleza) that will be used in the treatment of sporting injuries. It is expected that the commercial life of the Muleza will be four years after which technological advances will bring more sophisticated devices to the market and the sales will fall to virtually zero. K8, 000,000 has been spent in developing and testing the device over the past year. Initial market research has been conducted at a cost of K2, 500,000 and is due to be paid shortly. The market research indicates the following demand and selling price per unit: Year (from now) 2 3 4 5 Units demand 2,000 70,000 125,000 20,000 Selling Price K2, 000 K2,200 K1,600 K1,400 A factory will be built for the production of the Muleza for K30, 000,000 and will take a year to complete. Payment will be made in two instalments; the first instalment of K18, 000,000 is payable immediately and the remainder in a year’s time. The factory building is expected to be sold for K25, 000,000 when the production and sales cease. Machinery costing K16, 000,000 will be installed at the end of the first year. The machinery will be depreciated on a straight-line basis over the next four years and is expected to have a nil value at the end of the four years. At present the materials cost of making one Muleza unit is K700. Njenge has enough materials in stock to make 1,500 units, which it had purchased a year ago for K450 per Muleza unit. If the project does not go ahead then these materials will be sold for an equivalent of K120 per Muleza unit. Labour that will be used to make the Muleza is to be made redundant immediately at a cost of K2,000,000 if the project does not go ahead. Labour costs per unit are K250. It is expected that once the project is completed, the labour will be made redundant at a cost of K3, 500,000. Fixed production overheads relating specifically to the production of the Muleza are expected to be K13,000,000 per annum and variable production overheads are expected to be K150 per Muleza unit produced and sold. Administrative costs are expected to be K17, 000,000 per annum of which K5,500,000 is allocated from the head office and the remainder relates directly to the production of the Muleza. Working capital of K10,000,000 will be required at the beginning of the second year once the production and sales have commenced. This will be released when the production and sales cease. The relevant cost of capital for the project is 9%. Assume that all cash flows occur at the year- end unless stated otherwise. All workings should be in K’000s to the nearest K’000. Ignore tax and inflation. Required: (a) Calculate the net present value and internal rate of return of the project and recommend whether the Muleza should be produced. Provide a brief justification of the cash flows included and excluded in the calculations.

Answer 1

NOTE: PLEASE LIKE THE ANSWER, IT WILL ENCOURAGE ME. IF YOU HAVE ANY DOUBTS AND QUERIES ON THIS ANSWER PLEASE FEEL FREE TO COMMENT BELOW. I WILL REPLY "ASAP" AND PLEASE DONT DISLIKE THIS ANSWER.
HOPE I ANSWERED YOUR QUESTION.
THANK YOU.........

		K 8 million spent on developing and testing is a sunk cost and not relevant
		K 2.5 million on market research is a committed cost and not relevant for this analysis
		Present Value(PV) of Cash Flow:
		(Cash Flow)/((1+i)^N)
		i=discount rate =Cost of Capital=9%=0.09
		N=Year   of Cash Flow
		Direct material cost in year 2
		For 1500 units Opportunity cost=1500*150	225000
		For balance 500 units, cost=500*700	350000
		Material cost in year 2=225000+350000	575000
		Material cost in year 3	49000000	(70000*700)
		Material cost in year 4	87500000	(125000*700)
		Material cost in year 5	14000000	(20000*700)
		Annual Depreciation expense (16000000/4)	4000000	(Depreciation is a non cash expense. Since tax is ignored, there is no depreciation tax shield)
			(All Figures in 000 K)
		CASH FLOW ANALYSIS OF THE PROJECT
	N	Year	0	1	2	3	4	5
	a	Cash Flow to built factory	(18,000)	(12,000)
	b	Cash Flow for Machinery purchase		(16,000)
	c	Cash Flow for Working Capital		(10,000)
	d	Annual Demand in units			2,000	70,000	125,000	20,000
	e	Selling Price per unit (K000)			2.0	2.2	1.6	1.4
	f=d*e	Annual Sales Revenue			4,000	154,000	200,000	28,000
	g	Annual Materials Costs			(575)	(49,000)	(87,500)	(14,000)
	h	Savings in cost of labor redundancy	20,000
	i=d*0.25	Annual Labor Cost			(500)	(17,500)	(31,250)	(5,000)
	j=d*0.15	Variable Production Overhead			(300)	(10,500)	(18,750)	(3,000)
	k	Fixed Production Overhead			(13,000)	(13,000)	(13,000)	(13,000)
	l	Administrative Expense(17000-5500)			(11,500)	(11,500)	(11,500)	(11,500)
	M=f+g+h+i+j+k+l	Operating Cash Flow	20,000	-	(21,875)	52,500	38,000	(18,500)
		Terminal Cash Flow:
	p	Salvage value of factory						25,000
	q	Release of initial working capital				-		10,000
	r	Terminal Labor redundancy cost				-		(3,500)
	T=p+q+r	Total Terminal Cash Flow						31,500
	CF=a+b+c+M+T	Net Cash Flow	2,000	(38,000)	(21,875)	52,500	38,000	13,000	SUM
	PV=CF/(1.09^N)	Present Value of Net Cash Flow	2,000	(34,862)	(18,412)	40,540	26,920	8,449	24,635
	NPV=Sum of PV	Net Present Value(NPV)	K 24,635,000
		Internal Rate of Return	30.80%
		(Using IRR function of excel)