Question: restaurant chain is forecasting cash borrowing needs for the next three months. The controller for the company has assembled these forecasted data: Forecasted amounts January

restaurant chain is forecasting cash borrowing needs for the next three months. The controller for the company has assembled these forecasted data:

Forecasted amounts January February March
Cash collections for customers $120,000 $90,000 $150,000
Cash Payments
Direct materials purchases 25,000 35,000 30,000
Direct labor costs 17,000 15,000 18,000
Manufacturing overhead costs 30,000 25,000 35,000
Selling and administrative expenses 16,000 13,000 20,000
Interest payments 3,000 3,000 3,000
Income tax payments 0 0 5,000
Dividend payments 0 20,000 0
Machine purchase 0 40,000 0
Beginning cash balance, January 1: $7,000

Minimum month-end cash balance: $5,000

The controller is using these data to construct a month-by-month cash budget for January, February, and March.

For simplicity, assume that loans are repaid as soon as possible, when surplus cash is available. Also assume that no interest has to be paid on the loans, just a repayment of principal.

According to these data, how much borrowing is needed in February?

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 Accounting Questions!