FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $45,000 and $69,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale, 60% in the following month, and 10% is deemed uncollectible. What amount of cash collections from credit sales would the company include in its
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales. The selling price of the company's product is $26 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $73,600. The company expects to start the first quarter with 2,540 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,740 units. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,700 13,700 15,700 14,700 Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2.…arrow_forwardGarden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 220,000 $ 227,000 Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 190,000 $ 340,000 $ 267,000 $ 237,000 The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash…arrow_forwardEmerald Service anticipates the following sales revenue over a five-month period Its collection history indicates that credit sales are collected as follows E (Click the icon to view the sales data ) The company's sales are 40% cash and 60% credit O (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole dollar) Emerald Service Cash Collections Budget For the Months of January through March January Cash sales 6,080 Collection of credit sales 25% Month of sale 2,280 50% Month after 15% Two months after Total cash collectionsarrow_forward
- Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $42,000 and $71,000, respectively. The company expects to collect 45% of its credit sales in the month of the sale, 50% in the following month, and 5% is deemed uncollectible. What amount of cash collections from credit sales would the company include in its cash budget for the second month? Multiple Choice $56,500 $31,950 $35,500 $52,950arrow_forwardA company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken to meet this requirement at a cost of 1% interest per month (paid at the end of each month). Any preliminary cash balance above $12,400 is used to repay loans at month-end. The cash balance on March 1 is $12,400, and the company has no outstanding loans. Budgeted cash receipts from sales are: March, $26,000; April, $32,400; and May, $41,000. Budgeted cash payments (excluding loan or interest payments) are: March, $30,000; April, $30,200; and May, $32,400. Required: Prepare a cash budget for March, April, and May. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Beginning cash balance Add: Cash receipts from sales Total cash available Add: Cash receipts from sales Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance,…arrow_forwardAssume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $32,500 and $48,500, respectively. It also expects credit sales of $58,500 and $68,500, respectively. The company expects to collect 30% of its credit sales in the month of the sale, 65% in the following month, and 5% is deemed uncollectible. What amount of cash collections would appear in the company’s cash budget for the first month? Multiple Choice $50,050 $17,550 $66,050 $48,500arrow_forward
- Orange Company has sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on 1 May and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. • The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale • The firm recelves other income of $2,000 per month • The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively • Rent is $3,000 per month • Wages and salaries are 10% of the previous month's sales • Cash dividends of $3,000 will be paid in June • Payment of principal and interest of $4,000 is due in June • A cash purchase of equipment costing $6,000 is scheduled in July • Taxes of $6,000 are due in…arrow_forwardA company is preparing its cash budget for the upcoming quarter. The company's sales are expected to be $500,000 in January, $600,000 in February, and $700,000 in March. The company's cost of goods sold is 60% of sales. The company's beginning cash balance is $50,000, and the company desires to maintain a minimum cash balance of $25,000. What is the company's budgeted cost of goods sold for February? $360,000 $540,000 $450,000 $350,000arrow_forwardVishnuarrow_forward
- Mitchell Company had the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Assume that the accounts recelvable balance on January 1 was $76,000. Of this amount, $60,000 represented uncollected December sales and $16,000 represented uncollected November sales. Glven these data, the total cash collected during January would be: Multiple Choice $138.000 $100,000 $196,000 $197,000arrow_forwardThe company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?arrow_forwardAssume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $30,500 and $34,000, respectively. It also expects credit sales of $50,500 and $60,500, respectively. The company expects to collect 30% of its credit sales in the month of the sale, 60% in the following month, and 10% is deemed uncollectible. What amount of cash collections would appear in the company’s cash budget for the second month? A- $18,150 B- $77,400 C- $96,800 D- $82,450arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education