0% found this document useful (0 votes)
460 views10 pages

Cash Management Strategies and Calculations

The document discusses cash conversion cycles and float for two companies. For Camp Manufacturing: the operating cycle is 106 days and the cash conversion cycle is 71 days. The daily cash expenditure is 9,589.04. Resources invested must be 680,821.92. For Simon Corporation: collection float is 7 days. Using a lockbox could make 26,630.14 available but may not be worthwhile as it costs 9,000/year.

Uploaded by

Kim Custodio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
460 views10 pages

Cash Management Strategies and Calculations

The document discusses cash conversion cycles and float for two companies. For Camp Manufacturing: the operating cycle is 106 days and the cash conversion cycle is 71 days. The daily cash expenditure is 9,589.04. Resources invested must be 680,821.92. For Simon Corporation: collection float is 7 days. Using a lockbox could make 26,630.14 available but may not be worthwhile as it costs 9,000/year.

Uploaded by

Kim Custodio
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
  • Cash Conversion Cycle
  • Optimum Cash Balance
  • Collection and Disbursement Float

CASH CONVERSION CYCLE

Camp Manufacturing turns over its inventory eight times each year, has an average payment period of 35 days, and
a. Calculate the firm’s operating cycle and cash conversion cycle.
b. Calculate the firm’s daily cash operating expenditure.
c. How much in resources must be invested to support its cash conversion cycle?

a. Ave. Age of Invent.= # of working days/Inventory Turnover


= 365 / 8
= 46 days

Operating cycle= Ave. Age of Inv. + Ave. Age of Trade receivables


= 46 + 60
= 106 days

CCC= Operating cycle - Average age of trade payables


= 106 - 35
= 71 days

b. Annual sales 3,500,000


Divide: # of working days 365
Daily cash operating expenditure 9589.041096

c. Daily cash operating expenditure 9589.041096


Multiply:Cash conversion cycle 71
Resources 680821.9178

OPTIMUM CASH BALANCE


The cash requirements of Genie Company are estimated to be P500,000 per annum, spread evenly throughout the
Required:
[Link] the optimum amount of cash to be transferred.
[Link] the number of transactions per annum.
[Link] much is the total cost associated with the optimum cash balance?

1 ECQ= √ 2 x conversion cost x annual demand for cash/opportunity cost ( in percentag


= √ 2 x 150 x 500,000/0.12
= √ P 1,250,000,000
= P 35,355.34

2 Number of transactionTotal cash outlay/Optimal cash balance


= 500,000/35,355.54
= 14 transactions

3 Conversion cost= ( P 500,000 / P 35,355 ) x P 150


= P 2,121.34

Opportunity cost= ( P 35,355 / 2 ) x 0.12


= P 2,121.3

Total cost= Conversion cost + Opportunity cost


= P 2,121.34 + P 2,121.3
= P 4,242.64
nt period of 35 days, and has an average collection period of 60 days. The firm’s annual sales are P3.5 million. Assume there is

ad evenly throughout the year. The money on deposit earns 12%. The costs to purchase and sell marketable instruments is P15
tunity cost ( in percentage)
3.5 million. Assume there is no difference in the investment per peso of sales in inventory, receivables, and payables and that th

ketable instruments is P150 per transaction.


s, and payables and that there is a 365-day year.
COLLECTION AND DISBURSEMENT FLOAT
Float
Simon Corporation has daily cash receipts of P65,000. A recent analysis of its collections indicated that customers’ p
a. How much collection float (in days) does the firm currently have?
b. If the firm’s opportunity cost is 11%, would it be economically advisable for the firm to pay an annual fee of P16,50

a. b.
Collection float=Mail float + Processing float +Clearing float
Collection float=2.5 + 1.5 + 3=7 days

Lockbox system
Eagle Industries feels that a lockbox system can shorten its accounts receivable collection period by 3 days. Credit s
a. What amount of cash will be made available for other uses under the lockbox system?
b. What net benefit (cost) will the firm realize if it adopts the lockbox system?
c. Should it adopt the proposed lockbox system?

a. Annual credit sales 3,240,000


Divide:Number of days in year 365
Total 8876.712329
Multiply:Accounts Receivable Collection Period 3
Cash available for other use 26630.13699

b. Net Benefit = 26,630.14 x 0.15


Net Benefit=P 3,994.52

c. No,the cost of the lockbox system which is P 9,000 per year is greater than the net benefit of Eagle Indu
ndicated that customers’ payments were in the mail an average of 2.5 days. Once received, the payments are processed in 1.5

y an annual fee of P16,500 to reduce collection float by 3 days?

Opportunity cost = 65,000 x 3 x 0.11 $21,450.00

Opportunity cost-Annual fee=21,450 -16,500=4,950

It would be advisable because the savings exceed the cost.

period by 3 days. Credit sales are P3,240,000 per year, billed on a continuous basis. The firm has other equally risky investmen

e net benefit of Eagle Industries which will result in a net decrese of income.
nts are processed in 1.5 days. After payments are deposited, it takes an average of 3 days for these receipts to clear the banki

er equally risky investments that earn a return of 15%. The cost of the lockbox system is P9,000 per year. Assume a 365-day ye
receipts to clear the banking system.

year. Assume a 365-day year.

Common questions

Powered by AI

Substantial collection float implies that a firm’s cash receipts are delayed, impacting liquidity and potentially hindering timely payments and investment opportunities. By reducing collection float, through methods such as lockbox systems which reduce delays, a firm can lower the opportunity cost tied to uncollected funds. For example, Simon Corporation's collection float spans 7 days, and reducing this by implementing a lockbox or reducing mail delays can accelerate cash flow and enhance financial performance through better capital management, higher interest earnings, and improved credit standings .

The economic rationale for determining the optimum cash balance involves balancing the transaction costs associated with converting securities to cash against the opportunity cost of holding cash. For Genie Company, the Economic Order Quantity (EOQ) model for cash management is used to determine this balance. The formula is ECQ = √(2 * conversion cost * annual demand for cash / opportunity cost), computing to P 35,355.34 . This optimum cash balance minimizes total costs from holding and converting cash, guiding the company's financial strategy to maintain sufficient liquidity while minimizing costs.

The total cost associated with maintaining the optimum cash balance for Genie Company is the sum of its conversion and opportunity costs. Conversion costs are calculated as (annual cash demand / optimal cash balance) x conversion fee, which equals P 2,121.34. The opportunity cost, being the cost of holding cash without investing, is (optimal cash balance / 2) x interest rate, amounting to P 2,121.3. Therefore, the total cost to maintain the optimum cash balance is P 4,242.64 . These components ensure Genie maintains liquidity at minimal cost.

Eagle Industries might reconsider implementing a lockbox system because the cost of the system, P 9,000 per year, exceeds the net benefits derived from it. While it shortens the accounts receivable collection period by 3 days, allowing more cash to be available for use (P 26,630 approximately), it only offers a net benefit of P 3,994.52 against the system cost, resulting in a net decrease of income . Such a financial decision requires weighing the benefits of improved cash flows against the direct cost, indicating that the expected gains do not justify the expenditure.

The cash conversion cycle (CCC) for Camp Manufacturing is calculated by subtracting the average payment period from the operating cycle. The operating cycle includes the average age of inventory and the average collection period. Specifically, it is calculated as follows: CCC = (Average Age of Inventories + Average Collection Period) - Average Payment Period = (46 days for inventory turnover + 60 days for accounts receivable turnover) - 35 days for accounts payable turnover = 71 days . This 71-day cycle indicates the duration it takes for the company to convert its investments in inventory and other resources back into cash, which is critical for understanding how liquid the company's operations are.

Simon Corporation should consider the opportunity cost savings against the fee cost when deciding whether to reduce collection float. Specifically, with daily cash receipts of $65,000 leading to potential opportunity cost savings of $21,450 with a 3-day reduction in collection time, paying an annual fee of $16,500 results in net savings of $4,950 . The decision hinges on whether these savings outweigh alternative investment opportunities and the firm’s cost of capital, ensuring the cost reduction aligns with strategic financial goals.

The strategic considerations for determining the frequency of cash transactions involve the trade-off between transaction costs and opportunity costs. For Genie Company, with optimum cash transfers determined at P 35,355.34 and annual transactions numbering 14, the company seeks to minimize the sum of transaction costs (costs associated with purchasing and selling marketable instruments) and the opportunity cost of idle cash (interest that could be earned if capital were invested). The strategy ensures sufficient liquidity while maximizing returns on surplus funds . Balancing these elements impacts cash flow stability and investment returns, essential for financial planning.

The cash conversion cycle influences the amount of resources a company needs to commit to support its working capital. For Camp Manufacturing, a 71-day cash conversion cycle indicates that resources are tied up for this duration before converting investments back into cash. With a daily cash operating expenditure of P 9,589.04, the necessary resource investment amounts to P 680,821.92 . Longer cycles require more investment in working capital, reducing liquidity available for other operational needs or investments.

CASH CONVERSION CYCLE
Camp Manufacturing turns over its inventory eight times each year, has an average payment period of 35
3.How much is the total cost associated with the optimum cash balance?
1
ECQ= √ 2 x conversion cost x annual demand for cash/
nt period of 35 days, and has an average collection period of 60 days. The firm’s annual sales are P3.5 million. Assume there
tunity cost ( in percentage)
3.5 million. Assume there is no difference in the investment per peso of sales in inventory, receivables, and payables and th
s, and payables and that there is a 365-day year.
COLLECTION AND DISBURSEMENT FLOAT
Float 
Simon Corporation has daily cash receipts of P65,000. A recent analysis of its colle
dicated that customers’ payments were in the mail an average of 2.5 days. Once received, the payments are processed in 1.5 
y
nts are processed in 1.5 days. After payments are deposited, it takes an average of 3 days for these receipts to clear the ba
receipts to clear the banking system.
year. Assume a 365-day year.

You might also like