You must make a Treasury forecast similar to the attached file.;

The following table shows the figures provided by various departments regarding their expectations of operations throughout the year.

For simplicity, we analyze only some areas:

Purchasing area: Suppliers Human resources area: Salaries, Social Security and IRPF Commercial area: Sales to customers

To do this, take the sales and purchases (supplies) of a random company (the one you can check for in SABI accounts).

- Taking into account that monthly sales are charged (calculate annual sales / 12 months).

Customers: collected 90 days (following 3 months)

OPENING BALANCE : OPENING BALANCE

PAGOS : PAID

PROVEEDORES : SUPPLIERS

IVA : VAT OF SPAIN

SUELDOS : SALARIES

SEGUR. SOCIAL SOCIAL SECURITY

IRPFY

GASTOS FINANCIEROS : FINANCIAL EXPENSES

OTROS PAGOS : OTHER PAYMENTS

TOTAL PAGOS: TOTAL PAYMENT

COBROS : COLLECTIONS

CLIENTES : CLIENTS

INGRESOS FINANCIEROS : FINANCIAL INCOME

TOTAL BALANCE

FINANCION INVERSION INVESTMENT FINANCING,

FINAL BALANCE

And that monthly purchases (supplies / 12 months) are paid according to

QUESTIONS TO BE SOLVED:

Prepare a table with the treasury budget where the figures correspond to the actual collections and payments of each month

Assume also that the financing needs cost us 5% and the surpluses we make them profitable at 4% and that both are settled in the immediately subsequent month.

Calculate the new financial result

2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL MILL. 0 300 80 200 50 40 4.000 432 1.400 350 280 9 161 6.632 1 SALDO INICIAL 0 0 0 0 0 0 0 0 0 0 0 PAGOS PROVEEDORES 500 300 100 800 200 100 400 400 200 600 100 IVA 0 0 80 0 64 32 0 0 96 0 80 SUELDOS 100 100 100 100 100 100 200 100 100 100 100 SEGUR. SOCIAL 25 25 25 25 25 25 50 25 25 25 25 IRPF 20 20 20 20 20 20 40 20 20 20 20 GASTOS FINANCIEROS 0 2 1 0 3 0 0 1 0 1 OTROS PAGOS 5 13 15 21 13 17 5 17 15 TOTAL PAGOS 652 452 339 954 427 298 703 563 447 762 341 COBROS CLIENTES 100 300 600 300 600 300 400 200 800 500 600 INGRESOS FINANCIEROS 0 0 0 1 0 0 0 0 1 0 OTROS COBROS 5 3 11 7 13 19 11 15 3 15 13 TOTAL COBROS 105 303 611 308 613 320 411 215 803 516 613 SALDO FINAL COB/PAG (547) (149) 272 (646) 186 22 (292) (348) 356 (246) 272 SALDO TOTAL (547) (149) 272 (646) 186 22 (292) (348) 356 (246) 272 0 7 24 694 800 1 22 823 129 129 5.500 4 137 5.641 (992) (992) 292 0 FINANCIACIN INVERSION 547 0 149 0 0 (272) 646 0 0 0 (186) (22) 348 0 0 (356) 246 0 0 (272) (129) 0 SALDO FINAL 0 0 0 0 0 0 0 0 0 0 0 0 The final balance of the table is compensated with the use of financing or investment of surplus cash, according to the end-of-month balance. To make it easy, each month we will leave the treasury at 0, so that no idle monetary resources remain. 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL MILL. 0 300 80 200 50 40 4.000 432 1.400 350 280 9 161 6.632 1 SALDO INICIAL 0 0 0 0 0 0 0 0 0 0 0 PAGOS PROVEEDORES 500 300 100 800 200 100 400 400 200 600 100 IVA 0 0 80 0 64 32 0 0 96 0 80 SUELDOS 100 100 100 100 100 100 200 100 100 100 100 SEGUR. SOCIAL 25 25 25 25 25 25 50 25 25 25 25 IRPF 20 20 20 20 20 20 40 20 20 20 20 GASTOS FINANCIEROS 0 2 1 0 3 0 0 1 0 1 OTROS PAGOS 5 13 15 21 13 17 5 17 15 TOTAL PAGOS 652 452 339 954 427 298 703 563 447 762 341 COBROS CLIENTES 100 300 600 300 600 300 400 200 800 500 600 INGRESOS FINANCIEROS 0 0 0 1 0 0 0 0 1 0 OTROS COBROS 5 3 11 7 13 19 11 15 3 15 13 TOTAL COBROS 105 303 611 308 613 320 411 215 803 516 613 SALDO FINAL COB/PAG (547) (149) 272 (646) 186 22 (292) (348) 356 (246) 272 SALDO TOTAL (547) (149) 272 (646) 186 22 (292) (348) 356 (246) 272 0 7 24 694 800 1 22 823 129 129 5.500 4 137 5.641 (992) (992) 292 0 FINANCIACIN INVERSION 547 0 149 0 0 (272) 646 0 0 0 (186) (22) 348 0 0 (356) 246 0 0 (272) (129) 0 SALDO FINAL 0 0 0 0 0 0 0 0 0 0 0 0 The final balance of the table is compensated with the use of financing or investment of surplus cash, according to the end-of-month balance. To make it easy, each month we will leave the treasury at 0, so that no idle monetary resources remain