Chapter 3: Working capital investment Flashcards
Accounts payable payment period:
Accounts payable payment period = (Average trade payables/Purchases or Cost of sales) × 365 days
Average inventory
Average inventory = buffer safety inventory + (re-order/2)
Cash operating cycle:
The period of time that elapses between the point at which cash begins to be expended on the production of a product or service and the collection of cash from a customer.
Factoring:
An arrangement to have debts collected by a factor company, which advances a proportion of the money it is due to collect.
Maximum inventory level:
Maximum inventory level = re-order level + re-order quantity – (minimum usage × minimum lead time)
Minimum inventory or buffer safety inventory:
Minimum inventory or buffer safety inventory = re-order level – (average usage × average lead time)
Net working capital
The net working capital of a business is its current assets less its current liabilities.
Non-recourse factoring
The debt factor has no recourse to the client in the event of non-payment, ie bad debts insurance is being provided by the debt factor
Overtrading
A situation where a business has inadequate cash to support its level of sales (also known as undercapitalisation).
Re-order level:
Re-order level = maximum usage × maximum lead time
The economic order quantity (EOQ):
The optimal ordering quantity for an item of inventory which will minimise inventory related costs.
Working capital finance:
The approach taken to financing the level, and fluctuations in the level, of net working capital.
What is the quick ratio if the Company’s policy for inventory is to keep it three times lower than prepayments received, if the company has the following balances (in thousands of dollars):
prepayment received for services 120
cash deposit with maturity on demand 30
cash on hand 25
short-term prepayment issued for polygraphic products 20
outstanding bank loan with maturity in 3 years 80
0.625
The quick ratio is calculated as follows = (30+25+20)/120=0.625. Inventory should be ignored as it is excluded for calculation of quick ratio. Bank loan balance should be ignored as it is long term liability. Please keep in mind that the deposit should be included into calculation as it has maturity on demand.
Which of the following actions will increase quick ratio?
Sell inventory on credit term
The following are extracts from company Green accounts for the year ended 30 June 2016: Investments in subsidiaries - $310,000; Trade receivables - $150,000; Raw materials - $25,000; Finished goods - $40,000; Bank loan (maturity on 31 December 2017) - $200,000; Trade payables - $95,000; Sales for the year ended 30 June 2016 - $1,140,000; Cost of sales for the year ended 30 June 2016 - $730,000. Inventory amounts didn’t fluctuate much during the year. Which of the following statement is TRUE?
Each $1 invested in working capital by Green generates $9.5 of revenue
Working capital of company Green is calculated as follows: Receivables + Finished goods + Raw materials - Payables = 150,000 + 40,000 + 25,000 - 95,000 = 120,000 Net working capital ratio is in its turn calculated as follows: Sales / Working capital = 1,140,000 / 120,000 = 9.5 Please take into account that investments in subsidiaries and bank loan are long-term items, so not taken into account in the calculations.
Which of these statements about economic order quantity (EOQ) of inventory is true?
The higher the EOQ level the higher is the inventory cycle
The higher the EOQ level the higher is the inventory cycle. EOQ = √(2 x order cost x demand/holding cost). From this we can see that EOQ is directly proportional to both demand and order costs and inversely proportional to holding costs. Inventory cycle (in weeks) = 52 x (EOQ/demand), so the higher the level of EOQ the higher will be the inventory cycle.
As a firm’s cash operating cycle increases, the firm:
Increases its investment in working capital;
Given the following information about a company, calculate its inventory turnover ratio.
Sales revenue 600,000
Gross profit 200,000
Net profit 40,000
Average inventory 50,000
Ending inventory 80,000
8.0
Inventory turnover = Cost of sales/Average inventory. Cost of sales = Sales revenue – Gross profit. Cost of sales = 600,000 – 200,000 = 400,000. Inventory turnover = 400,000/50,000 = 8
Working capital can be best described as:
Net current assets or current assets minus current liabilities;
Working capital is short term investment that companies make in a day-to-day operating infrastructure and can be calculated as current assets minus current liabilities.
Given the following information about a company, find its average safety inventory (assume 50-week year)
Reorder level 15,000 units
Reorder size 35,000 units
Demand for coming year 300,000 units
Average lead time 2 weeks
20,500
First calculate the buffer safety inventory = Reorder level – (average usage x average lead time). Buffer safety = 15,000 - (300,000 / 50) x 2 = 15,000 - 12,000 = 3,000. Average inventory = buffer safety + re-order amount / 2 = 3,000 + (35,000 / 2) = 20,500 units.
Given the data, find the number of orders that need to be placed every year and the inventory cycle if inventory costs are to be minimized. Demand = 10,000 units. Holding costs = 2.5/unit. Order cost = 500/order.
5 orders and 10.4 weeks
EOQ =√[2C0D/Ch] = √[(2 x 500 x 10,000)/2.5] = 2,000 units. Number of orders = 10,000/2,000 = 5. Inventory cycle = 52/5 = 10.4 weeks.
Given the following information about a company, find its buffer safety inventory (assume 50-week year)
Reorder level 10,000 units
Reorder size 30,000 units
Demand for coming year 300,000 units
Average lead time 1 week
4,000
Buffer safety = Re-order level – (average usage x average lead time). Average usage per week = 300,000 / 50 = 6,000 units/week. Buffer safety = 10,000 - (6,000 x 1) = 4,000 units.
benefit of ‘Just in time’ inventory procurement
Reduction in inventory holding costs
Reduced manufacturing lead time
Reduced scrap rework
Which of the following are objectives of working capital
Profitability
Liquidity
A manufacturing company requires rubber as a raw material for its products. Placing an order to acquire rubber costs the company $22.05/order and holding costs are $ 0.1 per unit per year. If the company has a demand of 20,000 units per year and every unit uses 2 units of rubber, find the economic order quantity for the company. Answer: EOQ is
4200 units
EOQ = √[2CoD/Ch] = √[(2 x 22.05 x 20,000 x 2)/0.1] = 4,200
A supplier offers a client a 5% discount if it orders at least 5,000 units at a time. Given the following information about the client, what would be the difference in the costs for the client of taking up the discount offer? Price per unit = $23. Demand = 10,000 units per year. Ordering cost = $600. Holding cost = $1.92 per unit. Answer: $ (round the answer to nearest $
10,300
First find the EOQ = √(2 x order cost x demand/holding cost) = √(2 x 600 x 10,000/1.92) = 2,500. The without discount the annual costs will be: Cost of purchases = 23 x 10,000 = 230,000. Ordering costs will be = 600 x (10,000/2,500) = 2,400. Holding costs will be = 1.92 x (2500/2) = 2,400. Total costs = 230,000 + 2,400 + 2,400 = 234,800. With discount the costs will be: Cost of purchases = 23 x 10,000 x 0.95 = 218,500. Ordering costs will be = 600 x (10,000/5,000) = 1,200. Holding costs will be = 1.92 x (5,000/2) = 4,800. Total costs = 218,500 + 1,200 + 4,800 = 224,500. So the savings are = 234,800 – 224,500 = 10,300.