Question

In: Finance

Of​ Sharpe's sales, 30 percent is for​ cash, another 40 percent is collected in the month...

Of​ Sharpe's sales,

30

percent is for​ cash, another

40

percent is collected in the month following the​ sales, and

30

percent is collected in the second month following sales. November and December sales for 2018 were

​$250,000

and

​$205,000​,

respectively.Sharpe purchases its raw materials 2 months in advance of its sales. The purchases are equal to

60

percent of the final sales price of​ Sharpe's products. The supplier is paid 1 month after it makes a delivery. For​ example, purchases for April sales are made in​ February, and payment is made in March.In​ addition, Sharpe pays

$8,000

per month for rent and

$15,000

each month for other expenditures. Tax prepayments of

$20,000

are made each​ quarter, beginning in March. The​ company's cash balance on December​ 31, 2018, was

​$24,000.

This is the minimum balance the firm wants to maintain. Any borrowing that is needed to maintain this minimum is paid off in the subsequent month if there is sufficient cash. Interest on​ short-term loans​ (12 percent) is paid monthly. Borrowing to meet estimated monthly cash needs takes place at the beginning of the month.​ Thus, if in the month of April the firm expects to have a need for an additional​ $60,500, these funds would be borrowed at the beginning of April with interest of​ $605

​(0.12×​1/12×​$60,500)

owed for April and paid at the beginning of May.

a. Prepare a cash budget for Sharpe covering the first 7 months of 2019.

b. Sharpe has​ $200,000 in notes payable due in July that must be repaid or renegotiated for an extension. Will the firm have ample cash to repay the​ notes?

a. Prepare a cash budget for Sharpe covering the first 7 months of 2019.  

Fill in the Collections for the month of​ January:  ​(Round to the nearest​ dollar.)

Nov

Dec

Jan

Feb

Mar

Apr

May

June

July

Sales

​$250,000

​$205,000

​$220,000

​$150,000

​$165,000

​$270,000

​$330,000

​$300,000

​$255,000

​Collections:

  Month of sale

​(30​%)

nothing

  First month

​(40​%)

nothing

  Second month

​(30​%)

nothing

     Total Collections

​$nothing

Solutions

Expert Solution

1. The Cash budget for January to July 2019 is attached in the image.

2. The closing cash balance of July is $ 581,000, therefore it can repay the notes payable of $ 200,000 in the month itself.

3. Collections for January:

Cash Sales (30% of sales of january)=( 30% *220000)=$ 66,000

Credit Sales ( 40% of Sales of December)=(40% *205000)=$ 82,000

(30% of sales of November)= (30% * 250000)= $ 75000

Total Collection from Credit sales= $( 82000+ 75000)= $157,000

Total Receipts= Cash Sales+Total Collection from Credit sales

= 66000+ 157000= $ 223,000.


Related Solutions

3) 60 % percent of Putnam Corporation's sales are collected in the month of sale, 30%...
3) 60 % percent of Putnam Corporation's sales are collected in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company: January February March April             Budgeted sales $200,000 $300,000 $350,000 $250,000 Total budgeted cash collections in April would be: A) $175,000 B) $150,000 C) $285,000 D) $255,000 4) Half of Curry Corporation's sales are on account (credit)- the other half is cash on...
Seventy percent of Pitkin Corporation's sales are collected in the month of sale, 20% in the...
Seventy percent of Pitkin Corporation's sales are collected in the month of sale, 20% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company: January February March April Budgeted sales $200,000 $300,000 $350,000 $250,000 Total budgeted cash collections in April would be: Multiple Choice $175,000 $275,000 $70,000 $30,000
All sales are on account (credit) with 50% collected in the month of sale, 30% collected in the following month after sale, and 20% collected in the second month after sale.
Black Horse Transportation's sales budget for the first quarter follows: January February March $125,000 300,000 290,000   All sales are on account (credit) with 50% collected in the month of sale, 30% collected in the following month after sale, and 20% collected in the second month after sale. There are no uncollectable accounts. The March cash receipts are: Select one: A. $250,500 B. $172,500 C. $102,500 D. $260,000
October sales are estimated to be $300,000, of which 40 percent will be cash and 60...
October sales are estimated to be $300,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. The cost of goods sold is 70 percent of sales. The company desires to maintain...
Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale, and the remaining 30% in the second month following the sale.
Harrti Corporation has budgeted for the following sales: July August September October November December $455,000 $557,000 $663,000 $823,000 $773,000 $733,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale, and the remaining 30% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?$733,000 $659,700 $891,600 $231,900
BJT Corporation is owned 40 percent by Bill, 30 percent by Jack, and 30 percent by...
BJT Corporation is owned 40 percent by Bill, 30 percent by Jack, and 30 percent by the Trumpet Partnership. Bill and Jack are father and son. Jack has a 10 percent interest in Trumpet Partnership. What is Jack’s total direct and constructive ownership of BJT Corporation under Section 267? a.30 percent. b.100 percent. c.73 percent. d.70 percent. e.33 percent.
Receivables are collected 40% in the month of sale, 45% in the month following  sale, and 15%...
Receivables are collected 40% in the month of sale, 45% in the month following  sale, and 15% in the second month following sale. Budgeted sales:           July $28,000, August $24,000, September $30,000             Determine the September ending receivables balance: 1.b.      The budgeted sales volume is 8,700 units. Inventories planned for the period :                                                             Beginning                    Ending             Direct material                            8,000                          8,500             Finished goods                           2,400                          2,800             Each unit of finished goods requires four units of direct material in production. Work in process inventory is zero at the beginning and end of the period....
All of Pocast Corporation's sales are on account. Sixty percent of the credit sales are collected...
All of Pocast Corporation's sales are on account. Sixty percent of the credit sales are collected in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company:   January February March April Total sales $ 700,000   $ 500,000   $ 400,000 $ 600,000   Cash receipts in April are expected to be: $530,000 $410,000 $460,000 $360,000
Eastern Auto Parts Inc. has 30 percent of its sales paid for in cash and 70...
Eastern Auto Parts Inc. has 30 percent of its sales paid for in cash and 70 percent on credit. All credit accounts are collected in the following month.    Assume the following sales:    January $ 76,000 February 66,000 March 111,000 April 56,000 Sales in December of the prior year were $86,000. Prepare a cash receipts schedule for January through April Sales cash receipts cash sales prior months credit sales total cash receipts
95. Wichita Industries' sales are 10% for cash and 90% on credit. Credit sales are collected...
95. Wichita Industries' sales are 10% for cash and 90% on credit. Credit sales are collected as follows: 30% in the month of sale, 60% in the next month, and 10% in the following month. On December 31, the accounts receivable balance includes $32,000 from November sales and $42,000 from December sales. Assume that total sales for January and February are budgeted to be $70,000 and $140,000, respectively. What are the expected cash receipts for February from current and past...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT