1. Cash Collections for May :
Particulars | May | June |
Total Sales | $263000 | |
Cash Sales | $78900 | |
Credit Sales | $184100 | |
Credit Sales Collections | $92050 | $92050 |
Collections from April | $58500 | |
Expected cash collections from customers | $229450 |
2. Expected Cash disbursements for merchandise Purchases for May
40% of Purchases are paid in the month of purchase , remainder in the following month
Particulars | April | May | Cash disbursement in May |
Total Purchases | $112917 | $193000 | |
40% in the month of purchase | $45167 | $77200 | $77200 |
Remainder 60% in the next month | $67750 | $115800 | $67750 |
Expected cash disbursement in May | $144950 |
3. Cash Budget for May :
Particulars | Amountin $ |
Opening Balance | $18500 |
Cash Sales | $78900 |
Collections from customers | $150550 |
Borrowed money received | $27200 |
Total Cash receipts during May(A) |
$275150 |
Payments : | |
Cash disbursements for purchases | $144950 |
Selling & administraction expenses | $73200 |
Repayment of note payable | $15800 |
Interest on note payable | $210 |
New Refrigerating Equipment purchase | $11900 |
Total Payments (B) | $246060 |
Closing balance (A-B) | $29090 |
4. Budgeted incoome statement:
Particulars | Amount |
Sales | $263000 |
Less: Cost of goods sold ($193000-$63000) | $130000 |
Gross Profit | $133000 |
Selling & administrativee expenses | $73200 |
Depreciation expense | $4650 |
Interest expense | $210 |
Net Income before tax | $54940 |
5. MindenCompany
Budgeted Balance Sheet :
Assets | Note | Amount |
Cash | Closing balanceof cash budget | $29090 |
Accounts Receivable | Remaining 50% to be realized in June | $92050 |
Inventory | Closing balance at the end of May given plus opening balance ($40750+$63000) | $103750 |
Buildings and equipments | after additional equipment and Net of depreciation | $209250 |
Total Assets | $434140 | |
Liabilities and Stockholder's equity | ||
Accounts Payable | From cash disbursement table, 60% in the next month of purchase | $115800 |
Note Payable | $27200 | |
Common stock | 180000 | |
Retained earnings | Previous balance plus current profit ($56200+54940) | $111140 |
Total liabilities | $434140 |
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 $ 9,500 56,500 53, 250 234,000 $ 353, 250 $ 79,000 20,000 180,000 74,250 $ 353, 250 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 $ 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 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 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 $ 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 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 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...
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 $ 11,400 75,000 41,000 224,000 $ 351,400 $ 70,000 15,500 180,000 85,900 $ 351,400 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 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...