Question

Cash Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for Holidays Even

0 0
Add a comment Improve this question Transcribed image text
Answer #1
HOLIDAY EVENTS
Partial Cash Budgets
For the Months of October, November, and December
October November December Total
Cash balance, beginning 24000 12000 12000 24000
Collection on sales 36000 41000 81000 158000
Cash available for operations 60000 53000 93000 182000
Disbursements for operations -51000 -61000 -40000 -152000
Ending cash before borrowings or replacements 9000 -8000 53000 30000
Short-term finance:
New loans 3000 20000 0 23000
Repayments 0 0 -23000 -23000
Interest 0 0 -260 -260
Cash balance, ending 12000 12000 29740 29740

Interest = ($3000 x 1% x 2) + ($20000 x 1% x 1) = $60 + $200 = $260

Add a comment
Know the answer?
Add Answer to:
Cash Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for...
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 Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for...

    Cash Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for Holidays Events. Loans are obtained in increments of $1,000 at the start of each month to maintain a minimum end-of-month balance of $12,000. Interest is one percent simple interest (no compounding) per month, payable when the loan is repaid. Repayments are made as soon as possible, subject to the minimum end-of-month balance. Complete the short-term financing section of the cash budget and all missing...

  • eBook Question 4 Not complete Maried out of 100 p g question Cash Budget & Short-Term...

    eBook Question 4 Not complete Maried out of 100 p g question Cash Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for Holidays Events Loans are obtained in increments of $1,000 at the start of each month to maintain a minimum end-of-month balance of $12,000. Interest is one percent simple interest (no compounding) per month payable when the loan is repaid. Repayments are made as soon as possible, subject to the minimum end-of-month balance....

  • R elook & Print Qution 4 Marked out of 1.00 Not complete F Rag question Cash...

    R elook & Print Qution 4 Marked out of 1.00 Not complete F Rag question Cash Budget & Short-Term Financing Presented below are partial October, November, and December cash budgets for Holidays Events Loans are obtained in increments of $1,000 at the start of each month to maintain a minimum end of month balance of $12,000. Interest is one percent simple interest (no compounding) per month, payable when the loan is repaid. Repayments are made as soon as possible, subject...

  • a. Prepare a cash budget for September, October, November, and December. Use the minus sign to...

    a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate the cash outflows, a decrease in cash or cash payments. b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets? c. What are the budget implications for Craig Kovar? Craig can see that his present plan ______ sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $______ short at...

  • 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...

  • a) Sales budget October November December Cash Sales $ 126,000.00 $ 157,500.00 $ 196,875.00 Sales on...

    a) Sales budget October November December Cash Sales $ 126,000.00 $ 157,500.00 $ 196,875.00 Sales on Account $ 154,000.00 $ 192,500.00 $ 240,625.00 Total Budgeted Sales $ 280,000.00 $ 350,000.00 $ 437,500.00 b) Schedule of cash receipts October November December Current Cash sales $ 126,000.00 $ 157,500.00 $ 196,875.00 Add: Collection From A/R $ $ 154,000.00 $ 192,500.00 Total Collections $ 126,000.00 $ 311,500.00 $ 389,375.00 C) Inventory purchase budget October November December Budgeted Cost of goods sold $ 168,000.00...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $53,200. b. Actual sales for October and November and expected sales for December are shown below. Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 73,200 $ 78,000 $ 92,000 $ 485,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $41,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 68,400 $ 87,400 $ 95, 800 $ 415,000 $ 614,000 $ 692,000 Sales on account are collected over a three-month...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets Liabilities and Stockholders' Equity Cash $ 4,000 Accounts payable $31,000 Accounts receivable 31,000 Dividends payable 15,000 Inventory 36,000 Rent payable 3,000 Prepaid Insurance 3,000 Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000 Total liabilities and equity $99,000 Actual and forecasted...

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