please can u do this in 1h
Required:
- Result
- Box
- Balance
- Analysis
INTRODUCTION Trading SA (TSA) is a commercial company dedicated to the import and commercialization of industrial machinery in Spain. The company has been operating for a few years and is consolidated within the sector of the sale/distribution of industrial machinery in Spain Instead of working to order (waiting for the customer to place an order to purchase the product) and reducing the stock level to a minimum (just-in-time), TSA maintains a stock of machinery ready for sale throughout the year in a large industrial warehouse rent in Montcada Barcelona. At the beginning of the year 2021, TSA already has a determined equity structure (Initial Balance Sheet). As of 01/01/2021, the company presents the following opening balance sheet INITIAL SITUATION BALANCE 01/01/2021 non-current set Intangible Fixed Assets (GROSS) Intangible Amortization Intangible Fixed Assets (NET) Tangible Fixed Assets (GROSS) Material Depreciation Property, Plant and Equipment (NET) Current adve Back Realizable Available TOTAL ASSETS EXERCISE TO DO INITIAL SITUATION BALANCE TRANSACTIONS 377,000 Net Asell 45.000 Capital 18.000ations 27,000 Positive results from previous years 500,000 Negative results from previous years 150,000 Pro for the year 350.000 1018,000 Non-aret lubilles 850.000 UP bank loan 120,000 Other LP creditors 48.000 Current iss CF bark toan providers Other CP creditors 1.395.000 TOTAL LIABILITIES NETA A-Using the templates provided and from the beginning balance and the transactions that occurred in the year 21, prepare the income statement, cash flow and the closing balance sheet for the year 2021, B-From the financial statements prepared in the previous point and using the templates provided, perform an economic and financial analysis of the company. 11 The company collects 75,000 from a client. 2. The company pays 30,000 to a supplier. 3. The company buys industrial machinery for sale (inventories) worth 300,000. The company pay 20% in cash and the rest is pending payment (suppliers). 4. The 01/01/2021 290.000 180.000 300.000 60.000 250.000 8. The company repays 50,000 of the short-term loan granted and pays 15.000 in interest. The company pays corporate tax (25% of BAI). 750.000 700.000 50.000 355.000 250.000 90.000 15.000 1.395.000 company sells the stocks purchased in the previous point for a value of 600,000. The company charges 50% in cash and the rest is pending collection (customers). 5. The company acquires, with cash payment, a property, plant and equipment worth 40,000. 6. Fixed structural expenses for the year (personnel, rent, external services, etc.) amount to a total of 185,000 and paid in full. 7. The amortization expense for intangible assets amounts to 10,000. The depreciation expense of the tangible fixed assets amounts to 50,000 DATE RESULT BOX PROFIT AND LOSS ACCOUNT CONCEPT Revenue from sales or provision of services Supplies GROSS MARGIN Other operating income Other operating expenses (structure expenses) OPERATING RESULT (EBITDA) Depreciation and amortization BENEFIT BEFORE TAXES AND INTEREST (BAII) Financial income Financial expenses PRE-TAX BENEFIT (BAI) Corporation tax (25%) NET PROFIT BALANCE AMOUNT ANALYSIS % on sales DATE RESULT CASH FLOW STATEMENT OPERATING ACTIVITIES Cash entries Cash outflows CASH FLOW OPERATING ACTIVITIES INVESTMENT ACTIVITIES Cash entries Cash outflows CASH FLOW INVESTMENT ACTIVITIES FINANCING ACTIVITIES Cash entries Cash outflows CASH FLOW FINANCING ACTIVITIES BOX NET CASH FLOW 2019 Initial cash balance Final cash balance BALANCE AMOUNT AMOUNT AMOUNT AMOUNT 48.000,00 ANALYSIS DATE RESULT BALANCE SHEET BALANCE SHEET Active in the current Intangible Assets (GROSS) Intangible Depreciation Intangible Assets (NETO) Fixed Assets (GROSS) Material Depreciation Fixed Assets (NETO) Current assets Stocks Feasible Available TOTAL ASSETS BOX INITIAL 1/1/21 BALANCE 377.000,00 45.000,00 18.000,00 27.000,00 500.000,00 150.000,00 350.000,00 1.018.000,00 850.000,00 120.000,00 48.000,00 1.395.000,00 FINAL 31/12/21 ANALYSIS BALANCE SHEET Net worth Capital Reservations Positive results previous years Negative results previous years Result of the exercise Current liabilities L/P bank loan Other creditors of L/P Current liabilities C/P bank loan Suppliers Other creditors of C/P TOTAL LIABILITIES + NET P. INITIAL 1/1/21 290.000,00 180.000,00 300.000,00 60.000,00 250.000,00 0,00 750.000,00 700.000,00 50.000,00 355.000,00 250.000,00 90.000,00 15.000,00 1.395.000,00 0,00 FINAL 31/12/21 0,00 DATE RESULT BOX ECONOMIC AND FINANCIAL ANALYSIS LIQUIDITY ANALYSIS TEXERTY TREASURY AVAILABILITY [COMMENTS AND CONCLUSIONS TANT DENT QUALITY LOAN RETURN CAPACITY FINANCIAL COSTS KATIO COMMENTS AND CONCLUSIONS KATIO KATIO AVERAGE COST OF DEHE FINANCIAL EXPENSES ON SALES HNANCIAL EXPENSES COVERAGE COMMENTS AND CONCLEARINS MEDIUM TERM ASSET MANAGEMENT RATIO RITAL ASSETS HOTATHIN STOCK ROTATION CUSTOMER ROTATION COMMENTS AND CONCLUSIONS PROFEUBILITY RATIO MEDENFOCACCION FERODO LAVERAGE PAYMENT FORM COMMENTS AND CONCLUSIONS GRCOS MARION PROFITABILITY ON SALES TOTAL ASSET PROLABILITY O BALANCE ANALYSIS COMMENTS AND CONCLUSIONS VALKE YALLE CALCULATON FORMULA CHRIST ASSEIS CURRENT LILITIES GOAILABLE ACHEVABLE CURRENT LABETE AULABLE CURRENT LIMITE FINAL CONCLUSION AND RECOMMENDATIONS CALCULAION FORMULA LIABLITS EQUIRED TOTAL LALITIES CURRENT LARITIES TOTAL LIANITIES NEWS AMORTATIONS TOTAL LOAN VALUE CALCULATION FORMULA SALESTRAL A SALES/SOCKS CALCULATION FORMULA FINANCIAL EXPENSES/TOTAL LOANS FINANCIAL EXPENSES/AL [BAY FINACIAL EXPENSES CALCULATION FORMULA ALE SALES HE SUPRESSUPPLES NS ALTREY CALCULATON FORMULA GRENS SEARGINALE SET PROTESALES BAR TOTAL ASSES NAY PROFNE EQUITY INTRODUCTION Trading SA (TSA) is a commercial company dedicated to the import and commercialization of industrial machinery in Spain. The company has been operating for a few years and is consolidated within the sector of the sale/distribution of industrial machinery in Spain Instead of working to order (waiting for the customer to place an order to purchase the product) and reducing the stock level to a minimum (just-in-time), TSA maintains a stock of machinery ready for sale throughout the year in a large industrial warehouse rent in Montcada Barcelona. At the beginning of the year 2021, TSA already has a determined equity structure (Initial Balance Sheet). As of 01/01/2021, the company presents the following opening balance sheet INITIAL SITUATION BALANCE 01/01/2021 non-current set Intangible Fixed Assets (GROSS) Intangible Amortization Intangible Fixed Assets (NET) Tangible Fixed Assets (GROSS) Material Depreciation Property, Plant and Equipment (NET) Current adve Back Realizable Available TOTAL ASSETS EXERCISE TO DO INITIAL SITUATION BALANCE TRANSACTIONS 377,000 Net Asell 45.000 Capital 18.000ations 27,000 Positive results from previous years 500,000 Negative results from previous years 150,000 Pro for the year 350.000 1018,000 Non-aret lubilles 850.000 UP bank loan 120,000 Other LP creditors 48.000 Current iss CF bark toan providers Other CP creditors 1.395.000 TOTAL LIABILITIES NETA A-Using the templates provided and from the beginning balance and the transactions that occurred in the year 21, prepare the income statement, cash flow and the closing balance sheet for the year 2021, B-From the financial statements prepared in the previous point and using the templates provided, perform an economic and financial analysis of the company. 11 The company collects 75,000 from a client. 2. The company pays 30,000 to a supplier. 3. The company buys industrial machinery for sale (inventories) worth 300,000. The company pay 20% in cash and the rest is pending payment (suppliers). 4. The 01/01/2021 290.000 180.000 300.000 60.000 250.000 8. The company repays 50,000 of the short-term loan granted and pays 15.000 in interest. The company pays corporate tax (25% of BAI). 750.000 700.000 50.000 355.000 250.000 90.000 15.000 1.395.000 company sells the stocks purchased in the previous point for a value of 600,000. The company charges 50% in cash and the rest is pending collection (customers). 5. The company acquires, with cash payment, a property, plant and equipment worth 40,000. 6. Fixed structural expenses for the year (personnel, rent, external services, etc.) amount to a total of 185,000 and paid in full. 7. The amortization expense for intangible assets amounts to 10,000. The depreciation expense of the tangible fixed assets amounts to 50,000 DATE RESULT BOX PROFIT AND LOSS ACCOUNT CONCEPT Revenue from sales or provision of services Supplies GROSS MARGIN Other operating income Other operating expenses (structure expenses) OPERATING RESULT (EBITDA) Depreciation and amortization BENEFIT BEFORE TAXES AND INTEREST (BAII) Financial income Financial expenses PRE-TAX BENEFIT (BAI) Corporation tax (25%) NET PROFIT BALANCE AMOUNT ANALYSIS % on sales DATE RESULT CASH FLOW STATEMENT OPERATING ACTIVITIES Cash entries Cash outflows CASH FLOW OPERATING ACTIVITIES INVESTMENT ACTIVITIES Cash entries Cash outflows CASH FLOW INVESTMENT ACTIVITIES FINANCING ACTIVITIES Cash entries Cash outflows CASH FLOW FINANCING ACTIVITIES BOX NET CASH FLOW 2019 Initial cash balance Final cash balance BALANCE AMOUNT AMOUNT AMOUNT AMOUNT 48.000,00 ANALYSIS DATE RESULT BALANCE SHEET BALANCE SHEET Active in the current Intangible Assets (GROSS) Intangible Depreciation Intangible Assets (NETO) Fixed Assets (GROSS) Material Depreciation Fixed Assets (NETO) Current assets Stocks Feasible Available TOTAL ASSETS BOX INITIAL 1/1/21 BALANCE 377.000,00 45.000,00 18.000,00 27.000,00 500.000,00 150.000,00 350.000,00 1.018.000,00 850.000,00 120.000,00 48.000,00 1.395.000,00 FINAL 31/12/21 ANALYSIS BALANCE SHEET Net worth Capital Reservations Positive results previous years Negative results previous years Result of the exercise Current liabilities L/P bank loan Other creditors of L/P Current liabilities C/P bank loan Suppliers Other creditors of C/P TOTAL LIABILITIES + NET P. INITIAL 1/1/21 290.000,00 180.000,00 300.000,00 60.000,00 250.000,00 0,00 750.000,00 700.000,00 50.000,00 355.000,00 250.000,00 90.000,00 15.000,00 1.395.000,00 0,00 FINAL 31/12/21 0,00 DATE RESULT BOX ECONOMIC AND FINANCIAL ANALYSIS LIQUIDITY ANALYSIS TEXERTY TREASURY AVAILABILITY [COMMENTS AND CONCLUSIONS TANT DENT QUALITY LOAN RETURN CAPACITY FINANCIAL COSTS KATIO COMMENTS AND CONCLUSIONS KATIO KATIO AVERAGE COST OF DEHE FINANCIAL EXPENSES ON SALES HNANCIAL EXPENSES COVERAGE COMMENTS AND CONCLEARINS MEDIUM TERM ASSET MANAGEMENT RATIO RITAL ASSETS HOTATHIN STOCK ROTATION CUSTOMER ROTATION COMMENTS AND CONCLUSIONS PROFEUBILITY RATIO MEDENFOCACCION FERODO LAVERAGE PAYMENT FORM COMMENTS AND CONCLUSIONS GRCOS MARION PROFITABILITY ON SALES TOTAL ASSET PROLABILITY O BALANCE ANALYSIS COMMENTS AND CONCLUSIONS VALKE YALLE CALCULATON FORMULA CHRIST ASSEIS CURRENT LILITIES GOAILABLE ACHEVABLE CURRENT LABETE AULABLE CURRENT LIMITE FINAL CONCLUSION AND RECOMMENDATIONS CALCULAION FORMULA LIABLITS EQUIRED TOTAL LALITIES CURRENT LARITIES TOTAL LIANITIES NEWS AMORTATIONS TOTAL LOAN VALUE CALCULATION FORMULA SALESTRAL A SALES/SOCKS CALCULATION FORMULA FINANCIAL EXPENSES/TOTAL LOANS FINANCIAL EXPENSES/AL [BAY FINACIAL EXPENSES CALCULATION FORMULA ALE SALES HE SUPRESSUPPLES NS ALTREY CALCULATON FORMULA GRENS SEARGINALE SET PROTESALES BAR TOTAL ASSES NAY PROFNE EQUITY
