In: Finance
Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land three weeks ago (the survey cost $45,000) and concluded the following:
Please provide the Free Cash Flow for each year of this project (times t=0 through t=4) and compute the project’s NPV.
T = 0 Cash Flow: ___________
T = 1 Cash Flow: ___________
T = 2 Cash Flow: ___________
T = 3 Cash Flow: ___________
T = 4 Cash Flow: ___________
Project NPV: ___________
Computation of NPV | ||||||||
year | 0 | 1 | 2 | 3 | 4 | |||
i | Initial investment | (100,000) | ||||||
ii | Working capital | -15000 | ||||||
A=i+ii | Initial investment | (115,000) | ||||||
operating cash flow | ||||||||
i | Revenue=2500*120 | 300,000 | 300,000 | 300,000 | 300,000 | |||
ii | cost=2500*80 | 200,000 | 200,000 | 200,000 | 200,000 | |||
iii | depreciation=100000/4 | 25,000 | 25,000 | 25,000 | 25,000 | |||
iv=i-iii | Profit before tax | 75,000 | 75,000 | 75,000 | 75,000 | |||
v=iv*35% | Tax@ 35% | 26,250 | 26,250 | 26,250 | 26,250 | |||
vi=iv-v | Profit after tax | 48,750 | 48,750 | 48,750 | 48,750 | |||
B=vi+iii | operating cash flow | 73,750 | 73,750 | 73,750 | 73,750 | |||
Terminal cash flow | ||||||||
i | Release of working capital = | 15,000 | ||||||
ii | Post tax salvage value | |||||||
=25000*(1-35%) | 16250 | |||||||
C | NWC + salvage value | 31250 | ||||||
D=A+B+C | Net cash flow | (115,000) | 73,750 | 73,750 | 73,750 | 105,000 | ||
D | PVIF @ 11% | 1.0000 | 0.9009 | 0.8116 | 0.7312 | 0.6587 | ||
E=C*D | present value | (115,000) | 66,441 | 59,857 | 53,925 | 69,167 | 134,391 | |
Therefore NPV = | 134,391 | |||||||
ans a) | Year 0 Cash flow | (115,000) | ||||||
year -1 | 73,750 | |||||||
year -2 | 73,750 | |||||||
year -3 | 73,750 | |||||||
year -4 | 105,000 | |||||||
Ans b) | NPV = | 134,391 |