I need a full detailed cash flow in a table please, based on the follwing information tems Quarter 1 Quarter 2 Quarter 3 Quarter 4 Gross sales 400,000 500,000 300,000 200,000 Gross purchases 250,000 150,000 200,000 180,000 Paid cash machines and equipment ----- ----- 80,000 ----- Paid cash utilities ----- 400,000 ----- ----- Salary and wages 21000 26000 24000 ----- Interest credit 15000 ----- 10,000 35000 Interest debit 8000 6000 19000 4000 Overhead expenses 4000 3000 3500 3200 Minimum reserve of cash 300,000 300,000 300,000 300,000 If you know that: -The company can borrow money when required with the loan’s interest rate of 10% of the amount borrowed during the period. There are 20% of gross sales are considered as cash sales. Credit sales are collected as follows: 70% in the same quarter of sales, 20% in the following quarter, and 10% in the quarter after. Overhead expenses include 3000 EGP depreciation/ quarter. There are 10% of gross purchases are considered as cash purchases. Debit purchases are paid as follows: 60% in the same quarter of purchases, 25% in the following quarter, and 15% in the quarter after.   Eighth: Balance Sheet (B.S.) of the 31/12/2021 Assets Liabilities & Owner's Equity Cash 200,000 Loan Accounts payable 100,000 50,000 A/R 20,000 Capital 195000 Furniture 29000 Machines and equipment 36000 Depreciation (3000) Materials 3000 Merchandise (F.G.) 60,000 Total Assets 345000 Total Liabilities and O'E 345000

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter6: Cash And Receivables
Section: Chapter Questions
Problem 1E: Computing; the Cash Balance Listed below are ten items that may be found on a balance sheet....
icon
Related questions
Question

I need a full detailed cash flow in a table please, based on the follwing information

tems

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Gross sales

400,000

500,000

300,000

200,000

Gross purchases

250,000

150,000

200,000

180,000

Paid cash machines and equipment

-----

-----

80,000

-----

Paid cash utilities

-----

400,000

-----

-----

Salary and wages

21000

26000

24000

-----

Interest credit

15000

-----

10,000

35000

Interest debit

8000

6000

19000

4000

Overhead expenses

4000

3000

3500

3200

Minimum reserve of cash

300,000

300,000

300,000

300,000

If you know that:

-The company can borrow money when required with the loan’s interest rate of 10% of the amount borrowed during the period.

  • There are 20% of gross sales are considered as cash sales.
  • Credit sales are collected as follows: 70% in the same quarter of sales, 20% in the following quarter, and 10% in the quarter after.
  • Overhead expenses include 3000 EGP depreciation/ quarter.
  • There are 10% of gross purchases are considered as cash purchases.
  • Debit purchases are paid as follows: 60% in the same quarter of purchases, 25% in the following quarter, and 15% in the quarter after.

 

Eighth:

Balance Sheet (B.S.) of the 31/12/2021

Assets

Liabilities & Owner's Equity

Cash

200,000

Loan

Accounts payable

100,000

50,000

A/R

20,000

Capital

195000

Furniture

29000

Machines and equipment

36000

Depreciation

(3000)

Materials

3000

Merchandise (F.G.)

60,000

Total Assets

345000

Total Liabilities and O'E

345000

Expert Solution
steps

Step by step

Solved in 1 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage