Docsity
Docsity

Prepara tus exámenes
Prepara tus exámenes

Prepara tus exámenes y mejora tus resultados gracias a la gran cantidad de recursos disponibles en Docsity


Consigue puntos base para descargar
Consigue puntos base para descargar

Gana puntos ayudando a otros estudiantes o consíguelos activando un Plan Premium


Orientación Universidad
Orientación Universidad

excel-ingresos egresos, Ejercicios de Competencias en MS Microsoft Excel

ejercicios de costos 2018 curso de experiencias formativas que te ayudaran a ingresos egresos ejemplos

Tipo: Ejercicios

2017/2018

Subido el 01/02/2025

nayelli-yamiled-rojas-perez
nayelli-yamiled-rojas-perez 🇵🇪

1 documento

1 / 1

Toggle sidebar

Esta página no es visible en la vista previa

¡No te pierdas las partes importantes!

bg1
FLUJO DE CAJA
Aug-19 set-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mzo-20 Apr-20 May-20
RUBROS
CAJA INICIAL (SALDO APERTURA) S/. 100.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 600.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 100.00
INGRESOS
Ingreso por Ventas S/. 3,500.00 S/. 3,000.00 S/. 3,500.00 S/. 3,800.00 S/. 6,000.00 S/. 4,500.00 S/. 3,500.00 S/. 5,000.00 S/. 3,500.00 S/. 5,000.00
Ingreso por otros Negocios S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00
Recuperación de CxC S/. 200.00 S/. 180.00 S/. 180.00 S/. 200.00 S/. 200.00 S/. 200.00 S/. 180.00 S/. 150.00 S/. 180.00 S/. 150.00
Préstamo S/. 5,000.00
TOTAL INGRESOS S/. 3,720.00 S/. 3,200.00 S/ . 3,700.00 S/. 9,020.00 S/. 6,220.00 S/. 4,720.00 S/. 3,700.00 S/. 5,170.00 S/. 3,700.00 S/. 5,170.00
EGRESOS
Compras Mercaderia S/. 2,000.00 S/. 1,800.00 S/. 2,000.00 S/. 4,500.00 S/. 1,800.00 S/. 2,500.00 S/. 1,800.00 S/. 2,200.00 S/. 1,500.00 S/. 2,200.00
Luz, agua, teléfono S/. 550.00 S/. 530.00 S/. 550.00 S/. 480.00 S/. 600.00 S/. 480.00 S/. 450.00 S/. 550.00 S/. 500.00 S/. 500.00
Transporte S/. 50.00 S/. 50.00 S/. 60.00 S/. 60.00 S/. 90.00 S/. 50.00 S/. 50.00 S/. 60.00 S/. 60.00 S/. 70.00
Impuestos S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00
Cuota Ptmo actual S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.00
TOTAL EGRESOS S/. 2,650.00 S/. 2,430.00 S/. 2,660.00 S/. 5,090.00 S/. 3,037.00 S/. 3,577.00 S/. 2,847.00 S/. 3,357.00 S/. 2,607.00 S/. 3,317.00
SALDO MENSUAL FINAL S/. 1,070.00 S/. 770.00 S/. 1,040.00 S/. 3,930.00 S/. 3,183.00 S/. 1,143.00 S/. 853.00 S/. 1,813.00 S/. 1,093.00 S/. 1,853.00
Gastos Familiares S/. 709.00 S/. 689.00 S/. 739.00 S/. 719.00 S/. 973.00 S/. 669.00 S/. 659.00 S/. 709.00 S/. 649.00 S/. 669.00
SALDO DE CAJA FINAL S/. 361.00 S/. 81.00 S/. 301.00 S/. 3,211.00 S/. 2,210.00 S/. 474.00 S/. 194.00 S/. 1,104.00 S/. 444.00 S/. 1,184.00

Vista previa parcial del texto

¡Descarga excel-ingresos egresos y más Ejercicios en PDF de Competencias en MS Microsoft Excel solo en Docsity!

FLUJO DE CAJA

  • Aug-19 set-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mzo-20 Apr-20 May-
  • CAJA INICIAL (SALDO APERTURA) S/. 100.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 600.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 100.00 S/. 100. RUBROS
  • Ingreso por Ventas S/. 3,500.00 S/. 3,000.00 S/. 3,500.00 S/. 3,800.00 S/. 6,000.00 S/. 4,500.00 S/. 3,500.00 S/. 5,000.00 S/. 3,500.00 S/. 5,000. INGRESOS
  • Ingreso por otros Negocios S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.00 S/. 20.
  • Recuperación de CxC S/. 200.00 S/. 180.00 S/. 180.00 S/. 200.00 S/. 200.00 S/. 200.00 S/. 180.00 S/. 150.00 S/. 180.00 S/. 150.
  • Préstamo S/. 5,000.
  • TOTAL INGRESOS S/. 3,720.00 S/. 3,200.00 S/. 3,700.00 S/. 9,020.00 S/. 6,220.00 S/. 4,720.00 S/. 3,700.00 S/. 5,170.00 S/. 3,700.00 S/. 5,170.
  • Compras Mercaderia S/. 2,000.00 S/. 1,800.00 S/. 2,000.00 S/. 4,500.00 S/. 1,800.00 S/. 2,500.00 S/. 1,800.00 S/. 2,200.00 S/. 1,500.00 S/. 2,200. EGRESOS
  • Luz, agua, teléfono S/. 550.00 S/. 530.00 S/. 550.00 S/. 480.00 S/. 600.00 S/. 480.00 S/. 450.00 S/. 550.00 S/. 500.00 S/. 500.
  • Transporte S/. 50.00 S/. 50.00 S/. 60.00 S/. 60.00 S/. 90.00 S/. 50.00 S/. 50.00 S/. 60.00 S/. 60.00 S/. 70.
  • Impuestos S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.00 S/. 50.
  • Cuota Ptmo actual S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.00 S/. 497.
  • TOTAL EGRESOS S/. 2,650.00 S/. 2,430.00 S/. 2,660.00 S/. 5,090.00 S/. 3,037.00 S/. 3,577.00 S/. 2,847.00 S/. 3,357.00 S/. 2,607.00 S/. 3,317.
  • SALDO MENSUAL FINAL S/. 1,070.00 S/. 770.00 S/. 1,040.00 S/. 3,930.00 S/. 3,183.00 S/. 1,143.00 S/. 853.00 S/. 1,813.00 S/. 1,093.00 S/. 1,853.
  • Gastos Familiares S/. 709.00 S/. 689.00 S/. 739.00 S/. 719.00 S/. 973.00 S/. 669.00 S/. 659.00 S/. 709.00 S/. 649.00 S/. 669.
  • SALDO DE CAJA FINAL S/. 361.00 S/. 81.00 S/. 301.00 S/. 3,211.00 S/. 2,210.00 S/. 474.00 S/. 194.00 S/. 1,104.00 S/. 444.00 S/. 1,184.