Solution:
Minden Company | |
Schedule of Expected Cash collection | |
Cash Sales of May | 156000 |
Collection of Accounts Receivable: | |
April 30 Balance | 62000 |
May Credit sales [(520000-156000)*1/2] | 182000 |
Total Cash collection | 400000 |
Minden Company | |
Schedule of Expected Cash disbursement | |
April 30 Accounts payable balance | 72600 |
May Purchases (312000*40%) | 124800 |
Total Cash disbursement | 197400 |
Minden Company | |
Cash Budget | |
Beginning Cash Balance | 15400 |
Add: Collection from customers | 400000 |
Total cash available | 415400 |
Less: Cash Disbursement: | |
Purchase of Inventory | 197400 |
Selling and administrative expenses | 187200 |
Purchases of Equipment | 9700 |
Total Cash disbursement | 394300 |
Excess of cash available over disbursement | 21100 |
Financing: | |
Borrowing-Note | 52000 |
Repayments-Note | -17700 |
Interest | -100 |
Total Financing | 34200 |
Ending cash Balance | 55300 |
Minden Company | |
Budgeted Income Statement | |
For the month of May | |
Sales | 520000 |
Less: Cost of goods sold (34800+312000-104000) | 242800 |
Gross Margin | 277200 |
Less: Selling and administrative expenses (187200+5200) | 192400 |
Net Operating income | 84800 |
Less: Interest expense | 100 |
Net Income | 84700 |
Minden Company | |
Budgeted Balance Sheet | |
May-31 | |
Assets | |
Cash | 55300 |
Accounts receivable | 182000 |
Inventory | 104000 |
Building and Equipment, net of Depreciation (239000-5200+9700) | 243500 |
Total Assets | 584800 |
Liabilities and Stockholders' Equity | |
Accounts Payable (312000*60%) | 187200 |
Notes payable | 52000 |
Common stock | 212000 |
Retained earnings (48900+84700) | 133600 |
Total Liabilities and Stockholders' Equity | 584800 |
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April...
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 $ 10,600 56,000 31,200 215,000 Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation Total assets $312,800 Liabilities and Shareholders' Equity $ 65,400 15,300 188,000 44,100 Accounts payable, suppliers Note payable Capital shares, no par Retained earnings $312,800 Total liabilities and shareholders' equity 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...
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 $ 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 Cash Accounts receivable Inventory Buildings and equipment, net of depreciation $ 10,300 70,000 43,000 227,000 Total assets $350,300 Liabilities and Shareholders' Equity Accounts payable Note payable $86,000 23,000 180,000 Common shares Retained earnings 61,300 350,300 Total liabilities and shareholders' equity 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 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,500 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 9364,500 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 $ 9,800 Accounts receivable, customers 55,000 Inventory 30,600 Buildings and equipment, net of depreciation 211,000 Total assets $ 306,400 Liabilities and Shareholders’ Equity Accounts payable, suppliers $ 64,200 Note payable 14,900 Capital shares, no par 184,000 Retained earnings 43,300 Total liabilities and shareholders’ equity $ 306,400 The company is in the process...
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 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...