Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare cash flow statement for 2019, 2020 and 2021 linking each item to income statement or balance sheet. 3 Profitability Statement 3 Year Ended 31st
Prepare cash flow statement for 2019, 2020 and 2021 linking each item to income statement or balance sheet.
3 Profitability Statement 3 Year Ended 31st March - Sales: 5 Sale of Products 7 8 Sale of Goods - IMFL, ENA, By-products Royalty Export entitlements Scrap and other sales FY 2018 Audited 7,410.9 7,387.3 1.5 7.1 15.0 4,816.6 2,594.3 21.0 FY 2019 Audited 8,934.7 8,913.2 0.8 9.2 11.4 5,867.5 3,067.2 12.8 FY 2020 Audited 8,119.1 8,102.4 10. 5.1 10.6 5,123.1 2,995.9 17.5 FY 2021 Audited 6,378.8 6,358.7 0.6 10.4 9.1 4,030.4 2,348.4 20.0 10 11 Less: Excise duty 12 Net Sales 13 Other Income 14 Increase / (Decrease in Stocks) 15 2,615.4 3,080.0 3,013,4 2,368.4 22 16 Total - Sales 17 Expenses: 18 Cost of materials consumed 19 Power Water and Fuel 20 Bottling Charges 21 Other Direct Expenses Purchase of stock-in trade 23 Changes in inventories of finished goods and stock-in trade 24 Finished Goods 25 Work-in-progress Goods 26 Stock-in trade 27 Increase in excise duty on FG Gross Profit 29 Gross Profit % 30 1,588.8 36.7 73.6 14.6 5.5 (8.4) (30.6) (2.5) (0.0) 24.7 883.5 34.1% 1,835.1 36.2 65.2 34.4 5.1 (31.1) (55.8) (15.0) 0.0 39.7 1,122.3 36.6% 1,845.1 37.6. 59.0 28.9 5.2 17.6 3.7 10.0 (0.1) 3.9 1,002.6 33.5% 1,390.4 27.5 40.9 23.0 3.7 26.9 31.2 3.3 ai 28 (7.6) 835.8 35.6% FY 2018 Audited FY 2019 Audited FY 2020 Audited FY 2021 Audited 166.0 482.7 188.2 637.7 177.7 590.9 1715 468.8 2,359.6 2,770.8 2,761.9 2,152.9 255.8 9.9% 309.2 10.1% 251.6 8.4% 215.5 9.2% 10.02 3.5 15.28 42 3 Profitability Statement 4 Year Ended 31st March 5 Sales: 30 31 Employee benefit expense 32 Other expenses 33 34 Total - Expenses 35 36 EBITDA 37 EBITDA % 38 39 Non Operating / Exceptional Profit/(Loss) 40 Dividend/ Interest Income 41 Profit on sale of assets & iny 42 Exceptional items - liabilities/provisions no longer required written back 43 Foreign exchange gain/loss 44 Other non operating income (FV measurement changes) 45 Interest Charges 46 47 PBDT 48 Depreciation & Amortization 49 Exceptional items - share of loss of equity accounted investees 50 Profit before tax 51 Current tax 52 Net deferred tax expense 53 Tax adjustment in respect of earlier years 54 Profit after tax 55 PAT% 58 59 Net Profit 60 17.75 5.7 0.4 8.5 3.1 0.0 lowo w win 17.30 4.0 0.1 0.0 0.3 6.3 6.9 8.5 0.0 186.3 om 146.1 42 180.2 NN 4.7 Mi 1415 92 85.7 56 68.9 6 (13) 5.6 15.4 (8.0) (6.82) 0% 113 81.2 17.7 14 8.6 7.6 0.5 (2.69) 096 57 58.2 Exc (2) 4.6 6.7 (1.2) (11.59) Audi 096 (120) (0.4) (0.37) 0% (7) (3) (0) (12) FY 2018 Audited 85.7 FY 2020 Audited 68.9 FY 2021 Audited 58.2 E Year Ended 31st March Sales: B Depreciation & Amortization 9 Exceptional items - share of loss of equity accounted investees 0 Profit before tax 1 Current tax 2 Net deferred tax expense 3 Tax adjustment in respect of earlier years Profit after tax 5 PAT% 6 FY 20119 Audited 81.2 17.7 14 8.6 76 0.5 (2.69) 0% (13) 5.6 15.4 (8.0) (6.82) 0% (12.0) (0.4) (0.37) 0% (2) 4.6 6.7 (1.2) (11.59) Au 096 B (3) (0) (12) Net Profit ) 1 Surplus brought forward from previous years Gain on remeasurement of DB plans 3 Income tax relating to these items PAT after Prior Period Adjustment 5 5 Gross Cash Accruals 7. Net cash accruals 3 19 (0.7) (5.61) 0.3 (0.1) (2.48) (0.0) (0.36) (0.5) 0.2 (11.93) 79 96 68 61 86 53 29 1 100 20 (91.30) (18.60) (28.02) FY 2018 FY 2019 FY 2020 FY 2021 745.1 823.5 (209.3) 614.2 859.9 (277.7) 582.2 (322.3) 422.8 43.4 805.8 (372.2) 433.6 12.6 13.1 31.1 627.3 613.3 466.1 446.2 136.2 3.7 3.7 134.7 3.7 59.6 3.7 59.1 499 61.4 0.0 3 Balance Sheet 4 Year ended March 5 Fixed assets 7 Gross fixed assets Less : Depreciation 3 Net fixed assets 10 CWIP including Capital Advances 11 Fixed assets 2. 13 Right of Use assets 14 Goodwill 15 Other intangible assets 16 Intangible assets under development 17 Investment in subsidiaries, associates and JVs 18 Financial assets - Investments and loans 19 Financial assets - Other financial assets 20 Deferred Tax Asset (net) 21 Income tax asset (net) 22 Other Non Current assets 23 Non-current Assets 24 Current assets: 25 Inventories 26 Investments 27 Trade Receivables 28 Cash, cash equivalents and bank balance 29 Loans and other financial assets 30 Other current assets 31 Current Assets 2.2 7.5 19.7 2.3 2.4 Vw 23.6 20.7 44.2 31.2 30.1 23.0 21.6 15.3 7.5 22.5 40.6 16.0 9.1 7.4 10.5 789.4 8.6 125.2 125.2 120.5 857.7 873.5 884,9 304.9 416.8 369.6 345.8 930.1 934.7 866.9 1,141.4 43.0 25.2 102.9 69.8. 57.8 44.4 38.8 25.4 12:27 113.1 1.431.1 84.2 112.0 176813 DR FY 2018 FY 2019 FY 2020 FY 2021 743.7 940.4. 708.2 658.2 6.3 # Balance Sheet Year ended March 3 Current liabilities: 4 Fin liabilities - Borrowings 5 Fin liabilities - Lease Liabilities 5 Fin liabilities - Trade payables - Other financial liabilities Share application money Other Current liabilities Provisions Current tax liabilities (net) Current Liabilities 2.7 330.0 428.3 4329 372.8 286.2 305.9 313.9 324.6 750 110.4 183.4 195.8 214.9 11.9 14.2 14.5 14.7 1.0 3.6 0.8 1,483.2 1,950.8 1,672.4 2.2 1,590.1 Surplus of CA over CL (52.1) (182.4) (142.2) (170.2) Net tangible assets Net Working Capital 737.3 675.2 731.3 (52.1) (182.4) (142.2) 714.7 (170.2) 431.8 359.9 307.3 292.8 12.6 17.1 Lea 11.0 13.0 13.0 Long term liabilities: Financial liabilities - borrowings Financial liabilities - lease liabilties Other financial liabilities Provisions Total Long Term Liabilities Non-controlling interest Net worth Networth represented by: Fuity share 11.0 11.4 11.6 12.6 Pro 453.8 384.2 344.4 322.4 283.4 291.0 386.9 392.2 FY 2018 FY 2019 FY 2020 FY 2021 431.8 359.9 307.3 292.8 12.6 17.1 11.0 13.0 13.0 Balance Sheet Year ended March 3 Long term liabilities: Financial liabilities - borrowings 1 Financial liabilities - lease liabilties 2 Other financial liabilities 3 Provisions 4 Total Long Term Liabilities 5 Non-controlling interest 5 Net worth 7 Networth represented by: B Equity Share Capital 9 Equity component of NCCPS 0 Other equity 1 Total Equity 11.0 11.6 12.6 F 11.4 384.2 453.8 344.4 322.4 283.4 291.0 386.9 392.2 47.1 47.1 47.1 6.8 236.3 243.9 333.0 6.8C 338.3 ir 392.2 283.4 291.0 386.9 224.4 241.0 327.3 330.8 3 Tangible Net worth 4 5 Diff 6 3 Profitability Statement 3 Year Ended 31st March - Sales: 5 Sale of Products 7 8 Sale of Goods - IMFL, ENA, By-products Royalty Export entitlements Scrap and other sales FY 2018 Audited 7,410.9 7,387.3 1.5 7.1 15.0 4,816.6 2,594.3 21.0 FY 2019 Audited 8,934.7 8,913.2 0.8 9.2 11.4 5,867.5 3,067.2 12.8 FY 2020 Audited 8,119.1 8,102.4 10. 5.1 10.6 5,123.1 2,995.9 17.5 FY 2021 Audited 6,378.8 6,358.7 0.6 10.4 9.1 4,030.4 2,348.4 20.0 10 11 Less: Excise duty 12 Net Sales 13 Other Income 14 Increase / (Decrease in Stocks) 15 2,615.4 3,080.0 3,013,4 2,368.4 22 16 Total - Sales 17 Expenses: 18 Cost of materials consumed 19 Power Water and Fuel 20 Bottling Charges 21 Other Direct Expenses Purchase of stock-in trade 23 Changes in inventories of finished goods and stock-in trade 24 Finished Goods 25 Work-in-progress Goods 26 Stock-in trade 27 Increase in excise duty on FG Gross Profit 29 Gross Profit % 30 1,588.8 36.7 73.6 14.6 5.5 (8.4) (30.6) (2.5) (0.0) 24.7 883.5 34.1% 1,835.1 36.2 65.2 34.4 5.1 (31.1) (55.8) (15.0) 0.0 39.7 1,122.3 36.6% 1,845.1 37.6. 59.0 28.9 5.2 17.6 3.7 10.0 (0.1) 3.9 1,002.6 33.5% 1,390.4 27.5 40.9 23.0 3.7 26.9 31.2 3.3 ai 28 (7.6) 835.8 35.6% FY 2018 Audited FY 2019 Audited FY 2020 Audited FY 2021 Audited 166.0 482.7 188.2 637.7 177.7 590.9 1715 468.8 2,359.6 2,770.8 2,761.9 2,152.9 255.8 9.9% 309.2 10.1% 251.6 8.4% 215.5 9.2% 10.02 3.5 15.28 42 3 Profitability Statement 4 Year Ended 31st March 5 Sales: 30 31 Employee benefit expense 32 Other expenses 33 34 Total - Expenses 35 36 EBITDA 37 EBITDA % 38 39 Non Operating / Exceptional Profit/(Loss) 40 Dividend/ Interest Income 41 Profit on sale of assets & iny 42 Exceptional items - liabilities/provisions no longer required written back 43 Foreign exchange gain/loss 44 Other non operating income (FV measurement changes) 45 Interest Charges 46 47 PBDT 48 Depreciation & Amortization 49 Exceptional items - share of loss of equity accounted investees 50 Profit before tax 51 Current tax 52 Net deferred tax expense 53 Tax adjustment in respect of earlier years 54 Profit after tax 55 PAT% 58 59 Net Profit 60 17.75 5.7 0.4 8.5 3.1 0.0 lowo w win 17.30 4.0 0.1 0.0 0.3 6.3 6.9 8.5 0.0 186.3 om 146.1 42 180.2 NN 4.7 Mi 1415 92 85.7 56 68.9 6 (13) 5.6 15.4 (8.0) (6.82) 0% 113 81.2 17.7 14 8.6 7.6 0.5 (2.69) 096 57 58.2 Exc (2) 4.6 6.7 (1.2) (11.59) Audi 096 (120) (0.4) (0.37) 0% (7) (3) (0) (12) FY 2018 Audited 85.7 FY 2020 Audited 68.9 FY 2021 Audited 58.2 E Year Ended 31st March Sales: B Depreciation & Amortization 9 Exceptional items - share of loss of equity accounted investees 0 Profit before tax 1 Current tax 2 Net deferred tax expense 3 Tax adjustment in respect of earlier years Profit after tax 5 PAT% 6 FY 20119 Audited 81.2 17.7 14 8.6 76 0.5 (2.69) 0% (13) 5.6 15.4 (8.0) (6.82) 0% (12.0) (0.4) (0.37) 0% (2) 4.6 6.7 (1.2) (11.59) Au 096 B (3) (0) (12) Net Profit ) 1 Surplus brought forward from previous years Gain on remeasurement of DB plans 3 Income tax relating to these items PAT after Prior Period Adjustment 5 5 Gross Cash Accruals 7. Net cash accruals 3 19 (0.7) (5.61) 0.3 (0.1) (2.48) (0.0) (0.36) (0.5) 0.2 (11.93) 79 96 68 61 86 53 29 1 100 20 (91.30) (18.60) (28.02) FY 2018 FY 2019 FY 2020 FY 2021 745.1 823.5 (209.3) 614.2 859.9 (277.7) 582.2 (322.3) 422.8 43.4 805.8 (372.2) 433.6 12.6 13.1 31.1 627.3 613.3 466.1 446.2 136.2 3.7 3.7 134.7 3.7 59.6 3.7 59.1 499 61.4 0.0 3 Balance Sheet 4 Year ended March 5 Fixed assets 7 Gross fixed assets Less : Depreciation 3 Net fixed assets 10 CWIP including Capital Advances 11 Fixed assets 2. 13 Right of Use assets 14 Goodwill 15 Other intangible assets 16 Intangible assets under development 17 Investment in subsidiaries, associates and JVs 18 Financial assets - Investments and loans 19 Financial assets - Other financial assets 20 Deferred Tax Asset (net) 21 Income tax asset (net) 22 Other Non Current assets 23 Non-current Assets 24 Current assets: 25 Inventories 26 Investments 27 Trade Receivables 28 Cash, cash equivalents and bank balance 29 Loans and other financial assets 30 Other current assets 31 Current Assets 2.2 7.5 19.7 2.3 2.4 Vw 23.6 20.7 44.2 31.2 30.1 23.0 21.6 15.3 7.5 22.5 40.6 16.0 9.1 7.4 10.5 789.4 8.6 125.2 125.2 120.5 857.7 873.5 884,9 304.9 416.8 369.6 345.8 930.1 934.7 866.9 1,141.4 43.0 25.2 102.9 69.8. 57.8 44.4 38.8 25.4 12:27 113.1 1.431.1 84.2 112.0 176813 DR FY 2018 FY 2019 FY 2020 FY 2021 743.7 940.4. 708.2 658.2 6.3 # Balance Sheet Year ended March 3 Current liabilities: 4 Fin liabilities - Borrowings 5 Fin liabilities - Lease Liabilities 5 Fin liabilities - Trade payables - Other financial liabilities Share application money Other Current liabilities Provisions Current tax liabilities (net) Current Liabilities 2.7 330.0 428.3 4329 372.8 286.2 305.9 313.9 324.6 750 110.4 183.4 195.8 214.9 11.9 14.2 14.5 14.7 1.0 3.6 0.8 1,483.2 1,950.8 1,672.4 2.2 1,590.1 Surplus of CA over CL (52.1) (182.4) (142.2) (170.2) Net tangible assets Net Working Capital 737.3 675.2 731.3 (52.1) (182.4) (142.2) 714.7 (170.2) 431.8 359.9 307.3 292.8 12.6 17.1 Lea 11.0 13.0 13.0 Long term liabilities: Financial liabilities - borrowings Financial liabilities - lease liabilties Other financial liabilities Provisions Total Long Term Liabilities Non-controlling interest Net worth Networth represented by: Fuity share 11.0 11.4 11.6 12.6 Pro 453.8 384.2 344.4 322.4 283.4 291.0 386.9 392.2 FY 2018 FY 2019 FY 2020 FY 2021 431.8 359.9 307.3 292.8 12.6 17.1 11.0 13.0 13.0 Balance Sheet Year ended March 3 Long term liabilities: Financial liabilities - borrowings 1 Financial liabilities - lease liabilties 2 Other financial liabilities 3 Provisions 4 Total Long Term Liabilities 5 Non-controlling interest 5 Net worth 7 Networth represented by: B Equity Share Capital 9 Equity component of NCCPS 0 Other equity 1 Total Equity 11.0 11.6 12.6 F 11.4 384.2 453.8 344.4 322.4 283.4 291.0 386.9 392.2 47.1 47.1 47.1 6.8 236.3 243.9 333.0 6.8C 338.3 ir 392.2 283.4 291.0 386.9 224.4 241.0 327.3 330.8 3 Tangible Net worth 4 5 Diff 6
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