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’s budgeting process. Farmer’s staff is preparing the Bosworth cash budget for 2013. A key input to the budgeting process is last year’s 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 “2013” and denote the beginning and ending cash balances as “beginning” and “ending.” 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.