Question

In: Finance

Question 2: Gandul Limited has the option to invest in Project XXX. The following information is...

Question 2:

Gandul Limited has the option to invest in Project XXX. The following information is available on the project:

   Project XXX :
Investment R280 000
Scrap value Nil
Expected life 5 years
Cost of capital   12%
Expected after tax profits and cash flows: Profits Cash Flows


End of: Rand Rand
Year 1 23 000 79 000
Year 2 26 000 82 000
Year 3 40 000 96 000
Year 4 43 000 99 000
Year 5 14 000 70 000

Required:
2.1 Calculate the accounting rate of return. (Two decimal places)   
2.2 Calculate the payback period. (In years, months and days)   
2.3 If the payback cut off is three years, should the project be chosen? Why?   
2.4 Calculate the net present value of the project. (Round off amounts to the nearest Rand.)
2.5 Should the project be accepted on the basis of NPV? Why

Solutions

Expert Solution

1.) Calculation of Accounting Rate of Return :

Accounting Rate of Return = Average Net Income / Initial Investment

Average Net Income = Sum of After Tax Profits / Number of years

= (23000 + 26000 + 40000+ 43000 + 14000) / 5

= 146000 / 5

= 29200

Accounting Rate of Return (Baed on Itial Investment) = 29200 / 280000

= 10.43%

2.) Calculation of Payback Period

Below is the table showing Cash Flow and Cumulative Cash Flows

Year Cash Flows Cumulative Cash Flows
1 79000 79000
2 82000 161000
3 96000 257000
4 99000 356000
5 70000 426000

Payback period

= Complete years + (initial Investment - Remaining cash flows) / Cash flow of the year to be recovered

=3 years + (280000 - 257000) / 99000

=3.23 years

3.) If the payback cut off is three years, the project should not be chosen as the payback perod exceeds the acceptable payback period.

4.) Calculation of Net Present value :

Year Cash Inflow Present Value Factor @12% Present value of cash inflow
1 79000 0.892857143 70535.71429
2 82000 0.797193878 65369.89796
3 96000 0.711780248 68330.90379
4 99000 0.635518078 62916.28976
5 70000 0.567426856 39719.8799
Total Present value of cash inflow 306872.6857
Less : Cash outflow 280000
Net Present Value 26873

2.5) The project should be accepted as it has positive NPV.


Related Solutions

Gandul Limited has the option to invest in Project XXX. The following information is available on...
Gandul Limited has the option to invest in Project XXX. The following information is available on the project: Project XXX Investment R280 000 Scrap value Nil Expected life 5 years Cost of capital 12% Expected after tax profits and cash flows Profits Cash flows End of: Rand Rand Year 1 23 000 79 000 Year 2 26 000 82 000 Year 3 40 000 96 000 Year 4 43 000 99 000 Year 5 14 000 70 000 Required: 2.1...
INFORMATION Hattingh Limited has the option to invest in machinery in Projects A and B but...
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...
QUESTION 5 Dolby Enterprises has the option to invest in machinery in Projects M and N...
QUESTION 5 Dolby Enterprises has the option to invest in machinery in Projects M and N but finance is only available to invest in one of them. Project M (R) Project N (R) Initial cost 450 000 450 000 Net Profit Year 1 36 000 69 000 Year 2 75 000 69 000 Year 3 102 000 69 000 Year 4 129 000 69 000 Year 5 81 000 69 000 1. Assume that all cash flows take place at...
QUESTION 1.  (10 Marks) INFORMATION Medico Limited intends investing in a project during March 2021. The project...
QUESTION 1.   INFORMATION Medico Limited intends investing in a project during March 2021. The project is expected to cost R2 500 000 with a five-year useful life, and no residual value. The annual volume of production for the project is estimated at 150 000 units, which can be sold for cash at R12 per unit. Depreciation is expected to be R500 000 per year. Annual cash operating costs are as follows: Variable costs  R225 000 Fixed costs   R750 000 The cost...
Maria Corporation Limited (MCL) is interested to invest in a project. The initial cost of the...
Maria Corporation Limited (MCL) is interested to invest in a project. The initial cost of the project is Rs. 11.5 million with the salvage value of Rs. 2 million. The project will generate generates revenue of Rs 15 million per year with variable cost of Rs. 6 million and other expenses of Rs. 4 million. The revenue and cost/expense will expected to increase by 5% per annum for first 3 years and 7.5% for last 2 years. MCL’s cost of...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited:...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R...
QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract...
QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December:                                       2019          2018                                         $                   $ Sales                       2 000 000 1 600 000 Cost of sales              940 000      800 000 Operating profit       600 000      520 000 Profit before tax      520 000     450 000 Profit after tax           364 000    315 000 Extract of Statement of Financial Position as at 31 December: Assets                                   2019              2018...
Underwood Limited is considering investing in a new project, for which the following information is available:...
Underwood Limited is considering investing in a new project, for which the following information is available: Initial Investment                  £2,000,000 Life of Project                 5 years Estimated annual cash flow £400,000 per annum Residual Value                £150,000 The company has a cost of capital of 2%, but uses a 5% hurdle rate when assessing capital projects. Stating clearly any assumptions you make, evaluate the financial viability of the investment by determining the project’s: Payback Accounting Rate of Return Net Present...
The following information are the balances extracted from the books of Xxx for the year ended...
The following information are the balances extracted from the books of Xxx for the year ended 31 December 2017: accounts                  dr                        cr opening stock        8000 buildings                 15000 debitors                  4000 purchases               22000 salaries                    1200 sales                                                   36000 discount                  800 sales returns          1000 furniture                 3000 office exp               300 wages                      600 purchase returns                               600 interest                                                  500 travelling exp         400 insurance                 600 machinery              8000 carriage on purchases 800 commission           600 cash in hand          1400 rent and rates         2400 capital                                                   25000 creditors                                                8000 totals                      70100                   70100...
Alex Company is planning to invest in a project. The following information is provided: Initial cash...
Alex Company is planning to invest in a project. The following information is provided: Initial cash outflow = $75,000 Expected future cash flows = $20,000 every year for the next 5 years Alex’s before-tax cost of debt = 5% Tax rate = 30% Next year’s expected dividend = $1 per share Current price of the stock = $25 Expected growth rate = 4% Target capital structure = 70% equity and 30% debt Flotation costs for equity = 4% Calculate the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT