Answer -
1 and 2. Answer -
Total cash Collections | $245550 |
Total cash disbursements | $151400 |
Calculation:
1.
Expected Cash Collection from Customers | |
Cash sales-May | $87600 |
Collections on accounts receivable: | |
April 30 accounts receivable balance | $55750 |
May Sales ($204400 * 50%) | $102200 |
Total cash Collections | $245550 |
2.
Expected Cash disbursements for Merchandise Purchases | |
April 30 accounts payable balance | $65000 |
May Purchases ($216000 * 40%) | $86400 |
Total cash payments | $151400 |
3. Answer -
Minden Company | |
Cash Budget | |
For the Month of May | |
Beginning cash balance | $14300 |
Add: Collection from customers | $245550 |
Total cash available | $259850 |
Less: Cash disbursements | |
Purchase of inventory | $151400 |
Selling and administrative expenses | $82200 |
Purchases of equipment | $7100 |
Total cash disbursements | $240700 |
Excess of cash available over disbursements | $19150 |
Financing: | |
Borrowing-Note | $20500 |
Repayments-Note | ($16500) |
Interest | ($375) |
Total financing | $3625 |
Ending cash balance | $22775 |
4. Answer -
Minden Company | ||
Budgeted Income Statement | ||
For the Month of May | ||
Sales | $292000 | |
Cost of goods sold: | ||
Beginning inventory | $49250 | |
Add: Purchases | $216000 | |
Goods available for sales | $265250 | |
Less: Ending inventory | $72500 | |
$192750 | ||
Gross margin | $99250 | |
Selling and administrative expenses | $86700 | |
Net operating income | $12550 | |
Interest income | $375 | |
Net income | $12175 |
Calculation:
Selling and administrative expenses = $82200 + $4500 (depreciation expense) = $86700
5. Answer -
Minden Company | |
Budgeted Balance Sheet | |
May 31 | |
Assets | |
Cash | $22775 |
Accounts receivable | $102200 |
Inventory | $72500 |
Buildings and equipment, net of depreciation | $219600 |
Total assets | $417075 |
Liabilities and Stockholders Equity | |
Accounts payable | $129600 |
Notes payable | $20500 |
Common stock | $180000 |
Retained earnings | $86975 |
Total liabilities and stockholders equity | $417075 |
Calculation:
Accounts receivable = (50% * $204400) = $102200 (paid in June)
Buildings and equipment, net of depreciation = $217000 + $7100 (newly purchases) - $4500 (depreciation expense) = $219600
Accounts payable = ($216000 * 60%) = $129600 (paid in June)
Retained earnings = $74800 + $12175 (net income) = $86975
Cash = Total liabilities and stockholders equity - (Accounts receivable + Inventory + Buildings and equipment, net of depreciation)
Cash = $417075 - ($102200 + $72500 + $219600) = $22775
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of...
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 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 14,600 55,000 43,500 223,000 $ 336, 100 $ 74,500 15,000 180,000 66,600 $ 336,100 The company is in the process of preparing...
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 Total assets Liabilities and Stockholders' Equity Recounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 10,500 57,000 42,500 236,000 $ 346,000 $ 72,750 21,200 180,000 72,050 $ 346,000 The company is in the process of preparing a...
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 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity 18,700 70,250 41,250 230,000 $ 360,200 $ 72,250 13,700 180,000 94,250 $ 360,200 The company is in the process of preparing a budget...
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 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 10,000 62,750 32,750 219,000 $ 324,500 $ 69,000 22,700 180,000 52,800 324,500 $ The company is in the process of preparing a...
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 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 14,500 72,750 31,750 209,000 $ 328,000 $ 69,500 16,000 180,000 62,500 $ 328,000 The company is in the process of preparing a...
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 11,500 64,750 47,000 Cash Accounts receivable Inventory Buildings and equipment, net of depreciation 220,000 $ 343,250 Total assets Liabilities and Stockho lders ' Equity Accounts payable Note payable $ 70,750 19,900 180,000 72,600 Common stock Retained earnings Total liabilities and stockholders' equity $343,250 The company is in the process of preparing a...
Check my work Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below: Minden Coatpanty ance Sheet April 30 Sinn $ 10,00 70,000 43,000 227,000 $ 350, 300 Accoants receivable Inary Buildings and equipment, net of depreciation Total assets Liabilities and stockholders' Equity Acants payable Note payable Conan slock Retnine w ings Total liabilities and stokholders equiry $ 6,000 23.000 130,000 $ 350, 300 References The company is in...
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 9,400 78,500 44,000 221,000 $ 352,900 $ Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable $ 72,000 19,700 180,000 81,200 Common stock Retained earnings $ 352,900 Total liabilities and stockholders' equity The company is in the process of preparing a...
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 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 18,500 58,500 40,750 202,000 $ 319,750 $ 67,750 15,800 180,000 56,200 $ 319,750 The company is in the process of preparing a...
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 55,000 43,500 223,000 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets $336,100 Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings 74,500 15,000 180,000 66,600 $336,100 Total liabilities and stockholders' equity The company is in the process of preparing a budget for May and...