Based on the information, work out the P&L,balance sheet and cash flow statement for 2021.Please write the formulas that you used, thank you :)

JX C D E F Profit and Loss (1/1 - 31/12) G H K L M N Balance Sheet (31/12) 2020 WN 2021 2020 2021 2020 2021 4 Revenue Fixed assets Equity $3 343 851,00 5 Cost of Goods Sold Machines 8 560,00 Shareholder Capital S 6 740,58 $ 367 823,61 Land 6 Net Gain Sales Fixed Assets 40 967,00 Retained Earnings 5 706,10 $2 600 571,13 Buildings Salary 36 349,00 Capital Raise S $ 100 315,53 Equipment 8 Depreciation 11 719,00 Total Equity $2 607 311,71 1 472,92 Total Fixed Assets $ 97 595,00 9 Administrative, Selling, and General 6 343,00 10 Interest S Future liabilities 10 031,55 Current assets 11 Profit Before Tax Loan $ 167 192,55 $2 863 570,49 Bank 12 Tax $2 340 695,70 Total Fixed Liabilities $ 167 192,55 $ 629 985,51 Inventory $ 177 361,52 13 Profit After Tax $2 233 584,98 14 Accounts Receivable $ 192 385,95 Current liabilities Other Receivables 15 $ 100 315,53 Seasonal Credit 16 Total Current Assets $2 810 758,70 Accounts Payable 22 170,19 17 Dividend $ 111 679,25 18 Total Current Liabilities $ 133 849,44 19 Total Assets $2 908 353,70 20 Total Equity and Liabilities $2 908 353,70 21 Changes for 2021 22 23 Revenue 8,00% 24 Cost of Goods Sold (% change from last year) -7,00% 25 Salary 26,00% 26 Administrative, Selling, and General 8,00% 27 Interest of Loan 12,00% 28 Tax cost payable in same year 22,00% 29 Inventory (number of holding days) 66 30 Accounts Receivable (days) 46 31 Other Receivables (increase) 12,00% 32 Accounts Payable (days) 25 33 Dividend (paid next year) (% of after tax profit) 7,00% 34 Machine Sales (Market value), total paid in 2021 7 618,40 35 Machines book value of sold item 1 968,80 36 Machines New Investment, Paid in full 2021 12 668,80 37 Land New Investment, Paid in full 2021 8 193,40 38 Buildings New Investment, Paid in full 2021 25 807,79 39 Equipment New Investment, Paid in full 2021 15 469,08 40 Machine Depreciation 428,00 41 Land Depreciation 42 Buildings Depreciation 1 090,47 43 Equipment Depreciation 44 Downpayment of existing loan 10,00% 45 New Loan (Market Value) S 46 Sheet1 +