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.
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff3a637aa-6352-4d50-b2fa-db05ac42d600%2F1d777593-39b5-42bc-a5e5-9f1f35ac6913%2Ff4wuhns_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)