JUDLAH SERVICES LIMITED Judlah Services Limited has been trading for the past five years. Last year they have recently r

[answerhappygod]

Judlah Services Limited Judlah Services Limited Has Been Trading For The Past Five Years Last Year They Have Recently R 1 (86.7 KiB) Viewed 38 times

JUDLAH SERVICES LIMITED Judlah Services Limited has been trading for the past five years. Last year they have recently realized that they are experiencing frequent cash flow issues. Their financial accountant has suggested the tracking of the inflows and outflows of the company's cash. The following information on revenue and costs were made available to you: Month October 2020 November 2020 December 2020 January 2021 February 2021 March 2021 April 2021 Sales ($'000) 1 400 000 1 050 000 1 1 575 000 875 000 1 050 000 1 225 000 1 050 000 Purchases ($'000) 1 137 500 787 500 1 312 500 612 500 787 500 962 500 787 500 Additional notes: i i. The cash balance on January 01st 2021 was $262 500; ii. 20% of sales is usually attributable to cash sales while the remainder is settled: a. One month after sales: 50%; b. Two months after sales: 20%. iii. iv. 2% of sales is allocated to Sales Expenses and is paid in the month of sale; 50% of cost of purchases is paid in the month of purchase and the next 50% in the following month; 3% of purchases is allocated to Purchases Expenses and is paid in the following month after purchase; V. vi. New equipment of $157 500 to be purchased in January and is to be paid in three equal instalments from the same month; vii. Outdated equipment to be sold in February for $43 750; viii. Salaries are $52 500 per month; ix. Utilities will be $122 500 in January and is expected to increase by 10% each month; and X. The firm plans to take a loan in March at an interest rate of 15% per annum. The loan amount will be $700 000. Interest is to be paid monthly equally, starting in March. After proper tracking of their cash flow last year Judlah Services Limited has found themselves in a position where they have too much cash. The top management has established that the minimum amount of cash to hold should be $100 000. The accountant has also indicated that the daily cash flow for the business is $60 000. The finance manager has indicated that the annual interest rate is 10.95% and that the cost of selling one of Judlah Services Limited's security is $90.

Recording cash and cash equivalents at $443 216.97 Judlah Services Limited's top management has decided to utilize the cash amount over the cash return point to invest in a two-asset portfolio. Asset 1 will be allocated 33% while asset 2 will be allocated 67% of the excess cash. Three stocks trading on the JSE have been identified for analysis IBM, TCL and SAG. The following information has been given from the chief financial officer: Economic Condition Boom JBM 30% TCL 20% SAG 8% Neutral Recession 10% -3% 12% -4% 3.5% -2% Asset Combinations to consider: a. Asset 1 JBM and Asset 2 TCL (with a correlation of .90); b. Asset 1 SAG and Asset 2 JBM (with a correlation of .75); or C. Asset 1 SAG and Asset 2 TCL (with a correlation of - 40). Required: As the junior financial analyst, you have been approached by the CFO to help with the following: a. Prepare a cash budget for the four-month period ending April 30th, 2021.