CASE STUDY FINANCIAL VIABILITY INDICATORS

Kulula Ltd has been incorporated as an investment advisory company. The company sources for consulting services in investment appraisal and company valuation. You have recently joined the company as an investment analyst. You have been assigned to conduct an investment appraisal of two projects that a client is considering investing in. The two projects are tomato growing using drip irrigation and the second project is keeping layers for egg production. The initial investment required for each project is ZMW 15,000,000 to be invested in plant and machinery. The two projects are mutually exclusive meaning that only one can be undertaken and not both.

The client has indicated that they can only accept an investment that meets at least the following conditions:

Payback period of not more than 2 years.

Internal rate of return greater than 50%

Details of the project cash flows and other information are as follows:

Cash flows:

Project	Tomato Growing	Project	Chicken Layers
Year	ZMW'000	Year	ZMW'000
Outlay Year 0	(15,000)	Outlay Year 0	(15,000)
1	6,000	1	6,000
2	5,000	2	9,000
3	11,000	3	12,000
4	15,000	4	15,000
5	20,000	5	9,000

Depreciation Policy

The depreciation policy for the plant and machinery is straight line over 5 years with no residual value.

Cost of Capital

The weighted average cost of capital is 25%.

Required:

Using Microsoft Excel, you are required to:

Calculate the following financial viability indicators for each project:

a) Normal payback period		10 marks
b) Dynamic payback period		10 marks
c) Net Present		10 marks
d) Profitability index or Net Present Value Ratio		5 marks
e) Internal Rate of return		10 marks
f) Accounting rate of return		10 marks

Prepare a report to the client with a recommendation as to which of the two projects you recommend that the client undertakes with justification. 15 marks

Total marks = 70 marks