Part 1 (The accounting version): below you can find the income statement and the balance sheet of company for the last five years. Based on them, build the cash flow statement (accounting version) for each of the years included in the period 2020-2024, and write conclusions based on what you see in it. Note: the excel file with your calculations and comments should be uploaded to the campus before the midnight of the 30th of July (Florida time). (100 points) Profit and Loss statement Historical 2020 2021 2022 2023 2024 Revenues 3,007,602 2,901,431 2,858,944 3,030,361 3,333,513 COGS 1,580,736 1,439,432 1,371,433 1,376,514 1,451,064 Gross Margin 1,426,867 1,461,999 1,487,511 1,653,847 1,882,449 General expenses 1,260,359 1,279,020 ,392.595 1,474,730 630,616 Operating margin (EBITDA) 166,50 182,979 94,917 179,117 251,83 Depreciation 40.989 43,342 21,952 32,253 28,244 EBIT 125,518 139,636 72,965 146,864 223,589 Financial expenses 14,536 11,670 10,519 9,70 13,691 Interests earned 9,770 7,106 12,373 6,014 8,696 EBT 120,752 135,072 74,819 143,170 218,594 Taxes 40.234 47.047 22,850 46.398 88.498 Net Income 80,518 88,025 51,969 96,772 130,096 Balance Sheet Historical Assets 2020 2021 2022 2023 2024 Cash and Banks 14,006 87,580 130,764 171,729 237,447 Accounts receivables 945,347 937,046 1,078,480 1,189,924 1,283,573 Inventory 192,863 60,571 137,081 145,784 198,475 Current Assets 1,152,216 ,085,197 346,325 1,507,437 1,719,495 Gross fixed assets 664,495 688,572 744,548 781,068 870,768 Accumulated depreciation -123,245 -166,587 -188,539 -220,792 -249,036 Net Fixed Assets 541.250 521,985 556,009 560,276 621,732 Total Assets 1,693,466 1,607,182 1,902,334 2,067,713 2,341,227 Balance Sheet Historical Liabilities 2020 2021 2022 2023 2024 Accounts payables 951,694 767,453 1,006.526 1,055,242 1,164,021 Current Liabilities 951.694 767,453 ,006,526 1,055,242 1,164,021 Long term debt 126,213 136,145 140,254 160,145 194,784 Long term Liabilities 126,213 136, 145 140.25 160,145 194,784 Capital 240,405 240,405 240,405 240,405 240,405 Retained earnings 294,637 375,155 463,180 515, 149 611,921 Profit and Loss 80,518 88,025 51,969 96.772 130,096 Total Equity 615,560 703,585 755,553 852,326 982,422 Total Liabilities 1,693,466 1,607,182 1,902,334 2,067,713 2,341,227 The Accounting Cash-flow statement 2021 2022 2023 2024 INITIAL CASH 14.006 37,580 130,764 171,729 CF OF OPERATING ACTIVITES 175,015 95.050 57,594 120,779 NET INCOME 88,025 51,969 96,772 130,096 YEARLY DEPRECIATION 43,342 21,952 32 253 28,244 CHANGE IN INVENTORY - (21, +) 132,292 76,510 8,703 52,691 CHANGE IN ACCOUNTS RECEIVABLE - (21, +) 8,301 141,434 111,444 93,649 CHANGE IN ACCOUNTS PAYABLE + (21, -) ? 184,241 239,073 48,716 108,779 CF OF INVESTING ACTIVITIES -24,077 -55,976 -36,520 89,700 INTEREST IN FIXED ASSETS (CAPEX) 24,077 55,976 36,520 89,700 CF OF FINANCIAL ACCOUNTING 9,932 4,109 19,891 34,639 CHANGE IN DEBT (PRINCIPLE) 9,932 4,109 19.891 34,639 DIVIDENDS PAID 0 CASH GENERATED 73,574 43,184 40,965 65,718 ENDING CASH = INITIAL Cash + Cash Generated 87,580 130,764 171,728 237,447
