Question

In: Accounting

Cash Budget Cash budgeting for Nichole Mango, a merchandising firm, is performed on a quarterly basis....

Cash Budget

Cash budgeting for Nichole Mango, a merchandising firm, is performed on a quarterly basis. The company is planning its cash needs for the third quarter of 2017, and the following information is available to assist in preparing a cash budget. Budgeted income statements for July through October 2017 are as follows:

                                                                               July              August            September       October

Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $22,000        $28,000           $32,000            $40,000

Cost of goods sold  . . . . . . . . . . . . . . . . . . . . (11,000)          (15,000)            (17,000)          (21,000)

Gross profit. . . . . . . . . . . . . . . . . . . . . . . . . . .   11,000            13,000               15,000               19,000

Less other expenses

Selling  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .       3,300              4,000                    4,400              5,200

Administrative. . . . . . . . . . . . . . . . . . . . . .          3,600             5,000                   4,200                 4,600

Total  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .      (6,900)         (9,000)                 (8,600)              (9,800)

Net income. . . . . . . . . . . . . . . . . . . . . . . . . . .      $4,100        $4,000                   $6,400               $9,200

Additional information follows:

1. Other expenses, which are paid monthly, include $2,000 of depreciation per month.

2. Sales are 40 percent for cash and 60 percent on credit.

3. Credit sales are collected 25 percent in the month of sale, 65 percent one month after sale, and 10 percent two months after sale. May sales were $16,000, and June sales were $17,000.

4. Merchandise is paid for 50 percent in the month of purchase; the remaining 50 percent is paid in the following month. Accounts payable for merchandise at June 30 totaled $7,000.

5. The company maintains its ending inventory levels at 20 percent of the cost of goods to be sold in the following month. The inventory at June 30 is $2,200.

6. An equipment note of $6,000 per month is being paid through August.

7. The company must maintain a cash balance of at least $6,000 at the end of each month. The cash balance on June 30 is $6,100.

8. The company can borrow from its bank as needed. Borrowings and repayments must be in multiples of $100. All borrowings take place at the beginning of a month, and all repayments are made at the end of a month. When the principal is repaid, interest on the repayment is also paid. The interest rate is 12 percent per year.

Required

a. Prepare a monthly schedule of budgeted operating cash receipts for July, August, and September.

b. Prepare a monthly purchases budget and a schedule of budgeted cash payments for purchases for

July, August, and September.

c. Prepare a monthly cash budget for July, August, and September. Show borrowings from the company’s bank and repayments to the bank as needed to maintain the minimum cash balance.

Solutions

Expert Solution


Related Solutions

Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter. a. As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:   Cash $ 13,100   Accounts receivable 55,800   Inventory 18,620   Buildings and equipment (net) 135,000   Accounts payable $ 47,000   Common stock 115,000   Retained earnings 60,520 $ 222,520 $ 222,520 b. Actual...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter a. As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:   Cash $ 13,100   Accounts receivable 55,800   Inventory 18,620   Buildings and equipment (net) 135,000   Accounts payable $ 47,000   Common stock 115,000   Retained earnings 60,520 $ 222,520 $ 222,520 b. Actual...
An investment firm (Firm A) pays 10% interest per annum, compounded on a quarterly basis. To...
An investment firm (Firm A) pays 10% interest per annum, compounded on a quarterly basis. To remain competitive, the investment manager of another firm (Firm B) is willing to match the interest rate offered by Firm A, but interest will be compounded on a monthly basis. What nominal rate of interest must Firm B offer to its clients?
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT