Transcript Company is preparing a cash budget for February.The company has $150,000 cash at the beginning of February and anticipates total sales of $800,000, consisting of 25% cash sales and 75% credit card sales.The bank charges 3 percent for credit card transactions.The company sets its selling price at 160 percent of the cost of purchases and pays for each month's purchases at the end of the month.Other cash disbursements are $20,000 per month plus 4% of total sales.In addition, a $600,000 note will be due in February for equipment purchased last August.Transcript Company has an agreement with its bank to maintain a cash balance of $100,000.
Required: What amount, if any, must the company borrow during February?

Question

Quizplus · Accepted Answer

The Answer of Transcript Company is preparing a cash budget for February.The company has $150,000 cash at the beginning of February and anticipates total sales of $800,000, consisting of 25% cash sales and 75% credit card sales.The bank charges 3 percent for credit card transactions.The company sets its selling price at 160 percent of the cost of purchases and pays for each month's purchases at the end of the month.Other cash disbursements are $20,000 per month plus 4% of total sales.In addition, a $600,000 note will be due in February for equipment purchased last August.Transcript Company has an agreement with its bank to maintain a cash balance of $100,000.
Required: What amount, if any, must the company borrow during February?

Transcript Company Is Preparing a Cash Budget for February