kindly give explanation and analysis for the ratio base on P&L and BS provided.
AutoSave Off H20 Appendix 6 VASB v2 Search HASLINDA AHMAD SHAFIEE HA File Home Insert Design Layout References Mailings Review View Help Table Design Layout Share Comments Eva EE 7 AL 1 Times New Rom - 10 A A A A BI U ab X, X? ADA AaBbCcDc AaBbccdc AaBbc AaBbcc Aab 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace Select Paste Dictate Sensitivity Editor Clipboard Font Voice Paragraph Styles Editing 1:::1:1:21:3 X 4.1.5. 17::9. 10. 1.11. 1. 12. 1. 13. 14. 15. 1. 16. 1. 17. 18. 19. 20. Sensitivity Editor 6.3 VASB's Key Financial Ratios Table 6.3 VASB's Key Financial Ratios June 19 June 20 Ratios Profitability Ratio Gross Profit Margin Net Profit Margin Turnover Growth 30.91% 34.27% 1.61% 47.53% 99% 23.58% 11.83% 17.51% RM292K RM361k 42.33% 36.92% :20. 9., 18., 1. 1... HI 3:1 12. .11. 10 19,8:1.7.1.6. Retum of Assets Retum of Employee Per Employee) Retum on Capital Employed (ROCE) Eamings Per Share (RM) Solvency Ratio Debt to Equity Ratio Debt to Asset Ratio Liquidity Ratio (Times) 6.79 sen 9.97 sen 1.27 0.70 0.75 0.53 Current Ratio 1.38 1.83 Quick Ratio Efficiency Ratio Inventory Turnover Ratio Receivable Turnover Ratio Payable Tumover Ratio Page 10 of 10 1808 words LX English (United States) C Focus + 91% O FI Pi e w la 4 ENG 11:56 AM 24/8/2020 AutoSave Off Appendix 6 VASB v2 - Search HASLINDA AHMAD SHAFIEE HA File Home Insert Design Layout References Mailings Review View Help Table Design Layout Share Comments = E ALT Times New Rom - 10 A A A A BI U ab X, X? ADA AaBbCcDc AaBbCcDc AaBbC AaBbccl Aab 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace Select Paste E Dictate Editor Sensitivity Clipboard Font Voice Sensitivity Editor Paragraph Styles Editing 1::1:1:1:2:1:3 4.1.5. 1:7: 11:9. 10. 1.11. | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 L June Variance Particulars 2020 Approved Budget RM000 2019 2020 Budget RM1000 RM1000 RM1000 (A) (B) (C) 403 80 1.359 606 481 647 RM1000 % (B) vs (C) RM1000 % (B) vs (A) (403) (100) 80 100 (125) (21) (>100 (166) (100) (26) 2,719 1,293 150 809 767 936 554 720 980 - 5 468 5 100 (463) AP sugar sales Sales of cooking oil Sales of subsidies flour Sales supply chain Lestari Vitamin Enrich Flour Beras lestari Sardine lestari 425gm Lestari mineral water I keep on wheels Anugerah distribution centre Corporate sales Revenue Other Income Total Income (99) - - - 11 360 11 100 (349) (97) 1,009 450 1,459 75 652 1,151 1,803 2.834 1,344 4,178 75 (357) 701 344 100 75 100 (35) (2,182) (77) 100 (193) | (14) 24 (2,375) (57) 8,928 2,688 11,616 Page 1 of 10 Page 1 of 10 1808 words English (United States) Focus 91% jj 4) ENG 11:59 AM 24/8/2020 Table 6.1.1(b) Other Income Particulars 2019 RM000 June Variance Variance 2020 Budget RM'000 RM000 RM'000 % RM'000 % B (B) vs (A) (B) vs (C 2020 Approved Budget RM000 Remarks FD Placement 49 71 210 22 100 (139) (66) 420 June 20 vs Budget Decreased by RM139k or 66% due to the decreased of current interest rate which is 3.3% as compare to the approved interest rate which is 3.5% Fund utilisation is based on operational expenses. 401 1,080 1,134 679 100 (54) 2,268 Fund utilisation Total Other Income | Total Income 450 1.151 701 1,344 4,178 100 (193) (14) 24 (2,375) (57) 2,688 11,616 1,459 1,803 344 Table 6.1.2 Operating Expenses June 2020 Approved Budget 2019 2020 Particulars RM 000 RM000 Variance Budget RM'000 RM 000 % RM'000 % c (B) vs (A) (B) vs (C) 2,428 (65) (12) 1,805 74 RM 000 A B Direct cost 558 623 8,503 231 177 299 54 122 41 776 23 (100) - 39 (23) 16 41 77 Staff cost Depreciation Other Operating Exp Total Operating Expenses 23 123 170 557 47 28 434 78 1.415 959 946 3,323 13 1 2,377 72 10,771 Table 6.2(1) Statement of Financial Position As At June 2020 June 19 June 20 Particular RM000 RM000 RM3000 200,970 (26,976) Non-Current Asset Property, plant & equipment Accumulated depreciation Net property, plant & equipment Deferred tax Total Non-Current Asset Current Assets Trade receivables 426,203 173,994 236,574 410,568 426,203 Other receivables 176,728 66,358 125,105 8.736 Tax Recoverable 8,415,170 4,043,438 Amount due from PNS 4,538,003 Short term Investment 3,910,674 844.531 Fixed deposit and placements 235.068 100,757 Cash and bank balances 12,569,648 9.894.920 Total Current Asset Total Assets 12,995,851 10,305,488 557,641 36,000 5,112 8,455,973 9,054,726 7,047 81,948 5,330,316 5,419,311 Current Liabilities Amount due to holdings (PNS) Trade payables Accrual Grant-project i-Keep Total liabilities Net Total Assets Financed by: Share capital Retained profits/(losses) Profit (Loss) for the period Shareholder's fund 3.941,125 4.886.177 7,250,000 (3,801,713) 492,838 3,941,125 7,250,000 (3,087,309) 723,486 4.886,177 AutoSave Off H20 Appendix 6 VASB v2 Search HASLINDA AHMAD SHAFIEE HA File Home Insert Design Layout References Mailings Review View Help Table Design Layout Share Comments Eva EE 7 AL 1 Times New Rom - 10 A A A A BI U ab X, X? ADA AaBbCcDc AaBbccdc AaBbc AaBbcc Aab 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace Select Paste Dictate Sensitivity Editor Clipboard Font Voice Paragraph Styles Editing 1:::1:1:21:3 X 4.1.5. 17::9. 10. 1.11. 1. 12. 1. 13. 14. 15. 1. 16. 1. 17. 18. 19. 20. Sensitivity Editor 6.3 VASB's Key Financial Ratios Table 6.3 VASB's Key Financial Ratios June 19 June 20 Ratios Profitability Ratio Gross Profit Margin Net Profit Margin Turnover Growth 30.91% 34.27% 1.61% 47.53% 99% 23.58% 11.83% 17.51% RM292K RM361k 42.33% 36.92% :20. 9., 18., 1. 1... HI 3:1 12. .11. 10 19,8:1.7.1.6. Retum of Assets Retum of Employee Per Employee) Retum on Capital Employed (ROCE) Eamings Per Share (RM) Solvency Ratio Debt to Equity Ratio Debt to Asset Ratio Liquidity Ratio (Times) 6.79 sen 9.97 sen 1.27 0.70 0.75 0.53 Current Ratio 1.38 1.83 Quick Ratio Efficiency Ratio Inventory Turnover Ratio Receivable Turnover Ratio Payable Tumover Ratio Page 10 of 10 1808 words LX English (United States) C Focus + 91% O FI Pi e w la 4 ENG 11:56 AM 24/8/2020 AutoSave Off Appendix 6 VASB v2 - Search HASLINDA AHMAD SHAFIEE HA File Home Insert Design Layout References Mailings Review View Help Table Design Layout Share Comments = E ALT Times New Rom - 10 A A A A BI U ab X, X? ADA AaBbCcDc AaBbCcDc AaBbC AaBbccl Aab 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace Select Paste E Dictate Editor Sensitivity Clipboard Font Voice Sensitivity Editor Paragraph Styles Editing 1::1:1:1:2:1:3 4.1.5. 1:7: 11:9. 10. 1.11. | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 L June Variance Particulars 2020 Approved Budget RM000 2019 2020 Budget RM1000 RM1000 RM1000 (A) (B) (C) 403 80 1.359 606 481 647 RM1000 % (B) vs (C) RM1000 % (B) vs (A) (403) (100) 80 100 (125) (21) (>100 (166) (100) (26) 2,719 1,293 150 809 767 936 554 720 980 - 5 468 5 100 (463) AP sugar sales Sales of cooking oil Sales of subsidies flour Sales supply chain Lestari Vitamin Enrich Flour Beras lestari Sardine lestari 425gm Lestari mineral water I keep on wheels Anugerah distribution centre Corporate sales Revenue Other Income Total Income (99) - - - 11 360 11 100 (349) (97) 1,009 450 1,459 75 652 1,151 1,803 2.834 1,344 4,178 75 (357) 701 344 100 75 100 (35) (2,182) (77) 100 (193) | (14) 24 (2,375) (57) 8,928 2,688 11,616 Page 1 of 10 Page 1 of 10 1808 words English (United States) Focus 91% jj 4) ENG 11:59 AM 24/8/2020 Table 6.1.1(b) Other Income Particulars 2019 RM000 June Variance Variance 2020 Budget RM'000 RM000 RM'000 % RM'000 % B (B) vs (A) (B) vs (C 2020 Approved Budget RM000 Remarks FD Placement 49 71 210 22 100 (139) (66) 420 June 20 vs Budget Decreased by RM139k or 66% due to the decreased of current interest rate which is 3.3% as compare to the approved interest rate which is 3.5% Fund utilisation is based on operational expenses. 401 1,080 1,134 679 100 (54) 2,268 Fund utilisation Total Other Income | Total Income 450 1.151 701 1,344 4,178 100 (193) (14) 24 (2,375) (57) 2,688 11,616 1,459 1,803 344 Table 6.1.2 Operating Expenses June 2020 Approved Budget 2019 2020 Particulars RM 000 RM000 Variance Budget RM'000 RM 000 % RM'000 % c (B) vs (A) (B) vs (C) 2,428 (65) (12) 1,805 74 RM 000 A B Direct cost 558 623 8,503 231 177 299 54 122 41 776 23 (100) - 39 (23) 16 41 77 Staff cost Depreciation Other Operating Exp Total Operating Expenses 23 123 170 557 47 28 434 78 1.415 959 946 3,323 13 1 2,377 72 10,771 Table 6.2(1) Statement of Financial Position As At June 2020 June 19 June 20 Particular RM000 RM000 RM3000 200,970 (26,976) Non-Current Asset Property, plant & equipment Accumulated depreciation Net property, plant & equipment Deferred tax Total Non-Current Asset Current Assets Trade receivables 426,203 173,994 236,574 410,568 426,203 Other receivables 176,728 66,358 125,105 8.736 Tax Recoverable 8,415,170 4,043,438 Amount due from PNS 4,538,003 Short term Investment 3,910,674 844.531 Fixed deposit and placements 235.068 100,757 Cash and bank balances 12,569,648 9.894.920 Total Current Asset Total Assets 12,995,851 10,305,488 557,641 36,000 5,112 8,455,973 9,054,726 7,047 81,948 5,330,316 5,419,311 Current Liabilities Amount due to holdings (PNS) Trade payables Accrual Grant-project i-Keep Total liabilities Net Total Assets Financed by: Share capital Retained profits/(losses) Profit (Loss) for the period Shareholder's fund 3.941,125 4.886.177 7,250,000 (3,801,713) 492,838 3,941,125 7,250,000 (3,087,309) 723,486 4.886,177
