Question
Compute and insert the missing figures in the colored spaces. (Use Excel and Show Formula) Balance Sheet as at December 31, 2015 - 2019 Kshs.
Compute and insert the missing figures in the colored spaces. (Use Excel and Show Formula)
Balance Sheet as at December 31, 2015 - 2019 | |||||
| Kshs. Millions | ||||
| 2015 | 2016 | 2017 | 2018 | 2019 |
Assets |
|
|
|
|
|
Non-current Assets: |
|
|
|
|
|
Property, plant and equipment | 1,920.00 | 2,263.00 | 2,548.00 | 2,502.00 | 2,445.00 |
Investments | 358.00 | 358.00 | 358.00 | 358.00 | 358.00 |
Intangible assets | 93.00 | 54.00 | 42.00 | 146.00 | 106.00 |
Total non - current assets |
|
|
|
|
|
Current Assets: |
|
|
|
|
|
Inventories | 3,381.00 | 3,900.00 | 3,084.00 | 6,428.00 | 3,654.00 |
Accounts receivable | 2,164.00 | 4,513.00 | 4,068.00 | 5,536.00 | 5,846.00 |
Cash and cash equivalents | 436.00 | 320.00 | 1,346.00 | 1,343.00 | 886.00 |
Total Current Assets |
|
|
|
|
|
Total Assets |
|
|
|
|
|
|
|
|
|
|
|
Equity and Liabilities |
|
|
|
|
|
Capital and Reserves |
|
|
|
|
|
Share capital | 893.00 | 930.00 | 930.00 | 930.00 | 930.00 |
Share premium | 1,850.00 | 2,090.00 | 2,090.00 | 2,090.00 | 2,090.00 |
Revenue reserves | 1,172.00 | 1,320.00 | 1,885.00 | 1,936.00 | 2,028.00 |
Proposed dividends | 465.00 | 465.00 | |||
Total capital and reserves |
|
|
|
|
|
|
|
|
|
|
|
Long-term Liabilities |
|
|
|
|
|
Debenture | 638.00 | 585.00 | 531.00 | 956.00 | 1,010.00 |
Mortgage | 106.00 | 160.00 | 213.00 | 224.00 | 276.00 |
Total Long-term Liabilities |
|
|
|
|
|
|
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
Trade creditors and others | 1,858.00 | 2,388.00 | 1,293.00 | 4,850.00 | 4,011.00 |
Short-term borrowings | 1,370.00 | 3,271.00 | 4,505.00 | 5,327.00 | 2,950.00 |
Total Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
Total Liabilities |
|
|
|
|
|
Total Equity and Liabilities |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started