Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

Using the info above, calculate Sheng Siongs cash flow from assets for 2021 and 2022 using the template below. Show your workings clearly

image text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Performance Measurement In Finance

Authors: John Knight, Stephen Satchell, Nathalie Farah

1st Edition

ISBN: 0750650265, 978-0750650267

More Books

Students also viewed these Finance questions