3) Crystal Inc. Wants to prepare a short-term financial plan by the end of April in order to see its cash position in May and June. The sales of Crystal Inc. n April was 200 000. Firm estimates a sale of 250 000 in May amd a sale of 300 000 in June. Crystal Inc. extends a one month trade credit to its customers receiving 30% of sales revenue in the month of sale and 70% one month later (so 30% of April sales revenue is received in April, remaining 70% is received in May and this applies to other months as well).

Cost of Raw Materials is 60% of each months sales revenue. Firm pays 50% of the cost of raw materials in the month of sale and 50% one month later (e.g firm pays 50% of the cost of raw materials that it needs for April in the month of April and remaining 50% in the month of May). Crystal Inc. Also pays 120 000 for salaries and wages each month. It also pays a rent of 10 000 each

month and has a monthly utility (e.g electricity) cost of 4000 each month Firm also has a 40 000 interest payment to a bank in June. Given this

a) Calculate the estimated cash inflows and cash outflows of that firm for the months of May and June

b) Assume that the firm has a cash amount of 60 000 in its safes by the end of April. Given this; do this firm need to borrow by the end of May and by the end of June. If so; how much?

Hello. If I would like to do so, do not do it with excel. I want a handwriting or a word script. Hodja does not accept the other as excel. thanks