The Comodores ltd wants to determine its liquidity position in 6 years from closure of business in year 2021. The financial position as at December 2021 was:
Balance sheet as at 31 December, 2021
Additional information:
1. The loan will mature before the end of the 5 year period and will be duly settled.
2. Sales for year 2021 amounted to ksh 92,800m and are expected to grow by 6% per year in each of the six years from 2022 to 2027.
3. Dividend payout ratio of 28% is to be maintained.
4. Profit before tax is to be maintained at 14% of sales.
5. The 15% loan is maturing in the year 2025.
6. Each of the balance sheet items, (except ordinary share capital, reserves and 15% loan) have a relationship with the turnover which is expected to remain for the foreseeable future.
7. Corporation tax rate is 30%.
Required:
Determine the amount external financing required or surplus cash available as at 31 December, 2027 and prepare the proforma statement of financial position as at that date.