PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS(Not written.. please)1) La Metropolitana, S.A., has trained its personnel with courses at a renowned private university in the northwest, in order to be up to date in the planning of its financial resources. It knows that, in order to know the necessary rotations to quantify its cash cycle, it is indispensable to apply some financial ratios, studied by its personnel and that it cost a lot of money to do so, so it does not expect an "I don't know" for an answer. So how often you pay your suppliers, how often you rotate your inventories, and how often you charge your customers, will have to be calculated with the following data:Total company sales..........................$9'365,199.36Proportion of credit sales....................... 73.¾ %Average customer balance............................. $ 767,426.06Cost of sales ratio...................... 67½ %Average inventory balance...................... $1'053,584.93Average suppliers' balance................... $ 896,884.26Beginning inventory................................................ $ 985,556.36The company spends about $15.525 million in operating cycle investments. With this data it is necessary to calculate:1) The operating cycle.2) The cash conversion cycle.3) The cash turnover.4) The minimum cash balance.Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand.Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.please... understand the context of the exercise in Spanish, it is easy to understand-THERE IS AN EXAMPLE OF EXCEL FORMATTING (IN THE PICTURE) , I WANT YOU TO USE A SIMILAR FORMAT.----------------------------Formulas (those given to me by the professor, this to guide you as a bartleby expert.)-Accounts receivable turnover Sales (on credit) / Average customer balance.-Average collection period: 360 /accounts receivable turnover -------------------------------------------------------------------Inventory turnoverCost of sales / average inventory-Average inventory age360/inventory turnover-------------------------------------------------------------------Accounts Payable Rotation STEP ONE: Determine Ending InventorySTEP TWO: Determine PurchasesSTEP THREE: -Calculate accounts payable turnover.Purchases / Average supplier balance-Average payment period360/accounts payable turnover------------------------------------------------------------------Operating Cycle = Average age of inventory + Average collection periodCash Conversion Cycle = Average payable period - Cash cycle Cash Turnover = 360 / Cash Conversion Cycle Minimum Cash Balance = Annual Expense / Cash Turnover------------------------------------------------------------------ CICLO DE CAJACC2) La Reina de Oriente S.A.DATOS:Ventas TotalesProporción a créditoSaldo promedio ClientesSaldo promedio InventariosGastos anualesInventario InicialCÁLCULOS PREVIOS:Rotación CxCRotación InventariosRotación CxPCosto de VentasComprasVentas a créditoEdad Promedio InventarioPeríodo Promedio CobroPeríodo Promedio PagoInventario FinalSaldo promedio ProveedorCÁLCULOS:1) Ciclo Operativo2) Ciclo Conversión Efectivo3) Rotación de Cajadiasdíasveces4) Saldo mínimo en caja 1) La Metropolitana, S.A., ha capacitado a su personal con cursos enafamada universidad privada del noroeste, para estar al día en laplaneación de sus recursos financieros. Sabe que, para conocer lasrotaciones necesarias para cuantificar su ciclo de caja, es indispensableaplicar algunas razones financieras, estudiadas por su personal y que lecostó una lana que lo hiciera, por lo que no espera un "no sé" porrespuesta. Así que cada cuánto paga a sus proveedores, cada cuántorotan sus inventarios, y cada cuánto cobra a sus clientes, habrá quecalcularlo con los siguientes datos:Ventas totales de la empresa.Proporción de ventas a crédito..Saldo promedio de clientes.Proporción del costo de ventas..Saldo promedio de inventarios..Saldo promedio de proveedores..Inventario Inicial ..$9'365,199.3673.% %$ 767,426.06672 %$1'053,584.93$ 896,884.26$ 985,556.36La empresa gasta alrededor de $15.525 millones en inversiones delciclo operativo. Con estos datos hay que calcular:1) El ciclo operativo.2) El ciclo de conversión de efectivo.3) La rotación de caja.4) El saldo mínimo de caja.

Question

PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS(Not written.. please)1) La Metropolitana, S.A., has trained its personnel with courses at a renowned private university in the northwest, in order to be up to date in the planning of its financial resources. It knows that, in order to know the necessary rotations to quantify its cash cycle, it is indispensable to apply some financial ratios, studied by its personnel and that it cost a lot of money to do so, so it does not expect an &#34;I don't know&#34; for an answer. So how often you pay your suppliers, how often you rotate your inventories, and how often you charge your customers, will have to be calculated with the following data:Total company sales..........................$9'365,199.36Proportion of credit sales.......................      73.¾ %Average customer balance............................. $ 767,426.06Cost of sales ratio......................       67½ %Average inventory balance...................... $1'053,584.93Average suppliers' balance................... $ 896,884.26Beginning inventory................................................ $ 985,556.36The company spends about $15.525 million in operating cycle investments. With this data it is necessary to calculate:1) The operating cycle.2) The cash conversion cycle.3) The cash turnover.4) The minimum cash balance.Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand.Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.please... understand the context of the exercise in Spanish, it is easy to understand-THERE IS AN EXAMPLE OF EXCEL FORMATTING (IN THE PICTURE) , I WANT YOU TO USE A SIMILAR FORMAT.----------------------------Formulas (those given to me by the professor, this to guide you as a bartleby expert.)-Accounts receivable turnover Sales (on credit) / Average customer balance.-Average collection period: 360 /accounts receivable turnover -------------------------------------------------------------------Inventory turnoverCost of sales / average inventory-Average inventory age360/inventory turnover-------------------------------------------------------------------Accounts Payable Rotation STEP ONE: Determine Ending InventorySTEP TWO: Determine PurchasesSTEP THREE: -Calculate accounts payable turnover.Purchases / Average supplier balance-Average payment period360/accounts payable turnover------------------------------------------------------------------Operating Cycle = Average age of inventory + Average collection periodCash Conversion Cycle = Average payable period - Cash cycle Cash Turnover = 360 / Cash Conversion Cycle   Minimum Cash Balance = Annual Expense / Cash Turnover------------------------------------------------------------------ CICLO DE CAJACC2) La Reina de Oriente S.A.DATOS:Ventas TotalesProporción a créditoSaldo promedio ClientesSaldo promedio InventariosGastos anualesInventario InicialCÁLCULOS PREVIOS:Rotación CxCRotación InventariosRotación CxPCosto de VentasComprasVentas a créditoEdad Promedio InventarioPeríodo Promedio CobroPeríodo Promedio PagoInventario FinalSaldo promedio ProveedorCÁLCULOS:1) Ciclo Operativo2) Ciclo Conversión Efectivo3) Rotación de Cajadiasdíasveces4) Saldo mínimo en caja 1) La Metropolitana, S.A., ha capacitado a su personal con cursos enafamada universidad privada del noroeste, para estar al día en laplaneación de sus recursos financieros. Sabe que, para conocer lasrotaciones necesarias para cuantificar su ciclo de caja, es indispensableaplicar algunas razones financieras, estudiadas por su personal y que lecostó una lana que lo hiciera, por lo que no espera un &#34;no sé&#34; porrespuesta. Así que cada cuánto paga a sus proveedores, cada cuántorotan sus inventarios, y cada cuánto cobra a sus clientes, habrá quecalcularlo con los siguientes datos:Ventas totales de la empresa.Proporción de ventas a crédito..Saldo promedio de clientes.Proporción del costo de ventas..Saldo promedio de inventarios..Saldo promedio de proveedores..Inventario Inicial ..$9'365,199.3673.% %$ 767,426.06672 %$1'053,584.93$ 896,884.26$ 985,556.36La empresa gasta alrededor de $15.525 millones en inversiones delciclo operativo. Con estos datos hay que calcular:1) El ciclo operativo.2) El ciclo de conversión de efectivo.3) La rotación de caja.4) El saldo mínimo de caja.

Accepted Answer

Operating Cycle=Average age of inventory+Average collection periodCash Conversion Cycle=Average…