In: Finance
.a). Calculation of Initial cost of the project:
The amount of RM 22,300 spent is a sunk cost.It is not relevant cost for evaluation of the project.
Initial Cost:
Cost of machine |
135,000 |
Installation and modification cost |
8,800 |
Net working capital increase |
6,000 |
Total Initial Cost (RM) |
149,800 |
Total Initial Cost =RM149,800
.b).Calculation of annualcash inflow in each year :
Annual Depreciation under straight-line method=(Cost-Salvage Value)/Useful life =(135000+8800-15000)/4=32,200
A |
B=A*28% |
C=A-B |
D |
E=C+D |
|
Earning Before interest & Taxes |
Tax Expenses |
After tax Operating Income |
Depreciation |
Annual Cash Flow |
|
Year |
EBIT |
Expense(Non Cash) |
|||
1 |
32,000 |
8,960 |
23,040 |
32,200 |
55,240 |
2 |
32,000 |
8,960 |
23,040 |
32,200 |
55,240 |
3 |
32,000 |
8,960 |
23,040 |
32,200 |
55,240 |
4 |
32,000 |
8,960 |
23,040 |
32,200 |
55,240 |
Annual Cash Flow =RM 55,240
.c) Calculation of terminal cash in flow:
Terminal cash flow is given below:
Salvage value of machine |
15,000 |
Release of Net working capital |
6000 |
Total terminal cash inflow |
21,000 |
Terminal Cash Flow=RM21,000
.d)Calculation of Net cash flow in each year and the present value(PV) of net cash flow:
PV of cash flow=(cash flow)/((1+i)^A)
A=year of cash flow, i=Required return =18%=0.18
A |
B |
C |
D |
E=B+C+D |
G=E/(1.18^A) |
initial cash |
Annual |
Terminal |
Net |
Present value |
|
Year |
flow |
cash flow |
Cash flow |
Cash flow |
PV of cash flow |
0 |
-149,800 |
-149,800 |
-149,800 |
||
1 |
55,240 |
55,240 |
46,814 |
||
2 |
55,240 |
55,240 |
39,673 |
||
3 |
55,240 |
55,240 |
33,621 |
||
4 |
55,240 |
21,000 |
76,240 |
39,324 |
|
TOTAL |
9,631 |
NPV of the Project |
RM 9,631 |
Yes, you should buy the machine. NPV is positive
.e) Payback Period =149800/55240=2.71 Years
If maximum payback period is two years you should not purchase
.f)You should follow NPV
Because,