In: Accounting
INFORMATION Hattingh Limited has the option to invest in machinery in Projects A and B but finance is only available to invest in one of them. You are provided with the following projected data: Project A Project B Initial cost 500 000 500 000 Year 1 120 000 150 000 Year 2 160 000 150 000 Year 3 170 000 150 000 Year 4 180 000 150 000 Year 5 150 000 150 000 Depreciation per year 90 0000 100 000 Additional information 1. Project A machinery is expected to be disposed of at the end of year 5 with a scrap value of 50 000 (not included in the figures above) 2. Project B machinery is not expected to have any scrap value. 3. The discount rate to be used by the company is 15%. QUESTION 1 • Calculate the Payback Period of Project A (answer expressed in years, months and days). • Calculate the Accounting Rate of Return (on average investment) of Project A (answer expressed to two decimal places). • Calculate the Benefit Cost Ratio of Project A (answer rounded off to three decimal places). • Calculate the Internai Rate of Return of Project B (answer expressed to two decimal places).
| Discounted Cash Inflow = | Actual Cash Inflow/ | 
| (1 + i)n | 
Where,
   i is the discount rate
=15%
   n is the period to which the
cash inflow relates
Actual cash flow = 0 1 2 3 4 5
-500000 120000 160000 170000 180000 150000
PV factor = 1/(1+15%)^n
| 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
| 
 1  | 
 0.869565217391304  | 
 0.756143667296787  | 
 0.657516232431988  | 
 0.571753245593033  | 
 0.49717673529829  | 
| 
 -500000  | 
 discounted cash flow= 104347.826086957  | 
 120982.986767486  | 
 111777.759513438  | 
 102915.584206746  | 
 74576.5102947435  | 
| 
 Cumulative Discounted Cash Flow  | 
|||||
| 
 =  | 
 -395652.173913043  | 
 -274669.187145558  | 
 -162891.42763212  | 
 -59975.8434253736  | 
 14600.6668693699  | 
| 
 pay back period =  | 
 4+mod(-59975.84)/74576.51029  | 
 4.80421891245349  | 
| 
 as payback comes when cummultive cash flow is zeros it is after 4 years  | 
 now .8042*12 =9.6504 months now .6504*30 =19.51days  | 
so payback of project A=4 years 9 months 19.51 days approx