Question

ABC is considering launching a new product.

a. The initial investment in equipment is 300,000. This investment will be depreciated straight line over 3 years to a value of zero, but when the project comes to an end in 3 years, the equipment, in fact, be sold for 100,000.

b. ABC already spent 120,000 on market share research. The project will require on annual advertising cost of 60,000.

c. ABC estimates that the first year unit of sale will be 140,000 units. The unit of sale grow up by 100,000 units a year.

d. ABC planned price per unit is 10 and each product costs 7 to make.

e. ABC needs to spend 100,000 in its working capital account when it launched this. The company projects this working capital account will increase by 10,000 every year and capital will reduce to zero in the final year of the project.

d. ABC's current payroll expense is 400,000. The company projects the total payment will go up bu 50% if they launch the new product.

f. ABC's cost of capital is 15% and tax rate is 30%.

Qn1. Calculate the following to represent a discounted cash flow analysis.

price per unit
cost per unit
cost of capital

Qn2.

	year	year	year	yea
tax on gain
unit of sales
working capital
sales
cost of goods sold
depreciation
advertising
salary
income before tax
tax 30%
CF
Changes in WC
capital investment and recovery
Net CFs

Qn3. calculate the NPV.

Answer 1

	0	1	2	3
Sales in units		140000	240000	340000
Sales revenue		$    1,400,000	$    2,400,000	$    3,400,000
-Cost of production		$       980,000	$    1,680,000	$    2,380,000
-Increase in payroll expenses [400000*50%]		$       200,000	$        200,000	$        200,000
-Advertising		$          60,000	$          60,000	$          60,000
-Depreciation		$       100,000	$        100,000	$        100,000
=NOI		$          60,000	$        360,000	$        660,000
-Tax at 30%		$          18,000	$        108,000	$        198,000
=NOPAT		$          42,000	$        252,000	$        462,000
+Depreciation		$       100,000	$        100,000	$        100,000
=OCF		$       142,000	$        352,000	$        562,000
-Capital expenditure	$        300,000
+After tax salvage value [100000*(1-30%)]				$          70,000
-Change in NWC	$        100,000	$          10,000	$          10,000	$     (120,000)
=FCF	$      (400,000)	$       132,000	$        342,000	$        752,000
PVIF at 15% [PVIF = 1/1.15^t]	1	0.86957	0.75614	0.65752
PV at 15% [FCF*PVIF]	$      (400,000)	$       114,783	$        258,601	$        494,452
NPV	$        467,836