CASE STUDY FINANCIALVIABILITY INDICATORSKulula Ltd has been incorporated asan investment advisory company. The...CASE STUDY...

Free

80.2K

Verified Solution

Question

Accounting

CASE STUDY FINANCIALVIABILITY INDICATORS

Kulula Ltd has been incorporated asan investment advisory company. The company sources for consultingservices in investment appraisal and company valuation. You haverecently joined the company as an investment analyst. You have beenassigned to conduct an investment appraisal of two projects that aclient is considering investing in. The two projects are tomatogrowing using drip irrigation and the second project is keepinglayers for egg production. The initial investment required for eachproject is ZMW 15,000,000 to be invested in plant and machinery.The two projects are mutually exclusive meaning that only one canbe undertaken and not both.

The client has indicated that theycan only accept an investment that meets at leastthe following conditions:

Payback period of not more than 2 years.

Internal rate of return greater than 50%

Details of the project cash flowsand 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

DepreciationPolicy

The depreciation policy for theplant and machinery is straight line over 5 years with no residualvalue.

Cost of Capital

The weighted average cost of capitalis 25%.

Required:

Using MicrosoftExcel, you are required to:

Calculate the following financial viability indicatorsfor each project:

a) Normal payback period             

10 marks

b) Dynamic payback period            

10 marks

c) Net Present                      

10 marks

d) Profitability index or Net PresentValue 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 asto which of the two projects you recommend that the clientundertakes with justification.       15marks

Total marks = 70 marks

Answer & Explanation Solved by verified expert
3.9 Ratings (464 Votes)

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

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingCASE STUDY FINANCIALVIABILITY INDICATORSKulula Ltd has been incorporated asan investment advisory company. The...CASE STUDY FINANCIALVIABILITY INDICATORSKulula Ltd has been incorporated asan investment advisory company. The company sources for consultingservices in investment appraisal and company valuation. You haverecently joined the company as an investment analyst. You have beenassigned to conduct an investment appraisal of two projects that aclient is considering investing in. The two projects are tomatogrowing using drip irrigation and the second project is keepinglayers for egg production. The initial investment required for eachproject is ZMW 15,000,000 to be invested in plant and machinery.The two projects are mutually exclusive meaning that only one canbe undertaken and not both.The client has indicated that theycan only accept an investment that meets at leastthe following conditions:Payback period of not more than 2 years.Internal rate of return greater than 50%Details of the project cash flowsand other information are as follows:Cash flows:ProjectTomato GrowingProjectChicken LayersYearZMW'000YearZMW'000Outlay                  Year 0(15,000)Outlay                  Year 0(15,000)16,00016,00025,00029,000311,000312,000415,000415,000520,00059,000DepreciationPolicyThe depreciation policy for theplant and machinery is straight line over 5 years with no residualvalue.Cost of CapitalThe weighted average cost of capitalis 25%.Required:Using MicrosoftExcel, you are required to:Calculate the following financial viability indicatorsfor each project:a) Normal payback period             10 marksb) Dynamic payback period            10 marksc) Net Present                      10 marksd) Profitability index or Net PresentValue Ratio5 markse) Internal Rate of return             10 marksf) Accounting rate of return           10 marksPrepare a report to the client with a recommendation asto which of the two projects you recommend that the clientundertakes with justification.       15marksTotal marks = 70 marks

Other questions asked by students