Can someone help me to make cash flow statement from data?

296 views 5 replies

Zahid

B.Com

36 Points Joined July 2015

Dear Friends,

Can someone make cash flow statement for below Data ?

Current Assets:
Bank Balances and Cash			5,595,604
Post-dated cheques receivable
Accounts receivable			40,026,290
Inventories			21,499,553
Due from Related parties			10,604,919
Prepaid expenses and Other debit balances			328,889
Total Current Assets			78,055,256
Non- Current Assets
Property, plant and equipment			88,841,076

Total Assets			166,896,332

LIABILITIES AND PARTNER'S EQUITY
Current Liabilities:
Loan payable			16,742
Post-dated cheques payable
Accounts payable			25,356,370.02
Accrued expenses and other credit balances			905,097
Due to related parties			1,518,320

Total Current Liabilities			27,796,529
Non- Current Liabilities:
Loans payable			11,161
Post-dated cheques payable
Provision for employee's Terminal benefits			591,949
Total Non- Current Liabilities			603,110
Total Liabilities			28,399,639
Partner's Equity
Capital			2,000,000
Legal reserve			1,000,000
Partner's current accounts			83,691,232
Retained earnings			51,805,461
Total Partner's Equity			138,496,693
Total Liabilities and Partner's Equity			166,896,332

Replies (5)

Vikas Gupta

Tax Executive

530 Points Joined July 2012

Cash Flow is prepared for three activities - 1. Cash From Operating Activities; 2. Cash From Investing Activities and 3. Cash From Financing Activities.

Without 'Profit & Loss A/c' details, 'Cash from operations' cannot be prepared which is not available here.

Zahid

B.Com

36 Points Joined July 2015

Vikas Bhai Thank you very much please find below PROFIT & LOSS.

Sales		17,033,852.35
Cost of Sales		(4,590,135.87)

	Gross Profit	12,443,716

Other income		25,342.00
General and administrative expenses		(1,807,322.79)


Net Income before Depreciation		10,661,736
Depreciation Expense		-

Net Income / (Loss)		10,661,736

Zahid

B.Com

36 Points Joined July 2015

Viaks Bhai I have given detail of Profit & Loss. Can you please make Cash flow now.

Thanks

Vinay somani (CA, CS)

Assistant Manager-Accounts

549 Points Joined May 2012

This is only current year data. how can we get to know that how much amt paid to creditors or how much red. from sm one. and same in other case

Zahid

B.Com

36 Points Joined July 2015

Vinay Bhai, Please find below Year 2015 Data.

YEAR 2015
Current Assets:
Bank Balances and Cash			3,068,288.28
Post-dated cheques receivable
Accounts receivable			46,839,469.89
Inventories			19,479,900.35
Due from Related parties			1,840,188.65
Prepaid expenses and Other debit balances			539,271.00
Total Current Assets			71,767,118.17
Non- Current Assets
Property, plant and equipment			82,883,526.18

Total Assets			154,650,644.35

LIABILITIES AND PARTNER'S EQUITY
Current Liabilities:
Loan payable			21,749.42
Post-dated cheques payable
Accounts payable			23,562,240.02
Accrued expenses and other credit balances			948,266.95
Due to related parties			1,118,420.31

Total Current Liabilities			25,650,676.70
Non- Current Liabilities:
Loans payable			14,499.61
Post-dated cheques payable
Provision for employee's Terminal benefits			600,513.00
Total Non- Current Liabilities			615,012.61
Total Liabilities			26,265,689.31
Partner's Equity
Capital			2,000,000.00
Legal reserve			1,000,000.00
Revaluation reserve
Partner's current accounts			84,241,232.00
Retained earnings			41,143,725.41
Total Partner's Equity			128,384,957.41
Total Liabilities and Partner's Equity			154,650,646.72