Exercise 8-18 (REV) Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10]
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information:
Wolfpack Company Balance Sheet June 30 |
||
Assets | ||
Cash | $ | 92,200 |
Accounts receivable | 50,400 | |
Inventory | 30,800 | |
Buildings and equipment, net of depreciation | 177,000 | |
Total assets | $ | 350,400 |
Liabilities and Stockholders’ Equity | ||
Accounts payable | $ | 53,400 |
Common stock | 100,000 | |
Retained earnings | 197,000 | |
Total liabilities and stockholders’ equity | $ | 350,400 |
Budgeting Assumptions:
Required:
1. For the month of July, calculate the following:
a. Budgeted sales
b. Budgeted merchandise purchases
c. Budgeted cost of goods sold
d. Budgeted net operating income
2. Prepare a budgeted balance sheet as of July 31.
Answer 1-a.
Cash Collections during July = Accounts Receivable + 30% * Sales
during July
$81,300 = $50,400 + 30% * Sales during July
$30,900 = 30% * Sales during July
Sales during July = $103,000
Answer 1-b.
Cash Disbursement during July = Accounts Payable + 20% *
Merchandise Purchases during July
$63,000 = $53,400 + 20% * Merchandise Purchases during July
$9,600 = 20% * Merchandise Purchases during July
Merchandise Purchases during July = $48,000
Answer 1-c.
Cost of Goods Sold = Beginning Inventory + Purchases - Ending
Inventory
Cost of Goods Sold = $30,800 + $48,000 - $17,000
Cost of Goods Sold = $61,800
Answer 1-d.
Net Operating Income = Sales - Cost of Goods Sold - Selling and
Administrative Expenses - Depreciation
Net Operating Income = $103,000 - $61,800 - $17,060 - $3,540
Net Operating Income = $20,600
Answer 2.
Ending Cash = Beginning Cash + Cash Collections - Cash
Disbursements - Selling and Administrative Expenses
Ending Cash = $92,200 + $81,300 - $63,000 - $17,060
Ending Cash = $93,440
Accounts Receivable = 70% * Sales during July
Accounts Receivable = 70% * $103,000
Accounts Receivable = $72,100
Ending Building and Equipment = Beginning Building and Equipment
- Depreciation
Ending Building and Equipment = $177,000 - $3,540
Ending Building and Equipment = $173,460
Accounts Payable = 80% * Merchandise Purchases during July
Accounts Payable = 80% * $48,000
Accounts Payable = $38,400
Ending Retained Earnings = Beginning Retained Earnings + Net
Operating Income
Ending Retained Earnings = $197,000 + $20,600
Ending Retained Earnings = $217,600
Exercise 8-18 (REV) Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10] Wolfpack...
Exercise 8-18 Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10] Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 50,000 Inventory 30,000 Buildings and equipment, net of depreciation 150,000 Total assets $ 305,000 Liabilities and Stockholders’ Equity Accounts payable $ 35,300 Common stock 100,000 Retained earnings 169,700 Total liabilities and stockholders’...
Exercise 8-18 Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, L08-3, L08-9, L08- 10] Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 89,00 54,28 48.eee 238,888 $ 422,eee 257.ee $ 422,de...
Exercise 8-17 (REV) Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-4, LO8-9, LO8-10] Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 69,800 Accounts receivable 98,000 Inventory 37,800 Buildings and equipment, net of depreciation 310,000 Total assets $ 515,600 Liabilities and Stockholders’ Equity Accounts payable $ 145,100 Common stock 216,000 Retained earnings 154,500 Total liabilities and stockholders’ equity $ 515,600...
Problem 8-19 (REV) Cash Budget; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below: Minden Company Balance Sheet April 30 Assets Cash $ 14,600 Accounts receivable 55,000 Inventory 43,500 Buildings and equipment, net of depreciation 223,000 Total assets $ 336,100 Liabilities and Stockholders’ Equity Accounts payable $ 74,500 Note payable 15,000 Common stock 180,000 Retained earnings 66,600 Total liabilities...
Required information Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet (LO8-2, LO8-4, LO8-9, LO8-10) [The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity...
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet(LO8-2, LO8-4, LO8-9, LO8-10) (The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 78,400 Accounts receivable 65,800 Inventory 35,200 Buildings and equipment, net of depreciation 214,000 Total assets $ 393,400 Liabilities and Stockholders’ Equity Accounts payable $ 60,400 Common stock 100,000 Retained earnings 233,000 Total liabilities and stockholders’ equity $ 393,400 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 81,600 Accounts receivable 59,600 Inventory 42,800 Buildings and equipment, net of depreciation 152,000 Total assets $ 336,000 Liabilities and Stockholders’ Equity Accounts payable $ 57,000 Common stock 100,000 Retained earnings 179,000 Total liabilities and stockholders’ equity $ 336,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 91,400 Accounts receivable 67,200 Inventory 31,000 Buildings and equipment, net of depreciation 165,000 Total assets $ 354,600 Liabilities and Stockholders’ Equity Accounts payable $ 62,600 Common stock 100,000 Retained earnings 192,000 Total liabilities and stockholders’ equity $ 354,600 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...