Question

Sales are made on a cash basis only. Koehl's purchases must be paid for during the...

Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,600 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $850, but Koehl has agreed to maintain an average bank balance of $4,500 - this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.) The estimated sales and purchases for December, January, and February are shown below. Purchases during November amounted to $140,000.

Sales December $130,000, Purchases $25,000

Sales January 34,000, Purchases 25,000

Sales February 66,000, Purchases 25,000

Suppose Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company's loan requirements be at the end of December in this case?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Add a comment
Know the answer?
Add Answer to:
Sales are made on a cash basis only. Koehl's purchases must be paid for during the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Cash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business,...

    Cash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a...

  • Us MS Excel to compute. 122-14 Dorothy Koehl recently leased space in the Southside Mall and...

    Us MS Excel to compute. 122-14 Dorothy Koehl recently leased space in the Southside Mall and opened Budgeting business, Koehl's Doll Shop. Business has been good, but Koehl has free run out of cash. This has necessitated late payment on certain orders, which turn, is beginning to cause a problem with suppliers. Koehl plans to burn from the bank to have cash ready as needed, but first she needs a forecast : just how much she must borrow. Accordingly, she...

  • Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll...

    Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget...

  • please solve the question for me.thank you Excel Online Structured Activity: Cash Budgeting Dorothy Koehl recently...

    please solve the question for me.thank you Excel Online Structured Activity: Cash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of just how...

  • Excel Online Structured Activity: Cash Budgeting porothy Koehl recently leased space in the Southside Mall and...

    Excel Online Structured Activity: Cash Budgeting porothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of just how much she must borrow. Accordingly, she has...

  • Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October...

    Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October 2015, along with its forecast sales and purchases for the period November 2015 through April 2016, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The...

  • a. Sales are 60% cash and 40% credit. Credit sales are collected 20% in the month...

    a. Sales are 60% cash and 40% credit. Credit sales are collected 20% in the month of sale and the remainder in the month after sale. Actual sales in December were $56,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue January ................ $62,000 February .............. $72,000 b. Actual purchases of direct materials in December were $23,000. The company's purchases of direct materials in January are budgeted to be $20,000 and...

  • Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of...

    Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....

  • The following information pertains to Hepburn Company: Month Sales Purchases January $66,000 $40,000 February $84,000 $49,000...

    The following information pertains to Hepburn Company: Month Sales Purchases January $66,000 $40,000 February $84,000 $49,000 March $102,000 $60,000 cash is collected from customers in the following manner : month of sale 40% month following the sale 60% 45% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. labor costs are 30% of sales. other operating costs are $33,000 per month (including $9000 of depreciation) both of these are...

  • The following information pertains to Hepburn Company: Month Sales Purchases January $60,000 $35,000 February $84,000 $42,000...

    The following information pertains to Hepburn Company: Month Sales Purchases January $60,000 $35,000 February $84,000 $42,000 March $107,000 $66,000 Cash is collected from customers in the following manner: Month of sale 35% Month following the sale 65% 50% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Labor costs are 25% of sales. Other operating costs are $32,000 per month (including $10,000 of depreciation). Both of these are paid...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT