Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
can anybody help me with this cash budget on excel! A line of credit is available at a local bank that allows the company to
can anybody help me with this cash budget on excel! A line of credit is available at a local bank that allows the company to borrow up to $75,000 In one thousand dollar increments. all borrowings occur at the beginning of the month and all reoayments occur at the end of the month. the company does not have to make any payments until the end of the quarter. the interest rate is 10% annually. Fall creations inc desires a cash balance of at least $25,000 at the end of each month. the cash balance at the beginning of april was $13,600. cash dividends of $20,000 are to be paid to stockholders in april. equipment purchases of $100,250 are scheduled for may and $96,000 for june. this equipment will be installed and tested during the second quarter and will not become operational until july when depreciation charges will commence. a. CASH BUDGET Additional data: 1. A line of credit is available at a local bank that allows the company to borrow up to $75,000 in one-thousand-dollar increments. All borrowing occurs at the beginning of the month, and all repayments occur at the end of the month. b. The company does not have to make any payments until the end of the quarter. The interest rate is 10% annually. 2. Fall Creations Inc, desires a cash balance of at least $25,000 at the end of each month. The cash balance at the beginning of April was $13,600. 3. Cash dividends of $20,000 are to be paid to stockholders in April, c. 3. Cash dividends of $20,000 are to be paid to stockholders in April. I 4. Equipment purchases of $100,250 are scheduled for May and S96,000 for June. This equipment will be installed and tested during the second quarter and will not become operational until July, when depreciation charges will commence. $ 13,600 $ 38.600 $ 63.600 $ 13,600 3 Cash Budget 04 Cash balance, beginning Collections from customers Total cash available before financing DT Less disbursement 95 Direct material Direct labor 100 MOH 301 SG&A 102 Equipment purchases 109 Dividends 104 Total disbursements 105 Excess Defit 100 Financing 107 Borrowings 100 Repayments 10 Interest 11 Total fnancing 111 Cash Balance, ending 113 114 11 $ June Fall Creations Inc. is preparing budgets for the second quarter ending June 30, 2021. SALES BUDGET Budgeted sales of the company's only product for the next five months are: April 26,000 units May 39,400 units 37,000 units July 32,000 units August..... 20,500 units The selling price is $11.15 per unit. 1 SCHEDULE OF EXPECTED CASH COLLECTIONS Additional data: All sales are on account. The company collects 60% of these credit sales in the month of the sale; 36% are collected in the month following sale; and the remaining 4% are uncollectible. The accounts receivable balance on March 31 was $52,100. All of this balance was collectible. PRODUCTION BUDGET Additional data: The company desires to have inventory on hand at the end of each month equal to 16% of the following month's budgeted unit sales. . . . . DIRECTBUDGET Additional data: Each unit produced requires 0.05 hour of direct labor. Each hour of direct labor costs the company $16.25. Management fully adjusts the workforce to the workload each month. MANUFACTURING OVERHEAD BUDGET Additional data: Variable manufacturing overhead is $23 per direct labor-hour. Fixed manufacturing overhead is $52,600 per month. This includes $22,900 in depreciation, which is not a cash outflow. ENDING FINISHED GOODS INVENTORY BUDGET Additional data: The Company uses absorption costing in its budgeted income statement and balance sheet. Manufacturing overhead is applied to units of product on the basis of direct labor- hours. The company has no work in process inventories. a. CASH BUDGET Additional data: 1. A line of credit is available at a local bank that allows the company to borrow up to $75,000 in one-thousand-dollar increments. All borrowing occurs at the beginning of the month, and all repayments occur at the end of the month. b. The company does not have to make any payments until the end of the quarter. The interest rate is 10% annually. 2. Fall Creations Inc, desires a cash balance of at least $25,000 at the end of each month. The cash balance at the beginning of April was $13,600. 3. Cash dividends of $20,000 are to be paid to stockholders in April, c. 3. Cash dividends of $20,000 are to be paid to stockholders in April. I 4. Equipment purchases of $100,250 are scheduled for May and S96,000 for June. This equipment will be installed and tested during the second quarter and will not become operational until July, when depreciation charges will commence. $ 13,600 $ 38.600 $ 63.600 $ 13,600 3 Cash Budget 04 Cash balance, beginning Collections from customers Total cash available before financing DT Less disbursement 95 Direct material Direct labor 100 MOH 301 SG&A 102 Equipment purchases 109 Dividends 104 Total disbursements 105 Excess Defit 100 Financing 107 Borrowings 100 Repayments 10 Interest 11 Total fnancing 111 Cash Balance, ending 113 114 11 $ June Fall Creations Inc. is preparing budgets for the second quarter ending June 30, 2021. SALES BUDGET Budgeted sales of the company's only product for the next five months are: April 26,000 units May 39,400 units 37,000 units July 32,000 units August..... 20,500 units The selling price is $11.15 per unit. 1 SCHEDULE OF EXPECTED CASH COLLECTIONS Additional data: All sales are on account. The company collects 60% of these credit sales in the month of the sale; 36% are collected in the month following sale; and the remaining 4% are uncollectible. The accounts receivable balance on March 31 was $52,100. All of this balance was collectible. PRODUCTION BUDGET Additional data: The company desires to have inventory on hand at the end of each month equal to 16% of the following month's budgeted unit sales. . . . . DIRECTBUDGET Additional data: Each unit produced requires 0.05 hour of direct labor. Each hour of direct labor costs the company $16.25. Management fully adjusts the workforce to the workload each month. MANUFACTURING OVERHEAD BUDGET Additional data: Variable manufacturing overhead is $23 per direct labor-hour. Fixed manufacturing overhead is $52,600 per month. This includes $22,900 in depreciation, which is not a cash outflow. ENDING FINISHED GOODS INVENTORY BUDGET Additional data: The Company uses absorption costing in its budgeted income statement and balance sheet. Manufacturing overhead is applied to units of product on the basis of direct labor- hours. The company has no work in process inventories
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started