Question

1. Calculate the nominal annual cost of trade credit under each of the following terms. Assume...

1.

Calculate the nominal annual cost of trade credit under each of the following terms. Assume a 365-day year. Do not round intermediate calculations. Round your answers to two decimal places.

  1. 1/15, net 25.

      %

  2. 2/10, net 55.

      %

  3. 3/10, net 45.

      %

  4. 2/10, net 45.

      %

  5. 2/15, net 40.

      %

2.

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 for the critical period around Christmas, when needs will be especially high.

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 $5,000 per month, and the rent is $3,000 per month. In addition, she must make a tax payment of $11,000 in December. The current cash on hand (on December 1) is $800, but Koehl has agreed to maintain an average bank balance of $4,000 - 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 $120,000.

Sales Purchases
December $170,000 $45,000
January 48,000 45,000
February 68,000 45,000
  1. Prepare a cash budget for December, January, and February. Do not round intermediate calculations. Round your answers to the nearest dollar. Negative values, if any, should be indicated by a minus sign.

    Collections and Purchases:
    December January February
    Sales (Collections) $   $   $  
    Purchases $   $   $  
    Payments for purchases $   $   $  
    Salaries $   $   $  
    Rent $   $   $  
    Taxes $   --- ---
    Total payments $   $   $  
    Cash at start of forecast $   --- ---
    Net cash flow $   $   $  
    Cumulative cash balance $   $   $  
    Target cash balance $   $   $  
    Surplus cash or loans needed $   $   $  
  2. Suppose that 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? (Hint: The calculations required to answer this part are minimal.) Do not round intermediate calculations. Round your answer to the nearest dollar.

    $  

Homework Answers

Answer #1

1)

Know the answer?
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
Similar Questions
Problem 16-14 Cash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a...
Problem 16-14 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 has frequently run 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 asked...
Cost of Trade Credit Calculate the nominal annual cost of trade credit under each of the...
Cost of Trade Credit Calculate the nominal annual cost of trade credit under each of the following terms. Assume a 365-day year. Do not round intermediate calculations. Round your answers to two decimal places. 1/15, net 25.   % 2/10, net 50.   % 3/10, net 55.   % 2/10, net 55.   % 2/15, net 45.   %
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January February March   Sales budget $ 214,000 $ 234,000 $ 257,000 Credit sales are collected as follows: 60 percent in the month of the sale 25 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $98,000 ($68,000 of which was uncollected December sales). a. Calculate the...
The following is the sales budget for Coore, Inc., for the first quarter of 2019: January...
The following is the sales budget for Coore, Inc., for the first quarter of 2019: January February March   Sales budget $142,000 $159,000 $174,000 Credit sales are collected as follows: 70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales). a. Compute the sales for November....
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000.Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 40,000 $ 140,000 February $ 45,000 $ 160,000 March $ 42,000 $ 120,000 April $ 37,000 $ 122,000 May $ 47,000 $ 190,000 June $ 70,000 $ 160,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Sweeney Corporation has found that 80​% of its sales in any given month are credit​ sales,...
Sweeney Corporation has found that 80​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, Sweeney Corporation has experienced the following collection​ pattern: 25% received in the month of the sale 50% received in the month after the sale 24% received two months after the sale 1% of the credit sales are never received November sales for last year were $90,000​, while December sales were $110,000. Projected sales for...
HolidayHoliday Corporation has found that 6060 % of its sales in any given month are credit...
HolidayHoliday Corporation has found that 6060 % of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, HolidayHoliday Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 16% received two months after the sale 9% of the credit sales are never received November sales for last year were $ 90 comma 000$90,000 , while December sales...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master for the first quarter. a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances. ASSETS LIABILITIES AND EQUITY Cash $ 47,000 Accounts Payable $ 92,000 Accounts Receivable 224,000 Capital Stock 500,000 Inventory 60,000 Retained Earnings 109,000 Buildings and Equipment (net of depreciation) 370,000 TOTAL ASSETS...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT