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...
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...
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...
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...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$120,000 April ​$280,000 July ​$200,000 February   140,000 May   275,000 August   200,000 March   170,000 June   200,000 ​(Click on the icon located on the​ top-right corner of the data table above in order to copy its contents into a spreadsheet.​) PrintDone . Lewis collects 30 percent of its sales in the month of the​ sale, 50 percent in the month following...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,110. Actual sales for August and September are as follows: August September Cash sales $6,000     $4,500     Credit sales 58,000     62,000         Total sales $64,000     $66,500     Credit sales are collected over a three-month period: 40 percent in the month of sale, 36...