ACCT504 Devry Case Study 3: P4-55A Nathan Farmer chief financial officer of Bosworth Wireless

ACCT504 Devry Case Study 3 P4-55A (Learning Objective 5: Construct and use a cash budget) Nathan Farmer chief financial officer of Bosworth Wireless is responsible for the companyӳ budgeting process. Farmerӳ staff is preparing the Bosworth cash budget for 2013. A key input to the budgeting process is last yearӳ statement of cash flows which follows (amounts in thousands): Bosworth Wireless Statement of Cash Flows 2012 In thousands Cash Flows from Operating Activities Collection from customers 61 000 Interest received 400 Purchase of inventory (46 000) Operating expenses (13 200) Net cash provided by operating activities 2 200 Cash Flows from Investing Activities Purchase of equipment (4 500) Purchase of investments (800) Net cash used by investing activities (5 300) Cash Flows from Financing Activities Payment of dividends (500) Payment of long-term debt (200) (500) (3 600) Cash balance beginning 1 400 Cash balance ending (2 200) Requirements: 1. Prepare the Bosworth Wireless cash budget for 2013. Date the budget simply Ӳ013Ԡand denote the beginning and ending cash balances as ԢeginningԠand ԥnding.ԠAssume the company expects 2013 to be the same as 2012 but with the following changes:a. In 2013 the company expects a 15% increase in collections from customers and a 24% increase in purchases of inventory. b. There will be no sales of investments in 2013. c. Bosworth plans to issue no stock in 2013. d. Bosworth plans to end the year with a cash balance of $3 550.