The company El Invierno, S.A., presents the following information for you to calculate its accounting and cash profit:            Total Sales................................. $ 1'345,670.20              Cost of Sales.............................. $ 702,875.95            Operating Expenses:            Wages and salaries.......... $149,516.40            Rent.................................  69,250.50            Commissions.................... 320,000.00            Depreciation..............  114,129.32 $ 652,896.22                  Sales, purchases and expenses were made in cash.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

 

PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS

 

10.-
The company El Invierno, S.A., presents the following information for you to calculate its accounting and cash profit:

           Total Sales................................. $ 1'345,670.20

 

           Cost of Sales.............................. $ 702,875.95

           Operating Expenses:

           Wages and salaries.......... $149,516.40

           Rent.................................  69,250.50

           Commissions.................... 320,000.00

           Depreciation..............  114,129.32 $ 652,896.22

               

 Sales, purchases and expenses were made in cash.

 

 

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.

 

La empresa El Invierno, S.A., te presenta la siguiente información para que procedas a calcular su utilidad contable y en
efectivo:
Ventas totales.
$ 1345,670.20
Costo de Ventas.
$ 702,875.95
Gastos de Operación:
Sueldos y salarios. . $149,516.40
Renta.
69,250.50
Comisiones..
320,000.00
Depreciaciones . 114.129.32 $ 652,896.22
Las ventas, compras y gastos fueron hechos en efectivo.
Transcribed Image Text:La empresa El Invierno, S.A., te presenta la siguiente información para que procedas a calcular su utilidad contable y en efectivo: Ventas totales. $ 1345,670.20 Costo de Ventas. $ 702,875.95 Gastos de Operación: Sueldos y salarios. . $149,516.40 Renta. 69,250.50 Comisiones.. 320,000.00 Depreciaciones . 114.129.32 $ 652,896.22 Las ventas, compras y gastos fueron hechos en efectivo.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education