In: Finance
Kennedy Air is evaluating a new project. The equipment will cost $50,000 plus $10,000 to install. It will be depreciated using the MACRS 3-year class. The project would require an increase in inventories of $6,000 and an increase in A/P of $1,000. The firm’s yearly revenues would increase by $40,000 but would also increase operating costs by $10,000. The project is expected to last 3 years and the equipment can then be sold for $10,000. The firm’s tax rate is 40% and their cost of capital is 12%. What is the project’s NPV?
NPV of the project is $5,505
Calculations: -
A). Initial cash outflow of the project is $65,000
initial cash outflow = cost of new equipment + increase in Net working
1.cost of new equipment = cost of purchase + installation cost
= $50,000 + $10,000
= $60,000
2.increase in Net working capital
= increase in inventories – increase in accounts payable
= $6,000 - $1,000
= $5,000
initial cash outflow = ($60,000 + $5,000) = $65,000
B.) Yearly operating Cash Flow is $65,486
Step 1: calculation of depreciation
Depreciation base =$60,000
Depreciation expense = depreciation base * rate
years |
depreciation rate |
depreciation |
accumulated depreciation |
1 |
0.333 |
19980 |
19980 |
2 |
0.445 |
26700 |
46680 |
3 |
0.148 |
8880 |
55560 |
Step 2: calculation of operating cash flow
Years |
$1 |
$2 |
$3 |
Annual Sales |
$40,000 |
$40,000 |
$40,000 |
Operating costs |
($10,000) |
($10,000) |
($10,000) |
Depreciation expense |
($19,980) |
($26,700) |
($8,880) |
EBIT |
$10,020 |
$3,300 |
$21,120 |
Tax (40%) |
($4,008) |
($1,320) |
($8,448) |
Net income |
$6,012 |
$1,980 |
$12,672 |
add non-cash expense(depreciation) |
$19,980 |
$26,700 |
$8,880 |
Operating cash flows |
$25,992 |
$28,680 |
$21,552 |
C.) Terminal cash flow of the project is $12776
Terminal cash flow = NSV of project assets + Recovered Net working capital
. NSV of new equipment
Book value of new asset (BV) |
Depreciation basis - Accumulated Depreciation |
= $60,000 - $55560 |
|
=$4,440 |
|
Market value (MV) |
=$10,000 |
NSV of project old asset |
= MV - tax rate (MV-BV) |
=$10,000 - .4 *($10,000- $4,440) |
|
=$7,776 |
Recovered Net working capital = $5,000
Therefore, Terminal cash flow =$7,776 + $5,000 = $12776
D.) NPV calculation
Years |
0 |
1 |
2 |
3 |
initial investment |
(60,000) |
|||
change in net working capital |
(5,000) |
5000 |
||
operating cash flow |
$25,992 |
$28,680 |
$21,552 |
|
NSV of new equipment |
7776 |
|||
Total cash flows |
(65,000) |
$25,992 |
$28,680 |
$34,328 |
PVIF @ 12% |
1 |
0.8929 |
0.7972 |
0.7118 |
Discounted cash flows |
(65,000) |
$23,207 |
$22,864 |
$24,434 |
Sum of Discounted cash flows from year 1 to 6 = $70,505 |
NPV = Sum of Discounted cash flows from year 1 to 3 – initial outflow
NPV = $70,505 – 65,000
NPV = $5,505