Problem 14-20A (Static) Preparing a cash budget LO 14-5 Fayette Medical Clinic has budgeted the following cash flows. January $240, 000 February $232,000 $272,000 March Cash receipts Cash payments For inventory purchases For SSA expenses 220, 000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from last year's quarterly results. Required Prepare a cash budget. (Any repayments should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.)

Problem 14-20A (Static) Preparing a cash budget LO 14-5 Fayette Medical Clinic has budgeted the following cash flows. January $240, 000 February $232,000 $272,000 March Cash receipts Cash payments For inventory purchases For SSA expenses 220, 000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from last year's quarterly results. Required Prepare a cash budget. (Any repayments should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.)

Name: RequiredPrepare a cash budget. (Any repayments should be indicated wi
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: RequiredPrepare a cash budget. (Any repayments should be indicated with a minus sign. Round intermediate and final answers to thenearest whole dollar amounts.)Cash BudgetJanuaryFebruaryMarchSection 1: Cash receipts%24Total cash availableSection 2: C

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Newman Medical Clinic has budgeted the following cash flows. January February March $11,000 $117,000 $137,000 Cash receipts Cash payments For inventory purchases For S&A expenses 36,500 95,500 77,500 90,500 37,500 32,500 Newman Medical had a cash balance of $13,500 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.)
Exercise 2 (Schedule of Expected Cash Collections) Peak sales for General Products, Inc. occur in September. The company's sales budget for the third quarter showing these peak sales is given below, July Budgeted sales... P885,500 August P1,018,000 PI,222,000 P3,125,500 September Total From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P700,000 and June sales totaled P770,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted balance sheet of September 30. Compute the accounts receivable as of the date.
Newman Medical Clinic has budgeted the following cash flows. January February March $101,000 $107,000 $127,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Cash Budget Beginning cash balance Add: Cash receipt Cash available Less: Cash payments 90,500 31,500 Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) For inventory purchases For S&A expenses Interest expense per month…
Exercise 13-35 (Algo) Estimate Cash Collections (LO 13-5) Minot Corporation is preparing its cash budget for August. The following information is available concerning its accounts receivable: Estimated credit sales for August $ 130,000 Actual credit sales for July $ 99,000 Estimated collections in August for credit sales in August 25 % Estimated collections in August for credit sales in July 70 % Estimated collections in August for credit sales prior to July $ 11,000 Estimated write-offs in August for uncollectible credit sales $ 5,000 Estimated provision for bad debts in August for credit sales in August $ 4,800 Required: What is the estimated amount of cash receipts from accounts receivable collections in August?
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,690,000 Quarter 2 5,410,000 Quarter 3 4,890,000 Quarter 4 7,920,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,160,000 and for the fourth quarter of the current year are $7,430,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $_______ $______ 4, current year ________ _______ 1, next year _______ _______ 2,…
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July $109,000 $136,000 $174,000 M 46,000 58,000 63,000 32,000 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 37,000 38,000 42,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 85% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of May 1 include cash of…
Current Attempt in Progress Sunland Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $188,000 $28,200 February 206,800 33,840 March 235,000 35,720 A Sunland's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Sunland's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase, and 60% in the month following purchase. (a) Prepare a schedule of expected collections from customers for March. SUNLAND COMPANY Schedule of Expected Collections from Customers
11 Skipped Campbell Medical Clinic has budgeted the following cash flows. January February March Cash receipts $104,000 $110,000 $130,000 Cash payments For inventory purchases For S&A expenses 92,000 74,000 33,000 34,000 Campbell Medical had a cash balance of $10,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Campbell pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign.) January February Cash Budget Section 1: Cash Receipts 87,000 29,000 Total cash available Section 2: Cash…
Problem 13-57 (Algo) Sales Expense Budget (LO 13-4) SPU, Ltd., has just recelved its sales expense report for January, which follows. Item Amount Sales commissions $370, 500 9e,400 Sales staff salaries Telephone and mailing Building lease payment 51, 000 60,000 19,100 8e, 000 33,750 51,190 Utilities Packaging and delivery Depreciation Marketing consultants You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: Sales volume is expected to Increase by 14 percent. Sales prices are expected to decrease by 10 percent. Commissions are based on a percentage of sales revenue. • Sales staff salarles will increase 4 percent next year regardless of sales volume. • Bullding rent is based on a five-year lease that expires in three years. • Telephone and malling expenses are scheduled to Increase by 6 percent even with no change In…
Problem 8-24 (Algo) Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Incorporated, usually has to borrow money during the second quarter to support peak sales of lawn care equipment during May. It gathered the following information to prepare a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July Sales Cost of goods sold $ 660,000 462,000 Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 198,000 $ 830,000 581,000 249,000 $ 540,000 378,000 $ 440,000 308,000 162,000 132,000 84,000 103,000 65,000 44,000 47,000 131,000 63,200 166,200 39,800 104,800 42,000 86,000 $ 67,000 $ 82,800 $ 57,200 $ 46,000 *Includes $26,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10% collected in the month of sale, 70%…
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…