“We really need to get this new material-handling equipment in operation just after the new year begins. I hope we can finance it largely with cash and marketable securities, but if necessary we can get a short-term loan down at MetroBank.” This statement by Beth Davies-Lowry, president of Intercoastal Electronics Company, concluded a meeting she had called with the firm’s top management. Intercoastal is a small, rapidly growing wholesaler of consumer electronic products. The firm’s main product lines are small kitchen appliances and power tools. Marcia Wilcox, Intercoastal’s General Manager of Marketing, has recently completed a sales forecast. She believes the company’s sales during the first quarter of 20x1 will increase by 10 percent each month over the previous month’s sales. Then Wilcox expects sales to remain constant for several months. Intercoastal’s projected balance sheet as of December 31, 20x0, is as follows:
Cash |
$ |
35,000 |
|
Accounts receivable |
252,000 |
||
Marketable securities |
10,000 |
||
Inventory |
231,000 |
||
Buildings and equipment (net of accumulated depreciation) |
670,000 |
||
Total assets |
$ |
1,198,000 |
|
Accounts payable |
$ |
220,500 |
|
Bond interest payable |
22,500 |
||
Property taxes payable |
4,800 |
||
Bonds payable (15%; due in 20x6) |
360,000 |
||
Common stock |
400,000 |
||
Retained earnings |
190,200 |
||
Total liabilities and stockholders’ equity |
$ |
1,198,000 |
|
Jack Hanson, the assistant controller, is now preparing a monthly budget for the first quarter of 20x1. In the process, the following information has been accumulated:
Sales salaries |
$ |
45,000 |
|
Advertising and promotion |
25,000 |
||
Administrative salaries |
45,000 |
||
Depreciation |
15,000 |
||
Interest on bonds |
4,500 |
||
Property taxes |
1,200 |
||
In addition, sales commissions run at the rate of 2 percent of sales.
Prepare Intercoastal Electronics Company’s master budget for the first quarter of 20x1 by completing the following schedules and statements:
1A) Sales budget:
1B) Cash receipts budget:
1C) Purchases budget:
1D) Cash disbursements budget:
1E) Complete the first three lines of the summary cash budget. Then do the analysis of short-term financing needs in requirement (6). Then finish requirement (5).
1F) Calculation of required short-term borrowing.
1G) Prepare Intercoastal Electronics’ budgeted income statement for the first quarter of 20x1. (Ignore income taxes.)
1H) Prepare Intercoastal Electronics’ budgeted statement of retained earnings for the first quarter of 20x1.
1I) Prepare Intercoastal Electronics’ budgeted balance sheet as of March 31, 20x1. (Hint: On March 31, 20x1, Bond Interest Payable is $9,000 and Property Taxes Payable is $1,200.)
Please give positive ratings so I can keep answering. Thanks!
Sales Budget | December | January | February | March | Total | April | Note |
Budgeted Sales Revenue | 600,000.00 | 660,000.00 | 726,000.00 | 798,600.00 | 2,184,600.00 | 798,600.00 | A= 110% of previous month sales |
Cash sale is 40% | 240,000.00 | 264,000.00 | 290,400.00 | 319,440.00 | 873,840.00 | B=A*40% | |
Credit sale is 60% | 360,000.00 | 396,000.00 | 435,600.00 | 479,160.00 | 1,310,760.00 | C=A*60% | |
252,000.00 | |||||||
Collection Budget | January | February | March | Total | |||
Cash sale | 264,000.00 | 290,400.00 | 319,440.00 | 873,840.00 | B | ||
Credit sale 30% | 118,800.00 | 130,680.00 | 143,748.00 | 393,228.00 | D= 30% of C of previous month | ||
Credit sale 70% | 252,000.00 | 277,200.00 | 304,920.00 | 834,120.00 | E= 70% of C of previous month, For January take from Balance Sheet. | ||
Total Scheduled Collections | 634,800.00 | 698,280.00 | 768,108.00 | 2,101,188.00 | F=E+B+D | ||
Cost of Goods Sold | December | January | February | March | Total | April | |
Budgeted Cost of Goods Sold - 70% of sales | 420,000.00 | 462,000.00 | 508,200.00 | 559,020.00 | 1,529,220.00 | 559,020.00 | G=A*70% |
Closing stock @ 50% | 231,000.00 | 254,100.00 | 279,510.00 | 279,510.00 | H=F*50% | ||
Opening Stock | 231,000.00 | 254,100.00 | 279,510.00 | I=H of previous month, For January take from Balance Sheet. | |||
Required Purchases | 485,100.00 | 533,610.00 | 559,020.00 | 1,577,730.00 | J=G+H-I | ||
Cash Payment for Inventory | January | February | March | Total | |||
Required Purchases | 485,100.00 | 533,610.00 | 559,020.00 | 1,577,730.00 | J | ||
Payment of current month- 50% | 242,550.00 | 266,805.00 | 279,510.00 | 788,865.00 | K=J*50% | ||
Payment of prior month- 50% | 220,500.00 | 242,550.00 | 266,805.00 | 729,855.00 | L= 50% of J of previous month, For January take from Balance Sheet. | ||
Cash Payment for Inventory | 463,050.00 | 509,355.00 | 546,315.00 | 1,518,720.00 | |||
Cash Disbursement budget | |||||||
Cash Payment for Inventory | 463,050.00 | 509,355.00 | 546,315.00 | 1,518,720.00 | |||
Sales Salaries | 45,000.00 | 45,000.00 | 45,000.00 | 135,000.00 | |||
Advertising & Promotion | 25,000.00 | 25,000.00 | 25,000.00 | 75,000.00 | |||
Administrative Salaries | 45,000.00 | 45,000.00 | 45,000.00 | 135,000.00 | |||
Interest on Bonds | 27,000.00 | - | - | 27,000.00 | Payable for 6 months. (4500*6) | ||
Property taxes | - | 7,200.00 | - | 7,200.00 | Payable for 6 months. (1200*6) | ||
Dividends | - | - | 50,000.00 | 50,000.00 | |||
Cash Disbursement budget | 605,050.00 | 631,555.00 | 711,315.00 | 1,947,920.00 |
Cash budget | January | February | March | Total | |
Beginning Cash Balance | 35,000.00 | 25,000.00 | 91,725.00 | ||
Plus: Collections | 634,800.00 | 698,280.00 | 768,108.00 | 2,101,188.00 | |
Sales of securities | 10,000.00 | - | - | ||
Cash Available | 679,800.00 | 723,280.00 | 859,833.00 | 2,262,913.00 | |
Disbursements | - | ||||
Cash Disbursements | 605,050.00 | 631,555.00 | 711,315.00 | 1,947,920.00 | |
Total cash payments | 605,050.00 | 631,555.00 | 711,315.00 | 1,947,920.00 | |
Preliminary cash balance | 74,750.00 | 91,725.00 | 148,518.00 | ||
Short Term Loan | 65,250.00 | - | (65,250.00) | ||
Interest Paid on short Term Loan | - | - | 1,631.25 | ||
Equipment purchased | 115,000.00 | - | - | ||
Closing Cash Balance | 25,000.00 | 91,725.00 | 81,636.75 |
Calculation of required short-term borrowing: | ||
Preliminary cash balance at the end of Jan | 74,750.00 | M |
Equipment to be purchased | 115,000.00 | N |
Minimum Cash Balance to maintain | 25,000.00 | O |
Loan Required | 65,250.00 | P=N+O-M |
Interest Rate | 10% | Q |
Interest for 3 months | 1,631.25 | R=P*Q%*3/12 |
Income Statement | Amount ($) | |
Sales revenue | 2,184,600.00 | |
Cost of goods sold | 1,529,220.00 | |
Gross margin | 655,380.00 | |
Sales salaries | 135,000.00 | |
Advertising and promotion | 75,000.00 | |
Administrative salaries | 135,000.00 | |
Depreciation | 45,000.00 | |
Property taxes | 3,600.00 | |
Operating income | 261,780.00 | |
Interest on bonds | 13,500.00 | |
Interest Paid on short Term Loan | 1,631.25 | R |
Net income | 246,648.75 | |
Net income | 246,648.75 | S |
Opening Retained earnings | 190,200.00 | T |
Dividend Paid | 50,000.00 | U |
Closing Retained earnings | 386,848.75 | V=S+T-U |
Balance Sheet | Amount ($) | |
Assets | ||
Cash | 81,636.75 | Closing cash Balance from Cash Budget |
Accounts receivable | 335,412.00 | 70% of Credit Sale figure of December |
Inventory | 279,510.00 | Closing Stock figure of December |
Equipment | 740,000.00 | 670000+115000-45000 |
Total assets | 1,436,558.75 | |
Liabilities | ||
Accounts payable | 279,510.00 | 50% of Purchases of December month. |
Bond interest payable | 9,000.00 | |
Property taxes payable | 1,200.00 | |
Bonds payable (15%; due in 20x6) | 360,000.00 | |
Total liabilities | 649,710.00 | |
Equity | See Workings | |
Common stock | 400,000.00 | |
Retained earnings | 386,848.75 | U |
Total equity | 786,848.75 | |
Total liabilities and equity | 1,436,558.75 | |
“We really need to get this new material-handling equipment in operation just after the new year ...
"We really need to get this new material handling equipment in operation just after the new year begins. I hope we can finance it largely with cash and marketable securities, but if necessary we can get a short-term loan down at MetroBank." This statement by Beth Davies-Lowry, president of Intercoastal Electronics Company, concluded a meeting she had called with the firm's top management. Intercoastal is a small, rapidly growing wholesaler of consumer electronic products. The firm's main product lines are...
"We really need to get this new material handling equipment in operation just after the new year begins. I hope we can finance it largely with cash and marketable securities, but if necessary we can get a short-term loan down at MetroBank." This statement by Beth Davies-Lowry, president of Intercoastal Electronics Company, concluded a meeting she had called with the firm's top management. Intercoastal is a small, rapidly growing wholesaler of consumer electronic products. The firm's main product lines are...
Required informationProblem 9-44 Comprehensive Master Budget; Borrowing; Acquisition of Automated Material-Handling System (LO 9-2, 9-3, 9-5, 9-6)Skip to question[The following information applies to the questions displayed below.] “We really need to get this new material-handling equipment in operation just after the new year begins. I hope we can finance it largely with cash and marketable securities, but if necessary we can get a short-term loan down at MetroBank.” This statement by Beth Davies-Lowry, president of Intercoastal Electronics Company, concluded a meeting...
Universal Electric Company is a small, rapidly growing wholesaler of consumer electrical products. The firm's main product lines are small kitchen appliances and power tools. Marcia Wilcox, Universal's general manager of marketing, has recently completed a sales forecast. She believes that the company's sales during the first quarter of next year will increase by 10 per cent each month over the previous month's sales. Wilcox then expects sales to remain constant for several months. Universal's projected balance sheet as at...
RequiredOctober sales are estimated to be $140,000, of which 35 percent will be cash and 65 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.The cost of goods sold is 60 percent of sales. The company desires to maintain a minimum...
A-F for reference. Just need help with G & H. Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forccast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter's unit sales forecast, which are 60,000...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 48,000 Accounts receivable 438,750 Raw materials inventory 87,900 Finished goods inventory 383,760 Total current assets 958,410 Equipment, gross 616,000 Accumulated depreciation (158,000 ) Equipment, net 458,000 Total assets $ 1,416,410 Liabilities and Equity Accounts payable $ 187,200 Short-term notes payable 20,000 Total current liabilities 207,200 Long-term note payable 508,000 Total liabilities 715,200 Common stock 343,000...
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts...
Just need help with tying out summary cash budget to $107,750 for 3rd quarter (check figure) Cost Accounting Master Budget Project Walter Bond, president of Denmark Company, was just concluding a budget meeting with his senior staff. It was November of 20x0, and the group was discussing preparation of the firm’s master budget for 20x1. “I’ve decided to go ahead and purchase the industrial robot we’ve been talking about. We’ll make the acquisition on January 2 of next year, and...
just need help with #8 (the first three pics) Cash budget. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Calculation of Cash receipts from customers: April May June Total budgeted sales 40,000 S 124,296 83347 Cash sales 30%| Sales on credit Book 70% Ask Total cash receipts from customers Print April May June Ferences Current month's cash sales Collections of receivables Total cash receipts $ 0 $ ZIGBY MANUFACTURING Cash Budget April, May, and...