Question

In: Finance

Cash Conversion Cycle The HDL, Inc. balance sheet and income statement for the year ending 20xx...

Cash Conversion Cycle

The HDL, Inc. balance sheet and income statement for the year ending 20xx are as follows:

Balance Sheet

(In millions of Dollars)

ASSETS

Cash                                     $6.0

Accounts Receivable              14.0

Average Inventory                   12.0

Fixed Assets, net                  40.0

                                            --------

TOTAL ASSETS                 $72.0

                                             =====

LIABILITIES AND EQUITY

Accounts Payable                $10.0

Salaries and Benefits Payable   2.0

Other current Liabilities            10.0

Long-term debt                         12.0

Equity                                     38.0

                                               --------

TOTAL EQUITY                     $72.0

                                              =====

Income Statement

(In millions of Dollars)

Net Sales                            $100.0

Cost of Sales                            60.0

Selling and admin. Expenses   20.0

Other Expenses                        15.0

                                             --------

EARNINGS AFTER TAXES   $5.0

                                            =====

Part 1 of 2:

A. determine the length of the inventory conversion period.

B. determine the length of the receivables conversion period.

C. determine the length of the operating cycle.

D. determine the length of the payables deferral period.

E. determine the length of the cash conversion cycle.

F. what is the meaning of the number that you calculated in part E?

Formulas:

Inventory Conversion Period (ICP)

Average Inventory

-------------------------

Cost of Sales/365

Receivables Conversion Period (RCP)

Accounts Receivable

-------------------------

Net Sales/365

Operating Cycle (OC)

ICP + RCP

Payables Deferral Period (PDP)

Accounts Payable + Salaries & Benefits

-------------------------------------------------------

Cost of Sales + Selling and admin. Expenses/365

Cash Conversion Cycle

OC - PDP

Cash conversion cycle exercise -- part 2 of 2 (Show your work in the Excel template):

You have made some calculations on the cash conversion cycle -- so you are a little comfortable with that process. Now, let’s say that you are in upper management, and you want to "tighten your ship" a little to increase your cash flow just on current operations. You ask for the following, reasonable goals:

1) A 10% decrease in average inventory.

2) A 10% decrease in accounts receivable.

3) A 10% increase in accounts payable.

While these adjustments are small and reasonable, redo your calculations and see just how much of a difference these small adjustments can make on the total cash conversion cycle.

Solutions

Expert Solution

Inventory Conversion Period = Average Inventory / (Cost of Sales/365)

We are given Average Inventory = $ 12 million and Cost of Sales = $ 60 million

Hence Inventory Conversion Period = 12/(60/365) = 73 days

Receivables Conversion Period = Accounts Receivables /(Net Sales/365)

We are given Accounts Receivables = $ 14 million and Net Sales = $ 100 million

Hence Receivables Conversion Period = 14/(100/365) = 51.1 days

Operating Cycle = ICP + RCP = (73 + 51.1) = 124.1 days

Payables Deferral Period = (Accounts Payables + Salaries & Benefits)/[(Cost of sales + Selling & Admin Expenses)/365]

We are given Accounts Payables = $ 10 million, Salaries & Benefits = $ 2 million, Selling & Admin Expenses = $ 20 million.

Hence Payables Deferral Period = (10+2)/[(60+20)/365] = 54.75 days

Cash Conversion Cycle = OC - PDP = (124.1 - 54.75) = 69.35 days

Cash conversion cycle (CCC) is simply the lenght of the time it takes for a company to convert its input purchases into cash through sales. It is a measure of time the company (working) capital is tied in the production process and it is sum of time required to convert the inventory into goods & sell them and then collect the receivables in cash minus the time available from suppliers to pay the company's liabilities

The excel worksheet showing the impact of the proposed changes is as below:


Related Solutions

Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet...
Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement. a. Income Statement Data for 20XX:  Units produced and sold = 420  Sales ($80 per unit selling price) = $33600 ...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $ 140.0 Accounts payable $800.0 Accts. Receivable 880.0 Notes payable ` 600.0 Inventories 1,320.0 Accruals 400.0 Total current assets 2,340.0 Total current liabilities 1,800.0 Long-term bonds 1,000.0 Total debt 2,800.0 Common stock 200.0 (50,000 shares) Retained earnings 1,000.0 Net plant & equip 1,660.0 Total common equity 1,200.0 Total assets $4,000.0 Total liabilities & equity $4,000.0 INCOME STATEMENT Net sales $6,000.0 Operating costs 5,599.8 Depreciation 100.2...
Harrison Purvis is preparing his balance sheet and income and expense statement for the year ending...
Harrison Purvis is preparing his balance sheet and income and expense statement for the year ending December 31, 2016. He is having difficulty classifying six items and asks for your help. Which, if any, of the following transactions are assets, liabilities, income, or expense items? Some items will appear on both statements. a. Harrison rents a house for $1,350 a month. b. On June 21, 2016, Harrison bought diamond earrings for his wife and charged them using his Master Card....
Cash Budget, Income Statement and Balance Sheet
The following information is available in the question attached:
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question...
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question no longer need to be answered
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me...
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me to run a gas station business, and you may make up your own numbers, just dont copy someone elses from the internet.
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me...
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me to run a gas station business, and you may make up your own numbers, just dont copy someone elses from the internet.
Describe the changes to the balance sheet, income statement, and statement of cash flows for the...
Describe the changes to the balance sheet, income statement, and statement of cash flows for the following transactions: a. billing a client for a completed construction project b. pay invoices for building materials c. labor charged to a job d. paying employees wages e. signing a construction or development loan
prepare a classified balance sheet and a statement of cash flows for the month ending August...
prepare a classified balance sheet and a statement of cash flows for the month ending August On the 1st of August, “Brothers haircut” had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On August 4, Incurred $380 of advertising costs due in 20 days On August 5, Purchased salon equipment for $120 On August 7, Paid for supplies (shampoos, creams, and gels) $350 On August 8, received $280 for selling gels On August...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year ended December 31, 2018. Assume the following (all as of 12/31/18): a. Beta was 1.60 b. There are 3,756,000 shares outstanding c. There are 4,256,000 shares authorized d. There are 500,000 shares in Treasury e. The share price was $78.50share. f. The overall market return was 9.0% g. The risk-free rate of return is 2.5% h. The amount in current maturities ($3,500) of LTD...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT