This is ALL the information for the question!! I don't
understand the comment no data available? The red X's are all
wrong.
Sea Tech Inc | |||||
Cash Budget | |||||
For the quarter ended June | |||||
Answer for Question A |
April | May | June | ||
Beginning Cash Balance | 26600 | 7200 | 1394 | ||
Cash Receipts: | |||||
From cash sales made in current month | 79800 | 96900 | 108300 | ||
From credit Sale made in: | |||||
February | 85386 | ||||
March | 119540 | 79694 | |||
April | 111720 | 74480 | |||
May | 135660 | ||||
Total Cash Available (A) | 311326 | 295514 | 319834 | ||
Cash Disbursement: | |||||
For cost of goods sold/Operating expense s incurred in: | |||||
March | 42940 | ||||
April | 148960 | 37240 | |||
May | 180880 | 45220 | |||
June | 202160 | ||||
For payments of Notes Payable & Interest | 79546 | ||||
For Capital expenditure | 32680 | ||||
For Payment of Income Taxes | 76000 | ||||
For payment of Dividend | 30400 | ||||
Total Disbursement:(B) | 304126 | 294120 | 277780 | ||
Ending Cash balance | 7200 | 1394 | 42054 | ||
Question B | |||||
Sea Tech Inc | |||||
Cash Budget | |||||
For the quarter ended June | |||||
April | May | June | |||
Beginning Cash Balance | 26600 | 7200 | 1394 | ||
Cash Receipts: | |||||
From cash sales made in current month | 79800 | 96900 | 108300 | ||
From credit Sale made in: | |||||
February | 85386 | ||||
March | 119540 | 79694 | |||
April | 111720 | 74480 | |||
May | 135660 | ||||
Total Cash Available (A) | 311326 | 295514 | 319834 | ||
Cash Disbursement: | |||||
For cost of goods sold/Operating expense s incurred in: | |||||
March | 42940 | ||||
April | 148960 | 37240 | |||
May | 180880 | 45220 | |||
June | 202160 | ||||
For payments of Notes Payable & Interest | 79546 | ||||
For Capital expenditure | 32680 | ||||
For Payment of Income Taxes | 76000 | ||||
For payment of Dividend | 30400 | ||||
Total Disbursement:(B) | 304126 | 294120 | 277780 | ||
Excess (Deficiency) of cash Available after Disbursement | 7200 | 1394 | 42054 | ||
Borrowing | 12400 | 18206 | |||
Repayment | 22454 | ||||
Interest | |||||
Ending Cash Balance | 19600 | 19600 | 19600 |
This is ALL the information for the question!! I don't understand the comment no data available?...
i am missing a few parts in each chart and unsure how to find
them. thank you for your help!
How are the budgeted Income statements for the second quarter of 2016 for SeaTech, Inc. Cost of pood Gross profit Operating expenses Operating income $35.2005 49.500 59200 Includes all product costs (le, direct materials, direct labor, and manufacturing overhead Tincludes all period costs (le, seling, general, and administrative expenses). The company expects about 30% of sales to be cash transactions...
Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 210,000 $ 255,000 $ 285,000 Cost of goods sold* 144,000 171,000 189,000 Gross profit $ 66,000 $ 84,000 $ 96,000 Operating expenses† 33,000 37,500 40,500 Operating income $ 33,000 $ 46,500 $ 55,500 * Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead). † Includes all period costs (i.e., selling, general, and administrative expenses). The company expects...
A company sells cars. The data following data are taken from a statement of financial position at March 31, 2019 Cash $6000 Accounts Receivable $18000 Inventories $34000 Accounts payable $19750 Additional info: 1) Actual and expected sales are: March (Actual) $40000 April $50000 May $62000 June $80000 2) 30% of sales are on credit, the remaining are in cash. All credit sales are collected in the following month. 3) The ending inventory should be 70% of the following month's sales...
A company sells cars. The data following data are taken from a statement of financial position at March 31, 2019 Cash $6000 Accounts Receivable $18000 Inventories $34000 Accounts payable $19750 Additional info: 1) Actual and expected sales are: March (Actual) $40000 April $50000 May $62000 June $80000 2) 30% of sales are on credit, the remaining are in cash. All credit sales are collected in the following month. 3) The ending inventory should be 70% of the following month's sales...
Please create an Assumption page in excel for all given data.
Creating a master budget where all data needs to be links to
assumptions. No hard numbers can be used. Thank you
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 8,500 $ 24,000 $ 45, 600 $ 121,200 $ 27,300 $...
A company sells cars. The data following data are taken from a statement of financial position at March 31, 2019 Cash $6000 Accounts Receivable $18000 Inventories $34000 Accounts payable $19750 Additional info: 1) Actual and expected sales are: March (Actual) $40000 April $50000 May $62000 June $80000 2) 30% of sales are on credit, the remaining are in cash. All credit sales are collected in the following month. 3) The ending inventory should be 70% of the following month's sales...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 9, 100 $ 26,400 $ 49,200 $ 106,800 $ 29,550 $ 150,000 $ 11,950 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June Ouly $ 66,000 $ 82,000 $ 87,000 $ 112,000 $...
Please as fast as possible I only need the
numbers for this table
Question I (35 %) Here are some important figures from the budget of Scarlet Inc., for the second quarter of 2019 June May April 378,400 €314,500 336,900 Credit sales 180,300 152,400 134,100 Credit purchases Cash disbursements 62,300 67,600 48,910 Wages, taxes, and expenses 11,320 11,320 11,320 Interest 79,900 122,000 0 Equipment purchases Additional information: The company predicts that 5 percent of its credit sales will never be...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash 9,400 27,600 51,000 99,600 30,675 $ 150,000 Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings 6,925 a. The gross margin is 25% of sales b. Actual and budgeted sales data: S 69,000 S 85,000 90,000 S 115,000 S 66,000 March (actual) April May June July c. Sales are 60% for cash and...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 9,400 Accounts receivable $ 27,600 Inventory $ 51,000 Building and equipment, net $ 99,600 Accounts payable $ 30,675 Common stock $ 150,000 Retained earnings $ 6,925 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 69,000 April $ 85,000 May $ 90,000 June $ 115,000 July $ 66,000 Sales are...