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’ equity | $ | 305,000 |
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.
1.
a.
Expected cash collections | 77,000 |
Less: Cash collections of June | 50,000 |
July cash collection on sale | 27,000 |
% of cash sales | 30% |
Budgeted Total sales [27000/30%] | 90000 |
b.
Expected cash disbursements for merchandise purchases | 44500 |
Less: Accounts payable of July | 35300 |
Accounts payable at June | 9200 |
% of cash payments | 20% |
Budgeted Total purchases [ 9200/20%] | 46000 |
c.
Inventory at June | 30,000 |
Add: Purchases | 46000 |
Less: Closing inventory | 22000 |
Budgeted cost of goods sold | 54,000 |
d.
Sales | 90000 |
Less: COGS | 54,000 |
Gross Profit | 36,000 |
Less: Expenses | |
Depreciation | 3000 |
Selling and admin expenses | 15000 |
Net Income | 18,000 |
2.
Assets | |
Cash [75000+77000-44500-15000] |
92500 |
Accounts receivable | 63000 |
Inventory | 22000 |
Buildings and equipment, net of depreciation | 147000 |
Total assets | 324500 |
Liabilities and Stockholders’ Equity | |
Accounts payable | 36800 |
Common stock | 100000 |
Retained earnings | 187,700 |
Total liabilities and stockholders’ equity | 324500 |
Exercise 8-18 Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10] Wolfpack Company...
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...
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...
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...
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...
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...