In: Finance
Computation of Annual Cash flows
S.No | Particulars | Amount |
A | Sales | $768,938 |
B | Variable Cost( Sales * 29%) | $222,992.02 |
C | Fixed Cost | $189,339 |
D | Depreciation | $210,963.00 |
E | Profit Before Tax( A-B-C-D) | $145,643.98 |
F | Taxes @ 39% | $56,801.15 |
G | Profit After Tax( E-F) | $88,842.83 |
H | Depreciation | $210,963.00 |
I | Annual Cash flow ( G+H) | $299,805.83 |
Computation of Depreciation
Depreciation =( Cost - salvage value)/ Expected useful life
= ( $ 843852-0) /4
= $ 210963
Computation of Present value of future cash flows
Year | Annual Cash flow | Disc @ 13% | Discounted Cash flows |
1 | $299,805.83 | 0.8850 | $265,314.89 |
2 | $299,805.83 | 0.7831 | $234,791.94 |
3 | $299,805.83 | 0.6931 | $207,780.48 |
4 | $299,805.83 | 0.6133 | $183,876.53 |
Total | $891,763.84 |
Computation of Net Present value
Particulars | Amount |
PV of the Cash inflows | $891,763.84 |
Less: Initial investment | ($843,852) |
Net Present value | $47,911.84 |
Since NPV is positive, we can accept the Project.
Note: The amount incurred on Marketing Survey is treated as Sunk Cost. Eventhough the Project has been started or not, this amount is already incurred. Hence this amount should not be considered for Decision making.
If you have any doubt,Please post a comment.
Thank you.Please rate it.