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.
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.
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.
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.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.
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
- 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.arrow_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?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_forward
- Brandeis, 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_forwardNuParts, 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_forward
- Your 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_forwardSwifty Corporation expects to purchase $140,000 of materials in July and $160,000 of materials in August. Three-fourths of all purchases are paid for in the month of purchase, and the other one-fourth are paid for in the month following the month of purchase. How much will August's cash disbursements for materials purchases be?arrow_forward
- Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April 45,000 55,000 June 55,000 45,000 May Sales 35,000 45,000 Production Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals $174,000, which will be paid in April. All units are sold on account for $19 each. Cash collections from sales are budgeted at 50% in the month of sale, 30% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. Accounts receivable on April 1 totaled $433,000 ($93,000 from February's sales and $340,000 from March's sales). Required: a. Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation. b. Prepare a…arrow_forwardDevelop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.arrow_forwardjagdisharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
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