Question

In: Finance

Question 1 The financial statements of Old Chang Kee Pte Ltd are given below: Old Chang...

Question 1
The financial statements of Old Chang Kee Pte Ltd are given below:

Old Chang Kee Profit & Loss
for Year ending 31 March  ($'000)
2019 2018 2017
Revenue 89,789 85,487 78,345
less Cost of goods sold (32,251) (33,249) (28,721)
Gross Profit 57,538 52,238 49,624
less Expenses
Selling and distribution (38,039) (35,291) (32,333)
Administrative (12,892) (11,782) (11,614)
Other expenses (1,774) (1,791) (4,504)
Operating Profit 4,833 3,374 1,173
Interest income 64 49 81
Other income 1,145 1,680 1,351
Profit before interest & tax 6,042 5,103 2,605
Share of results of joint venture (301) (76)
less Interest expense (329) (291) (175)
Profit before tax 5,412 4,736 2,430
less Tax (1,074) (952) 685
Profit after tax 4,338 3,784 1,745
Other comprehensive income 76 (19) (1,703)
Net profit 4,414 3,765 42
Old Chang Kee Balance Sheet
as at March 31 ($'000) 2019 2018 2017
Fixed Assets
Property, plant 28,453 31,560 27,571
Intangible assets 228 289 352
Other investment 394 525 273
Long term deposits 2,568 2,434 2,024
Total Fixed Assets 31,643 34,808 30,220
Current assets
Inventories 1,097 1,192 705
Trade and other receivables 336 277 253
Deposits 756 1,015 1,040
Prepayments 1,013 1,192 2,939
Other debtors 625
Cash 15,447 12,787 15,555
Total Current Assets 19,274 16,463 20,492
Total Assets 50,917 51,271 50,712
Current Liabilities
Trade and other payables 7,491 7,891 8,252
Other liabilities 176 170 170
Provisions 2390 2,398 2,285
Bank loans 1,430 1,430 4,230
Finance lease liabilities 146 166 117
Provisions 1,321 697 1,129
Total Current Liabilities 12,954 12,752 16,183
Long Term Liabilities
Bank term loans 7,748 9,179 6,032
Finance lease liabilities 502 506 160
Deferred Tax Liabilities 1,256 1,336 963
Total Liabilities 22,460 23,773 23,338
Shareholders' Equity 13,964 13,964 13,964
Retained earnings 14,398 13,515 13,372
Other reserves 95 19 38
Total Shareholders' Equity 28,457 27,498 27,374
Total Liabilities and SE 50,917 51,271 50,712
Other Statistics
Net assets value (cents) 27.43 28.52 22.55
Earnings per share (cents) 4.35 4.1 1.44
Share price (cents) 78.5 75 85

Answer the following questions regarding the analysis of Old Chang Kee’s financial statements:

  1. (i) Interpret Old Chang Kee’s liquidity and discuss whether it has any difficulty paying its creditors.

  2. (ii) Which ratios computed in part (a) suggest that the inventory level is relatively low. Briefly discuss why this is so.

  3. (iii) An analyst computed the expected earnings of the company to be $0.05. Based only on the PE ratios you have computed and the financial data given in the question, what would be a reasonable value of each share? Examine and explain.

  4. (iv) Discuss why Old Chang Kee’s stock price is very much higher than its net asset value.

Solutions

Expert Solution

Answer (i) : The know the liqudity position of the company these are the following ratio have to be computed:

1) Current Ratio

2) Liquid Ratio

3) Cash Ratio

4) Debtors Turnover Ratio

5) Creditors Turnover Ratio

the above ratios as calculated below :

Current Assets
2019 2018 2017
Inventories $   1,097.00 $   1,192.00 $       705.00
Trade and other Receivables $       336.00 $       277.00 $       253.00
Prepayments $   1,013.00 $   1,192.00 $   2,939.00
Other Debtors $       625.00
Cash $ 15,447.00 $ 12,787.00 $ 15,555.00
Deposits $       756.00 $   1,015.00 $   1,040.00
Total current Assests $ 19,274.00 $ 16,463.00 $ 20,492.00
Current Liabilities
2019 2018 2017
Trade other payables $   7,491.00 $   7,891.00 $   8,252.00
Other Liabilities $       176.00 $       170.00 $       170.00
Provisions $   2,390.00 $   2,398.00 $   2,285.00
Bank Loans $   1,430.00 $   1,430.00 $   4,230.00
Finance Lease liabilities $       146.00 $       166.00 $       117.00
Provisions $   1,321.00 $       697.00 $   1,129.00
Total Current liabilities $ 12,954.00 $ 12,752.00 $ 16,183.00
CR =Current Assets/Current Liabilities 1.48788019 1.29101317 1.26626707
Cash and bank Deposit
2019 2018 2017
cash $ 15,447.00 $ 12,787.00 $ 15,555.00
Deposits $       756.00 $   1,015.00 $   1,040.00
$ 16,203.00 $ 13,802.00 $ 16,595.00
Cash Ratio= Cash & bank Deposit/Current Liabilties 1.25081056 1.08234003 1.02545881
Liquid Assets
2019 2018 2017
Trade and other Receivables $       336.00 $       277.00 $       253.00
Cash $ 15,447.00 $ 12,787.00 $ 15,555.00
Other Debtors $       625.00
Deposits $       756.00 $   1,015.00 $   1,040.00
$ 17,164.00 $ 14,079.00 $ 16,848.00
Liquid Liabilities
2019 2018 2017
Trade other payables $   7,491.00 $   7,891.00 $   8,252.00
Other Liabilities $       176.00 $       170.00 $       170.00
Provisions $   2,390.00 $   2,398.00 $   2,285.00
Bank Loans $   1,430.00 $   1,430.00 $   4,230.00
Finance Lease liabilities $       146.00 $       166.00 $       117.00
Provisions $   1,321.00 $       697.00 $   1,129.00
$ 12,954.00 $ 12,752.00 $ 16,183.00
LR = Liqud Assets/ Liquid Liabilities 1.32499614 1.10406211 1.0410925
Debtors Turover Ratio
2019 2018 2017
Revenue $ 89,789.00 $ 85,487.00 $ 78,345.00
Trade & Other Receivables $       336.00 $       277.00 $       253.00
Other Debtors $       625.00
Total trade Debtors and Receivables $       961.00 $       277.00 $       253.00
Debtors Turover Ratio= Revenue/ Total Trade Debtors & Receivables 93.43288 308.61733 309.66403
in days 3.90654757 1.18269444 1.17869679
Creditors Turover Ratio
2019 2018 2017
Trade and other payables $   7,491.00 $   7,891.00 $   8,252.00
Cost of goods Sold $ 32,251.00 $ 33,249.00 $ 28,721.00
b/a 4.30529969 4.21353441 3.48048958
indays 84.7792317 86.6256128 104.870304

The liquidity position of the company is as follows :

1)Current ratios of the company has been increasing from year 2017 to 2019 I,e from 1.26 to 1.48 but shows within industry bench mark 2:1

2)Liquid Ratio of the company has been increasing from year 2017 to 2019 I,e from 1.04 to 1.32 but shows it exceeds the industry bench market of 1:1 which is not good liquid postion.

3)Cash ratio of the company has been increasing from year 2017 to 2019 I,e from 1.02 to 1.25 but it shows it exceeds the industry benchmark 0.5:1 which is not having good cash position.

4)Debtors turnover in days has been increasing from year 2017 to 2019 I,e from 1.17 days to 3.90 days but credit collection period very good and its in control of the company.

5)Creditors Turnover in days shows that an improvement in credit payable to suppliers from year 2017 to 2019 I,e 100 days to 84 days. The company has improved its liquidity position to pay to suppliers in 84 days in 2019.


Related Solutions

QUESTION 1 Below are the financial statements of Purple Panther Ltd. PURPLE PANTHER LTD Statement of...
QUESTION 1 Below are the financial statements of Purple Panther Ltd. PURPLE PANTHER LTD Statement of Financial Position as at 31 December 2007 2007 2006 Assets Cash 72,000 31,200 Accounts receivable 43,200 33,600 Inventory 81,600 84,000 Plant 168,000 187,200 Less: Accumulated depreciation (72,000) 96,000 (57,600) 129,600 Total Assets 292,800 278,400 Liabilities and Equity Accounts payable 69,600 79,200 Income tax payable 36,000 48,000 Debentures payable 36,000 24,000 Share capital 72,000 60,000 Retained earnings 79,200 67,200 Total Liabilities and Equity 292,800 278,400...
The financial statements of PLC Pte Ltd had been completed but not yet released to shareholders....
The financial statements of PLC Pte Ltd had been completed but not yet released to shareholders. The closing inventory of PLC Pte Ltd amounted to $332,000 as at 31 December 20X1, its financial year-end. This total included two products with the following information: (i) 150 units of Product A were carried at a cost of $12 each. On 2 January 20X2, they were sold for $9 each, with total selling expenses of $100. (ii) 300 units of Product B were...
Lion Pte Ltd is finalising its financial statements for the year ended 31 December 20X1. The...
Lion Pte Ltd is finalising its financial statements for the year ended 31 December 20X1. The date of authorisation of financial statements for issue was 14 March 20X2 and the annual general meeting is scheduled on 23 April 20X2. The following events occurred as follows: (a) Inventory held by Lion Pte Ltd was recorded at its cost of $1,104,000 at 31 December 20X1 in the statement of financial position. The whole inventory was damaged by flood water in December 20X1....
XY Pte Ltd is finalising its financial statements for the year ended 31 December 20X1. The...
XY Pte Ltd is finalising its financial statements for the year ended 31 December 20X1. The date of authorisation of financial statements for issue was 14 March 20X2 and the annual general meeting is scheduled on 23 April 20X2. The following events occurred as follows: (a) Inventory held by XY Pte Ltd was recorded at its cost of $1,104,000 at 31 December 20X1 in the statement of financial position. The whole inventory was damaged by flood water in December 20X1....
QUESTION 1 Given the financial statements below for Firefly Enterprises, what is the external financing need...
QUESTION 1 Given the financial statements below for Firefly Enterprises, what is the external financing need for a pro forma increase in sales of 5%? Enter your answer as the nearest whole (e.g., 123), but do not include the $ sign.    Firefly Enterprises Income Statement ($ Million) 2011 Sales 740 Cost of Goods Sold 452 Selling, General, & Admin Exp. 124 Depreciation 40 Earnings Before Interest & Taxes 124 Interest Expense 24 Taxable Income 100 Taxes at 40% 40...
QUESTION 1. Given the financial statements below for Firefly Enterprises, what is the external financing need...
QUESTION 1. Given the financial statements below for Firefly Enterprises, what is the external financing need for a pro forma increase in sales of 18%? Enter your answer as the nearest whole (e.g., 123), but do not include the $ sign. Firefly Enterprises Income Statement ($ Million) 2011 Sales 740 Cost of Goods Sold 452 Selling, General, & Admin Exp. 124 Depreciation 40 Earnings Before Interest & Taxes 124 Interest Expense 24 Taxable Income 100 Taxes at 40% 40 Net...
The financial statements for Linked Ltd. are shown below:
The financial statements for Linked Ltd. are shown below: During the year, the company purchased a capital asset valued at $30,000; payment was made by issuing common shares. Additional capital assets were acquired for cash. Changes in other accounts were typical transactions. Required:1. Prepare the SCF using the indirect method. Include required note disclosure of non-cash transactions. Omit the separate disclosure of cash flow for interest, investment income, and income tax.2. Explain the company’s cash transactions for the year, based...
Question No. 1 (Marks 15) C Company’s forecasted 2020 financial statements are given below, along with...
Question No. 1 (Marks 15) C Company’s forecasted 2020 financial statements are given below, along with industry average ratios.                                                                                     C Company: Forecasted Balance sheet as of December 31, 2020 Cash 72,000 Accounts Receivable 439,000 Inventories 894,000 Total Current Assets 1,405,000 Land and Buildings 238,000 Machinery 132,000 Other Fixed assets 61,000 Total Assets ,1,836,000 Equity & Liabilities Accounts and Notes Payable 432,000 Accrued liabilities 170,000 Total Current liabilities 602,000 Long term Debt 404,290 Common stock 575,000 Retained earnings 254,710...
QUESTION 1 [25] The following are extracts from the financial statements of ABC Ltd for the...
QUESTION 1 [25] The following are extracts from the financial statements of ABC Ltd for the year ended 31 December 2019: ABC Ltd Statement of Profit or Loss and Other Comprehensive Income for the year ended 31 December 2019 Revenue 280 842 Cost of Sales (100 000) Gross Profit 180 842 Interest received 4 528 Dividends received on listed investments 6 680 Profit on disposal of property, plant & equipment 560 Administration expenses (64 730) Depreciation of property, plant &...
Wing Sdn.Bhd is responsibility to pay royalties of RM70,000 to Way Pte Ltd for the financial...
Wing Sdn.Bhd is responsibility to pay royalties of RM70,000 to Way Pte Ltd for the financial year ended 31 December 2018. Wing Sdn.Bhd paid RM63,000, net of tax to Way Pte Ltd on 30 December 2018. The company claimed the entire RM70,000 as a tax deduction to arrive at the chargeable income of RM800,000 for Y/A 2018. Wing Sdn.Bhd submits its tax return Form C for Y/A 2018 on 31 July 2019, showing a tax charge of RM192,000 (24% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT