cash budget:
cash budget for the month ended june 30 | |
amount($) | |
cash balance , june 1 | 33000 |
cash collections | 442000 |
Total cash available | 475000 |
cash disbursements: | |
payment for purchase of inventory | 234000 |
selling and administrative expenses | 138000 |
equipment purchases | 64000 |
dividends | 18000 |
Total cash disbursements | 454000 |
Excess(deficiency)of cash available | 21000 |
financing: | |
borrowing on line-of-credit | 9000 |
cash balance,june 30 | 30000 |
note:1) cash collection schedule
particulars | may | june |
credit sales | 410000 | 350000 |
collections: | ||
30% in the month of sale | 123000 | 105000 |
70% in the following month | 287000 | |
add:cash sales | 40000 | 50000 |
Total collections | 163000 | 442000 |
cash payment schedule:
particulars | june |
total credi purchase made in june | 265000 |
payment: | |
60% during the month | 159000 |
paid for may purchase | 75000 |
Total payments | 234000 |
the depreciation is a non cash item and hence excluded from the fixed costs.
income statement amounts
sales revenue | $400000 |
selling and administrative expenses | $152000 |
calculation:
1) sales revenue=cash sale+credit sale=50000+350000=$400000
2) selling and administrative expenses includes both variable and fixed=20% x 400000+72000=$152000.
Balance sheet amounts
cash | $30000 |
accounts receivable | $245000 |
accounts payable | $106000 |
ending retained earnings | $357000 |
calculations:
1) cash balance is the minimum amount as per company's policy.
2) accounts receivable=70% of credit sale of june=$350000x70%=$245000
3) accounts payable=40% of june credit purchase=40%x$265000=$106000
4) ending retained earnings=beginning retained earnings+net income of the current year-dividend of the current year
ie $280000+$95000-$18000=$357000.
answer the required 1A-D and 2 Check my work Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Balance Sheet Cash Accounts receivable $ 75,200 60,000 46,800 210,000 Inventory Buildings and equipment, net of depreciation $392,000 Total assets Liabilities and Stockholders' Equity payable Common stock Retained earnings $ 52,000 100,000 240,000 392,000 Total 1iabilities and stockholders equity Budgeting Assumptions: 1, All sales are on account. Thirty percent...
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...
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...
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 Accounts receivable Inventory Buildings and equipment, net of depreciation $ 16,500 67,000 32,000 249,000 Total assets $364,600 Liabilities and Shareholders' Equity Accounts payable Note payable Common shares Retained earnings $ 68,750 20,500 180,000 95,250 Total liabilities and shareholders' equity $364,500 The company is in the process of preparing a budget for...
2. Prepare a budgeted balance sheet as of July 31. Help Save&ExitSubm Check my work halance Sheet June 30 Assets Cash 79,200 68,600 40,200 Accounts receivable Inventory Buildings and equipment,net of depreciation213,000 Total assets Liabilities and Stockholders' Equity Accounts payable Conmon stock 401,000 56,00o 100,000 Total liabilities and stockholders equity s 401,000 Budgeting Assumptions: 1. All sales are on account. Thirty percent of the credit sales are collected in the month of sale and the remaining 70% are collected in...
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...
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 $ 16,500 Accounts receivable 67,000 Inventory 32,000 Buildings and equipment, net of depreciation 249,000 Total assets $ 364,500 Liabilities and Stockholders’ Equity Accounts payable $ 68,750 Note payable 20,500 Common stock 180,000 Retained earnings 95,250 Total liabilities and stockholders’ equity $ 364,500 The company is in the process of preparing a...