In: Finance
Pappy's Potato has come up with a new product, the Potato Pet that they are considering launching. The company has determined they will need a fixed asset investment at the beginning of the project of $260,000. This asset will last for four years which is the life of the project. Also, they will need to have more net working capital (NWC) of which they have estmated an amount of $16,500 for this purpose. The NWC will be recovered when the project is over. The Accounting Department has indicated that the depreciation method to be used for the fixed asset is the straight-line method over the life of the project and the asset is depreciated to a zero book value. Even though the asset is depreciated to a zero book value, the company estimates it will have a salvage value at the end of the project of $50,000. The OCF (operating cash flow) for each year of the project is estimated to be $82,500. The appropriate discount rate and tax rate to use for this analyis is 12 percent and 21 percent, respectively. Calculate the NPV (net present value) of this Potato Pet project.
Annual depreciation of equipment = Purchasing cost/Number of useful years
= $ 260,000 /4 = $ 65,000
Computation of annual cash flow:
Operating cash flow |
$82,500 |
Less: Depreciation |
$65,000 |
Profit before tax |
$17,500 |
Tax @ 21 % |
$3,675 |
Net profit |
$13,825 |
Add: Depreciation |
$65,000 |
Net annual cash flow |
$78,825 |
Cash flow in year 0 = Purchasing cost of equipment + Working capital
= $ 260,000 + $ 16,500 = $ 276,500
Cash flow in year 4 = Net annual cash flow + Salvage value x (1-Tax rate) + Working capital release
= $ 78,825 + $ 50,000 (1- 0.21) + $ 16,500
= $ 78,825 + ($ 50,000 x 0.79) + $ 16,500
= $ 78,825 + $ 39,500 + $ 16,500
= $ 134,825
NPV = PV of future cash inflow – Initial investment
Year |
Cash Flow (C) |
Computation of PV Factor |
PV Factor @ 12 % (F) |
PV (C x F) |
0 |
-$276,500 |
1/ (1+0.12)0 |
1 |
-$276,500.00 |
1 |
$78,825 |
1/ (1+0.12)1 |
0.892857142857143 |
$70,379.46 |
2 |
$78,825 |
1/ (1+0.12)2 |
0.797193877551020 |
$62,838.81 |
3 |
$78,825 |
1/ (1+0.12)3 |
0.711780247813411 |
$56,106.08 |
4 |
$134,825 |
1/ (1+0.12)4 |
0.635518078404831 |
$85,683.72 |
NPV |
-$1,491.93 |
NPV of the project is - $ 1,491.93