Question

ABC company is considering producing a new range of smartphones that will require it to build a

new factory. Feasibility studies have been done on the factory which cost $5 million. The studies

have found the following:

1. The factory will cost $25 million and will have a useful life of 20 years.

2. The land where the factory will go is currently used as a carpark for workers and it is assumed that the company will have to pay $200000 per year for their workers to park in a nearby carpark.

3. The factory will be depreciated on a straight line basis and will have a salvage value of $0 but it is believed that most of it can be sold for scrap after 20 years for $50000.

4. Due to the nature of the business they are in, they will have to perform some environmental tests to make sure that some of the chemicals they are using are not entering the ground water around the factory. These tests will be performed every 5 years and cost $625000.

5. Through the building of this factory and the selling of the phones it produces, it’s revenue will increase by $5 million in year 1 and remain at this level for the operational life of the factory.

6. The extra costs that the company accrues per year due to the project are $435000 for labour, $50000 for overhead like power and water bills and marketing costs for the new line of phones will be $500000 per year but will decrease by $15000 per year as the phone gains greater penetration.

7. The company’s current cost of capital is 8% per year.

8. The tax rate is 30%.

9. The project requires an initial investment in working capital of $1000000 that is returned

   in year 20.

Use the above information to answer the following.

A. Calculate the free cash flows that come from this project for the 20 years it is operational. ​

Answer 1

Discounted free cash flow = 4,803,753

a	b	c	d	e	f	g	h	i	j	k	l	m	n	o	p	q
Years	Factory cost	Working capital	Depreciation	Salvage	Parking cost	Environment test	Revenue	Labour+overhead	Marketing	Net income	Tax @30%	Net profit	Net cash flow from operations	Total Net cash flow	Discount factor @ 8%	Discounted cash flow
			Investment/20 yrs			(Once 5 years)			(Reduced by 15k every year)	107400000	k*30%	=k-l	Add back depreciation (d)	=(b+c+n)	=(1/1+i^n	=o*p
0	-25,000,000	-1,000,000								0				-26,000,000	1	-26,000,000
1			-1,250,000		-200,000		5,000,000	-385,000	-500,000	2,665,000	-799,500	1,865,500	3,115,500	3,115,500	0.9259	2,884,722
2			-1,250,000		-200,000		5,000,000	-385,000	-485,000	2,680,000	-804,000	1,876,000	3,126,000	3,126,000	0.8573	2,680,041
3			-1,250,000		-200,000		5,000,000	-385,000	-470,000	2,695,000	-808,500	1,886,500	3,136,500	3,136,500	0.7938	2,489,855
4			-1,250,000		-200,000		5,000,000	-385,000	-455,000	2,710,000	-813,000	1,897,000	3,147,000	3,147,000	0.735	2,313,139
5			-1,250,000		-200,000	-625,000	5,000,000	-385,000	-440,000	2,100,000	-630,000	1,470,000	2,720,000	2,720,000	0.6806	1,851,186
6			-1,250,000		-200,000		5,000,000	-385,000	-425,000	2,740,000	-822,000	1,918,000	3,168,000	3,168,000	0.6302	1,996,377
7			-1,250,000		-200,000		5,000,000	-385,000	-410,000	2,755,000	-826,500	1,928,500	3,178,500	3,178,500	0.5835	1,854,624
8			-1,250,000		-200,000		5,000,000	-385,000	-395,000	2,770,000	-831,000	1,939,000	3,189,000	3,189,000	0.5403	1,722,917
9			-1,250,000		-200,000		5,000,000	-385,000	-380,000	2,785,000	-835,500	1,949,500	3,199,500	3,199,500	0.5002	1,600,547
10			-1,250,000		-200,000	-625,000	5,000,000	-385,000	-365,000	2,175,000	-652,500	1,522,500	2,772,500	2,772,500	0.4632	1,284,204
11			-1,250,000		-200,000		5,000,000	-385,000	-350,000	2,815,000	-844,500	1,970,500	3,220,500	3,220,500	0.4289	1,381,217
12			-1,250,000		-200,000		5,000,000	-385,000	-335,000	2,830,000	-849,000	1,981,000	3,231,000	3,231,000	0.3971	1,283,075
13			-1,250,000		-200,000		5,000,000	-385,000	-320,000	2,845,000	-853,500	1,991,500	3,241,500	3,241,500	0.3677	1,191,893
14			-1,250,000		-200,000		5,000,000	-385,000	-305,000	2,860,000	-858,000	2,002,000	3,252,000	3,252,000	0.3405	1,107,179
15			-1,250,000		-200,000	-625,000	5,000,000	-385,000	-290,000	2,250,000	-675,000	1,575,000	2,825,000	2,825,000	0.3152	890,558
16			-1,250,000		-200,000		5,000,000	-385,000	-275,000	2,890,000	-867,000	2,023,000	3,273,000	3,273,000	0.2919	955,358
17			-1,250,000		-200,000		5,000,000	-385,000	-260,000	2,905,000	-871,500	2,033,500	3,283,500	3,283,500	0.2703	887,428
18			-1,250,000		-200,000		5,000,000	-385,000	-245,000	2,920,000	-876,000	2,044,000	3,294,000	3,294,000	0.2502	824,320
19			-1,250,000		-200,000		5,000,000	-385,000	-230,000	2,935,000	-880,500	2,054,500	3,304,500	3,304,500	0.2317	765,693
20		1,000,000	-1,250,000	50,000	-200,000	-625,000	5,000,000	-385,000	-215,000	2,375,000	-712,500	1,662,500	2,912,500	3,912,500	0.2145	839,420
	-25,000,000	0	-25,000,000	50,000	-4,000,000	-2,500,000	100,000,000	-7,700,000	-7,150,000	########	-16,110,000	37,590,000	62,590,000	37,590,000		4,803,753