Grow Corp is a medium sized commodity producer. It is already involved with indu
ID: 2725668 • Letter: G
Question
Grow Corp is a medium sized commodity producer. It is already involved with industries such as oil and gas, forest products and gold exploration. Grow Corp operates in Australasia as well as in North America and the company exports everywhere in the world. The General Manager of Grow Corp, Mr Tandori Nanczos, is very much in favour of expanding operations into new markets and is considering developing a new plant that will specialise in the production of cannabis for medicinal and legitimate business activities. Legitimate cannabis cultivation for industrial hemp is estimated to yield up to $800 per acre. Mr Tandori Nanczos is considering the implementation of the following strategy in order to produce hemp for the domestic market. STRAGEY HEMP involves the traditional method of purchasing a block of land in central Victoria and establishing the site for productive measures. Mario Williams, a financial analyst, has prepared estimates of the initial investment, the net cash inflows associated with each method given two future possible states of the world.
HEMP PRODUCTION BEST CASE
HEMP PRODUCTION WORST CASE Initial Investment (t=0) $3,750,000 $3,750,000 Year (t) Cash Inflows Cash Inflows 1 2 3 4 5 $1,126,000 $1,351,200 $1,621,440 $1,945,728 $2,237,587 $975,000 $1,121,250 $1,255,800 $1,368,822 $1,450,951 Pr.(Event) 0.60 0.40
Note that Mario plans to analyse each alternative over a five-year period. At the end of that time, the equipment required for each method would be sold, thus accounting for the large final year cash inflow. Mario believes that, due to the operation will have no impact on the firm’s overall risk. It is therefore decided to use the firms’ 12% cost of capital when analysing the proposed project. Mario would like you to estimate the following:
a) Expected Net Present Value [E(NPV)] (8 marks) b) Standard Deviation [(NPV)] (8 marks) c) Coefficient of Variation [CV(NPV)] (4 marks)
Explanation / Answer
a) CALCULATION OF EXPECTED NPV:
_____________________________________________________________________________________________
YEARS PROB. 0 1 2 3 4 5
BEST CASE 0.60 (3,750,000) 1,126,000 1,351,200 1,621,440 1,945,728 2,237,587
WORST CASE 0.40 (37,50,000) 975,000 1,121,250 1,255,800 1,368,827 1,450,951
NPV IN BEST CASE = (3,750,000) + 1,126,000/(1+0.12) + 1,351,200/(1+0.12)2 + 1,621,440/(1+0.12)3 + 1,945,728/(1+0.12)4 + 2,237,587/(1+0.12)5
= (3,730,000) + 1,005,357+1,094,621+1,154,877+ 1,104,272 + 2,026,780 = 2,635,907
NPV UNDER BEST CASE = NPV X PROBABILTY = 2,635,907 X 0.60 = 1,581,544
NPV UNDER WORST CASE = (3,750,000) + 975,000/(1+0.12) + 1,121,250/(1+0.12)2 + 1,255,800/(1+0.12)3 +1,368,827/(1+0.12)4 + 1,490,957/(1+0.12)5
= (3,750,000) + 870,536 + 893,854 + 894,444 + 776,544 +1,350,545 = 1,036,193
NPV UNDER WORST CASE = NPV X PROBABILTY = 1,036,193 X 0.40 = 414,477
EXPECTED NPV = NPVE UNDER BEST CASE+ NPV UNDER WORST CASE = 1,581,544 + 414,477 = $1,996,021
b) CALCULATION OF STANDARD DEVIATION NPV:
_____________________________________________________________________________________
YEAR 1 2 3 4 5 TOTAL
BEST CASE 1,126,000 1,351,200 1,621,440 1,945,928 2,237,587 --
PROBABILITY 0.60 0.60 0.60 0.60 0.60 --
NET CASH FLOW 675,600 810,720 972,864 1,167,557 1,342,552 4,969,293
WORST CASE 975,000 1,121,250 1,255,800 1,368,822 1,450,951
PROBABILITY 0.40 0.40 0.40 0.40 0.40
NET CASH FLOWS 390,000 448,500 502,230 547,529 580,380 2,468,639
STANDARD DEVIATION OF NPV =
BEST CASE
YEAR 1 (1,126,000 - 675,600)2X0.60 =
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.