Cash Budget | ||||
July | August | September | Quarter | |
Opening Balance | $ 8,000 | $ 8,000 | $ 8,000 | $ 8,000 |
Cash Collection | $ 36,160 | $ 47,760 | $ 59,600 | $ 143,520 |
Cash available | $ 44,160 | $ 55,760 | $ 67,600 | $ 151,520 |
Less: Payments | ||||
Inventory purchases | $ 30,450 | $ 35,250 | $ 30,375 | $ 96,075 |
Selling Expenses | $ 7,200 | $ 11,700 | $ 8,500 | $ 27,400 |
Administrative Expenses | $ 3,600 | $ 5,200 | $ 4,100 | $ 12,900 |
Land | $ 4,500 | $ 4,500 | ||
Dividend | $ 1,000 | $ 1,000 | ||
Total Disbursements | $ 45,750 | $ 52,150 | $ 43,975 | $ 141,875 |
Payments minus receipts | ||||
Excess /(Deficiency) | $ (1,590) | $ 3,610 | $ 23,625 | $ 9,645 |
Financing Activity | ||||
Borrowings | $ 9,495 | $ 4,252 | $ - | $ 13,747 |
Repayment | $ (13,747) | $ (13,747) | ||
Interest | $ 95 | $ 138 | $ (137) | $ 96 |
Total Financing | $ 9,590 | $ 4,390 | $ (13884) | $ (96) |
Ending Balance | $ 8,000 | $ 8,000 | $ 9,741 | $ 9,741 |
Working:
Borrowings for July = x |
-1590+0.01x +x = 8000 |
1.01x = 9590 |
x = 9495 |
Borrowings for July = $9495 |
Interest = 9495 *1% = 95 |
Borrowing for August = x |
3610+0.01x+x+95 = 8000 |
1.01x = 4295 |
x = 4252 |
Borrowings for August = $4252 |
Interest = 4252 * 1% + 4295 *1% = 138 |
Managrial accounting Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplie...
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back- to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for for July through October...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July to October are as...
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 recelvable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 75,000 140,000 66,500 227,000 $...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of the calendar year. The company's balance sheet as of June 30 is shown below: COLERAIN CORPORATION Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation 95,000 141,000 67,000 350,000 Total assets $ 653,000 Liabilities and Shareholders' Equity Accounts payable Common shares Retained earnings 76,000 450,000 127,000 Total liabilities and shareholders' equity $653,000 Colerain's managers have made the following...