Provide workings and/or explanations for all calculations.

CHAPTER 3. CASH FLOW AND FINANCIAL PLANNING

PROBLEM 3.1 (25 marks)

White Ltd generated sales revenues of $325,000 and $375,000 in March and April, and projected sales of $375,000, $400,000, $450,000 and $500,000 for May to August, respectively.

• Twenty per cent of the firms sales is for cash, 40% collected 1 month later and the remaining 40% is collected two months later.
• The firm expects to receive a monthly income of $12,500 attributable to interest and dividends.
• The firms purchases during March and April were $200,000 each month and are expected to be $225,000, $250,000, $275,000 and $325,000 during May to August, respectively.
• Ten percent of the firms purchases are for cash, 40% is paid one month later and the remaining 50% is paid after a two-month lag.
• Wages and salaries can be found for each month by adding 10% of the previous months sales to a fixed $50,000 charge.
• Monthly office and warehouse rents of $40,000 must be paid.
• Cash dividends of $20,000 will be paid in May and August.
• Taxes of $37,500 will be paid in May and August.
• A loan payment of $75,000, which includes principal and interest, must be made in July.
• A cash payment of $125,000 will be completed for a new machine in June.
• The firms cash balance at the end of April was $87,500.
• The policy requires a minimum cash balance of $50,000.

Requirements:

• Prepare a cash budget for May, June, July and August.
• Comment on the firms cash status forecast for May, June, July and August and the importance of preparing a cash budget.

CHAPTER 14. WORKING CAPITAL AND CURRENT ASSETS MANAGEMENT

PROBLEM 14.1 (10 marks)

ABC Manufacturing has an average inventory age of 80 days, an average collection period of 70 days and an average payment period of 60 days.

• Calculate the firms cash conversion cycle
• Calculate the firms cash turnover, or frequency of its cash conversion cycle in a year (assuming a 365-day year)
• Should the firm try to minimise or maximise the cash conversion cycle and cash turnover? Why?

PROBLEM 14.2 (15 marks)

Leopard Corporation purchases 1.2 million units per year of one component. The fixed cost per order is $25. The annual carrying cost of the item is 27% of its $2 cost.

Determine the EOQ if:

• No changes
• Order cost of zero
• Carrying cost of zero

What do your answers illustrate about the EOQ model? Explain.

CHAPTER 15. CURRENT LIABILITIES MANAGEMENT

PROBLEM 15.1 (10 marks)

Albert Ltd has purchases of $1,000,000 on credit. The supplier has offered Albert terms of 1.5/5, net 30. The current interest rate on a bank overdraft is 12%. What is the cost of giving up the cash discount? Should the company take it up?

PROBLEM 15.2 (10 marks)

Data#3 has obtained a $10,000 90-day bank loan at an annual interest rate of 15%, payable at maturity.

• How much interest in dollars will the firm pay on the 90 day loan?
• Find the effective cost of the loan for the 90 days.
• Annualise your finding in b) to find the effective annual rate of interest for this loan.