0.- 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.

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

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.

 

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 2 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