Question

The financial analyst at Medupe Company has prepared the following sales and cash disbursement estimates (in thousand rand) for the period February to June of the current year

	February	March	April	May	June
Sale	5000	6000	4000	2000	2000
Cash disbursement	4000	4000	6000	5000	3000

Historically Medupe Company has had 30% of sales being for cash. Of the credit sales, 70% are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company has access to a R20000 revolving line of credit at a cost of 12% interest per year, assuming 365-day year. No administrative fees are applicable.

All purchases and other disbursements are procured on a cash basis. The depreciation for the year is estimated at R1 500 The beginning cash balance at April 1 is R1 500.

Required
Draw up a cash budget for Medupe Company for April, May and June and determine how much the requisite short-term financing by way of revolving line of credit will cost, if utilised.

	February	March	April	May	June
Opening balance
Cash sales (30%)
Credit sales (70%)
February
March
April
May
June
Total credit sales
Cash disbursement
Cash in/(out) flow
Financing costs
Total financing cost

Answer 1