The company was established in 1 January 20X5, the owner's capital consisted of only cash contribution 200000$ and 10000$ by computers. We bought necessary equipment (2 cars each by 6000$). The company hired employees with monthly salary 10000$ including taxes and social payments. There was rented an office with monthly fee 1000$. During a week company purchased goods amounting 60000$. Prior to payment there was found out some damage, and our company claimed for return of 5000$ inventory. Return was accepted and the supplier offered a 10% discount in case the company paid by cash in 5 days. Our company doesn't pay within discounted period. Within a week, we make sales 90000$. The customer pays 45000$ by cash. We offered a customer 10% discount if he pays the rest amount within 3 days by cash and he pays. Depreciation expenses for the end of the month for cars were 2000s, for computers 800$. Company decided to change 1 of the cars for truck and pays on it additionally 1000$. At the end of the month company paid immediately for utility expenses 200$, paid 20% of trade payables. Salaries aren't yet paid out. Ending inventory 2000. Required: Prepare Cash flow statement using Indirect method can you calculate in excel please

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter11: Long-term Assets
Section: Chapter Questions
Problem 2EB: Johnson, Incorporated had the following transactions during the year: Purchased a building for...
icon
Related questions
Question
The company was established in 1 January 20X5, the owner's capital consisted of only cash
contribution 200000$ and 10000$ by computers. We bought necessary equipment (2 cars each by
6000$). The company hired employees with monthly salary 10000$ including taxes and social
payments. There was rented an office with monthly fee 1000$. During a week company purchased
goods amounting 60000$. Prior to payment there was found out some damage, and our company
claimed for return of 5000$ inventory. Return was accepted and the supplier offered a 10% discount in
case the company paid by cash in 5 days. Our company doesn't pay within discounted period. Within a
week, we make sales 90000$. The customer pays 45000$ by cash. We offered a customer 10%
discount if he pays the rest amount within 3 days by cash and he pays. Depreciation expenses for the
end of the month for cars were 2000$, for computers 800$. Company decided to change 1 of the cars
for truck and pays on it additionally 1000$. At the end of the month company paid immediately for
utility expenses 200$, paid 20% of trade payables. Salaries aren't yet paid out. Ending inventory 2000.
Required: Prepare Cash flow statement using Indirect method
can you calculate in excel please
Transcribed Image Text:The company was established in 1 January 20X5, the owner's capital consisted of only cash contribution 200000$ and 10000$ by computers. We bought necessary equipment (2 cars each by 6000$). The company hired employees with monthly salary 10000$ including taxes and social payments. There was rented an office with monthly fee 1000$. During a week company purchased goods amounting 60000$. Prior to payment there was found out some damage, and our company claimed for return of 5000$ inventory. Return was accepted and the supplier offered a 10% discount in case the company paid by cash in 5 days. Our company doesn't pay within discounted period. Within a week, we make sales 90000$. The customer pays 45000$ by cash. We offered a customer 10% discount if he pays the rest amount within 3 days by cash and he pays. Depreciation expenses for the end of the month for cars were 2000$, for computers 800$. Company decided to change 1 of the cars for truck and pays on it additionally 1000$. At the end of the month company paid immediately for utility expenses 200$, paid 20% of trade payables. Salaries aren't yet paid out. Ending inventory 2000. Required: Prepare Cash flow statement using Indirect method can you calculate in excel please
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Section 179 Deduction and Modified Accelerated Cost Recovery System (MACRS) Depreciation
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College