Schedule of cash collection | ||||
July | Aug | Sept | Quarter | |
Sales | 3,90,000 | 4,10,000 | 4,00,000 | 12,00,000 |
From accounts receivable | 1,39,000 | 1,39,000 | ||
from july sales | 1,75,500 | 2,14,500 | 3,90,000 | |
from august sales | 1,84,500 | 2,25,500 | 4,10,000 | |
from september sales | 1,80,000 | 1,80,000 | ||
total cash collections | 3,14,500 | 3,99,000 | 4,05,500 | 11,19,000 |
Merchandise purchase budget | ||||
july | Aug | Sept | Quarter | |
cost of goods sold @ 60%of Sales | 2,34,000 | 2,46,000 | 2,40,000 | 7,20,000 |
Ending inventory (20% of next Month COGS) | 49,200 | 48,000 | 50,400 | 50,400 |
Total needs | 2,83,200 | 2,94,000 | 2,90,400 | 7,70,400 |
Less: Beginning merchandise inventory | 70,200 | 49,200 | 48,000 | 70,200 |
Required purchases | 2,13,000 | 2,44,800 | 2,42,400 | 7,00,200 |
Sept , Endding Inventory:= October sales X 60%X 20% |
Schedule of cash disbursement | ||||
july | Aug | Sept | Quarter | |
From accounts payable | 89,000 | 89,000 | ||
from july purchase | 63,900 | 1,49,100 | 2,13,000 | |
from August purchase | 73,440 | 1,71,360 | 2,44,800 | |
From september purchase | 72,720 | 72,720 | ||
total cash disbursements | 1,52,900 | 2,22,540 | 2,44,080 | 6,19,520 |
income statement | ||
sales | 12,00,000 | |
Less: cost of goods sold | 7,20,000 | |
Gross margin | 4,80,000 | |
Less: Selling and administrative expense (54000*3) | 1,62,000 | |
net operating income | 3,18,000 | |
interest expense | - | |
net income | 3,18,000 |
Balance sheet | ||
Assets | ||
Cash | 4,54,480 | |
Account receivable (400000*55%) | 220000 | |
inventory | 50,400 | |
plant and Equipment ,net | 2,07,000 | |
(228000-21000 dep) | ||
total assets | 9,31,880 | |
Liabilities & Stockholders Equity | ||
Accounts payable (242400*70%) |
169680 | |
Common stock | 3,33,000 | |
Retained earnings (111200+318000) |
429200 | |
Total liabilities & stockholders equity | 9,31,880 |
cash = opening + receipts - disbursement - selling expense (43000*3) | |
96000+1119000- 619520-(47000X3)=$4,54,480 |
please show steps thanks! Required information The following information applies to the questions displayed below Beech...
Required information [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 90,000 136,000 62,000...
Required information [The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 81,000 132,000 56,250...
Required information (The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 92,000 130,000 48,600...
Saved automatic | Che Required information [The following information applies to the questions displayed below] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 96,000 139,000 70,200 228,000 $ 533,200 Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stokkholders Equity Accounts payable Conmon stock...
Chel Required information The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stokkholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 96,000 139,000 70.200...
Required information The following information applies to the questions displayed below.) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Coomon stock Retained earnings Total liabilities and stockholders' equity $ 71,000 131.000 45.500...
Required information
[The following information applies to the questions
displayed below.]
Beech Corporation is a merchandising company that is preparing a
master budget for the third quarter of the calendar year. The
company’s balance sheet as of June 30th is shown below:
Beech Corporation
Balance Sheet
June 30
Assets
Cash
$
73,000
Accounts receivable
125,000
Inventory
56,000
Plant and equipment, net of depreciation
221,000
Total assets
$
475,000
Liabilities and Stockholders’
Equity
Accounts payable
$
82,000
Common stock
309,000
Retained...
[The following information applies to the questions displayed below) Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below. Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 90,000 136,000 62,000 210,000 $498,000...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 72,000 128,000 60,900 218,000 $ 478,900 $ 79,000 308,000 91,900 $ 478,900 Beech's managers...
Help please
[The following information applies to the questions displayed below. Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below Beech Corporation Balance Sheet June 30 Assets इ96/०0० 139,000 70,200 228,000 Cash Accounts receivable Inventory Plant and equipment, net of depreciation $533 200 Total assets Liabilities and Stockholders Equity Accounts payable Common stock Retained earnings |৪9,000 333.000 i11/200...