Question: Help with this please!!! The November through February months represent a seasonal slow down for Green's Lawn Care & Services Co. Green's has some winter

Help with this please!!!

The November through February months represent a seasonal slow down for Green's Lawn Care & Services Co. Green's has some winter services, but they do not generate as much revenue as their standard summer services. Because of this seasonal down turn, the firm develops a cash budget in order to plan for possible short falls. Based on historical trends, the firm's economic forecasting staff has provided the information below. All of Green's sales are on a credit basis, and 90% are collected in the month following the sale. The remaining 10% are collected two months after the sale. "Material expenses" are 40% of the current months sales and are paid in the month incurred. All wages and overhead are also paid in the month incurred. As part of the firm's extension of its services, a monthly payment for new equipment of $300 is required through the end of 2003. In February the firm must repay a $13,000 note. Green's will have an end cash balance for December of $15,000. The firms required minimum cash balance is $60,000. The firm has an agreement with a bank; a line of credit allows it to borrow up to $45,000 and it is the firms policy to repay outstanding balances as soon as excess cash is available. Based on the cash budget you prepare for the months of January through March, will the firm have to increase its line of credit in order to meet its borrowing needs?

Month

Estimated Sales Wages Overhead (Cash)
November, 2002 $25,000 $7,000 $3,000
December, 2002 27,000 8,000 4,000
January, 2003 25,000 7,000 3,000
February, 2003 10,000 5,000 2,000
March, 2003 50,000 10,000 7,000

Question 2 options:

1) No, the firms maximum borrowing needs are $13,400

2) No, the firms maximum borrowing needs are $18,500

3) Yes, the firms maximum borrowing needs are $51,350

4) Yes, the firms maximum borrowing needs are $63,400

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!