Question

In: Finance

The following information has been extracted from the financial statements of a company. Use it to...

The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar.

Earnings before interests and taxes: EBIT in 2020 =

600

Tax rate: T =  

25%

Accumulated depreciation in balance sheet of 2019 =

50

Accumulated depreciation in balance sheet of 2020 =

60

Net Fixed Assets in 2019 =

1,200

Net Fixed Assets in 2020 =

1,500

Other Long-Term assets in 2019 =

0

Other Long-Term assets in 2020 =

0

Net operating working capital (NOWC) in 2019 =

30

Current assets in balance sheet of 2020 =

30

Current liabilities in balance sheet of 2020

20

1. What is the Net Cash Flow (NFC) for 2020?

2. What is the Investment in Gross Fixed Assets for 2020?

3. What is the investment in net operating working capital (Investment NOWC) for 2020?

4. What is the Free Cash Flow (FCF) for 2020?

Solutions

Expert Solution

1) Net Cash Flow = Cash Flow from Operations + Cash flow from Investing + Cash Flow from Financing

Particulars Amount
EBIT 600.00
(-) Tax @25% -150.00
Net Income 450.00
(+) Depreciation 10.00
(-) Working capital changes 20.00
Cash Flow From Operations 480.00

Depreciation Expense = Accumulated depreciation (2020) - Accumulated Depreciation (2019)
= 60 - 50 = 10

Cash Flow From Investing = Net Fixed Assets (2019) - Net Fixed Assets (2020) - Depreciation expense (2020)
= 1,200 - 1,500 - 10
= -310

Cash Flow From Financing = 0

Net Cash Flow = 480 + (-310) + 0
Net Cash Flow = 170

2) Investment in Gross Fixed Assets = Gross Fixed Assets in 2019 - Gross Fixed Assets in 2020
Gross Fixed Assets = Net Fixed Assets + Accumulated Depreciation

Gross Fixed Assets (2020) = 1,500 + 60
= 1,560
Gross Fixed Assets (2019) = 1,200 + 50
= 1,250
Investment in Gross Fixed Asset = 1,250 - 1,560 = -310

3) Net Operating Working Capital (NOWC) = Current Assets - Current Liabilities

Net Operating Working Capital (2020) = 30 - 20 = 10
Net Operating Working Capital (2019) = 30

Investment in NOWC in 2020 = NOWC (2019) - NOWC (2020)
= 30 - 10
Investment in NOWC in 2020 = 20

4) Free Cash Flow = Cash Flow From operations - Capital Expenditure
Capital Expenditure = Investment in Gross Fixed Asset = 310

Free Cash Flow (2020) = 480 - 310 = 170


Related Solutions

The following information has been extracted from the financial statements of a company. Use it to...
The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar. Earnings before interests and taxes: EBIT in 2020 = 400 Tax rate: T =  ...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and notes of Brown Ltd. 2014 2013 Revenue $ 870 000 $ 862 500 Interest expense 34 500 39 750 Income tax expense 66 900 39 750 Profit 78 750 84 150 Dividends 42 000 42 000 Total assets 810 000 832 500 Total debt 429 750 458 250 Share capital 258 000 243 000 Retained earnings 122 250 131 250 Required: Using the above...
The following information has been extracted from the financial statements of YDI Limited: Extract of Statement...
The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R R Non-current assets...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited:...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R...
QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract...
QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December:                                       2019          2018                                         $                   $ Sales                       2 000 000 1 600 000 Cost of sales              940 000      800 000 Operating profit       600 000      520 000 Profit before tax      520 000     450 000 Profit after tax           364 000    315 000 Extract of Statement of Financial Position as at 31 December: Assets                                   2019              2018...
(i) The following information is extracted from the financial statements of XERO
(i) The following information is extracted from the financial statements of XEROLimited:Cash $677,423 Accounts Payable $1,721,669Accounts Receivable $1,845,113 Notes Payable $2,113,345Inventories $1,312,478Total Current Assets $3,835,014 Total Current Liabilities $3,835,014Net Sales $9,912,332Cost $5,947,399 (a) Briefly explain what you understand by the term ‘operating cycle’. (1 mark)Click or tap here to enter text. (b) What is the operating cycle for XERO Limited? Click or tap here to enter text. (c) What can you say about XERO Limited’s accounts receivable and inventorymanagement if...
The following information was extracted from the 2020 financial statements of Arigato LLC:
The following information was extracted from the 2020 financial statements of Arigato LLC:Income from continuing operations before income tax           $755,123Selling and administrative expenses                                            480,357Income from continuing operations                                            495,951Gross profit                                                                                           1,357,530The amount reported for Other Revenue/Gains and Other Expenses/Losses is: $  Blank 1. Fill in the blank, read surrounding text.Use “-“ sign for negative amount, as needed. Use commas, as needed.
The following financial information was extracted from MCL’s current draft financial statements and those of the...
The following financial information was extracted from MCL’s current draft financial statements and those of the previous year:​ 2017 ($M) 2016 ($M) 2015 ($M) Revenue 220 260 240 Total assets 260 280 250 Net Profit before tax 19 (3) 17 The car parts and accessories industry has been very competitive and consumer demand appears to be slowing in anticipation of change with electric and driverless cars coming into the market. The company has recently restructured its operations to outsource its...
The following information has been extracted from the financial records of Platinum Ltd and its subsidiary...
The following information has been extracted from the financial records of Platinum Ltd and its subsidiary Serum Ltd at 30 June 2017. Income statement Platinum Ltd ($) Serum Ltd ($) Sales revenue 198,000 112,000 Cost of goods sold -149,000 -102,000 Gross profit 49,000 10,000 Dividend revenue 8,000 25,000 Depreciation expense -12,000 -11,000 Other expenses -8,000 -4,000 Profit before tax 37,000 20,000 Tax expense -11,100 -6,000 Profit for the year 25,900 14,000 Retained earnings – 30 June 2016 110,000 46,000 Interim...
accounting question The following information has been extracted from the financial records of Associate Ltd     at...
accounting question The following information has been extracted from the financial records of Associate Ltd     at 1 April 2004 and at 31 March 2017. Associate Ltd 1 April 2004 Associate Ltd 31 March 2017 $ $ Sales 1 800 000 Less cost of goods sold 1 200 000 Gross profit 600 000 Less expenses 328 400 Profit before tax 271 600 Plus rental income 26 000 Less income tax expense 71 880 Profit after tax 225 720 Retained earnings- opening...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT