Calculating Cash Collections [LO3] The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year:
a. Accounts receivable at the beginning of the year are $345. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following:
b. Rework (a) assuming a collection period of 60 days.
c. Rework (a) assuming a collection period of 30 days.
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.
Answer to Problem 5QP
Q1-$755
Q2-$835
Q3-$890
Q4-$970
Explanation of Solution
Given information:
Accounts receivable at the beginning of the year is $345, Collection period is 45 days.
Compute cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected in the current year
Compute ending receivables for quarter 1:
Therefore ending receivable will be half of the current year sales
Hence, ending receivables is $410.
Compute cash collection for quarter 1:
Hence, cash collected for the quarter 1 is $755.
Compute ending receivables for quarter 2:
Hence, ending receivables is $425.
Compute cash collection for quarter 2:
Hence, cash collected for the quarter 2 is $835.
Compute ending receivables for quarter 3:
Hence, ending receivables is $465.
Compute cash collection for quarter 3:
Hence, cash collected for the quarter 1 is $890.
Compute ending receivables for quarter 4:
Hence, ending receivables is $505.
Compute cash collection for quarter 4:
Hence, cash collected for the quarter 1 is $970.
b)
To determine: The cash collection for each four quarters when the collection period is 60 days.
Answer to Problem 5QP
Q1-$891.67
Q2-$840
Q3-$903.33
Q4-$983.33
Explanation of Solution
Given information:
Accounts receivables at the beginning of the year are $345, Collection period is 45 days.
Compute cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected by this current year
Compute ending receivables for quarter 1:
Therefore ending receivable will be half of current year sales
Hence, ending receivables is $273.33.
Compute cash collection for quarter 1:
Hence, cash collected for the quarter 1 is $891.67.
Compute ending receivables for quarter 2:
Hence, ending receivables is $283.33.
Compute cash collection for quarter 2:
Hence, cash collected for the quarter 2 is $840.
Compute ending receivables for quarter 3:
Hence, ending receivables is $310.
Compute cash collection for quarter 3:
Hence, cash collected for the quarter 1 is $903.33.
Compute ending receivables for quarter 4:
Hence, ending receivables is $336.67.
Compute cash collection for quarter 4:
Hence, cash collected for the quarter 1 is $983.33.
c)
To determine: The cash collection for each four quarters when the collection period is 30 days.
Answer to Problem 5QP
Q1-$618.33
Q2-$830
Q3-$876.67
Q4-$956.67
Explanation of Solution
Given information:
Accounts receivable at the beginning of the year is $345, Collection period is 30 days.
Compute cash collection for each four quarters:
Note: All the receivables, which are outstanding, will be collected in this current year
Compute ending receivables for quarter 1:
Therefore ending receivable will be half of the current year sales
Hence, ending receivables is $546.67.
Compute cash collection for quarter 1:
Hence, cash collected for the quarter 1 is $618.33.
Compute ending receivables for quarter 2:
Hence, ending receivables is $566.67.
Compute cash collection for quarter 2:
Hence, cash collected for the quarter 2 is $830.
Compute ending receivables for quarter 3:
Hence, ending receivables is $620.
Compute cash collection for quarter 3:
Hence, cash collected for the quarter 1 is $876.67.
Compute ending receivables for quarter 4:
Hence, ending receivables is $673.33.
Compute cash collection for quarter 4:
Hence, cash collected for the quarter 1 is $956.67.
Want to see more full solutions like this?
Chapter 18 Solutions
Fundamentals of Corporate Finance
- Q1: Aztec Products wishes to evaluate its cash conversion cycle (CCC). Research by one of the firm’s financial analysts indicates that on average the firm holds items in inventory for 65 days, pays its suppliers 35 days after purchase, and collects its receivables after 55 days. The firm’s annual sales (all on credit) are about $2.1 billion, its cost of goods sold represent about 67 percent of sales, and purchases represent about 40 percent of cost of goods sold. Assume a 365-day year. A) How many dollars of resources does Aztec have invested in (1) inventory, (2) accounts receivable, (3) accounts payable, and (4) the total CCC? B). If Aztec could shorten its cash conversion cycle by reducing its inventory holding period by 5 days, what effect would it have on its total resource investment found in part A?arrow_forwardQ1: Aztec Products wishes to evaluate its cash conversion cycle (CCC). Research by one of the firm’s financial analysts indicates that on average the firm holds items in inventory for 65 days, pays its suppliers 35 days after purchase, and collects its receivables after 55 days. The firm’s annual sales (all on credit) are about $2.1 billion, its cost of goods sold represent about 67 percent of sales, and purchases represent about 40 percent of cost of goods sold. Assume a 365-day year. a) If Dean Muhammad Suppliers receive an invoice for purchases dated 12/12/2002 subject to credit terms of "2/10, net 30", what is the last possible day the discount can be taken? January 11 January 22 January 30 December 22arrow_forwardQ1: Aztec Products wishes to evaluate its cash conversion cycle (CCC). Research by one of the firm’s financial analysts indicates that on average the firm holds items in inventory for 65 days, pays its suppliers 35 days after purchase, and collects its receivables after 55 days. The firm’s annual sales (all on credit) are about $2.1 billion, its cost of goods sold represent about 67 percent of sales, and purchases represent about 40 percent of cost of goods sold. Assume a 365-day year. A. How many dollars of resources does Aztec have invested in (1) inventory, (2) accounts receivable, (3) accounts payable, and (4) the total CCC?arrow_forward
- Q1: Aztec Products wishes to evaluate its cash conversion cycle (CCC). Research by one of the firm’s financial analysts indicates that on average the firm holds items in inventory for 65 days, pays its suppliers 35 days after purchase, and collects its receivables after 55 days. The firm’s annual sales (all on credit) are about $2.1 billion, its cost of goods sold represent about 67 percent of sales, and purchases represent about 40 percent of cost of goods sold. Assume a 365-day year. a. What is Aztec Products’ operating cycle (OC) and cash conversion (CCC)?arrow_forwardWhat amount of cash must be invested today in order to have $30,000 at the end of one year assuming the rate of return is 9%? A) $22,727.28B) $27,000.00C) $27,522.94D) $27,300.00arrow_forwardEconomic Order Quantity. Assume that Every-man's Bookstore uses up cash at a steady rate of$200,000 per year. The interest rate is 2% and each saleof securities costs $20. (LO1)a. How many times a year should the store sellsecurities?b. What is its average cash balance?arrow_forward
- Green Corporation anticipates a cash requirement of P1,500 over a 1- month period. It is expected that cash will be paid uniformly. The annual interest rate is 24 percent. The transaction cost of each borrowing or withdrawal is P30. (a) What is the optimal cash balance? (b) What is the average cash balance? CHOOSE THE CORRECT ANSWER FOR A AND B(A) P1,432.05 and (B) P566.03(A) P2,121.32 and (B) P8060.66(A) P1,121.32 and (B) P1060.66(A) P2,121.32 and (B) P1060.66(A) P1,732.05 and (B) P866.03arrow_forwardThe firm PAR inc. forecasts monthly disbursements of $ 75,000 over the next year. The firm invests its cash in treasury bills at an annual rate of 30%. A treasury bill transaction costs the firm $ 150.a) What would be the optimal amount of treasury bills that the business must sell to minimize the total cost of cash on hand during the year? b) What would that total cost of cash be during the year?arrow_forwardSuppose that the interest rate on Treasury bills is 6%, and every sale of bills costs P60. You pay out cash at a rate of P800,000 a year. According to Baumol's model of cash balances, what is Q? P17,376 P20,000 P50,000 P40,000 P10,000arrow_forward
- en experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm’s cash conversion cycle. Using the following information and a 365-day year,(b) what is your Net Working Capital • Current inventory = $ 180,000.00 • Annual sales = $ 700,000.00 • Accounts receivable = $ 165,000.00 • Accounts payable = $ 85,000.00 • Total annual purchases = $ 567,000.00 • Purchases credit terms: net 30 days. • Receivables credit terms: net 50 daysarrow_forwardWhat amount of cash must be invested today in order to have $60,000 at the end of one year assuming the rate of return is 9%? (Do not round your PV factors.)A. $54,600.00B. $45,454.56 C. $55,045.88 D. $54,000.00arrow_forwardH1. A bank bill with a face value of $250,000 was issued today and it matures in 60 days' time. If interest rates are 4.5% p.a. what amount of cash does the issuer receive today? Show proper step by step calculationarrow_forward
- 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 LearningCorporate 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