None QS 20-23 Budgeted loan activity LO P2Santos Co. is preparing a cash budget for February. The company has $18,000 cash at the beginning of February and anticipates$69,000 in cash receipts and $109,000 in cash payments during February. What amount, if any, must the company borrow duringFebruary to maintain a $4,000 cash balance? The company has no loans outstanding on February 1. (Negative cash balances, if any,should be indicated with minus sign.)SANTOS CO.Cash BudgetFor Month Ended February 28Beginning cash balanceESTotal cash availablePreliminary cash balanceEnding cash balance

Step 1:The cash budget is prepared hereunder:…

Answered: QS 20-23 Budgeted loan activity LO P2…

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter4: Internal Control And Cash

Section: Chapter Questions

Problem 66.2C

See similar textbooks

Similar questions

CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.
Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March 2016: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lbs. Batting helmet........ 40 units at 25 per unit Foam lining 80 lbs. Football helmet....... 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic50 lbs. Batting helmet......... 50 units at 25 per unit Foam lining65 lbs. Football helmet........ 220 units at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lbs. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lbs. per unit of product Foam lining 1.50 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventor) of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department 1.80 hrs. at 14 per hr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2,300 h. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expense-selling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.
Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.
Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.
Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 2016: At the end of December 2016, the following unit sales data were reported for the year: For the year ending December 31 , 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 3. Prepare a sales budget for the year ending December 31, 2017.

Recommended textbooks for you

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Accounting (Text Only)

Accounting

ISBN:

9781285743615

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Accounting (Text Only)

Accounting

ISBN:

9781285743615

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781285867977

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Fundamentals of Financial Management, Concise Edi…

Finance

ISBN:

9781305635937

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS