1) Expected Cash Collection for May (Amounts in $)
Cash Sales | 79,800 |
Collection of credit sales: | |
50% of credit sales for May [(266,000-79,800)*50%] | 93,100 |
Accounts Receivable on April 30 | 77,250 |
Total expected cash collections | 250,150 |
2) Expected Cash Disbursements for Purchases for May (Amounts in $)
Cash Payments for: | |
Accounts Payable as on April 30 | 79,750 |
40% of purchases in May ($170,000*40%) | 68,000 |
Total expected cash disbursements for purchases | 147,750 |
3) Cash Budget for the Month of May (Amounts in $)
Beginning Cash Balance | 9,100 |
Total expected cash collections | 250,150 |
Total Cash Available (A) | 259,250 |
Cash disbursements: | |
Total cash payments for purchases | 147,750 |
Selling and administrative expenses (except dep.) | 81,900 |
Purchase of Refrigerator | 9,600 |
Total cash disbursements (B) | 239,250 |
Excess or Deficit of Cash (C = A-B) | 20,000 |
Financing: | |
Issue of Notes Payable | 23,400 |
Repayment of note | (12,300) |
Interest on note | (140) |
Total Financing (D) | 10,960 |
Ending Cash Balance (C+D) | 30,960 |
4) Budgeted Income Statement for May (Amounts in $)
Sales (A) | 266,000 | |
Cost of goods sold: | ||
Beginning Inventory | 40,000 | |
Merchandise Purchases | 170,000 | |
Ending Inventory | (44,500) | |
Cost of goods sold (B) | 165,500 | |
Gross Profit (C = A-B) | 100,500 | |
Expenses: | ||
Selling and Administrative expenses | 81,900 | |
Depreciation | 6,450 | |
Interest on Notes Payable | 140 | |
Total expenses (D) | 88,490 | |
Net Income (C-D) | 12,010 |
5) Budgeted Balance Sheet as of May 31 (Amounts in $)
Minden Company | |
Balance Sheet | |
May 31 | |
Assets | |
Cash | 30,960 |
Accounts Receivable [(266,000-79,800)*50%] | 93,100 |
Inventory | 44,500 |
Buildings and equipment, net of depreciation (239,000+9,600-6,450) | 242,150 |
Total assets | 410,710 |
Liabilities and Stockholders Equity | |
Accounts Payable ($170,000*60%) | 102,000 |
Note Payable | 23,400 |
Common Stock | 180,000 |
Retained Earnings (93,300+12,010 net income) | 105,310 |
Total Liabilities and Stockholders Equity | 410,710 |
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is...
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 9,600 54,750 53,750 214,000 332,100 $ $ 70,500 18,100 180,000 63,500 332,100 $ 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 S 16,500 67,000 32,000 249,000 Accounts receivable Inventory Buildings and equipment, net of depreciation $364,500 Total assets Liabilities and Stockholders Equity Accounts payable Note payable S 68,750 20,500 180,000 95,250 Common stock Retained earnings $ 364,500 Total liabilities and stockholders' equity 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 on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation $ 15.400 62,000 34,800 239,000 Total assets $351,200 Liabilities and Shareholders' Equity Accounts payable, suppliers $ 72,600 Note payable 17,700 Capital shares, no par 212,000 Retained earnings 48,900 Total liabilities and shareholders' equity $351,200 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 $ 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...
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 Accounts receivable Inventory Buildings and equipment, net of depreciation $ 10,300 70,000 43,000 227,000 Total assets 350,300 Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings $86,000 23,000 180,000 61,300 Total liabilities and stockholders' equity 350,300 The company is in the process of preparing a budget for May 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,700 75,500 37,000 258,000 Accounts receivable Inventory Buildings and equipment, net of depreciation 387,200 Total assets Liabilities and Stockholders' Equity Accounts payable Note payable 86,750 15,700 180,000 104,750 Common stock Retained earnings Total liabilities and stockholders' equity S387,200 The company is in the process of preparing a budget for May 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 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...
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 282,280 $319,750 67,750 15,800 180.000 56,200 319,750 $ The company is in the process of preparing a budget for May...
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation $ 15,400 62.000 34,800 239,000 Total assets $351,200 Liabilities and Shareholders' Equity Accounts payable, suppliers $ 72,600 Note payable 17,700 Capital shares, no par 212,000 Retained earnings 48.900 Total liabilities and shareholders' equity $351.200 The company is in the process of preparing...
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation $ 13,000 59,000 33,000 227,000 Total assets $332,000 Liabilities and Shareholders' Equity Accounts payable, suppliers $ 69,000 Note payable 16,500 Capital shares, no par 200,000 Retained earnings 46,500 Total liabilities and shareholders' equity $332,000 The company is in the process of preparing...