Question

In: Accounting

CASE STUDY FINANCIAL VIABILITY INDICATORS Kulula Ltd has been incorporated as an investment advisory company. The...

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

Solutions

Expert Solution

Tomato Growing Chicken layers
Year Annual Cash flow Cumlative cash flow Annual Cash flow Cumlative cash flow
1           60,00,000.00                 60,00,000.00        60,00,000.00                 60,00,000.00
2           50,00,000.00              1,10,00,000.00        90,00,000.00              1,50,00,000.00
3        1,10,00,000.00              2,20,00,000.00    1,20,00,000.00              2,70,00,000.00
4        1,50,00,000.00              3,70,00,000.00    1,50,00,000.00              4,20,00,000.00
5        2,00,00,000.00              5,70,00,000.00        50,00,000.00              4,70,00,000.00
Pay back period 2 years 4 months Pay back period 2 years

Related Solutions

Case study This case study is about Zama Brooks Ltd, a company that has been known...
Case study This case study is about Zama Brooks Ltd, a company that has been known to have bad results for the past three years. Our company has been trying to carry out an analysis to undermine whether acquisition of controlling shares in Zama Brooks Ltd will yield fruits. You are the financial director in the company interested in obtaining controlling shares in Zama Brooks Ltd and management at the company are so eager to produce good results. Management has...
Case Study: Orpheus Financial Advisors Orpheus was an extremely successful, and very well respected financial advisory...
Case Study: Orpheus Financial Advisors Orpheus was an extremely successful, and very well respected financial advisory firm with offices throughout the United States. Orpheus had a reputation for well-trained advisors and was known to be very selective in terms of the investment managers they would recommend to their clients. As a result, Orpheus clients tended to stay with the investment choices they were recommended for an average of ten years. The average for other platform managers was less than five...
Oyolium Ltd was incorporated 10 years ago and has been quite successful. The company wants to...
Oyolium Ltd was incorporated 10 years ago and has been quite successful. The company wants to expand and requires further funds to do so. Rather than seeking finance from Banks it decides to offer Ordinary shares to the public. A Prospectus was issued on 1st August 20X3 seeking applications for 5,000,000 Ordinary share at $10.00 each. Details of the offer are: $3.00 on Application to be received on or by 30th September 20X3 $2.00 payable on Allotment The remaining $5.00...
Case study Susan Chumley has worked at Suspenders Ltd for six months and has been appointed...
Case study Susan Chumley has worked at Suspenders Ltd for six months and has been appointed a team leader. In the time she has been there, out of the eight members of her team who were there when she joined three have left and one is on long-term sick after having a breakdown. She has to attend meetings of other team leaders and supervisors. At one of the meetings she was told that certain suppliers were to be given ‘special...
you are the business manager who has been tasked with researching the financial viability of opening...
you are the business manager who has been tasked with researching the financial viability of opening a satellite clinic. Identify which things you should measure to determine if you open the satellite clinic. Identify 10-15 financial and nonfinancial metrics used to assess the viability of opening a satellite clinic. From this list, select three financial and three nonfinancial metrics that are the most important and explain their significance (net revenue, demographics, customer relations). Where will you find, and how will...
you are the business manager who has been tasked with researching the financial viability of opening...
you are the business manager who has been tasked with researching the financial viability of opening a satellite clinic. Identify which things you should measure to determine if you open the satellite clinic. that addresses the following: Identify 10-15 financial and nonfinancial metrics used to assess the viability of opening a satellite clinic. From this list, select three financial and three nonfinancial metrics that are the most important and explain their significance (net revenue, demographics, customer relations). Where will you...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few related gardening enterprises. It has a large display garden that it opens for public inspection several times a year. These enterprises include the Regional Gardens Nursery which sells plants and garden supplies to the public, and Regional Garden Planners which provides garden advice, design and consultancy services. Regional Gardens Ltd has a small data centre at its main site in Bathurst where the company’s...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few related gardening enterprises. It has a large display garden that it opens for public inspection several times a year. These enterprises include the Regional Gardens Nursery which sells plants and garden supplies to the public, and Regional Garden Planners which provides garden advice, design and consultancy services. Regional Gardens Ltd has a small data centre at its main site in Bathurst where the company’s...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few...
Case Study: Regional Gardens Case study Regional Gardens Ltd is a company that runs a few related gardening enterprises. It has a large display garden that it opens for public inspection several times a year. These enterprises include the Regional Gardens Nursery which sells plants and garden supplies to the public, and Regional Garden Planners which provides garden advice, design and consultancy services. Regional Gardens Ltd has a small data centre at its main site in Bathurst where the company’s...
The financial report of Allgreen Ltd, a company incorporated in Singapore, for the year ended 31...
The financial report of Allgreen Ltd, a company incorporated in Singapore, for the year ended 31 December 2018, contained the following disclosure: Foreign currency – Effective 1 January 2019, the Malaysian Ringgit became the functional currency for translating the financial statements of Allgreen’s 59% owned Malaysian subsidiary Allgreen Sendirian Berhad. Economic factors and circumstances related to Allgreen Sendirian Berhad’s operations have changed significantly since the last quarter of 2018. It is deemed that Allgreen Sendirian Berhad is now an independent...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT