Question

The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000. In months where a shortfall

0 0
Add a comment Improve this question Transcribed image text
Answer #1
a) Estimated interest payment $               -   (since there is no outstanding loan at the end of March and interest in calculated on the beginning balance)
b) Total financing effect $ 17,190.00 (W.N.1)
W.N.1
Particulars Amount
Beginning cash balance $ 33,000.00 ($ 14000 + loan of $ 19000)
Excess of cash collected over expenses $ 18,000.00
Unadjusted ending balance $ 51,000.00
Less: Interest ($ 19000 x 1%) $      (190.00)
Ending balance after deducting interest $ 50,810.00
Less: Loan repayment $ (17,000.00) ($ 50000 - $ 33000)
Adjusted ending balance $ 33,810.00
Particulars Q2 2020 Workings Q3 2020 Workings
Expected sales in units 19375 (15500 x 125%) 18750 (15000 x 125%)
Selling price (@ $ 2) $ 38,750.00 $ 37,500.00
Scheduled production 13950 (W.N.2)
W.N.2
Particulars Q1 Q2 Q3
Sales 15100 13500 18000
Add: Ending Inventory 1350 1800
Less: Beginning Inventory 1350
Scheduled production 13950

Is this correct?

Add a comment
Know the answer?
Add Answer to:
The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000....
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
  • The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000....

    The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000. In months where a shortfall is expected, the company can draw In $1,000 Increments on a line of credit it has with a local bank, at an Interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000 Increments of principal) are assumed to occur at the end...

  • The George Company has a policy of maintaining an end-of-month cash balance of at least $34,000. In months where a short...

    The George Company has a policy of maintaining an end-of-month cash balance of at least $34,000. In months where a shortfall is expected, the company can draw in $1,000 increments on a line of credit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000 increments of principal) are assumed to occur at the end...

  • Easy Clean operates a chain of dry cleaners. It is experimenting with the use of a...

    Easy Clean operates a chain of dry cleaners. It is experimenting with the use of a continuous Improvement (1.e., kalzen) budget for operating expenses. Currently, a typical location has operating expenses of $22,000 per month. Plans are in place to achieve labor and utility savings. The associated operational changes are estimated to reduce monthly operating expenses by a factor of 0.99 beginning in January What is the estimated operating expenses for January? For June? For December? (Do not round Intermediate...

  • Brief Exercise 10-14 (LO 10-4) Kraft Bakeries introduced in 2019 a new line of frozen apple...

    Brief Exercise 10-14 (LO 10-4) Kraft Bakeries introduced in 2019 a new line of frozen apple pie. For 2019, sales by quarter were as follows: 20,000 units, 25,700 units, 23,500 units, and 29,200 units. Because of aggressive marketing and promotion, the company expects that sales for each quarter of 2020 will be 25% higher than the respective quarter in 2019. The selling price per unitin 2020 is expected to be $5.40 What are the expected sales, in units and dollars,...

  • You are a relatively recent hite to Hartz & Co. a local manufacturer of plumbing supply...

    You are a relatively recent hite to Hartz & Co. a local manufacturer of plumbing supply products. You have been asked to prepare a condensed statement of cash flows for the months of November and December of the current year for presentation to the company's management Assume the cash balance at November 1 will be $75,000. It is the company's policy to maintain a minimum cash balance of $50,000 at the end of each month Cash receipts (from cash sales...

  • 1. 2. A cash budget, by quarters, is given below for a retail company (000 omitted)....

    1. 2. A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash Budget 1 Quarter (000 omitted) 2 3 4 Year Cash balance, beginning Add collections from customers Total cash available 99 348 I Less disbursements: Purchase...

  • You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply...

    You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare, for a presentation to the company's management, a condensed cash flow statement for the months of November and December 2016 Assume the cash balance at November 1 will be $82,000. It is the company's policy to maintain a minimum cash balance of $55,000 at the end of each month. Cash receipts (from cash sales and collection of...

  • Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter....

    Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support pealk sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are April June July Sales Cost of goods sold Gross margin Selling and administrative expenses $650,000 820,000...

  • Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019.

    To prepare a master budget for January, February, and March of 2020, management gathers the following information. The company’s single product is purchased for $20 per unit and resold for $56 per unit. The expected inventory level of 5,250 units on December 31, 2019, is more than management’s desired level, which is 20% of the next month’s expected sales (in units). Expected sales are January, 7,250 units; February, 9,000 units; March, 10,750 units; and April, 10,000 units.Cash sales and credit sales...

  • The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The b...

    The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made To provide this information for the bank, the...

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