cash balance of $10,000 will be maintained throughout the cash budget period. Preparea monthly cash budget for January and February and answer the following:How much surplus (or loan) is expected at the end of February?A $1,900B. $200C. $1,400D. $3,100E. none of the other choices is correct The owner of Madison Pratt Designs is planning to request a line of credit from herbank She has estimated the following sales forecasts for the firm for the followingmonths:November$30,000December $24,000January $19,000February$21,000Collection of sales is expected to be as follows: 20% within the month of sale; 70% themonth following the sale; and 10% the second month following the sale. Total labor andraw materials costs are expected to be incurred as follows:November$12,000December $9,500January $10,500February $13,000These labor and raw materials costs (above) are paid for the month after they areincurred. Salaries cost the firm $4,000 per month; lease payments are $1000 permonth; depreciation charges are expected to be $600 per month; an income taxpayment of $900 will be made in January; and a payment of $1500 for advertising willbe made in February. Cash on hand on January 1st will amount to $2,000, and a targetcash balance of $10.000 will be maintained throughout the cash budget period. Prepare

Cash budget is one of the important budget being prepared in business. It shows expected cash…

Answered: cash balance of $10,000 will be…

Financial & Managerial Accounting

13th Edition

ISBN:9781285866307

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter21: Budgeting

Section: Chapter Questions

Problem 9DQ: A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year...

See similar textbooks

Similar questions

A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?
Review the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)
A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year
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 2019 and 2020: 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: 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 2019. 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.
The most common budget is prepared for a __________. A. week B. month C. quarter D. year
A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. a. Beginning cash balance on July 1: $50,000. b. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,720,000; June (actual), $1,200,000; and July (budgeted), $1,400,000. c. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchases amounts are: June (actual), $700,000; and July (budgeted), $750,000. d. Budgeted cash payments for salaries in July: $275,000. e. Budgeted depreciation expense for July: $36,000. f. Other cash expenses budgeted for July: $200,000. g. Accrued income taxes due in July: $80,000. h. Bank loan interest paid in July: $6,600.
From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…
Cheyenne Company has budgeted the following information for June: Cash receipts Beginning cash balance Cash payments Desired ending cash balance If there is a cash shortage, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,000 increments, and interest is paid monthly at 1% on the first day of the following month. The company had no debt before June 1. The amount of interest paid on July 1 would be: Multiple Choice $590. $ 339,000 22,000 382,000 42,000 $476.
Prime Products hopes to borrow $30,000 on April 1 and repay it plus interest of $1,200 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $ 300,000 210,000 $ 20,000 $ $ 22,000 $ 60,000 $ 15,000 Required 1 Required 2 Total cash collections May $ 400,000 $ 160,000 c. Merchandise…
The LaChut Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. View the cash payment information. Requirement Prepare a cash payments budget for April, May, and June and for the quarter. (If an input field is not used in the table, leave the input field empty; do not enter a zero.) The LaChut Company Cash Payments Budget For the Months of April through June April May Cash payments for direct materials: 50% of current month purchases 50% of last month's purchases Cash payments for direct labor Cash payments for manufacturing overhead Cash payments for operating expenses Cash payments for new server Cash payment for taxes Total cash payments June Quarter Cash payment information a. The company pays for 50% of its direct materials purchases in the month of purchase and the remainder the following month. The company's direct material purchases for March through June are…

SEE MORE QUESTIONS

Recommended textbooks for you

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial & Managerial Accounting

Accounting

ISBN:

9781337119207

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

cash balance of $10,000 will be maintained throughout the cash budget perlod. Prepare a monthly cash budget for January and February and answer the following: How much surplus (or loan) is expected at the end of February? A. $1,900 B. $200 C. $1,400 D. $3,100 E. none of the other choices is correct