Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you calculate in excel please Q#2-10 points The company was established in 1 January 20X5, the owner's capital consisted of only cash contribution 200000$

image text in transcribed

can you calculate in excel please

Q#2-10 points 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Examine how service firms use different branding strategies.

Answered: 1 week ago

Question

What are the attributes of a technical decision?

Answered: 1 week ago

Question

How do the two components of this theory work together?

Answered: 1 week ago