In: Finance
Cashflows of the project are calculated as given below :
year | 0 | 1 | 2 | 3 | 4 | 5 |
Annual Sales | 554000 | 554000 | 554000 | 554000 | 554000 | |
Annual Costs | 430000 | 430000 | 430000 | 430000 | 430000 | |
Depreciation | 97500 | 68250 | 47775 | 33442.5 | 23409.75 | |
EBT | 26500 | 55750 | 76225 | 90557.5 | 100590.25 | |
Less Tax @38% | 10070 | 21185 | 28965.5 | 34411.85 | 38224.295 | |
PAT | 16430 | 34565 | 47259.5 | 56145.65 | 62365.955 | |
Add Depreciation | 97500 | 68250 | 47775 | 33442.5 | 23409.75 | |
Fixed Assests Cost | 325000 | |||||
Net Working capital | 95000 | 95000 | ||||
Cashflows | -420000 | 113930 | 102815 | 95034.5 | 89588.15 | 180775.705 |
a) NPV
= -420000+113930/1.15 +102815/1.15^2+95034.5/1.15^3+89588.15/1.15^4+180775.71/1.15^5
= - $39601.01
b) PV of operating cashflow = 113930/1.15+102815/1.15^2+95034.5/1.15^3+89588.15/1.15^4+180775.71/1.15^5
= $380398.99
c) Project's total cash flow for the 1st year of the project (only year 1) = $113930 as calculated above