In: Finance
A firm purchased some office equipment for a total cost of $300000. The equipment generated net income of $100000 per year. The firm’s marginal tax rate is 20%. The equipment was sold at the end of the 4th year for a total of $75000. Assume that MARR is 12%/year. Calculate the net present worth (NPW) of this investment for problems 5-8.
7 (15 points). If the firm used the DDB depreciation, NPW =
8 (15 points). If the firm used the MACRS depreciation, NPW =
A.NPV calculation if following SLM depreciation
Income generated (per annum) =100000
less; depreciation((300000-75000)/4) =56250 p.a
Cash flow before Tax =43750
.Tax @20% =8750
Cash flow after tax =35000
Add;depreciation+cash from
sale of machine =75000+56250=131250
Net cash flow =166250
PVAF @ 12% for 4year =3.037
Discounted cash flow =504901.25
Initial outflow =300000
NPV =204901.25
B.NPV under DDB depreciation method(WDV method)
Depreciation calculation If depreciation rate is 50% per annum
| Year | Opening WDV | Depreciation | closing WDV | 
| 1 | 300000 | 150000 | 150000 | 
| 2 | 150000 | 75000 | 75000 | 
| 3 | 75000 | 37500 | 37500 | 
| 4 | 37500 | 37500 | 0 | 
NPV calculation
| Particulars | 1 | 2 | 3 | 4 | 
| Sales | 100000 | 100000 | 100000 | 100000 | 
| Less; depreciation | 150000 | 75000 | 37500 | 37500 | 
| Cash flow before tax | -50000 | 25000 | 62500 | 62500 | 
| Tax @20% | -10000 | 5000 | 12500 | 12500 | 
| cash flow after tax | -40000 | 20000 | 50000 | 50000 | 
| add; depreciation +sales vale of machine | 150000 | 75000 | 37500 | 112500 | 
| Net cash flow | 110000 | 95000 | 87500 | 162500 | 
| Df@ 12% | .893 | .797 | .712 | .636 | 
| Discounted cash flow | 98230 | 75715 | 62300 | 103350 | 
NPV =DCF-iniatial out flow
=339595-300000 =39595
C.NPV if Depreciation method is MACRS
Depreciation calculation
| Year | Depreciation Rate | amount of depreciation | 
| 1 | 20% | 60000 | 
| 2 | 32% | 96000 | 
| 3 | 19.2% | 57600 | 
| 4 | 11.52% | 34560 | 
NPV calculation
| Particulars | 1 | 2 | 3 | 4 | 
| Sales | 100000 | 100000 | 100000 | 100000 | 
| Less; depreciation | 60000 | 96000 | 57600 | 34560 | 
| Cash flow before tax | 40000 | 4000 | 42400 | 65440 | 
| Tax @20% | 8000 | 800 | 8480 | 13088 | 
| cash flow after tax | 32000 | 3200 | 33920 | 52352 | 
| add; depreciation +sales vale of machine | 60000 | 96000 | 57600 | 109612 | 
| Net cash flow | 92000 | 99200 | 91520 | 161912 | 
| Df@ 12% | .893 | .797 | .712 | .636 | 
| Discounted cash flow | 82156 | 79062.4 | 65162.24 | 102976 | 
NPV=329356.64-300000 =29356.64