Loose Leaf for Foundations of Financial Management Format: Loose-leaf
17th Edition
ISBN: 9781260464924
Author: BLOCK
Publisher: Mcgraw Hill Publishers
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 21P
The Denver Corporation has
Monthly material purchases are set equal to 40 percent of forecast sales for the next month. Of the total material costs, 50 percent are paid in the month of purchase and 50 percent in the following month. Labor costs will run
Prepare a monthly summary of cash payments for the six-month period from January through June. (Note: Compute prior December purchases to help get total material payments for January.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Assume that sales and expenses forecasts for months April, May, June, and July are as follows.
month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Â
Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%.Â
Requirements:
Prepare cash budget proforma for months June and July and interpret the result in detail.
Management wants to know if there will be a need for short-term financing in February. Essential information is as follows:
Estimated sales for January and February are $1.1 million and $750,000, respectively.
Sixty percent of sales are for cash and 40 percent are credit sales that are collected the next month.
Cash disbursements that vary with sales are 35 percent of sales.
Fixed operating disbursements are $400,000 a month.
Depreciation expense is $50,000 a month.
A tax payment of $70,000 is due in January.
A bond payment of $250,000 is owed and will be due in February.
The cash balance at the beginning of January is $12,000.
Management seeks a minimum cash balance of $9,000.
December credit sales were $110,000.
Round your answers to the nearest dollar. Use a minus sign to enter shortage of cash, if any.
Â
Â
January
February
Excess (shortage) of cash
$Â Â
$Â Â
Â
The firm  need short-term funds in February.
Assume that sales and expenses forecasts for months April, May, June, and July are as follows.
20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Any excess over $20,000,000 will be used to reduce or pay off cumulative loan.Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time.Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%.
Requirements:
Prepare cash budget proforma for months June and July and interpret the result in detail.
Chapter 4 Solutions
Loose Leaf for Foundations of Financial Management Format: Loose-leaf
Ch. 4 - What are the basic benefits and purposes of...Ch. 4 - Explain how the collections and purchases...Ch. 4 - With inflation, what are the implications of using...Ch. 4 - Explain the relationship between inventory...Ch. 4 - Prob. 5DQCh. 4 - Discuss the advantage and disadvantage of level...Ch. 4 - What conditions would help make a percent-of-sales...Ch. 4 - Prob. 1PCh. 4 - Philip Morris expects the sales for his clothing...Ch. 4 - Galehouse Gas Stations Inc. expects sales to...
Ch. 4 - The Alliance Corp. expects to sell the following...Ch. 4 - Prob. 5PCh. 4 - Cyber Security Systems had sales of 3,500 units at...Ch. 4 - Dodge Ball Bearings had sales of 15,000 units at...Ch. 4 - Sales for Ross Pro’s Sports Equipment are expected...Ch. 4 - Vitale Hair Spray had sales of 13,000 units in...Ch. 4 - Delsing Plumbing Company has beginning inventory...Ch. 4 - On December 31 of last year, Wolfson Corporation...Ch. 4 - At the end of January, Higgins Data Systems had an...Ch. 4 - At the end of January, Mineral Labs had an...Ch. 4 - Convex Mechanical Supplies produces a product with...Ch. 4 - The Bradley Corporation produces a product with...Ch. 4 - Sprint Shoes Inc. had a beginning inventory of...Ch. 4 - J. Lo’s Clothiers has forecast credit sales for...Ch. 4 - Simpson Glove Company has made the following sales...Ch. 4 - Watt’s Lighting Stores made the following sales...Ch. 4 - Ultravision Inc. anticipates sales of $290,000...Ch. 4 - The Denver Corporation has forecast the following...Ch. 4 - Wright Lighting Fixtures forecasts its sales in...Ch. 4 - The Volt Battery Company has forecast its sales in...Ch. 4 - Graham Potato Company has projected sales of...Ch. 4 - Harry’s Carryout Stores has eight locations. The...Ch. 4 - Archer Electronics Company’s actual sales and...Ch. 4 - Prob. 27PCh. 4 - The Manning Company has financial statements as...Ch. 4 - Conn Man’s Shops, a national clothing chain, had...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- To meet projected annual sales, Bluegill Manufacturers, Inc. needs to produce 75,000 machines for the year. The estimated January 1 inventory is 7,000 units, and the desired December 31 inventory is 12,000 units. What are projected sales units for the year?arrow_forwardAssume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.arrow_forwardAssume that sales and expenses forecasts for months April, May, June, and July are as follows. 20% of all sales in a month are paid in the same month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan.Any excess over $20,000,000 will be used to reduce or pay off cumulative loan.I nitial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: 1. Prepare cash budget proforma for months June and July. Provide in-text citations and references, and explain your work in detail.arrow_forward
- Cash DisbursementTimber Company is in the process of preparing its budget for next year. Cost of goods sold has been estimated at 70 percent of sales. Lumber purchases and payments are to be made during the month preceding the month of sale. Wages are estimated at 15 percent of sales and are paid during the month of sale. Other operating costs amounting to 10 percent of sales are to be paid in the month following the month of sale. Additionally, a monthly lease payment of $64,000 is paid for computer services. Sales revenue is forecast as follows Month Sales Revenue February $220,000 March 260,000 April 270,000 May 310,000 June 290,000 July 330,000 RequiredPrepare a schedule of cash disbursements for April, May, and June.Do not use a negative sign with your answers. Timber Company Schedule of Cash Disbursements April, May, and June  April May June Lumbers purchases Answer Answer Answer Wages Answer Answer Answer Operating expenses Answer Answer…arrow_forwardRishi Sunak Manufacturing Pte. Ltd. is preparing its budget for next year. The company estimates that it will be making the following raw materials purchases in the last five months of 2021: $200,000 in August, $220,000 in September, $250,000 in October, $280,000 in November and $240,000 in December. The company anticipates that it will pay 55% of what is owed one month after the month of purchase, 30% of what is owed two months after the month of purchase and the remaining 15% three months after the month of purchase. What figure will be presented in the company’s cash budget for payments for raw materials purchases in December 2021?   $233,500    $253,500    $262,000    $403,500arrow_forwardTerrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash.(a) Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June.(b) The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances? Make your recommendations.arrow_forward
- Terrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash. Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June. The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances?arrow_forwardBrandeis, Inc has a 45-day accounts payable period. The firm has expected quarterly sales of $2,400, $2,800, $3,600, and $4,200, respectively, for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $1,200 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for quarter 3 of the next year? Each quarter has 90 days. Multiple Choice $3,900 $2,730 $2,240 $2,870 $3,060arrow_forwardTo meet projected annual sales, Bluegill Manufacturers, Inc. needs to produce 75,000 machines for the year. The estimated January 1 inventory is 7,000 units, and the desired December 31 inventory is 12,000 units. What are projected sales units for the year? unitsarrow_forward
- NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33arrow_forwardYour projected sales for the first 3 months of next year are as follows:January, $15,000; February, $20,000; and March, $25,000. Based on lastyear’s data, cash sales are 20 percent of total sales for each month. Of theaccounts receivable, 60 percent are collected in the month after the sale and40 percent are collected in the second month following the sale. Sales forNovember of the current year are $15,000 and for December are $17,000.You have the following estimated payments: January, $4,500; February,$5,500; and March, $5,200.a. Using the format from the pro forma cash budget in Table 6–8, what is yourmonthly cash budget for January, February, and March?b. What will your accounts receivable be for the beginning of April?c. Will your company have any borrowing requirements for any month duringthis 3-month period?arrow_forwardWilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual November December Sales Credit sales $ 600,000 January 620,000 February March Cash sales One month after sale Two months after sale Total cash receipts Of the firm's sales, 50 percent are for cash and the remaining 50 percent are on credit. Of credit sales, 50 percent are paid in the month after sale and 50 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 40 percent of sales and is paid for in the month of sales. Selling and administrative expense is 20 percent of sales and is paid in the month of sales. Overhead expense is $38,000 in cash per month. Forecast…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY