3.Cash Budget for May
Receipts | Dr. | Payments | Cr. |
Opening balance of cash | $10,000 |
Purchase of Inventory (40% of $137,000) |
$54,800 |
Cash Sales | $76,200 | April accounts payable | $69,000 |
Credit sales collected ( $254,000 - $76,200 = $177,800 / 2 = $88,900/-) |
$88,900 | Selling & Administrative Expenses | $98,400 |
April accounts receivable | $62,750 |
Notes Payable ($22,700+$350) |
$23,050 |
Borrowing from bank | $27,400 | Purchase of refrigerating equipment | $8,700 |
Total Receipts | $265,250 | Total Payments | $253,950 |
Opening Balance of cash in June | $11,300 |
1. The expected cash collection for May will exclude the borrowing from the bank and opening balance = $227,850/-
2. The total cash disbursement for merchandise purchase for May = $54,800/-
4. Budgeted income statement for May
Particulars | Amount($) | |
Revenue | $254,000 | |
Less COGS | Nil | |
Gross Profit | $254,000 | |
Less Operating Expenses: |
||
Selling & Admin expenses | $98,400 | |
Depreciation expenses | $5,550 | |
Interest on notes payable | $350 | $104,300 |
Net income / Profit | $149,700 |
5. Budgeted balance sheet as of May 31 :
Liabilities | Amount($) | Assets | Amount($) |
Accounts Payable | $82,200 | Cash | $11,300 |
Notes Payable | $27,400 | Accounts Receivable | $88,900 |
Common Stock | $180,000 | Inventory | $45,000 |
Retained Earnings $52,800+$149,700) | $202,500 |
Building & Equipment(less depreciation) ($219,000 - $5,550=$213,450) |
$213,450 |
Refrigeration Equipment | $8,700 | ||
Total Liabilities | $492,100 | Total Assets | $367,350 |
Balance Sheet April 30 Assets Cash $ 10, eee Accounts receivable 62.750 Inventory 32,750 Buildings and...
Check my wol 10 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 points Skipped $ 69,000 22,700 180,000 52,800 $ 324,500 eBook Print The company is in the process of preparing a budget for May and has assembled the following data: References a. Sales are...
Balance Sheet April 30 Assets Cash $ 12,700 Accounts receivable 66,500 Inventory 48,500 Buildings and equipment, net of 229,000 depreciation Total assets $356,700 Liabilities and Stockholders' Equity Accounts payable $ 67,500 Note payable 19,100 Common stock 180,000 Retained earnings 90,100 Total liabilities and stockholders' equity $356,700 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $262.000 for May. Of these sales. $78,600 will be for cash;...
$ 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 12,000 77,500 42,000 225,000 356,500 $ $ 78,250 19,300 180,000 78,950 356,500 $ The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $231,000 for May. Of these sales, $69,300...
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 $ 10,000 Accounts receivable 62,750 Inventory 32,750 Buildings and equipment, net of depreciation 219,000 Total assets $ 324,500 Liabilities and Stockholders’ Equity Accounts payable $ 69,000 Note payable 22,700 Common stock 180,000 Retained earnings 52,800 Total liabilities and stockholders’ equity $ 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 $ 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 wholesalle 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 $ 9,500 56,500 53,250 234,000 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets $353,250 Liabilities and Stockholders Equity Accounts payable Note payable Common stock Retained earnings $ 79,000 20,000 180,000 74,250 Total liabilities and stockholders' equity $ 353,250 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 9,100 77,250 40,000 239,000 365,350 $ $ 79,750 12,300 180,000 93,300 365,350 $ 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 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...
w Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total Habilities and stockholders equity 71.800 42.80 46,000 149,000 309,600 points $ Skipped $ 125, 100 70,000 114,500 $ 309,600 eBook References Budgeted Income Statements April Sales $120,000 Cost of goods sold 72,000 Gross margin 48,000 Selling and administrative expenses 18,100 Net operating income $ 29,900 May $130,000 78,000 52.000 19,600 $...