Question

In December 2019, Bob Prescott, the controller for the Blue Ridge Mill, was considering the addition of new on-site long-wood woodyard. The addition would have two primary benefits: to eliminate the need to purchase short-wood from an outside supplier and create the opportunity to sell short-wood on the open market as a new market for Worldwide Paper Company (WPC). The new woodyard would allow the Blue Ridge Mill not only to reduce its operating costs but also to increase its revenues. The proposed woodyard will utilise new technology that allows tree-length logs, called long-wood, to be processed directly, whereas the current process required short-wood, which had to be purchased from the Shenandoah Mill.

This nearby mill, owned by a competitor, has excess capacity that allows it to produce more short-wood than it needs for its own pulp production. The excess is sold to several different mills, including the Blue Ridge Mill. Thus, adding the new long-wood equipment would mean that Prescott would no longer need to use the Shenandoah Mill as a short-wood supplier and that the Blue Ridge Mill would instead compete with the Shenandoah Mill by selling on the short-wood market. The question for Prescott was whether these expected benefits were enough to justify the $18m capital outlay plus the incremental investment in working capital over the six-year life of the investment.

Construction would start within a few months, and the investment outlay would be spent over two calendar years: $16m in 2020 and the remaining $2m in 2021. When the woodyard begins operating in 2021, it would significantly reduce the operating costs of the mill. These operating savings would come mostly from the difference in the cost of producing short-wood on-site versus buying it on the open market and were estimated to be $2m for 2021 and $3.5m per year thereafter.

Prescott also planned on taking advantage of the excess production capacity afforded by the new facility by selling short-wood on the open market as soon as possible. For 2021, he expected to show revenues of approximately $14m, as the facility came on-line and began to break into the new market. He expected shortwood sales to reach $20m in 2022 and continue at the $20m level through 2026. Prescott estimated that the cost of goods sold (before including depreciation expense) would be 75%.

In addition to the capital outlay of $18m, the increased revenues would necessitate higher levels of inventories and accounts receivable. Therefore the amount of working capital investment each year would equal 15% of incremental sales for the year. At the end of the life of the equipment, in 2026, all the net working capital on the books would be recoverable at cost fully. Taxes would be paid at a 30% rate, and the equipment depreciation is to be calculated on a straight-line basis over the six-year life to zero balance. However, the new equipment is estimated to have a salvage value (scrap value) of $3m at the end of its life. WPC’s accountants have told Prescott that depreciation charges could not begin until 2021, when all the $18m had been spent and the equipment is in service.

Prepare cash flow statement/s and compute the NPV and IRR of the proposed project. Comment on the feasibility of the project (（the cash flow involves 2020-2026, but exclude 15% hurdle rate in NPV calculation, want to know each year working capital how to calculate in cash flow statement )

Answer 1

			2020	2021	2022	2023	2024	2025	2026
	N	Year	0	1	2	3	4	5	6
		Investments:
	a	Capitl Outlay	($16,000,000)	($2,000,000)
		Operations:
	b	Savings in operations costs		$2,000,000	$3,500,000	$3,500,000	$3,500,000	$3,500,000	$3,500,000
	c	Increase in Revenue		$14,000,000	$20,000,000	$20,000,000	$20,000,000	$20,000,000	$20,000,000
	d	Increase in Cost of goods sold (75%)		($10,500,000)	($15,000,000)	($15,000,000)	($15,000,000)	($15,000,000)	($15,000,000)
	e	Depreciation($18 million/6)		($3,000,000)	($3,000,000)	($3,000,000)	($3,000,000)	($3,000,000)	($3,000,000)
	f=b+c+d+e	Increase in Earning Before Taxes		$2,500,000	$5,500,000	$5,500,000	$5,500,000	$5,500,000	$5,500,000
	g=f*30%	Taxes(30%)		($750,000)	($1,650,000)	($1,650,000)	($1,650,000)	($1,650,000)	($1,650,000)
	h=f+g	Net Income/(Loss)		$1,750,000	$3,850,000	$3,850,000	$3,850,000	$3,850,000	$3,850,000
	i	Add back depreciation(non cash expense)		$3,000,000	$3,000,000	$3,000,000	$3,000,000	$3,000,000	$3,000,000
	j=h+i	Net Operating Cash Flow		$4,750,000	$6,850,000	$6,850,000	$6,850,000	$6,850,000	$6,850,000
	k	Cash Flow due to change in working Capital	($2,100,000)	($900,000)	$0	$0	$0	$0	$3,000,000
	l	Before tax Salvage value							$3,000,000
	m	Tax on Salvage (30%)							($900,000)
	p=l+m	Cash Flow on salvage							$2,100,000
	CF=a+j+k+p	PROJECT NET CASH FLOW	($18,100,000)	$1,850,000	$6,850,000	$6,850,000	$6,850,000	$6,850,000	$11,950,000	SUM
	PV=CF/(1.15^N)	Present Value of Net Cash Flow(at 15% discount rate)	($18,100,000)	$1,608,696	$5,179,584	$4,503,986	$3,916,510	$3,405,661	$5,166,315	$5,680,751
		Net Present Value (NPV)	$5,680,751
		Internal Rate of Return (IRR)	23.92%	(Using IRR function of excel over the Projected Net Cash Flows)
		Based on NPV and IRR , Project is accepted (NPV is positive, IRR greater than 15%)
		However, cost of capital need to be recalculated and risk of the project assessed