Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $40,000, marketable securities of $75,000, and accounts receivable of $300,000 ($60,000 from July sales and $240,000 from August sales). Sales on account for July and August were $200,000 and $240,000, respectively. Current liabilities as of September 1 include $40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $55,000 will be made in October. Bridgeport’s regular quarterly dividend of $25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $50,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Enter all amounts as positive values except for overall cash decrease and deficiency which should be indicated with a minus sign.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance be maintained in November. This situation can be corrected by and/or by the of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will the minimum desired balance.

Check My Work

The 2020 inventory data for Garden Corporation’s patio furniture Bermuda set is presented below. Assume that Garden uses periodic inventory tracking.

When Garden examines the actual units in ending inventory, they see that 15 of the units are from 2020 beginning inventory, 20 units are from the 1/20/20 purchase, and 60 units are from the 6/15/20 purchase.  

1. In a period of falling prices, which of the following statements is true?
   1. FIFO produces a lower amount of net income than LIFO
   2. LIFO produces a lower cost for ending inventory than FIFO
   3. Average cost produces a higher net income than FIFO or LIFO
   4. LIFO produces a higher cost of goods sold than FIFO

2. Heavenly Rest, Inc. uses a periodic inventory system. When a warehouse supervisor counts the inventory on December 31, 2019, he accidentally counts one pile of blankets twice, resulting in 2019 ending inventory being overstated by $100,000. The warehouse supervisor counts the December 31, 2020 inventory correctly. Which of the following statements is true related to Heavenly Rest's 2019 and 2020 financial statements?
   1. 2019 Cost of Goods Sold will be understated by $100,000.
   2. 2020 Beginning Inventory will be understated by $100,000.
   3. 2020 Cost of Goods Sold will be overstated by $100,000.
   4. All of the above are true.
   5. Both a and c are true.

3. On October 28, Unilever sells and ships $100,000 worth of merchandise to Target. The goods are shipped FOB shipping point and arrive at Target stores on November 4. Which of the following statements is TRUE?
   1. The goods are in transit on October 31 so neither company includes the $100,000 as part of its October 31 Inventory balance.
   2. Unilever includes the $100,000 as part of its October 31 Inventory balance.
   3. Target includes the $100,000 as part of its October 31 Inventory balance.
   4. Both companies include the $50,000 as part of their October 31 Inventory balances.

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $45,000, marketable securities of $64,000, and accounts receivable of $131,200 ($103,000 from July sales and $28,200 from August sales). Sales on account for July and August were $94,000 and $103,000, respectively. Current liabilities as of September 1 include $8,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $17,000 will be made in October. Bridgeport’s regular quarterly dividend of $8,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $44,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance   be maintained in November. This situation can be corrected by   and/or by the   of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will   the minimum desired balance.

1. Financial Statements and Closing Entries

   The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2018, the end of the fiscal year, the accountant for The Gorman Group prepared an end-of-period spreadsheet, part of which follows:

   The Gorman Group End-of-Period Spreadsheet For the Year Ended October 31, 2018
   	Adjusted Trial Balance
   Account Title	Dr.	Cr.
   Cash	$16,140
   Accounts Receivable	35,140
   Supplies	5,490
   Prepaid Insurance	11,860
   Land	125,000
   Buildings	449,000
   Accumulated Depreciation-Buildings		146,300
   Equipment	324,000
   Accumulated Depreciation-Equipment		190,500
   Accounts Payable		41,560
   Salaries Payable		4,120
   Unearned Rent		1,870
   Common Stock		187,000
   Retained Earnings		346,010
   Dividends	31,200
   Service Fees		592,650
   Rent Revenue		6,260
   Salaries Expense	424,870
   Depreciation Expense-Equipment	23,100
   Rent Expense	19,300
   Supplies Expense	13,670
   Utilities Expense	12,350
   Depreciation Expense-Buildings	8,240
   Repairs Expense	6,810
   Insurance Expense	3,730
   Miscellaneous Expense	6,370
   	1,516,270	1,516,270

   Required:

   1. Prepare an income statement.

   The Gorman Group Income Statement For the Year Ended October 31, 2018
   Revenues:
   Total Revenues
   Expenses:
   Total Expenses
   Net income

   Prepare a Retained Earnings Statement.

   The Gorman Group Retained Earnings Statement For the Year Ended October 31, 2018

   Prepare a balance sheet.

   The Gorman Group Balance Sheet October 31, 2018
   Assets				Liabilities
   Current assets:				Current liabilities:
   				Total liabilities
   Total current assets
   Property, plant, and equipment:				Stockholders' Equity
   Total property, plant, and equipment				Total stockholders' equity
   Total assets				Total liabilities and stockholders' equity

   2. Journalize the entries that were required to close the accounts at October 31. For a compound transaction, if a box does not require an entry, leave it blank.

   Date	Account	Debit	Credit
   2018
   Oct. 31 Close revenues
   Oct. 31 Close expenses
   Oct. 31 Close income/loss
   Oct. 31 Close dividends

   3. If Retained Earnings had instead decreased $43,600 after the closing entries were posted, and the dividends remained the same, what would have been the amount of net income or net loss? Enter all amounts as positive numbers.
   $  

Check My Work

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $40,000, marketable securities of $57,000, and accounts receivable of $118,500 ($93,000 from July sales and $25,500 from August sales). Sales on account for July and August were $85,000 and $93,000, respectively. Current liabilities as of September 1 include $10,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $16,000 will be made in October. Bridgeport’s regular quarterly dividend of $10,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $39,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance   be maintained in November. This situation can be corrected by   and/or by the   of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will   the minimum desired balance.

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $54,000, marketable securities of $77,000, and accounts receivable of $159,200 ($125,000 from July sales and $34,200 from August sales). Sales on account for July and August were $114,000 and $125,000, respectively. Current liabilities as of September 1 include $10,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $21,000 will be made in October. Bridgeport’s regular quarterly dividend of $10,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $53,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance will not be maintained in November. This situation can be corrected by borrowing and/or by the sale of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will exceed the minimum desired balance.

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $37,000, marketable securities of $53,000, and accounts receivable of $109,400 ($86,000 from July sales and $23,400 from August sales). Sales on account for July and August were $78,000 and $86,000, respectively. Current liabilities as of September 1 include $7,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $15,000 will be made in October. Bridgeport’s regular quarterly dividend of $7,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $36,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance   be maintained in November. This situation can be corrected by   and/or by the   of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will   the minimum desired balance.

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $41,000, marketable securities of $58,000, and accounts receivable of $120,800 ($95,000 from July sales and $25,800 from August sales). Sales on account for July and August were $86,000 and $95,000, respectively. Current liabilities as of September 1 include $6,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $17,000 will be made in October. Bridgeport’s regular quarterly dividend of $6,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $40,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance be maintained in November. This situation can be corrected by and/or by the of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will the minimum desired balance.

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $47,000, marketable securities of $67,000, and accounts receivable of $138,700 ($109,000 from July sales and $29,700 from August sales). Sales on account for July and August were $99,000 and $109,000, respectively. Current liabilities as of September 1 include $10,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $18,000 will be made in October. Bridgeport’s regular quarterly dividend of $10,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $46,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

The budget indicates that the minimum cash balance   be maintained in November. This situation can be corrected by   and/or by the   of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will   the minimum desired balance.

Financial Statements and Closing Entries

The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2018, the end of the fiscal year, the accountant for The Gorman Group prepared an end-of-period spreadsheet, part of which follows:

Required:

1. Prepare an income statement.

Prepare a retained earnings statement.

Prepare a balance sheet.

2. Journalize the entries that were required to close the accounts at October 31. For a compound transaction, if an amount box does not require an entry, leave it blank.

3. If the balance of Retained Earnings had instead increased $115,000 after the closing entries were posted, and the dividends remained the same, what would have been the amount of net income or net loss? Enter all amounts as positive numbers.
$