UPENN: LOOSE LEAF CORP.FIN W/CONNECT
17th Edition
ISBN: 9781260361278
Author: Ross
Publisher: McGraw-Hill Publishing Co.
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 26, Problem 12QP
Summary Introduction
To compute: The cash collection from sales for each quarter.
Cash Budget:
Cash budget is prepared to ascertain the amount of cash for a given period. Cash budget is a statement that contains the information of cash receipts and cash payments. Closing balance of cash is calculated with the help of cash budget.
Cash Collection:
The receipts side of the cash account shows the cash collected by the company. The company receives cash when there are cash sales and the collection from accounts receivable is the cash collection of a company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Blue Company’s budgeted sales and budgeted cost of goods sold for the coming year are $144,440,000 and $90,720,000, respectively. Short-term interest rates are expected to average 10%. If Blue can increase inventory turnover from its present level of 9 times a year to a level of 10 times per year.Compute its expected cost savings for the coming year.
Expected Cost Savings
Pronghorn Company’s budgeted sales and budgeted cost of goods sold for the coming year are $137,590,000 and $87,840,000, respectively. Short-term interest rates are expected to average 10%. If Pronghorn can increase inventory turnover from its present level of 9 times a year to a level of 12 times per year.Compute its expected cost savings for the coming year.
AB Company’s budgeted sales and cost of sales for the coming year are P72 million and P45 million respectively. Shortterm interest rates are expected to average 10%. If the company can increase inventory turnover from its current levelof 9 times per year to 12 times per year, its cost savings in the coming year are expected to beA. P125,000 C. P375,000B. P300,000 D. P500,000
Chapter 26 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
Ch. 26 - Prob. 1CQCh. 26 - Prob. 2CQCh. 26 - Prob. 3CQCh. 26 - Cost of Current Assets Grohl Manufacturing, Inc.,...Ch. 26 - Prob. 5CQCh. 26 - Shortage Costs What are the costs of shortages?...Ch. 26 - Prob. 7CQCh. 26 - Prob. 8CQCh. 26 - Prob. 9CQCh. 26 - Prob. 10CQ
Ch. 26 - Prob. 11CQCh. 26 - Prob. 12CQCh. 26 - Prob. 1QPCh. 26 - Cash Equation Blizzard Corp. has a book value of...Ch. 26 - Changes in the Operating Cycle Indicate the effect...Ch. 26 - Prob. 4QPCh. 26 - Calculating Cash Collections The Litzenberger...Ch. 26 - Prob. 6QPCh. 26 - Prob. 7QPCh. 26 - Calculating Payments The Thakor Corporations...Ch. 26 - Calculating Cash Collections The following is the...Ch. 26 - Prob. 10QPCh. 26 - Prob. 11QPCh. 26 - Prob. 12QPCh. 26 - Prob. 13QPCh. 26 - Prob. 14QPCh. 26 - Prob. 15QPCh. 26 - Prob. 1MCCh. 26 - Rework the cash budget and short-term financial...Ch. 26 - Rework the sales budget assuming an 11 percent...
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
- A. SALES AND PRODUCTION BUDGET (1 Rak Sarang Corporation expects to sell 5,000 units in the first year, followed by a 300-unit increment in subsequent quarters. The company believes that by retaining an ending inventory equivalent to 15% of the next quarter's anticipated sales volume, it can satisfy future sales requirements. Based on a sales price of P150 per unit: a. Prepare the Sales Budget (For the year 2022). b. Prepare the Production Budget (For the year 2022).arrow_forwardMultiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $96,000 during each of the next 3 months. It will make monthly purchases of $58,000 during this time. Wages and salaries are $12,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $17,000 in the next month and a $20,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance are assumed to be zero. a. Construct a cash budget for the next 3 months. b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $77,000 per month and the most optimistic is $124,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periods? c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for…arrow_forwardShow the solution in good accounting formarrow_forward
- 2019 Sales Cost of Goods Sold Rent Wages Insurance Utilities Auto Maintenance Advertising Other Expenses Total Expenses Net Income Jan 3,250 1,788 525 175 46 220 40 98 2,891 359 Feb 2,700 1,485 525 175 46 225 40 81 2,577 123 Mar 3,855 2,120 525 175 46 285 80 60 116 3,407 448 Tom's Business Income Statement 98 2,900 354 2019 May Jul Aug Sep Oct Nov Dec Total Apr 3,254 3,650 2,850 2,600 2010 2,200 2,250 3,755 4,890 37,264 1,790 2,008 1,106 1,210 1,238 2,065 2,690 20,495 525 525 525 525 525 525 6,300 2,100 175 175 175 175 175 175 46 46 46 46 46 46 550 227 265 210 185 220 230 2,657 40 40 40 80 640 60 147 525 175 46 200 40 110 Jun 588 * º * * * 88 * § 547 1,568 525 175 46 185 80 60 86 3,103 2,724 126 1,430 525 175 46 205 40 78 2,499 101 40 60 2217 (207) 80 60 66 2,372 (172) 68 2,276 (26) 113 3,184 3,952 571 938 240 1,118 34,100 3,164arrow_forwardParker Corporation, which operates on a calendar year, expects to sell 3,000 units in October, and expects sales to increase 10% each month thereafter. Sales price is expected to stay constant at $10 per unit. What are budgeted revenues for the fourth quarter? Multiple Choice O O $30,000 $90,000 $99,000 $99,300arrow_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 and interpret the result in detail.arrow_forward
- 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.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_forwardDiscus Productions needs to know its anticipated ensh inflows for the next quarter by month Cash sales are 10% of total sales each month. Historically, sales on sccount have been collected as follows 60% in the month of ale, 30% in the month after the sale, and the reurining 10% two months after the sale. Sales for the quarter are projected as follows: April, S120,000: May, S100,000; and June, 590,000. Accounte receivable on March 31 were S60,000, The expected caalh collections of Discn Productions for June are Oa $92,000. Oh S89.000. Oe $91.200. Od 595.400.arrow_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_forwardOmegon Limited has the following sales forecasts for its watches next year:First Quarter..10,000 unitsSecond Quarter.5% increase over first quarterThird Quarter 3% increase from second quarterFourth Quarter.8% increase over third quarterWhat is Omegon’s total sales budget in units for next year?1) 43,485 units.2) 42,995 units.3) 40,685 units.4) 40,000 unitsarrow_forward15. Texas Company has begun selling new chili recipe and they want you to help with next year's budgeted financial statements. Using the worksheet below, complete Texas Company forecast and answer the questions which follow. Assumptions: To begin with, Texas Company is sure sales will grow 40% next year. Assume that is true. Then assume that COGS, Current Assets, and Current Liabilities all vary directly with Sales (that means if sales grow a certain percentage, then the account in question will grow by that same percentage). Assume that fixed expenses will remain unchanged, and that $3,000 worth of new Fixed Assets will be obtained next year. Lastly, the current dividend policy will be continued next year. Texas Company Financial Forecast Estimated This Year for next year $45,000 $5,000 40,000 Sales COGS Gross Profit 3,000 37,000 Fixed Expenses Before-Tax Profit Tax @ 33.3333% Net Profit 12.332 24,668 Dividends $0 Current Assets $30,000 20,000 $50,000 Net Fixed Assets Total Assets…arrow_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