Question

Tiger Trade has the following cash transactions for the period.
  

Accounts	Amounts
Cash received from sale of products to customers	$	39,500
Cash received from the bank for long-term loan		44,500
Cash paid to purchase factory equipment		(49,500	)
Cash paid to merchandise suppliers		(11,900	)
Cash received from the sale of an unused warehouse		12,900
Cash paid to workers		(23,900	)
Cash paid for advertisement		(3,900	)
Cash received for sale of services to customers		29,500
Cash paid for dividends to stockholders		(5,900	)

Assume the balance of cash at the beginning of the period is $4,900.
  

Required:

1. Calculate the ending balance of cash.
  

  

2. Prepare a statement of cash flows. (Cash outflows should be indicated by a minus sign.)
  

	TIGER TRADE Statement of Cash Flows Cash Flows from Operating Activities Cash inflows: Cash outflows: Net cash flows from operating activities Cash Flows from Investing Activities Net cash flows from investing activities Cash Flows from Financing Activities Net cash flows from financing activities Cash at the beginning of the year Cash at the end of the year

Answer 1

Solution :

1. The ending cash balance = $ 36,200.

2.Please find the attached screenshot of the excel sheet containing the detailed cash flow statement.

07.02.2020 - Microsoft Excel XES FILE | HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW B Amount Amount $ 39,500.00 $ 29,500.00 Statement of Cash Flows Cash flows from operating activities : Cash Inflows: Cash received from sale of products to customers Cash received for sale of services to customers Cash outflows: Cash paid to merchandise suppliers Cash paid to workers Cash paid for advertisement Net cash flow from operating activities $ -11,900.00 $ -23,900.00 $ -3,900.00 $ 29,300.00 Cash flows from investing activities : Vesting activities : Cash paid to purchase factory equipmen Cash received from the sale of an unused warehouse Net cash flow from investing activities $ -49,500.00 $ 12,900.00 $ -36,600.00 Cash flows from financing activities: Cash received from the bank for long-term loan Cash paid for dividends to stockholders Net cash flow from financing activities $ $ 44,500.00 -5,900.00 $ 38,600.00 Change in Cash = ($ 29,300.00 - $ 36,600.00 + $ 38,600.00) Cash at the beginning of the Year Cash at the end of the Year = ($ 31,300.00 + $ 4,900.00) $ 31,300.00 $ 4,900.00 $36,200.00