month of sale. The company requires a minimum cash balance of $1,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yeaman need to borrow cash by the end of February?

month of sale. The company requires a minimum cash balance of $1,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yeaman need to borrow cash by the end of February?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION es Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,650 Purchase season football tickets in September 100 Additional entertainment for each month 270 Pay fall semester tuition in September 4,100 Pay rent at the beginning of each month 370 Pay for food each month 210 Pay apartment deposit on September 2 (to be returned December 15) 500 Part-time job earnings each month (net of taxes) 950 Question Content Area a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOYCash BudgetFor the Four Months…
You are preparing a cash budget for the month of September. how would you use information about sales in the preceding July?
The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Sales/Costs April May June Sales $150,000 $175,000 $195,000 Manufacturing costs 66,000 87,000 115,000 Selling and admin. expenses 40,000 46,000 51,000 Capital expenses 0 0 120,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in December, and the annual property taxes are paid in September. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current…
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s credit sales were $90,000. The firm has a certificate of deposit for $50,000 that matures in April. Salaries are $150,000 a month. The monthly mortgage payment is $20,000. Monthly depreciation is $10,000. Property tax of $35,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative beginning and ending cash values, if any. Do not leave any cells blank. If the answer is zero, enter "0". February March April Sales $ 170,000 $ 200,000 $ 230,000 Cash sales $ 35,000 $ 20,000 $ 70,000 Collections $ $ $ Other receipts $ $ $ Total cash receipts $ $ $ Salaries $ $ $ Mortgage $ $ $ Other disbursements $ $ $ Total cash disbursements $ $ $ Net…
Messers Company is preparing a cash budget for February. The company has $20,000 cash at the beginning of February and anticipates $75,000 in cash receipts and $100,250 in cash disbursements during February. What amount, if any, must the company borrow during February to maintain a $5,000 cash balance? The company has no loans outstanding on February 1. MESSERS COMPANY Cash Budget For Month Ended February 28 Beginning cash balance Total cash available Preliminary cash balance Ending cash balance
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $9,060 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay fall semester tuition in September 4,900 Pay rent at the beginning of each month 440 Pay for food each month 250 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,120 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. KATHERINE MALLOYCash BudgetFor the Four Months Ending December 31…
At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,900 Purchase season football tickets in September 190 Additional entertainment for each month 290 Pay fall semester tuition in September 4,600 Pay rent at the beginning of each month 700 Pay for food each month 640 Pay apartment deposit on September 2 (to be returned December 15) 700 Part-time job earnings each month (net of taxes) 1,400 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. a. Prepare a cash budget for September, October, November, and December. Enter all amounts as…
Floss Company has $13,000 in cash on hand on January 1 and has collected the following budget data: Assume Floss has cash payments for selling and administrative expenses including salaries of $66,000 plus commissions of 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,000. Prepare a cash budget for January and February. Will Floss need to borrow cash by the end of February? Beginning bye preparing the cash budget for January, then the cash budget for February. (Complete all input fields. Enter a “0” for any zero balances. )
B. Mahmoud Repair Company is preparing its budget for the first quarter of 2021. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2021 are: November 2020, $120,000; December 2020, $110,000; January 2021, $140,000; February 2021, $160,000; March 2021, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2020 and expected purchases for 2021 are: December 2020, $21,000; January 2021, $20,000; February 2021, $22,000; March 2021, $27,000. Instructions (a) Prepare the following schedules for each month in the first quarter of 2021 and for the quarter in total: (1)…
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $8,780 Purchase season football tickets in September Additional entertainment for each month Pay fall semester tuition in September 120 310 4,700 Pay rent at the beginning of each month 430 Pay for food each month 240 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,090 KATHERINE MALLOY Cash Budget a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign. For the Four Months Ending December 31 September October Estimated…
The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Sales/Costs Sales Manufacturing costs Selling and admin. expenses Capital expenses April May June $150,000 $175,000 $195,000 66,000 87,000 115,000 40,000 46,000 51,000 0 0 120,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in December, and the annual property taxes are paid in September. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of April 1 include cash of $42,000, marketable…