Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The income statement and balance sheet of Sheng Siong Group Ltd (Sheng Siong), one of Singapores largest retailers with 67 stores located across the island.
The income statement and balance sheet of Sheng Siong Group Ltd (Sheng Siong), one of Singapores largest retailers with 67 stores located across the island. over the last three years are provided below.
Using the info above, calculate Sheng Siongs cash flow from assets for 2021 and 2022 using the template below. Show your workings clearly
\begin{tabular}{|l|r|r|r|} \hline Income Statement & & \\ \hline \\ \hline (S\$00) \end{tabular} \begin{tabular}{|c|c|c|} \hline & 2021 & 2022 \\ \hline \multicolumn{3}{|l|}{ Operating Cash Flow } \\ \hline \multicolumn{3}{|l|}{ Earnings before Interest and Taxes } \\ \hline \multicolumn{3}{|l|}{ Add Depreciation } \\ \hline \multicolumn{3}{|l|}{ Less Taxes } \\ \hline \multicolumn{3}{|l|}{ Operating Cash Flow (OCF) } \\ \hline \multicolumn{3}{|l|}{ Capital Spending } \\ \hline \multicolumn{3}{|l|}{ Ending Net Fixed Assets } \\ \hline \multicolumn{3}{|l|}{ Less Beginning Net Fixed Assets } \\ \hline \multicolumn{3}{|l|}{ Add Depreciation } \\ \hline \multicolumn{3}{|l|}{ Net Capital Spending (NCS) } \\ \hline \multicolumn{3}{|l|}{ Net Working Capital } \\ \hline \multicolumn{3}{|l|}{ Ending Net Working Capital } \\ \hline \multicolumn{3}{|l|}{ Less Beginning Net Working Capital } \\ \hline Change in NWC & & \\ \hline CFFA = OCF - NCS - Change in NWC & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Balance Sheet & & & \\ \hline(S$000) & & & \\ \hlines of 31Dec & 2020 & 2021 & 2022 \\ \hline Current ssets & & & \\ \hline Cash and Cash liquivalents & 253,901 & 246,642 & 275,499 \\ \hline Trade and Other Receivables & 19,949 & 11,604 & 19,540 \\ \hline Inventories & 77,911 & 98,383 & 101,182 \\ \hline Total Current Asscts & 351,761 & 356,629 & 396,221 \\ \hline Non Current ssets & & & \\ \hline Right of Use Assets & 48,711 & 79,505 & 97,286 \\ \hline Property, Plant and Equipment & 291,588 & 302,883 & 291,608 \\ \hline Total ssets & 692,060 & 739,017 & 785,115 \\ \hline Current I iabilities & & & \\ \hline Trade and Other Payables & 208,089 & 212,391 & 197,455 \\ \hline Term Loan & 15,000 & 5,000 & - \\ \hline I case I iabilities & 22,374 & 27,749 & 33,052 \\ \hline Current lax P'ayable & 29,754 & 25,381 & 35,297 \\ \hline Total Current I iabilities & 275,217 & 270,521 & 265,804 \\ \hline Non Current I iabilitics & & & \\ \hline Term I oan & 15,000 & - & - \\ \hline Lease Liabilitics & 23,129 & 48,945 & 62,598 \\ \hline Deferral Tax I iabilities & 3,615 & 3,229 & 1,540 \\ \hline Sharcholders" l'xuity & & & \\ \hline Common Stock - Par Valuc & 235,373 & 235,373 & 235,373 \\ \hline Accumulated Profit & 205,248 & 246,365 & 285,541 \\ \hline Statutory Reserves & & & 156 \\ \hline Forcign Currency Translation Rescrve & 3 & (98) & (5%) \\ \hline Merger Rescives & (68,234) & (68,234) & (68,234) \\ \hline Total Sharcholders Iqquity & 372,390 & 413,406 & 452,246 \\ \hline Minority Intcrest & 2,709) & 2,916 & 2,927 \\ \hline Total I sabiltes \& Sharcholders l'quity & 692,060 & 739,017 & 785,115 \\ \hline \end{tabular}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