Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

I M Real Estate Ask Me For My Card

Authors: Be Mi Real Estate Store

1st Edition

B0BW2C6KY6

More Books

Students also viewed these Finance questions

Question

2. If you were Don, what action would you take?

Answered: 1 week ago