Question

In: Accounting

A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted)....

A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given quarter. Suppose the company starts the first quarter with no bank debt. How much total bank debt does the company expect to have at the end of the third quarter?

Cash Budget

Quarter (000 omitted)

1

2

3

Cash balance, beginning

$8

?

?

Add collections from customers

88

128

87

Total cash available

?

?

?

Less disbursements:

Purchase of inventory

56

65

65

Selling and administrative expenses

40

45

48

Equipment purchases

9

10

12

Dividends

2

2

2

Total disbursements

?

?

?

Excess (deficiency) of cash available over disbursements

?

?

?

Financing:

Borrowings

?

?

?

Repayments

?

?

?

Total financing

?

?

?

Cash balance, ending

?

?

?

Multiple Choice

  • $16,000

  • $40,000

  • $6,000

  • $50,000

Solutions

Expert Solution

Correct answer--------------$40,000

Working

Cash Budget Quarter (000 omitted)
1 2 3
Cash balance, beginning $     8.00 $     5.00 $     5.00
Add collections from customers $   88.00 $128.00 $   87.00
Total cash available $   96.00 $133.00 $   92.00
Less disbursements:
Purchase of inventory $   56.00 $   65.00 $   65.00
Selling and administrative expenses $   40.00 $   45.00 $   48.00
Equipment purchases $     9.00 $   10.00 $   12.00
Dividends $     2.00 $     2.00 $     2.00
Total disbursements $107.00 $122.00 $127.00
Excess (deficiency) of cash available over disbursements $ (11.00) $   11.00 $ (35.00)
Financing:
Borrowings $   16.00 $   40.00
Repayments $   (6.00)
Total financing $   16.00 $   (6.00) $   40.00
Cash balance, ending $     5.00 $     5.00 $     5.00

Related Solutions

A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted)....
A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given...
Exercise 8-11 Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a...
Exercise 8-11 Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $6 Add collections from customers 96 323 Total cash...
Presented below are four overhead costs of Chemtrails Mfg. Corp. for the first three quarters of...
Presented below are four overhead costs of Chemtrails Mfg. Corp. for the first three quarters of 2017. Q1 Q2 Q3 Units Produced 245,700 262,900 251,800 Overhead Costs: Factory Maintenance $ 229,206 $ 239,182 $ 232,744 Indirect Labor 800,982 857,054 820,868 Factory Real Estate Taxes 25,100 25,100 25,100 Indirect Materials 535,626 573,122 548,924 Total Overhead Costs $ 1,590,914 $ 1,694,458 $ 1,627,636 a) Analyze the data to determine the behavior of each cost. Indicate whether each cost is a variable cost,...
Suppose the following are the seasonal indices for the first three quarters of the year for...
Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 71.7 Q2 84.7 Q3 107.1 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,215 Time 75.9 What is the trend projection of the series for...
Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below...
Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below Sweetums Cookies, Inc.: A Master Budget CaseIntroductionYou knew they were good, but you never thought Grandma’s old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma’s cookie recipe to bake cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has...
Beasley Company prepared a cash budget by quarters for the upcoming year. Missing data amounts are...
Beasley Company prepared a cash budget by quarters for the upcoming year. Missing data amounts are indicated with question marks or lower case letters; these lower case letters will be referred to in the questions that follow. Beasley requires a minimum balance of $10,000 to start a quarter. All data are in thousands. Beasley Corporation Cash Budget QTR 1 QTR 2 QTR 3 QTR 4 Cash balance, beginning $16 $ e $13 $10 Add collections from customers a 70 67...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters...
Calculating the Cash Budget Wiggles, Inc., has estimated sales (in millions) for the next four quarters as follows: (40 ptos) Q1 Q2 Q3 Q4 Sales $105 $90 $122 $140 Sales for the first quarter of the year after this one are projected at $120 million. Accounts receivable at the beginning of the year were $34 million. Wiggles, has a 45-day collection period. Wiggle’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales,...
Compute ratios and please see additional information listed below. Apple Company Comparative Income Statements (000's omitted)...
Compute ratios and please see additional information listed below. Apple Company Comparative Income Statements (000's omitted) For the Years Ended December 31, 20x6 and 20x5 20x6 20x5 Net Sales $          360 $          290 Cost of Goods Sold              255              172 Gross Profit              105              118 Operating Expenses                84                65 Operating Income                21                53 Interest Expense                10                12 Income Before Income Taxes                11                41 Income Taxes                  4                16 Net...
Joplin Laminating Corporation reported income before income taxes during the first three quarters
Joplin Laminating Corporation reported income before income taxes during the first three quarters, and management’s estimates of the annual effective tax rate at the end of each quarter as shown below:   Required:Determine the income tax expense to be reported in the income statement in each of the three quarterly reports.  
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 185,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT