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