Solution
Minden Company
Minden Company |
|
Statement of expected cash collections for May: |
|
Cash sales |
$72,300 |
Collection of April Sales |
$67,000 |
Collection of May sales |
$84,350 |
Total cash collections for May |
$223,650 |
Note:
Credit sales for May = ½ x (241,000 – 72,300) = $168,700 x ½ = $84,350
Minden Company |
|
Statement of expected cash disbursement for merchandise purchases in May: |
|
Payment for April purchases |
$68,750 |
payment for May purchases |
$76,400 |
Total cash disbursements for merchandise purchases in May |
$145,150 |
Note – payment for purchases made in May = 191,000 x 40% = $76,400
Minden Company |
|
Cash Budget for May |
|
Beginning cash balance |
$16,500 |
Expected cash collections |
$223,650 |
Available cash |
$240,150 |
Cash Disbursements: |
|
for merchandise purchases |
$145,150 |
selling and administrative expenses |
$76,200 |
Purchase of equipment |
$6,600 |
Total disbursements |
$227,950 |
Excess of cash over disbursements |
$12,200 |
Financing: |
|
Borrowings |
$27,000 |
Repayments |
($20,500) |
Interest |
($170) |
Total financing |
$6,330 |
Ending Cash balance |
$18,530 |
Minden Company |
||
Budgeted Income Statement |
||
Sales |
$241,000 |
|
Cost of goods sold: |
||
Beginning inventory |
$32,000 |
|
add: purchases |
$191,000 |
|
cost of goods available for sale |
$223,000 |
|
Less: ending inventory |
($86,000) |
|
Cost of goods sold |
$137,000 |
|
Gross Margin |
$104,000 |
|
selling and administrative expenses |
$81,500 |
|
Net Operating Income |
$22,500 |
|
Interest Expense |
$170 |
|
Net Income |
$22,330 |
Note: Depreciation expense of $5,300 is included in the selling and administration expenses. Depreciation is a non-cash expense. Hence does not form part of cash budget statement created above.
However, depreciation of $5,300 is a monthly expense and would form part of the income statement.
Minden Company |
|
Budgeted Balance Sheet |
|
as on May 31 |
|
Assets: |
|
Cash |
$18,530 |
Accounts Receivable |
$84,350 |
Inventory |
$86,000 |
Building and equipment, net of depreciation |
$250,300 |
Total Assets |
$439,180 |
Liabilities and Stockholders' Equity: |
|
Liabilities |
|
Accounts Payable |
$114,600 |
Note Payable |
$27,000 |
Common Stock |
$180,000 |
Retained Earnings |
$117,580 |
Total Liabilities and Stockholders' Equity |
$439,180 |
Notes:
Beg. Balance = $249,000
Add: purchase of equipment = $6,600
Total = $255,600
Less: depreciation = $5,300
Building and equipment, net of depreciation May 31 = 250,300
Beg. Balance = $95,250
Add: net income = $22,330
Ending balance = $117,580
Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 3...
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 $ 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 as of April 30 is given below: Minden Company Balance Sheet April 30 Assets Cash $ 16,500 Accounts receivable 67,000 Inventory 32,000 Buildings and equipment, net of depreciation 249,000 Total assets $ 364,500 Liabilities and Stockholders’ Equity Accounts payable $ 68,750 Note payable 20,500 Common stock 180,000 Retained earnings 95,250 Total liabilities and stockholders’ equity $ 364,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 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 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 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 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...