Question: Mitch & Murray's had projected its sales for the first six months of 2023 to be as follows: January $50,000 February $60,000 March $100,000 April

Mitch & Murray's had projected its sales for the first six months of 2023 to be as follows: January $50,000 February $60,000 March $100,000 April $180,000 May $240,000 June $240,000 Cost of goods sold is 60% of sales. Purchases are made and paid for two months prior to the sale. 42% of sales are collected in the month of the sale, 38% are collected in the month following the sale, and the remaining 20% in the second month following the sale. Total other cash expenses are $40,000/month. The company's cash balance as of March 1, 2023 is projected to be $40,000, and the company wants to maintain a minimum cash balance of $15,000. Excess cash will be used to retire short-term borrowing (if any exists). M&M has no short-term borrowing as of March 1, 2023. Assume that the interest rate on short-term borrowing is 1% per month.

QUESTION: How much short-term financing (in $) is needed by March 30, 2023? Note: Round to the nearest dollar. No decimal needed.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!