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

ACCT504
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.
Powered by