Concept explainers
Videos
a)
To determine: The cash collection for each four quarters, when the collection period is 45days.
Introduction:
Cash collection is the amount collected through business. It is a task of accounts receivables.
Average cash collection period is the number of days taken to collect the cash from the customers.
a)
Answer to Problem 12QP
The cash collection for each quarters are Quarter 1 is $4,050, Quarter 2 is $4,750, Quarter 3 is $5,000 and Quarter 4 is $4,400.
Explanation of Solution
Given information:
Accounts receivable at the beginning of the year is $1900, and the collection period is 45 days.
Compute the cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected in the current year.
Compute the ending receivables for quarter 1:
Therefore, the ending receivable will be half of the current year sales.
Hence, the ending receivables are $2,150.
Compute the cash collection for quarter 1:
Hence, the cash collected for the quarter 1 is $4,050.
Compute the ending receivables for quarter 2:
Hence, the ending receivables are $2,600.
Compute the cash collection for quarter 2:
Hence, the cash collected for the quarter 2 is $4,750.
Compute the ending receivables for quarter 3:
Hence, the ending receivables are $2,400.
Compute the cash collection for quarter 3:
Hence, the cash collected for the quarter 1 is $5,000.
Compute the ending receivables for quarter 4:
Hence, the ending receivables are $2,000.
Compute the cash collection for quarter 4:
Hence, the cash collected for the quarter 1 is $4,400.
b)
To determine: The cash collection for each four quarters, when the collection period is 60 days.
b)
Answer to Problem 12QP
The cash collection for each quarter: Quarter 1 is $4,767, Quarter 2 is $4,900, Quarter 3 is $4,933, and Quarter 4 is $4,267.
Explanation of Solution
Given information:
Accounts receivables at the beginning of the year are $1,900 and the collection period is 60 days.
Compute the cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected in the current year.
Compute the ending receivables for quarter 1:
Therefore, the ending receivable will be half of the current year sales.
Compute ending receivables for quarter 1:
Hence, the ending receivables are $1,433.
Compute the cash collection for quarter 1:
Hence, the cash collected for the quarter 1 is $4,767.
Compute ending receivables for quarter 2:
Hence, the ending receivables are $1,733.33.
Compute the cash collection for quarter 2:
Hence, the cash collected for the quarter 2 is $4,900.
Compute the ending receivables for quarter 3:
Hence, the ending receivables are $1,600.
Compute the cash collection for quarter 3:
Hence, the cash collected for the quarter 1 is $4,933.
Compute the ending receivables for quarter 4:
Hence, the ending receivables are $1,333.
Compute the cash collection for quarter 4:
Hence, the cash collected for the quarter 1 is $4,267.
c)
To determine: The cash collection for each four quarters, when the collection period is 30 days.
Introduction:
Cash collection is the amount collected through business. It is a task of accounts receivables.
Average cash collection period is the number of days taken to collect the cash from the customers.
c)
Answer to Problem 12QP
The cash collections for each quarter are Quarter 1 is $3,333, Quarter 2 is $4,600, Quarter 3 is $5,067, and Quarter 4 is $4,533.
Explanation of Solution
Given information:
Accounts receivable at the beginning of the year is $1900, and the collection period is 30 days.
Compute the cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected in the current year.
Compute the ending receivables for quarter 1:
Therefore, the ending receivables will be half of the current year sales.
Hence, the ending receivables are $2,866.67.
Compute the cash collection for quarter 1:
Hence, the cash collected for the quarter 1 is $3,333.
Compute ending receivables for quarter 2:
Hence, the ending receivables are $3,466.67.
Compute the cash collection for quarter 2:
Hence, the cash collected for the quarter 2 is $4,600.
Compute the ending receivables for quarter 3:
Hence, the ending receivables are $3,200
Compute the cash collection for quarter 3:
Hence, the cash collected for the quarter 1 is $5,067.
Compute the ending receivables for quarter 4:
Hence, the ending receivables are $2,667.
Compute the cash collection for quarter 4:
Hence, the cash collected for the quarter 1 is $4,533.
Want to see more full solutions like this?
Chapter 16 Solutions
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- 6. Smith Company was organized on August 1 of the current year. Projected sales for the next three months are: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash and 50% for sales on account. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections from cash and accounts receivable for the three months.arrow_forwardCrane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $11 Crane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000 How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $ I Iarrow_forwardThe George Company has a policy of maintaining an end-of-month cash balance of at least $30,000.In months where a shortfall is expected, the company can draw in $1,000 increments on a line ofcredit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed forbudgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000increments of principal) are assumed to occur at the end of the month. Interest is paid at the end ofeach month. For April, an end-of-month cash balance (prior to any financing and interest expense)of $18,000 is budgeted; for May, an excess of cash collected over cash payments (prior to any interest payments and loan repayments) of $22,000 is anticipated. What is the interest payment estimatedfor April (there is no bank loan outstanding at the end of March)? What is the total financing effect(cash interest plus loan transaction) for May?arrow_forward
- The beginning cash balance is $16,500. Sales are forecasted at $820,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $472,000. Accounts Receivable from previous accounting periods totaling $11,800 will be collected in the current year. The company is required to make a $16,500 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $90,000, and the annual interest rate is 9%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $arrow_forwardKamal Co. has an average collection period (ACP) of 30 days and an operating cycle of 170 days. It has a policy of keeping at least RO 15,000 on hand as a minimum cash balance, and has a beginning cash balance for the first quarter of RO 20,000. Beginning receivables for the first quarter amount to RO 30,000 Sales for the first second and the third quarters are expected respectively to be RO 100,000; RO120,000; and RO 150,000. The purchases amount represents 50% of the next quarter's forecasted sales. The quarterly wages and other expenses is RO 7,000. The capital spending occurs in the second quarter and equals to RO 15,000. The accounts payable period is 45 days. The beginning accounts payable is RO 10,000. A. What are cash collections in the first and second quarters? B. What are cash disbursements for the first and second quarters ? C. What is the cumulative surplus (deficit) at the end of the first and second quarters ?arrow_forwardHere is a forecast of sales by National Bromide for the first four months of 2019 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16 Sales on credit 120 140 110 90 On the average 52% of credit sales are paid for in the current month, 32% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? (Do not round intermediate calculations. Enter your answers in thousands rounded to the nearest whole number.)arrow_forward
- The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: 01 Sales $ 330 Q2 $ 390 Beginning receivables Sales Cash collections Ending receivables a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q3 $ 450 Show Transcribed Text Beginning receivables Sales Cash collections Ending receivables Q1 Q1 Q1 330 04 $ 600 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. 330 Q2 Q2 Q2 390 390 390…arrow_forwardAssume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If credit sales are collected 55% during the month of sale, 25% the month following the sale, and 15% in the second month following the sale, what is the total expected cash collections to be received in May? Round your answer to one dollar.arrow_forwardThe beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on account. The remainder are cash sales. Sixty percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $465,000. Accounts receivable from previous accounting periods totaling $11,000 will be collected in the current year. The company is required to make a $21,500 loan payment and an annual interest payment on the last day of the year. The loan balance as of the beginning of the year is $145,000, and the annual interest rate is 10%. What will be reported as 'cash' on the budgeted balance sheet?arrow_forward
- Indarrow_forwardThe Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Sales Q1 $ 540 Q2 $ 570 Q3 Q4 $ 630 $ 780 a. Accounts receivable at the beginning of the year are $300. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 b. Accounts receivable at the beginning of the year are $300. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 c. Accounts receivable at the beginning of the year are $300. The company…arrow_forwardHow much is the company's expected cash collections in the month of May?arrow_forward
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College