How to calculate budgeted cash collections

QUESTION 1

1.The following details have been extracted from the budget of a merchandising company.

Rent Expense $8,000 per month

Depreciation Expense $ 3,500 per month

Insurance Expense $1,250 per month

Miscellaneous Expense 2% of sales, paid as incurred

Commissions Expense 10% of sales

Salaries Expense $7,000 per month

Dec Jan Feb March

Sales $45,000 $50,000 $65,000 $80,000

Commission and salaries expenses are paid 50% in the month to which they relate and the balance in the next month.

Rent and miscellaneous expenses are paid as and when they occur. Insurance is prepaid at the beginning of the quarter. Calculate cash payments for the selling and administrative expenses for the first quarter of the next year.

$50,500

$75,000

$70,400

$62,750

1 points

QUESTION 2

1.June sales were $40,000 while projected sales for July and August were $50,000 and $60,000, respectively. Sales are 40% cash and 60% credit. All credit sales are collected in the month following the sale. Calculate expected collections for July.

$36,000

$54,000

$44,000

$50,000

1 points

QUESTION 3

1.Diemans Corp .has provided a part of its budget for the second quarter:

Apr May June

Cash collections $40,000 $45,000 $52,000

Cash payments:

Purchases of inventory 4,500 7,200 4,500

Operating expenses 7,900 5,600 9,000

Capital expenditures 0 20,000 4,600

The cash balance on April 1 is $12,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the cash balance at the end of June.

$40,800

$85,700

$21,800

$26,500

1 points

QUESTION 4

1.Which of the following best describes the term sensitivity analysis?

It evaluates a company's financial condition by doing financial statement analysis.

It is a testing technique to determine how results would differ if key assumptions are changed.

It is an evaluation of the accuracy of the assumptions.

It is an analysis of the emotional sensitivity of a company's employees.

1 points

QUESTION 5

1.Farmerlands Inc. has budgeted sales for the months of September and October at $300,000 and $280,000, respectively. Monthly sales are 80% credit and 20% cash. Of the credit sales, 50% are collected in the month of sale and 50% are collected in the following month. Calculate cash collections for the month of October.

$168,000

$288,000

$232,000

$290,000

1 points

QUESTION 6

1.Châtelain Company is preparing its budget for the third quarter. Cash balance on July 31 was $30,000. Assume there is no minimum balance of cash required and no borrowing is undertaken. Additional budgeted data is provided here:

Jul Aug Sep

Cash collections $50,000 $51,000 $52,000

Cash payments:

Purchases of inventory 20,000 19,000 18,000

Operating expenses 25,000 21,000 32,000

Capital expenditures 5,000 9,000 16,000

Calculate the balance of cash at the end of August.

$29,050

$32,000

$28,800

$19,100

1 points

QUESTION 7

1.McLeod Fries Inc. has budgeted sales for June and July at $680,000 and $720,000, respectively. Sales are 80% credit, of which 70% is collected in the month of sale and 30% is collected in the following month. What is the budgeted accounts receivable balance on July 31?

$ 225,320

$ 158,200

$ 200,500

$ 172,800

1 points

QUESTION 8

1.The cash budget and the budgeted financial statements are collectively known as the ________.

financial budget

master budget

operating budget

production budget

1 points

QUESTION 9

1.Gamma Corp. is preparing its budget for the first quarter of 2015. The following data is provided:

Inventory, Purchases and COGS Budget Jan Feb Mar

Cost of goods sold (a) $30,000 $28,500 $22,500

Desired ending inventory(b) 10,700 9,500 9,800

Total inventory required 40,700 38,000 32,300

less Beginning inventory -11,000 -10,700 -9,500

Purchases 29,700 27,300 22,800

(a) COGS = 75% of sales

(b) $5,000 + 20% of COGS for next month

The amount of Merchandise Inventory to be shown on the budgeted balance sheet at March 31 would be ________.

$9,500

$8,750

$10,700

$9,800

1 points

QUESTION 10

1.Fulkron Inc. provides the following data taken from its third quarter budget:

Jul Aug Sep

Cash collections $66,000 $42,000 $45,000

Cash payments:

Purchases of inventory 50,000 48,000 25,000

Operating expenses 10,000 15,000 20,000

Capital expenditures 0 32,000 6,000

The cash balance on June 30 is projected to be $10,000. Based on the above data, calculate the shortfall the company is projected to have at the end of September.

$43,000

$28,000

$40,000

$35,000

1 points

QUESTION 11

1.Which of the following is true of the sales budget?

It captures the variable and fixed expenses of the business.

It is used in the production budget.

It shows the value of expected production in a period.

It provides sales values that are used to prepare financial statements for external reporting purposes.

1 points

QUESTION 12

1.Which of the following describes the production budget?

It gives the quantity of finished goods to be manufactured during a budget period.

It depicts the breakdown of sales on the basis of terms and conditions of collection of sales revenue.

It helps in planning to ensure the business has adequate cash.

It aids in planning to ensure the company has adequate inventory and cash on hand.

1 points

QUESTION 13

1.Nobula Corp. is preparing their budget for the second quarter and provides the following data:

Apr May Jun

Budgeted purchases $20,000 $24,000 $18,000

Budgeted Cash Payments for Inventory Purchases Apr May Jun

60% of previous month purchases $6,000 $12,000 $14,400

40% of current month purchases 8,000 9,600 7,200

Total cash payments $14,000 $21,600 $21,600

Assume that accounts payable pertains only to suppliers of inventory. Based on the above data, the amount of Accounts Payable that should be shown in the budgeted balance sheet as on June 30 is ________.

$3,600

$10,800

$5,400

$12,000

1 points

QUESTION 14

1.Acme Inc. has prepared its third quarter budget and provided the following data:

Jul Aug Sep

Cash collections $50,000 $40,000 $48,000

Cash payments:

Purchases of inventory 31,000 22,000 18,000

Operating expenses 12,000 9,000 11,600

Capital expenditures 13,000 25,000 0

The cash balance on June 30 is projected to be $4,000. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the ending cash balance before financing for August.

($8,000)

$5,000

$9,000

$3,000

1 points

QUESTION 15

1.Which of the following describes the selling and administrative expenses budget?

It captures the variable and fixed components of selling and administrative expenses of the business.

It depicts the breakdown of sales based on terms of collection.

It shows the cash flows related to the selling and administrative expenses and helps in planning to ensure the business has adequate cash.

It aids in planning to ensure the company has adequate inventory on hand.

1 points

QUESTION 16

1.Uncle's Caps Inc. a merchandising company has provided the following budgeted amounts for the next budget period.

Balance of cash at the beginning $30,000

Cash collections 680,000

Payments for:

Purchase of inventory 350,000

Selling and administrative expenses 70,400

Capital expenditures 89,000

A minimum cash balance of $250,000 is required to be maintained. The company can borrow in increments of $10,000 as and when required. Assume the company can borrow the needed funds at the end of the period. Calculate the ending cash balance for the budget period.

$250,600

$540,230

$300,000

$320,300

1 points

QUESTION 17

1.Gamma Corp. has prepared a preliminary cash budget for the third quarter as shown below:

Cash Budget Jul Aug Sep

Beginning cash balance $32,000 $4,400 $6,900

Plus: Cash collections 49,400 51,000 44,600

Cash available $81,400 $55,400 $51,500

Less: Cash payments:

Purchases of inventory 36,000 9,000 11,000

Operating expenses 41,000 30,500 30,900

Capital expenditures 0 9,000 7,700

Ending cash balance $4,400 $6,900 $1,900

Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $52,000 in July, $50,000 in August, and $42,000 in September. Based on the new data, calculate the new projected cash balance at the end of September.

$7,000

$2,400

$8,500

$900

1 points

QUESTION 18

1.Freighters Inc. has the following budgeted figures:

JAN FEB MAR APRIL

SALES 50k 65k 70k 95k

Cost of goods sold 60% of Sales

Required ending inventory 15k + 25% of sales of next month

Inventory on hand on Jan 1st 27.5k

Calculate the ending merchandise inventory for the month of March.

$33,750

$52,000

$39,000

$38,750

1 points

QUESTION 19

1.Kapital Inc. has prepared the operating budget for the first quarter of 2015. They forecast sales of $50,000 in January, $60,000 in February, and $70,000 in March. Variable and fixed expenses are as follows:

Variable: Power cost (40% of Sales)

Miscellaneous expenses: (5% of Sales)

Fixed: Salary expense: $8,000 per month

Rent expense: $5,000 per month

Depreciation expense: $1,200 per month

Power cost/fixed portion: $800 per month

Miscellaneous expenses/fixed portion: $1,000 per month

Using the information above, calculate the amount of selling and administrative expenses for the month of February.

$47,500

$41,700

$43,000

$38,500

1 points

QUESTION 20

1.Acme Inc. has prepared its third quarter budget and provided the following data:

Jul Aug Sep

Cash collections $50,000 $40,000 $48,000

Cash payments:

Purchases of inventory 31,000 22,000 18,000

Operating expenses 12,000 9,000 11,600

Capital expenditures 13,000 25,000 0

The cash balance on June 30 is projected to be $4,000. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash.

How much will the company have to borrow at the end of July?

$5,000

$15,000

$0

$10,000