On June 30, Alpha Company's cash balance is $4.000. Alpha is now prepaning their cash budget for the third quarter of the year. The following datas proded Cash budget Beginning cash balance Plus: Cash collections Cash available Less Cash payments Purchases of direct materials July $4.000 50.000 554.000 Aug $8.000 40.000 348.000 Sep $6.958 48800 31,000 12,000 13.000 22.000 9.000 25.000 17.500 11.500 Operating expenses Capital expenditures Interest expense at 5% Less Total cash payments Ending cash balance before financing Minimum cash balance desired Cash excess/(deficiency) Financing Borrowing at end of month Principal repayyments at end of month Total effects of financing Ending cash balance 104 $29300 $26654 $56.000 $12.000 (5.000 S0.000 %255.042 S(8.042 (5.000 SC13.042 $21.65 10.000 15.000 S20.000 (20.000 10.000 $8.000 15.000 The amount of cash that should be shown in the budgeted balance sheet as of September 30 would be O s21,654 O s55.758 O $6.958 O 56.654

On June 30, Alpha Company's cash balance is $4.000. Alpha is now prepaning their cash budget for the third quarter of the year. The following datas proded Cash budget Beginning cash balance Plus: Cash collections Cash available Less Cash payments Purchases of direct materials July $4.000 50.000 554.000 Aug $8.000 40.000 348.000 Sep $6.958 48800 31,000 12,000 13.000 22.000 9.000 25.000 17.500 11.500 Operating expenses Capital expenditures Interest expense at 5% Less Total cash payments Ending cash balance before financing Minimum cash balance desired Cash excess/(deficiency) Financing Borrowing at end of month Principal repayyments at end of month Total effects of financing Ending cash balance 104 $29300 $26654 $56.000 $12.000 (5.000 S0.000 %255.042 S(8.042 (5.000 SC13.042 $21.65 10.000 15.000 S20.000 (20.000 10.000 $8.000 15.000 The amount of cash that should be shown in the budgeted balance sheet as of September 30 would be O s21,654 O s55.758 O $6.958 O 56.654

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 6PA: Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were...

See similar textbooks

Similar questions

Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year
What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the beginning and ending balances of accounts payable are $95,000 and $92,000, respectively?
A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?
What is the amount of budgeted cash payments if purchases are budgeted for $190,500 and the beginning and ending balances of accounts payable are $21,000 and $25,000, respectively?
ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…
the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Required:Prepare a Cash Budget for the period 1 November and 31 December 2018
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700Additional information:1. Cash in respect of credit sales is collected as follows: 50% within 30 days 30% within 60 days 15% within 90 days The balance is written off as irrecoverable. BAD DEBT - IGNORE2. The following discounts are allowed on sales: 10% on cash sales 7.5% on credit sales if accounts are settled within 30 days.3. All salaries, wages and sundry expenses are paid in cash.4. Sundry expenses include depreciation of R4 200 per month. Exclude depreciation5. Seventy-five (75%) of all purchases are on credit and paid within 30 days. The balance is paid…
Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
* CengageNOWv2 | Online teachin x v.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false еВook Show Me How E Print Item Cash Budget 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: June July August Sales $160,000 $185,000 $200,000 Manufacturing costs 66,000 82,000 105,000 Selling and administrative expenses 40,000 46,000 51,000 Capital expenditures 120,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% 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 February, and the annual property taxes are paid in November. Of the remainder of the manufacturing…
Nana Kay company must maintain a minimum cash balance of ghc 25000. At the beginning June, the company's cash balance was ghc 17000. Budgeted cash receipts for June are ghc 150000 and budgeted cash disbursement are ghc 201000. Budgeted net income for July totals ghc 11,000. How much will Nana Kay company need to borrow by the end of June?
The following information was taken from Nash's Trading Post, LLC cash budget for the month of June Beginning cash balance $51000 Cash receipts 69000 Cash disbursements 87000 If the company has a policy of maintaining an end of the month cash balance of $44000, the amount the company would have to borrow is $11000. $27000. $18000. $0.