A management accountant was working on a cash budget for Boone Company when he

accidentally spilled his coffee. Some of the liquid splattered on his working papers, rendering a few

of the amounts illegible. The budget with missing amounts indicated is provided below:

Boone Company

Cash Budget

For the Quarter Ended March 31

January February March

Section 1: Cash Receipts

Beginning cash balance $ 6,000 (f) (k)

Add: Cash receipts (a) 187,000 250,000

Total cash available $ 260,000 (g) (l)

Section 2: Cash Payments

For inventory purchases $ 127,000 $ 113,000 $ 118,500

For S&A expenses (b) 67,000 69,000

For asset purchases 37,000 37,000 37,000

For interest expenses 0 0 (m)

Total disbursements $ 240,000 $ 217,000 $ 225,170

Section 3: Financing Activities

Surplus (shortage) (c) (h) (n)

Borrowing (repayments) (d) (i) (o)

Ending cash balance (e) (j) (p)

The company desires to maintain an ending cash balance of at least $7,000 each month. In any

month in which there is cash shortage, the company's bank will extend it a loan equal to the

shortage amount. The loan is assumed to have been made on the last day of the month. Any time the

company has a cash surplus it must repay as much of any outstanding loans as possible. The bank

charges monthly interest of 1% on any outstanding loan balance.

Required: Compute the missing amounts for items (a) through (p) (show work)

(a) $ (i) $

(b) $ (j) $

(c) $ (k) $

(d) $ (l) $

(e) $ (m) $

(f) $ (n) $

(g) $ (o) $

(h) $ (p) $

(k) 4. A management accountant was working on a cash budget for Boone Company when he accidentally spilled his coffee. Some of the liquid splattered on his working papers, rendering a few of the amounts illegible. The budget with missing amounts indicated is provided below: Boone Company Cash Budget For the Quarter Ended March 31 January February March Section 1: Cash Receipts Beginning cash balance $ 6,000 (1) Add: Cash receipts 187,000 250,000 Total cash available $ 260,000 (1) Section 2: Cash Payments For inventory purchases $ 127,000 $ 113,000 $ 118,500 For S&A expenses (b) 67,000 69,000 For asset purchases 37,000 37,000 37,000 For interest expenses 0 Total disbursements $ 240,000 $ 217,000 $ 225,170 Section 3: Financing Activities Surplus (shortage) (c) (h) (n) Borrowing (repayments) (d) (i) (0) Ending cash balance (e) 6) (p) The company desires to maintain an ending cash balance of at least $7,000 each month. In any month in which there is cash shortage, the company's bank will extend it a loan equal to the shortage amount. The loan is assumed to have been made on the last day of the month. Any time the company has a cash surplus it must repay as much of any outstanding loans as possible. The bank charges monthly interest of % on any outstanding loan balance. Required: Compute the missing amounts for items (a) through (p) (show work) (a) s (i) $ (b) s 6) S (c) S (k) S (d) (1) $ (e)s (m) S (1) S (n) S (g) S (0) $ (h) S (p) S