Hi

Can you please help with the below question.

Charleston Aerospace Company had cash and cash equivalents of $200 million on December 31, 2011. The following items are on the companys statement of cash flows ($ in millions) for the first 6 months of 2012: ,Capital expenditures for property and equipment $ (1,710),Receipts from customers .. 9,455 ,Interest paid, net .. (190) ,Repurchase of common stock .. (193) ,Sales of marketable securities . 191 ,Retirement of long-term debt . (160) ,Payments to suppliers and employees . (7,499) ,Issuance of common stock for employee stock plans . 251 ,Dividend payments . (17) ,Issuance of long-term debt . 135 ,Other investing activity (134) ,Taxes paid (167) ,Prepare a statement of cash flows for the first 6 months of 2012 using the direct method. Include the balance of cash and cash equivalents at year-end 2011 and calculate the cash balance at June 30, 2012. Omit the schedule reconciling net income to net cash provided by operating activities and the schedule of noncash investing and financing activities.